Re: Sending emails using people picker to multiple people

Hilary Stoupa — Tue, 12 Jun 2018 14:51:37 GMT

Thanks for posting this! I think you could have also used substring-after to get just the user email info.... and I'm wondering if the third eval is necessary or if this could have been done w/ a formula inside the concat?

Sending emails using people picker to multiple people

jacooper — Tue, 12 Jun 2018 09:56:07 GMT

I recently needed to have a form send emails to multiple users selected from the people picker tool. The first issue I had was the accounted had lots of unwanted and unhelpful text within i.e i:0#.w|domain\MUDID;

Doing some searching I found a code to strip out the unwanted bits and just leave the MUDID, semi colon separated, I used this and it didn't resolve the names when sent, so it needed the email added to the accountid to work, so MUDID@email.com

The code strips out the beginning characters so 18 characters removes everything up to the MUDID from the example above and then appends the email part to the remaining MUDID separated by semi colons

eval(eval(eval(AccountId, "substring(., 18)"), 'concat(., "@email.com;")'), "..")

This gives the following in a text box i.e person1@email.com;person2@email.com;person3@email.com

I tried up to 13 names in the people picker and then used this field as the To in an email connection and all people received an email, you may have to start with 0 instead of 18 in the code and then adjust to strip out all the unnecessary text

General

Re: Sending emails using people picker to multiple people

Sending emails using people picker to multiple people