Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Email Automation Streamlining

(1) ShareShare
ReportReport
Posted on by 2
I've made a flow that sends an email to various inboxes based on a microsoft form submission but I'm hoping there's a better way. The form is currently setup so that each submission picks from a multiple choice question what mailing lists they'd like to be added to, among other questions. Then the flow sends a copy of their responses to the leadership for whatever group(s) were selected. There are a number of groups and at the moment I have a parallel condition for each group, which, while it works, is a very cumbersome and slow process to edit and puts a strain on my outbox if it needs to send 20+ individual emails per response with potentially hundreds of responses in quick succession. Is there a way to instead change the "To:" input for the "send email v2" action so it's one email but to variable recipients based on the form selections? Or if anyone has a better idea, I'm all ears. I attached a photo of what I've slapped together so far, I zoomed in to about a third for legibility but the real one has even more parallel actions.
  • narayan225 Profile Picture
    2,513 Super User 2025 Season 1 on at
    Email Automation Streamlining
    It totally depends on the form you have created. If you have an option where the user selects a group. You can then use that value to find a group with the matching name or any other condition and get the email address from there and send an email.
     
    I have done similar but for users rather than the group. For group, you might need to use Microsoft Graph.
     
     
    After you have found the group, you can then get the owner and then so on.
     
    Hope it helps.
     
    Cheers!

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492