Automatically email Form submissions

Microsoft Forms allows you to send email notifications when a response is submitted in the form's Settings under Response receipts:

However, these emails also don't include the results of the submitted form. We can use Power Automate to address this.

Create a new flow from a template

For this case, we can start with a Microsoft-created template to do most of the work for us, then customize it to our needs.

1. Visit the Power Automate template gallery, and then select the template named Notify me in Outlook when a student completes a quiz.
    
2. Sign in with your Stonehill account if prompted, and then click Continue.
    
3. You'll be brought to the Power Automate flow designer, where you'll see your flow's steps (or cards) displayed. You can click on a card to configure it.

Configure the flow

1. Click the first step in the flow, When a new response is submitted, and select your form in the Form Id box.
   
    
2. In the next step in the flow, Get response details, select your form again in the Form Id field. Leave everything else as it is.
   
    
3. Skip the Get my profile (V2) step. If you don't need to send the email to yourself, you can delete this step.
    
4. In the final step in the flow, Send an email, enter the recipients, subject, and body of the email. You can click the dynamic content button (looks like a lightning bolt) to include details from the form response in your email. In the popup that displays, search for the word "Answer" to insert answers from the submitted form into the body of the email.
   
   
    
5. Once finished, select the flow's name at the top of the Power Automate canvas to rename it.
    
6. Click Save. You can also use the Flow Checker to pre-test your flow. Once saved, you'll see a green banner across the top letting you know your flow is ready to test.