Hello-I need to send single email to all users specified in the multi-valued field.
I tried to use the Query Data token for email addresses but it says no multiple values supported.
How can I make this work? Thank you.
Hello-I need to send single email to all users specified in the multi-valued field.
I tried to use the Query Data token for email addresses but it says no multiple values supported.
How can I make this work? Thank you.
No, that's not going to work, that's just the first row from your query results. You have to process each row separately and add its value to the token.
Query Data does not generate multi-value tokens. It generates a results set that you can go over with For Each Row. Within each row, the tokens corresponding to the columns in your query are single-value.
If you want a single email to all the people returned, you can create a multi-value token and collect all emails in it as you iterate through For Each Row.
Thanks Miruna. I have created the token before the email activity hoping that it will capture up to three user emails but did not work.. Is this how I should have set the token as?
Thanks, Aya