General

Re: double eval to get person data from SharePoint list (no code, browser form)

SusanP — Sat, 28 Jun 2014 18:56:46 GMT

OK, I get it now. I just need xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Approvers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Approver/pc:Person/pc:AccountId, 'concat(., "; ")'), "..")

My mistake was thinking Person was a repeating type. Thank you Patrick!!

Re: double eval to get person data from SharePoint list (no code, browser form)

SusanP — Mon, 23 Jun 2014 15:18:35 GMT

Patrick Halstead:
Hi Susan,

I'm attaching a sample from a webinar I did last year. Expand the data source and take a look at the default value on the /my:myFields/my:AccountIdAggregation/my:People node. It has a double eval that it gets from a People Picker.

Good luck!

thanks Patrick - I don't have any trouble with persons in the Main data source. I'm running into difficulty when I'm trying to get the details of a person field from a SharePoint list -- I think the namespace is the problem -- neither "pc:" nor "d:" is working for me in both InfoPath verify formula and browser form rendering.

Re: double eval to get person data from SharePoint list (no code, browser form)

Patrick Halstead — Mon, 23 Jun 2014 03:05:34 GMT

Hi Susan,

I'm attaching a sample from a webinar I did last year. Expand the data source and take a look at the default value on the /my:myFields/my:AccountIdAggregation/my:People node. It has a double eval that it gets from a People Picker.

Good luck!

double eval to get person data from SharePoint list (no code, browser form)

SusanP — Thu, 19 Jun 2014 17:54:09 GMT

I can use this formula

xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Approvers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW, 'concat(d:Approver, "; ")'), "..")

to retrieve all the Approver data . . .

But I can't figure out how to change the formula to get only AccountId. When I use "pc:" in front of Person, InfoPath says formula is valid, but browser says "msxml6.dll
Reference to undeclared namespace prefix: 'pc'." When I use "d:" in front of Person, InfoPath says the formula does not point to a valid location path of a field or group.

Advice greatly appreciated. Thank you!