InfoPath Dev

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!   

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!

 

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. 

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!!