Newbie Questions

Re: Double eval with substring

Wheels — Fri, 18 Jan 2019 20:40:01 GMT

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

Re: Double eval with substring

Hilary Stoupa — Fri, 18 Jan 2019 20:16:57 GMT

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/

Re: Double eval with substring

Wheels — Fri, 18 Jan 2019 18:03:56 GMT

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.

Re: Double eval with substring

Wheels — Fri, 18 Jan 2019 17:59:58 GMT

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

Re: Double eval with substring

Hilary Stoupa — Fri, 18 Jan 2019 17:40:50 GMT

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

Re: Double eval with substring

Wheels — Fri, 18 Jan 2019 17:07:06 GMT

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

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

WHEELS

Re: Double eval with substring

Wheels — Fri, 18 Jan 2019 16:13:06 GMT

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

Re: Double eval with substring

djsolzs — Thu, 31 Aug 2017 13:43:50 GMT

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

Re: Double eval with substring

djsolzs — Wed, 30 Aug 2017 20:24:47 GMT

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!

Re: Double eval with substring

Hilary Stoupa — Wed, 30 Aug 2017 20:03:16 GMT

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\"), ";")'), "..")

Double eval with substring

Fitchet86 — Wed, 30 Aug 2017 14:21:30 GMT

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!