How to Automatically Send an Email When Microsoft Forms Answers Are No
Question details
The user wants to set up automated email notifications for specific answers (like 'No') submitted in a Microsoft Form.

- Product
- Microsoft Forms and Power Automate
- Device & OS
- not provided
- Scenario
- Creating conditional automated workflows for form submissions, such as safety inspections where a 'No' requires immediate attention from a responsible party.
- Observed behavior
- The user needs a step-by-step method to configure a Power Automate flow that filters form responses and triggers an Outlook email based on the specific answer value.
Ensure you have access to both Microsoft Forms and Power Automate with an active Microsoft 365 account, and that your form is fully created and ready to receive responses.
Use Power Automate to Trigger an Email on a Specific Form Answer
Create an automated cloud flow in Power Automate that triggers upon form submission, checks the answer, and sends an email if the condition is met.
Power Automate (formerly Microsoft Flow) is the standard way to bridge Microsoft Forms with Outlook. By setting up a conditional statement in your flow, you can filter incoming responses and only send alert emails when someone selects a specific answer, such as 'No'.
Log in to Power Automate, go to 'Create' in the left menu, and select 'Automated cloud flow'. Name your flow, select 'When a new response is submitted' under Microsoft Forms as the trigger, and click 'Create'.
In the trigger box, select your specific form from the 'Form Id' dropdown. Click 'New step', search for 'Get response details' (Microsoft Forms), select it, and map it to your chosen Form Id and Response Id using the dynamic content menu.
Click 'New step' and select the 'Condition' control. In the 'Choose a value' field on the left, select the specific question from your form using the dynamic content list. Set the operator in the middle to 'is equal to', and type 'No' (or your target answer) in the right field.
Inside the 'If yes' branch, click 'Add an action' and search for 'Send an email (V2)' (Office 365 Outlook). Fill in the recipient's email address in the 'To' field, and customize the Subject and Body. You can insert dynamic content (like the respondent's name or other form answers) directly into the email body.
Click 'Save' at the bottom or top right. Once saved, open your Microsoft Form and submit a test response where the answer is 'No' to verify that the flow runs successfully and the email is delivered to the correct recipient.

Boost Your Productivity with WPS Office
While Microsoft Forms and Power Automate handle your online surveys and automated workflows, you can seamlessly manage all your exported form data, reports, and daily documents using WPS Office. It is a highly compatible alternative to Microsoft Office that is free, lightweight, and incredibly easy to use.
- 1. Export Data from Microsoft Forms: Open your Microsoft Form, navigate to the Responses tab, and click 'Open in Excel' to download your response data as an .xlsx file.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded Excel file. You can now sort, filter, and analyze your form responses seamlessly without needing a paid Microsoft Office subscription.

Frequently Asked Questions
Can I send notifications to multiple people based on a Microsoft Forms answer?
Yes, in the 'Send an email (V2)' action within your Power Automate flow, you can add multiple email addresses in the 'To' field by separating them with a semicolon (;).
Why isn't my Power Automate flow triggering when a form is submitted?
Ensure that your flow is turned on and that the correct Form ID is selected in the trigger action. Also, check the flow run history for any connection errors with Microsoft Forms or Office 365 Outlook.
Can I include the respondent's other answers in the automated email?
Absolutely. When configuring the email body in the 'Send an email' action, use the 'Dynamic content' menu to insert specific responses or the respondent's email directly into your message.
Do I need a premium license to connect Microsoft Forms and Outlook in Power Automate?
No, both the Microsoft Forms and Office 365 Outlook connectors are standard connectors. They can be used with most basic Microsoft 365 business, enterprise, or educational licenses without an extra premium add-on.




