Answered

In this instance this action sends email to each user in the column field, how can I send it to all at the same time?

(0) Share

Report

Posted on by MikeRooker

364

This action works great but it automatically adds "apply to each", sending an individual email to every user in in the "person column field" (Site Owners1). But how can I send the email to them all at the same time, letting them see who also received the email?

Thanks in advance for any help.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (2)

Report

Hi @MikeRooker

You will want to create a string variable.

Now inside the Apply to each loop use a Append to string variable and add the dynamic content email address with a ; at the end.

Now outside the loop have your send email action and put the string variable that will have all the emails separated by a ; in the To field.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (2)

Report

Hi@MikeRooker!
First of all, hope you and your people are well
Now let's talk about the issue

"sending an individual email to every user in in the "person column field" (Site Owners1). But how can I send the email to them all at the same time, letting them see who also received the email?"

So my suggesrion is to keep 'Apply to each' and add an 'initialize variable' type array name 'myTargetEmails' just before it.
So use 'Apply to each to iterate all over every user, by adding inside an'append to array variable' value email from current user
Now remove 'send an email' from Apply toEach.
Then outside Apply to each add a 'Send an email', assignt to To input the following expression:
join(variables('myTargetEmails'),';')

Not with my laptop, hope it helps

Was this reply helpful? Yes No
MikeRooker 364 on at

Like (0)

Report

Hello jcook, thank you however I ran into an issue. It won't let me add a Name.

Was this reply helpful? Yes No
MikeRooker 364 on at

Like (0)

Report

Hello efialttes, and thank you again. I must be doing something wrong. It won't take the email address.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (1)

Report

Hi @MikeRooker
You must first initialize a string variable.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
MikeRooker 364 on at

Like (0)

Report

I had to figure out how that worked and your follow up underlining the fact I needed to create a string variable made me seek out other examples on line to see how that worked , then applied your steps. Thank you!

Was this reply helpful? Yes No
MikeRooker 364 on at

Like (1)

Report

Thank you again as always efialttes! You know how amazing you are. I'm sorry I must have missed a step following your solution. But Jcook was able to pull me through ( thank you). I was really short for time and got it done.
You guys are so amazing. I'm so grateful!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

No problema. @Jcook deserves all the credit, since he was faster and more precise in his answers

You guys make this community great!

Was this reply helpful? Yes No