InfoPath Dev

 Hi all,

 Relatively new to all this InfoPath stuff and royally stuck on combining double eval when I have substring included in a formula already! 

What I'm trying to do is send emails to multiple people from a people picker. I can get it to send to the first person, by taking the last part of the Account ID and using this to send the email, but I can't get it to send to the other users who will be entered in the picker. I've read all about double eval but can't work out how to combine the two.

This is what I have so far for substring... just need some help if possible with combining this with a double eval?

substring-after(AccountId, "GLOBAL\")  

Thanks! 

 So, one way to set up a double eval looks like this:

eval(eval(AccountId, 'concat(., ";")'), "..")

Use the button for select a field or group to select the AccountId node.

Then for your enhancement:

 eval(eval(AccountId, 'concat(substring-after(., "GLOBAL\"), ";")'), "..")

Hi - I am looking for help with something similar. I am currently doing a double eval to pull back "Display Name" on multiple values from a list.. but that pulls back more than just the users name (Example: Mickey Mouse, profile url, Department, etc) I need to now split up the multiple values (or user names) in to a seperate textbox I can get it to show me 1 name by using this as default value for the second text box: substring-before(OPAckNeeded, ",") which delivers Mickey Mouse. I need to be able to do a double eval on this to show all the names with a comma between (Mickey Mouse, Donald Duck, etc) Any help much appreciated!

I ended up figuring it out based on your example - thanks for posting!

Good morning.

I have been successfully using the Person/Group Picker control for a while now with the following:

eval(eval(DisplayName, 'concat(., ";")'), "..")

I ran into an issue where this would fail if 2 individuals have the same name. So I am try to go with the AccountId. I created the following to user the user name minus the domain prefix:

eval(eval(substring-after(AccountId,"UP\"), 'concat(., ";")'), "..")

but I am coming up with a  Type mismatch - Error occurred during a call to property or method 'Eval'.

Any suggestions or thoughts? 

WHEELS

I tried the following, but it only resolves the 1st name when emailing:

concat(substring-after(AccountId, "UP\"), ";")

WHEELS 

I think you need to move the substring part of the formula: eval(eval(AccountId, 'concat(substring-after(.,"UP\"), ";")'), "..")

Hi Hilary.

I will give that a try. I did find the following, and although it looked promising, I am getting an error:

 Unexpected character.
substring(eval(eval(my:group/pc:Person, -->‘<--concat(pc:my:group/pc:Person/pc:AccountId, “;”)’), “..”), 1, string-length(eval(eval(my:group/pc:Person, ‘concat(pc:my:group/pc:Person/pc:AccountId, “;”)’), “..”)) – 1)  

https://mysharepointpage.wordpress.com/2014/07/14/using-eval-function-for-people-picker-in-infopath/
substring(eval(eval(Person, ‘concat(pc:AccountId, “;”)’), “..”), 1, string-length(eval(eval(Person, ‘concat(pc:AccountId, “;”)’), “..”)) – 1) 

WHEELS 

Hi Hilary. I tried your simple, but brilliant expression and it worked as expected. You saved the day once again. Thank you very much. WHEELS.

Happy to help. Here's what's happening - the place where you select the field (AccountID) is what gets all the repeating nodes. Then, any formulas you want to apply to the text (like the concat, to add the ";" or the substring-after) go in the single quotes. Here's a good explanation of double eval: https://blogs.msdn.microsoft.com/infopath/2006/04/05/email-submit-to-line-loops-in-formulas/

 Thanks again. I hope I will have the opportunity to help you sometime and repay the favor. WHEELS