Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jdcfzasOaD54BxZer1YIdR
Power Automate - Building Flows
Unanswered

Email Automation Streamlining

Like (1) ShareShare
ReportReport
Posted on 24 Jul 2024 13:20:41 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,449 Super User 2025 Season 1 on 24 Jul 2024 at 14:49:06
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard
Loading started