InfoPath Dev

Hi, I'm trying to using the double eval as mentioned in numerous posts, to pull multiple email addresses from a people picker. Using this formula it fails with the above error. Could anyone assist on this? It's driving me crazy!

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

If you picked "Person" with the field or group picker, I'd think your formula would be: eval(eval(Person, 'concat(pc:AccountId, ";")'), "..")

 Hi Hillary,

I got this KIND of working, but now with strange results.   Here is the formula again, and the results.  

People Picker Selection -  "Darcy Wilson; Kevin Lambert; Peter Scott" 

Formula -  "eval(eval(Person, 'concat(../../my:group/pc:Person/pc:AccountId, ";")'), "..")"

Result  -  "i:0#.f|membership|[email protected];i:0#.f|membership|[email protected];i:0#.f|membership|[email protected];"

 Now I know the stupid i:0#|membership stuff is the result of SharePoint 365.  Though I have no idea how I can clean that up to have JUST the email address.  But the bigger question is why I don't get three different results? 

Your formula is still wrong. You are not using a relative path to the AccountId node - that is why you don't get three different results. What happened if you just use "pc:AccountID" like I suggested? "eval(eval(Person, 'concat(pc:AccountId, ";")'), "..")"

 Oops, yes, I do see that this appears to fix the issue.  Thanks for that! 

Is there a simple way now to remove all the garbage from the result, so I can then using that result for an email form submit? 

I think so - I think you can use a substring-after function: eval(eval(Person, 'concat(substring-after(pc:AccountId, "membership|"), ";")'), "..")

 You are so wonderful! Thank you again for all the assistance you provide!

Hi Hilary - I believe I have the same issues, but need your help. What information can I send you so that you can help me through this issue? Please let me know. I really need to solve this issue soon. Thanks, Kellie

Can you attach your template under the Options tab in a reply & let me know a few more details? Are you using double eval and running into the same error?

Hi Hilary - I've attached the file. All I want to do is have the People Picker validate the email address and then send the form to whomever is added to the people Picker.

You probably just need a formula in your "E-Mail" field then as a default. In your form, set the fields task pane to display in advanced view. Drag the data source for the "pc:Person" group (inside "smart email") onto the form as a repeating table. Preview your form and pick a user with your people picker - the account id field will have the account info. You will likely need to use a substring-after formula to get just the email back - like this: (substring-after(pc:AccountId, "membership|"), but selecting the pc:AccountId field using the field picker.

Hi Hilary - This is still not working. Can I set up a quick WebEx to show you where I'm getting stuck? Thanks, Kellie

Hi Hilary - I was able to get it working. Thanks so much for your help! Kind Regards, Kellie