Skip to main content

How to set Current User Name to InfoPath Person/Group Picker

This method also use for get User Profile Information such as First Name , Last Name , Office and etc.

In generally we can not set a default value to InfoPath Person/Group Picker. On the other hand we can not get Current Username in the InfoPath. (Yeh it is true that we can use userName() function. But this will return the Current User Account ID not the name).

image

So we want to use SharePoint user profile services to do this.

  • First we need to  create a user profile connection.
    • Thus First go to Manage connection and click add connection.

image

    • Then go to receive data option and SOAP Web service and specify the User Profile Service URL. The URL will be something like (http://sever/sites/site/_vti_bin/UserProfileService.asmx). This is depends on your site or site collection. if it is a site collection you can omit /sites/site/ part from your URL.

image

then proceed to next , select UserProfileByName and un select the Automatically load. Now you have created the connection.

image

  • Now you have User Profile connection to receive profile data.

image

  • For an example we will design a form like below. You need to set the current user automatically when the form load.

image

  • Then Go to the Form Load Rules.

Note : – If we Query the data source  with out parsing any parameters it will load the current user detail.

  • Thus now we are going to query the data connection (GetUserProfileByName) in the form load. thus Go to Form Load rules and then set a  Action as Query for data and select the UserProfile Data Connection.

image

then click Ok. now you have configured the data connection. Now you have Form Load rule for query user profile service.

image

for InfoPath person picker to identify the user we need to set DisplayName  as well as AccountID.

Now we are going to set the display name for the control. so Add a new Action Set a Field’s Value in the form load and Click the DisplayName in the date picker control field in the Main Data Connection. You can follow below steps to do that.

 

image

then we need to assign the value for displayname.thus we need to get that value form the data connection “GetUserProfileByName” that we already queried in the form load. thus now it contains user profile data for the current user. only we need to fetch the value related to Display name.

image

User profile data coming as key value pairs. Ex:-

  • value[“PreferredName”] = Some Name
  • value[“AccountName”] = Some Value
  • value[“FirstName”] = Some Name

thus we need to pick the correct data from the Value. Thus we need a filter Display Name from the Value.

image

after that click Ok. After several Clicks you can see below dialog.

image

Now you have two actions (one for query and other for Set PreferredName to DisplayName field in the person/group picker control )

image

Now you are done with setting the DisplayName of the Person/Group Picker Control. Then we need to assign the AccountID. so go to very first step. and then add a new action to assign the value for AccountID. So select the AccoutID (Very first step, we selected DisplayName earlier)

image

Then proceed with the same method and finally give filter as  AccountName , which we assign PreferredName earlier.

image

Now you are having three actions in the Form Load and now you are done.

image

Now if you preview the form you can see values coming. You can also use following name parameters to load other user profile data (FirstName, LastName) to controls (Ex- TextField , Combo) as well.

UserProfile_GUID
AccountName
FirstName
LastName
PreferredName
WorkPhone
Office
Department
Title
Manager
AboutMe
PersonalSpace
PictureURL
UserName
QuickLinks
WebSite
PublicSiteRedirect
SPS-Dotted-line
SPS-Peers
SPS-Responsibility
SPS-Skills
SPS-PastProjects
SPS-Interests
SPS-School
SPS-SipAddress
SPS-Birthday
SPS-MySiteUpgrade
SPS-DontSuggestList
SPS-ProxyAddresses
SPS-HireDate
SPS-LastColleagueAdded
SPS-OWAUrl
SPS-ResourceAccountName
SPS-MasterAccountName
Assistant
WorkEmail
CellPhone
Fax
HomePhone

Comments

Albert Henry said…
I did get this worked with Account ID and Display Name but the thing is that when I save data, it is not getting submitted to SharePoint.
b said…
@Albert Henry,

I did not exactly understand your point. If you are not matched any filed to list entire document is submitting to the SharePoint
Ahmed Hlabba said…
Hi ,thanks for your post , it works great in preview mode but when i piblished form i get an error ID 5566

An entry has been added to the Windows event log of the server.
Log ID:5566

Correlation ID:8a7023db-9e56-45ae-9832-51193a4d23c2
AprilD said…
i have a list for my team members made up of people picker columns. i draw from that list to set the values in a separate list/infopath form (also people picker). the data does NOT save/publish to the list. just like Albert Henry says perhaps? i'm going to instead have to get rid of the people picker i think and just have it be text fields in the 2nd form (the consumer).
b said…
@AprilD,

People picker is a complex control which hold the data as semicolon separated (Ex- DisplayName;ID;Email). So what you can do it you can save the entire thing to a text field or accoutID to a text field to retrieve data in future.
Anonymous said…
Hello

this works on now form but not on an edit form - I have the need to fill the people picker also in an edit form

how to do this?

robert
Anonymous said…
I got the same error as @Ahmed Hlabba. Does anyone know how to resolve this error ID 5566?
b said…
@Anonymous,

Does it submit any value or nothing

Popular posts from this blog

How to Link Two List and Create a combine view in the SharePoint 2010

In this way you can join multiple list together and can create a combine view. for an example assume that you are managing a list for some events. And also you are having a participants in separate list. Thus you want to join the two list and create a composite view. SharePoint 2010 allows you to create this kind of view using  Linked Data Source. in this approach you can create your own custom list in the SharePoint. How to Create a Linked Data source Go to SharePoint designer and  go to the link called data sources. And Click the Linked Data Source button in the ribbon. Then SharePoint designer will prompt following kind of a dialog. In there add two list, that you wan to linked together. I'm adding airline schedule and booking list. those are the two list that i wan to merge. then click next. And it will guide you another screen. it will ask you to select either Merge Merge use to combine list which are having same columns definition. for and example we can say th

Motion Eye Docker compose File

Docker compose files are comes in handy when considering container orchestration. Below example shows my docker compose files and folder structure. ---- Your Folder (motioneye)   -- etc   -- lib   -- docker-compose.yaml You can run the docker compose file using docker-compose -d , and etc and lib folder will be automatically populated in the initiation. --- Below shows the content of the docker-compose.yaml file. version: '3' services:   nodered:    image: "ccrisan/motioneye:master-amd64"    container_name: motioneye    restart: always    user: root    ports:      - 8765:8765    volumes:      - "/etc/localtime:/etc/localtime:ro"      - "./etc:/etc/motioneye"      - "./lib:/var/lib/motioneye"

How to get Username , UserID in CAML Query

If you are want to get the userID you can simple use following code. <Where>    <Eq>       <FieldRef Name='userfieldname' />       <Value Type='Integer'>            <UserID Type='Integer' />       </Value>    </Eq> </Where> in here you should declare the UserID variable before it uses. normally If you make a user filter in the SharePoint designer it will automatically create the parameter in parameter binding section in the web part. <ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/> But assume you want to filter using a user name and the field is not a persongroup feild and it is just a text field. then you can use following query to archive it. <Where>    <Eq>       <FieldRef Name='userfieldname' />       <Value Type=’Text’>            <UserID Type=’Text’/>       </Value>    </Eq> </Wh