Controls

Re: 'double eval trick' and people picker in InfoPath 2010

nathangoss — Wed, 29 Apr 2015 10:08:34 GMT

Hi there, I have been trying to do exactly as you have done, however instead of getting Display Name (that is correctly shwon in the People Picker) I get the user's Claims Based id - eg: i:0#.w|domain\userid; Any suggestions on how to get the nice Display Name into the Text Box - eg: First Last? Thanks, Nathan

Re: 'double eval trick' and people picker in InfoPath 2010

Hilary Stoupa — Tue, 05 Aug 2014 17:34:33 GMT

Try this:

xdMath:Eval(xdMath:Eval(my:ccpeople/pc:Person, 'concat (pc:AccountId, " | " ) '), " .. ")

Re: 'double eval trick' and people picker in InfoPath 2010

Ilovetoski — Tue, 05 Aug 2014 17:21:51 GMT

I am having the same issue. I've done all the tricks from the blogs I've looked at (closing form, shutting down, editing with xpath, etc).

My form is deployed as infopath filler form to sharepoint. Infopath 2010. I cannot seem to get this to work and am absolutely desparate. Can anyone help?

myFields

-ccpeople

-- pc:person

---DisplayName

---AccountId

---AccountType

xdMath:Eval(xdMath:Eval(my:ccpeople/pc:Person, 'concat (my:ccpeople/pc:Person/pc:AccountId, " | " ) '), " .. ")

"my:ccpeople/pc:Person/my:ccpeople/pc:Person/pc:AccountId" does not point to a valid location path of a field or group.

Re: 'double eval trick' and people picker in InfoPath 2010

snehalrana — Thu, 13 Feb 2014 16:03:57 GMT

I am having similar issue. In my case, I have a drop-down list control (Let's call it "Team Assignment") which is getting populated from a SharePoint list column "Title". Now, there is a People Picker control called "AssignedTo". The SharePoint list has two columns - Title and SubTeam. When user select a value from Team Assignment (drop-down) the "AssignedTo" value changes.

Now the SubTeam column has multiple values. That being said, the AssignedTo only shows first value. How do I use the double eval trick to retrieve multiple values in the AssignedTo

Any suggestions, idea, tricks ?

Re: 'double eval trick' and people picker in InfoPath 2010

Hilary Stoupa — Tue, 05 Nov 2013 23:31:28 GMT

Here's a sample w/ a double eval in it. I stored data when I created the list connection, so save it locally from the link, right click and select design. Preview and say "okay" or "yes" (can't remember the option) when it asks about connection to data sources. The connection will fail and it will ask about working offline. If you say "yes" it should use its stored data.

Re: 'double eval trick' and people picker in InfoPath 2010

Wesaw3 — Tue, 05 Nov 2013 18:13:39 GMT

I am also having a hard time wih this. Please see below:

I've been round and round and in and out of forums. I see that this is similar to my inquiry and it is very possible to achieve what I am trying to do.

First I have the form set up and pointed to my SP list, data connecttions set etc. Works great....

I have:

Condition- Rule Runs when Field Is Changed

Set Field Value:

Field: (RoleName (PX))

Value: DisplayName[PX=PX and Title = Title]

The objective:

Project Name Person Role 1 Person Role 2 Person Role 3 Person Role 4

1234 A John Doe Jane Doe Susan Doe Blank

Peter Doe Mark Doe

Oscar Doe

Everything is working fine, when a user selects a project name (ie. Drop Down) Infopath. It auto populates the person associated with the role etc...... However if there is more than one person in a SP column, it does not transfer over to Infopath like that. Only one user appears. Currently I am using single text fields to "Display Name" in Infopath. Does my Infopath fields need to be "People Picker" to accomplish this.

I have read that it is possible to concatenate the values of my SP list and have them display in Infopath as follows: Name1;Name2;Name3. But I am having a difficult time doing this. ie (double eval trick)

My primary objective is to use the OOB features, no coding. I have read that even using a web service, it is still impossible to display more than one name per field.

Please help if you can. I am unsure why I do not get the alerts when someone posts a reply. However could anyone post a reply and send a step by step to my email as well.

Thank You

Re: 'double eval trick' and people picker in InfoPath 2010

sevid11 — Fri, 23 Nov 2012 20:14:05 GMT

Hi man, can you help me please? pliiisss i try to filter a repeating table that contain a people picker path: /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Responsable_x0020_acargo/pc:Person/pc:AccountId do you know what i must put in queryFields/Responsable_x0020_acargo? thx man

Re: 'double eval trick' and people picker in InfoPath 2010

bkwdesign — Wed, 19 Sep 2012 14:04:42 GMT

I'm using InfoPath 2010 and had a booger of a time getting the 'double-eval trick' code to work...

There was one little thing I was doing wrong.. to clarify, I'll enumerate all the steps that work for me:

1.) Open the rules panel (I click the Manage Rules button on the Home tab of my Office ribbon)

2.) Set up the "Action" rule type by clicking the "Add" button and choose the "Set a field's value"

3.) Eventually, you find yourself in the Rule Details dialog:

a.) For the Field: Choose the hidden text field that will contain your string to be generated.

b.) For the Value: click on the fx button at the right

c.) CLICK THE CHECKBOX AT THE BOTTOM RIGHT: Edit XPath (advanced)

d.) Paste in thefollowing code (in this scenario SubmittedBy is the name of my specific person-picker control):
xdMath:Eval(xdMath:Eval(my:SubmittedBy/pc:Person, 'concat(pc:AccountId, ";")'), "..")

Step 3.c highlighted in red, above, is what I was missing all along.

Re: 'double eval trick' and people picker in InfoPath 2010

traveladic — Tue, 08 May 2012 19:19:36 GMT

I still get the pc error,

Re: 'double eval trick' and people picker in InfoPath 2010

sofusok — Wed, 06 Jul 2011 07:07:58 GMT

Problem solved as described below:

Shut down computer, go home, and come back the next morning..then open your form, enter the formula

xdMath:Eval(xdMath:Eval(Person, 'concat(pc:AccountId, ";")'), "..")

and it works..! So it was the namespace thing..

'double eval trick' and people picker in InfoPath 2010

sofusok — Tue, 05 Jul 2011 12:07:47 GMT

Despite reading lots of forum posts, several blog posts (incl. the informative walkthrough from alec pojidaev on codeless programming), I find myself needing your expertise..

I simply cannot get the double eval trick to work when using the people picker in Infopath 2010.

(I can get it to work with a repeating table though, just not the people picker).

What I want to accomplish:

Concatenate the AccountId’s of users selected in the people picker, separated by semi-colon, like this:

domain/user1;domain/user2;domain/user3

What I’ve done so far:

Created a blank infopath form with the following structure

myFields

Picker

pc:Person

DisplayName
AccountId

AccountType

strAccountIds

Where ‘Picker’ is the peoplepicker and strAccountIds is a text box where I would like the concatenated string to appear.

When I enter the following in Edit Xpath mode:

xdMath:Eval(xdMath:Eval(../my:Picker/pc:Person, 'concat(my:AccountId, ";")'), "..")

it results in the following:

eval(eval(Person; 'concat(my:AccountId, ";")'); "..")

and returns this error:

“"../my:Picker/pc:Person/my:AccountId" does not point to a valid location path of a field or group.”

When I use ‘Insert Field or Group’ to select the AccountId field, this is what is generated in Xpath-mode:

xdMath:Eval(xdMath:Eval(../my:Picker/pc:Person, 'concat(../my:Picker/pc:Person/pc:AccountId, ";")'), "..").

I have read in other posts that the reference to AccountId must be relative but I can't seem to find the correct relative reference.

I think it is the 'pc:' before AccountId that confuses me.

Hope someone can help me or point me in the right direction.