web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / In this instance this ...
Power Automate
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) ShareShare
ReportReport
Posted on by 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.

 

sendemail1.PNG

Categories:
I have the same question (0)
  • Verified answer
    Jcook Profile Picture
    7,781 Most Valuable Professional on at

    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

  • efialttes Profile Picture
    14,756 on at
    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
  • MikeRooker Profile Picture
    364 on at

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

    st1.PNG

  • MikeRooker Profile Picture
    364 on at

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

    st2.PNG

  • Jcook Profile Picture
    7,781 Most Valuable Professional on at

    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 

  • MikeRooker Profile Picture
    364 on at

    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!

  • MikeRooker Profile Picture
    364 on at

    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!

  • efialttes Profile Picture
    14,756 on at

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

    You guys make this community great!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard