create a variable

(0) Share

Report

Posted on by Pinoq

102

Hey , I would like to know that how can I create a variable in order to store emails in a variable?

I have created a flow when trigger by when an item is created, send an email to assign to and CC email.

which CC email is a multiple selection of groups of email. It cause in some case if 2 persons selected in cc, assign to will receive 2 identical emails. Thus,I would like to to store all cc emails in a variable. How can I set it up?Because I cannot choose the variable in dynamic.

Set CC Email varaible.PNG

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

sudharsan1985 1,325 on at

Like (0)

Report

Hi @Pinoq
Try to use the array variables and append the values to the array variable and finally use the join condition to join all the values in an array with ';' separated and then the final output to the mail CC. Try to use the below expression for joining the arrary variable.
join(variables('ArrayVariableName'),';')

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
Pinoq 102 on at

Like (0)

Report

Sorry, I am new in Power Automate. Can you explain more detail?

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report

Hi @Pinoq
Based on your screenshot below please follow the below steps
1. In your 'Initialize Variable' section, create a variable of type 'Array' and in the value just give '[]'
2. In your 'Apply to each 2' action, remove the 'Set Variable' action use 'Append to array variable' and then use the above declared variable.
3. In the email action use the dynamic expression 'join(variables('array variable name'),';')'.

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
Pinoq 102 on at

Like (0)

Report

Still cannot set, any thing I have set wrong?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Pinoq

You can follow the suggestion provided in the thread here.

https://powerusers.microsoft.com/t5/Building-Flows/Array-Setting/m-p/493581#M61166

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report

Hi @Pinoq ,

If the CC column and the assign to column are person type column, please refer to screenshot below to create the flow:

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No