Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Send email when a specific response on MS Forms is received?

Like (0) ShareShare
ReportReport
Posted on 19 Jul 2022 16:28:07 by

Hello, 

 

I work for a small mental health charity and am trying to set up a system so their service can be monitored online (vs on paper as it has done until now!) I've never used Power Automate before and am finding it a minefield. 

 

So far we have the monitoring form set up as an MS Form with the responses going into an Excel sheet which is stored on Sharepoint. 

 

I would like to set up two flows so that:

1) The local colleague (inside our organisation) receives an alert when a response is received in their county (question on the form asks which county)

2) The therapist who fills in the form (outside of our organisation) receives an email with the responses on the form. 

 

Is this possible? & where do I start please?

 

Any help is greatly appreciated. 

 

Many thanks, 

 

Claire 

  • ScottShearer Profile Picture
    25,223 Most Valuable Professional on 19 Jul 2022 at 16:43:58
    Re: Send email when a specific response on MS Forms is received?

    @clairebear1 

    I suggest storing the email addresses of the local colleagues along with their county somewhere - either in an Excel table or in a SharePoint list.  You can lookup the county and email address when a new Form comes in and store the email in a variable.  Use that variable in the email TO: line.

    You can use a Office 365 Outlook send an email action to send an email to the responder along with the responses provided that you ask for their email in the Form.

    If you tell me where you want to store the County info, I'll provide an example if you need it.

     

     

     

  • Pstork1 Profile Picture
    66,154 Most Valuable Professional on 19 Jul 2022 at 16:39:19
    Re: Send email when a specific response on MS Forms is received?

    Yes, it should be possible.  You'll use the When a form response is submitted trigger followed by a get response detail action.

    1) You will need a data source somewhere that can be used to cross reference the local colleague with the county. then use the county answer to find the email of the local colleague and send them an email.

    2) This is a bigger problem.  If the therapist is outside your org then the form was submitted anonymously, which means the email of the submitter is not included automatically.  So you'll need to add a question to the form for the therapist to add their email.  Then use that answer to send an email back to them.

     

    It will look something like this

    image.png

     

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!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 79

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started