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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard