I have a list which is used to send email to notifications to peoples in "CC Email To" field. In that field, I used person name and then used Set Variable workflow actions to look up their email in another list. The problem is that this workflow doesnt works if the field contains more values (>1). Please have a look and give me your nice ideas to fix it.
Any support is highly appreciated.
Solved! Go to Solution.
You have to use a collection to read more than one value.
Try below steps.
1. Store CC email output to a collection variable.
2. Collection operation - get the count of collection.
3. If the count is 1, then set CC Email to directly.
4. If count is more than 1 then use for each action to read each user name.
Thanks for your help. Can you guild me more details? How can I store CC email output to collection variable. I used Set Variable action, but it did not works.Which actions should I use
Create a workflow variable of type collection called 'pplRequestor' and insert a 'Query List' action and configure like below.
Output will be (login ids separated by semicolon)
If you want display name for each log in name then insert a 'For each' action (create workflow variable 'tempName' as single line of text).
Insert 'Set Variable' action (create workflow variable 'tempPersonDispName' as single line of text).
3 steps look like
Then process your actions accordingly.