Power Automate Send Email Based on Form Response

Are you working on Microsoft forms to send emails based on responses? Recently, I got a requirement to send an email to responder when response submitted in Microsoft Forms.

In this tutorial, I will explain how to send email based on form response in Power Automate.

Follow along with me step by step.

Create a New Microsoft Form for Sending Email Based on Form Response

First, I will begin with creating a Microsoft Form. To create a new Microsoft Form, go through the below steps:

• Click on App Launcher; Select Explore all your apps. Then, Choose and select Forms from the Apps window.
• Click on +New form to create a new form in the Microsft Forms.
• Inside the Microsoft Form, Provide the Title and add details in the table below, as shown in the image below.

I have a Microsoft Form, i.e., Training Feedback, consisting of below questions and question type form as shown below:

The Microsoft form looks like below:

Here is the requirement:

• If a user responds to Technology as SharePoint -> Send email to SharePoint trainer (Miriam Graham)
• If a user responds to Technology as Power Platform -> Send email to Power Platform trainer (Patti Fernandez)

Now, we will create a flow using Power Automate to send an email to the responder when the response is submitted in Microsoft Forms.

Power Automate send email when form is submitted

Here, we will send an email to the responded when a new response is submitted in the Microsoft Forms.

Scenario:

When a new response is submitted in the Microsoft form [Training Feedback], the responder will get an email notification about successfully submitting the Training feedback form.

Follow the below steps to implement the flow.

1. Open the Power Automate home page in your browser, click + Create -> Select the Automated cloud flow -> Provide the flow name, and choose the trigger’s flow (When a new response is submitted) -> Click Create button.

• Form Id: Select the Microsoft Form you created from the drop-down.

2. Then, add the Get response details flow action to retrieve the responses submitted in the Microsft Form.

Give the following details:

• FormId: Select value from the drop-down menu.
• Response Id: Click the field -> Take Response Id from the dynamic content.

Then, For each loop will be added automatically.

3. Next, add Send an email(v2) flow action. Configure the below parameters:

• To: Provide the email address of the responder from dynamic content.
• Subject: Enter a subject line for mail
• Body: Provide detailed description of the mail.

4. After the flow is completed, Click on Save and Test the flow Manually.

5. When a new response is submitted to the Microsoft form [Taining Feedback], the flow will trigger and send an email to the responder as below:

This is how to send an email to the responder in Power Automate when a form is submitted.

Power Automate Send email from Microsoft Forms based on Multiple Choice

Let us see how to send email based on the selected choice from the form response in Power Automate.

Scenario:

In the Microsoft Form, if the Trained Technology is selected as ‘Power Automate,’ the feedback email will be automatically sent to the SharePoint trainer (Lidia Holloway and Miriam Graham).

In the same way, the user responds to the trained technology as Power BI; then, the feedback email will be automatically sent to the Power Platforms trainer (Henrietta Muller).

Dive into the following steps!

1. Create an automated cloud flow, Enter the flow name, and choose the trigger When a new response is submitted. Select the Form ID from the dropdown.

Here, I have selected my Training Feedback.

2. Add a new step and choose the Get response details trigger from action triggers and provide the required parameters:

• Form Id: From the dropdown, select the form Id.
• Response Id: From the dynamic content, choose the Response Id.

3. Now, I will check the condition based on trained technology column values.

For that, add a condition control and provide the below condition.

From the dynamic content, select the Trained Technology value.

@outputs('Get_response_details')?['body/r126e601e39a74b9aae56b9e1cb44185d']

4. Under If yes condition, select the Send an email (V2) action and provide the required parameters.

• To – Pass the SharePoint trainer email address.
• Subject – Enter the subject of the mail.
• Body – Enter the body of the mail.

5. Under If No condition, I will take another condition control.

Add the condition like below:

6. If yes, then select the Send an email (V2) action and configure the required parameters.

• To – Give the SharePoint trainer an email address.
• Subject – Enter the subject of the mail.
• Body – Enter the description of the mail.

7. Once the flow is ready, the complete flow looks like the below:

Save and run the flow.

Case-1: (Trained Technology – Power Automate)

The flow will trigger when a new form response is submitted. Fill out the Microsoft form and click the submit button.

Once the flow runs successfully, it will automatically send an email to the assigned trainers like the one below:

Case-2: (Trained Technology – Power BI)

If the submitted response Trained Technology is Power BI, the assigned trainer will automatically get an email about the feedback.

Conclusion

I hope you understand how to send emails based on Microsoft form responses using Power Automate. Following the above steps, you can email to the responder when a response is submitted in Microsoft Forms using Power Automate.

You may also like:

• Power Automate Condition Based on Form Response Example
• Create PDF from Microsoft Forms via Power Automate
• Power Automate Forms to Excel

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.