Power Automate: Combine values of Multiple Person or Allow Multiple Choice field to send email

I have a list with Multiple Choice or Multiple Persons field. I have to send email to Multiple persons and mention Multiple Choice also in that email.

If you try to choose the above fields directly while sending an email, there will be 2 Apply to each controls as below.


To avoid this, follow the below steps. This works better if you are using "when an item is created or modified" or if are using "Get items" step and want to send email for all users at a time.

1. Initialize 1 array variable each for Multiple Choice and Multiple Person field.

2. Use "Append to Array Variable" for both choice and person fields. For Choice field use the "Choice Value" and for Person field use "Person Email".
3. Use Join "Data Operation" to combine all the values using ";" for Person variables and ";" or "," for choice fields based on requirement.

4. Use outputs from Join operation to send email. 










No comments:

Post a Comment