Here are some of the top scenarios in which you can use Power Automate with forms:
- Send an email when there is a new form response.
- Send an email to the form responder after they submit a response.
- Send an approval with contents of the form.
- Upload Microsoft Forms responses to Excel.
- Get an attachment from a form and send an email with the attachment.
Send an email when there is a new form response
Although you can enable a notification to “Get email notification of each response” within the Microsoft Form settings, you can create a customized email notification with Power Automate.
First, add the When a response is submitted trigger.
If your form is only for people in your organization, that means that the form is automatically recording the responder’s email and you need to use the 'Apply to Each' control. This demo will demonstrate this scenario and require you to choose “List of response notifications Response Id.” However, if your form is public and anyone with the link can respond, you will need to ask for their email as a response in the form and you will not need to add the 'Apply to Each' control.
Then, add the Get response details action. Select Response Id to view the dynamic content. Select the Response Id option, which means that you’ll get the response details for the responses that caused the trigger. After that, choose the Send an email (V2) action. Within the action card, click on Add dynamic content so that you can use the forms responses in your email.
Send an email to the form responder after they submit a response
Although you can enable a notification to Send email receipt to respondents within the Microsoft Form settings, you can create a customized email notification with Power Automate. This is similar to top scenario #1, except the Send an email (V2) action is now being sent to the responder.
Send an approval with contents of the form
Create an approval with dynamic content from the form. In this example, the content will be the feedback, which is denoted by the question “What can we improve about our product?”
After adding the Microsoft Forms trigger and action, the third step is to add the Start and wait for an approval action.
You can view more examples with approvals in the documentation.
Upload Microsoft Forms responses to Excel
Create a new Excel Online sheet and add a table to the sheet. Learn more about tables in the Excel documentation.
You can also add an approval to approve a response before it enters the Excel sheet. The Approve a Microsoft Forms response to add a row to an Excel spreadsheet template can help you do this!
Get an attachment from a form and send it in an email message
Ensure that you’ve added a section in your form for the responder to upload their file.
After adding the Forms trigger and action, add the Parse JSON action. We recommend running the flow before adding this action to generate the JSON schema from a sample.
Once you’ve pasted the full sample, you can Get file content using path from OneDrive and find your Microsoft Form. Then, add a ‘/’ followed by the following expression: first(body('Parse_JSON'))?['id']. This would extract the one file that the responder will be uploading.
Finally, you can send that upload to via email using the Send an email (V2) action card from Office 365 Outlook. Include the expression first(body('Parse_JSON'))?['id']
You can combine the scenario of getting an attachment from a form and creating an approval flow by exploring a blog post here.