Set variable with multiple values

  • 2 November 2017
  • 4 replies
  • 10 views

Badge +4

Hi team,

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.

Thanks


4 replies

Badge +9

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.

210329_pastedImage_1.png

Badge +4

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

Badge +9

Create a workflow variable of type collection called 'pplRequestor' and insert a 'Query List' action and configure like below.

210354_pastedImage_1.png

Output will be (login ids separated by semicolon)

210365_pastedImage_3.png

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).

210366_pastedImage_4.png

Insert 'Set Variable' action (create workflow variable 'tempPersonDispName' as single line of text).

210367_pastedImage_5.png

3 steps look like

210368_pastedImage_6.png

Then process your actions accordingly.

Badge +4

Thanks Lakshimi, it works.

Reply