You are viewing limited content. For full access, please sign in.

Question

Question

Append string "@domainname.com" to make email address to the Each values of multivalue field

asked on January 24, 2019 Show version history

Hello,

 

We have one field named Email address which is single value right now. User will just input firstname.lastname and workflow will append the "@domainname.com" to make the valid email address and send the email to that person.

Now, they want to make this field multivalued and they want to put the first value as To email address and any other values they put should be on CC. They will just put the firstname.lastname and worflow should append the "@domainname.com".

 

Can anyone help me to achieve this, please?

 

Thank you

0 0

Replies

replied on January 24, 2019 Show version history

If you're already modifying the single value field, then you are already most of the way there. All you need to do is add a For Each Value activity and iterate over the multivalue field and perform the same action.

1 0
replied on January 24, 2019 Show version history

I did almost the same thing as Devin.  In my example I created a blank token to hold the appended values, then used the token to replace all values in the template field.  To send the email, I retrieve the email addresses after the were appended and used just the first value in the TO box.  Then I used ALL values but removed the first value in the CC box.

Append2.png
Append2.png (96.03 KB)
1 0
replied on January 25, 2019 Show version history

Haha, I was trying to set this up yesterday and getting stuck on how to remove the first value for the CCs because I completely forgot we can remove at a given index. Thanks, Jennifer!

We can do this directly in the To/Cc boxes in the email activity with formatting and functions on the multi-value field token, you don't need the For Each loop. Delimiters are not limited to a single character, so you can use "@domainname.com;" as your delimiter. That would add the domain name to all values except for the last one, so you'd need to append an @domainname.com at the end.

("people" is my multi-value field token in the screenshots below)

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.