Others

How to Send Conditional Email Notifications in Microsoft Forms

John Wilson Oct 20, 2026 868 views

Question details

The user wants to configure Microsoft Forms to automatically route email notifications to different recipients based on the specific department or option selected in the form response.

How to Send Conditional Email Notifications in Microsoft Forms Using Logic Routing

Product: Microsoft Forms
Device & OS: not provided
Scenario: Setting up logic-based routing to ensure form responses are sent directly to the relevant support, scheduling, or customer service departments.
Observed behavior: Microsoft Forms does not natively support conditional email notifications to specific recipients, requiring an external workflow solution to handle dynamic logic routing.

Before you start

Ensure you have access to Microsoft Power Automate and SharePoint within your Microsoft 365 environment, as these tools are required to build the logic routing workaround.

Solution 1Recommended

Set Up Logic Routing Using Power Automate and SharePoint

Since Microsoft Forms cannot route emails directly, use a SharePoint lookup list and a Power Automate flow to match form responses to the correct department email.

This method involves storing your routing logic in a SharePoint list. When a form is submitted, Power Automate reads the user's selection, checks the SharePoint list for the corresponding email address, and sends the customized notification.

Create a SharePoint Reference List

Navigate to your SharePoint site and create a new List. Add two columns: one for 'Department' (matching your Microsoft Forms options) and one for 'Email Address' (containing the responsible person's email).

Build a New Power Automate Flow

Open Power Automate and click 'Create' > 'Automated cloud flow'. Select the trigger 'When a new response is submitted' from Microsoft Forms and link it to your specific form.

Retrieve the Form Details

Add a new action called 'Get response details' for Microsoft Forms. Map the 'Form Id' and 'Response Id' to the dynamic content from your trigger.

Match the Department in SharePoint

Add the 'Get items' action from SharePoint. Point it to your reference list and use an OData Filter Query to match the Department column to the department selected in the form response.

Configure the Email Notification

Add a 'Send an email (V2)' action. Because 'Get items' can technically return multiple results, Power Automate will automatically place this inside an 'Apply to each' loop. In the 'To' field, use the expression items('Apply_to_each')?['Email'] to dynamically insert the retrieved address.

Set Up Logic Routing Using Power Automate and SharePoint

Testing Your Flow: Always submit a test response in your Microsoft Form selecting different departments to verify that the emails are routed successfully before sharing the form publicly.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

If you frequently work with forms, data collection, and complex workflows, consider WPS Office. It is a highly compatible, free alternative to Microsoft Office that includes an easy-to-use Form tool for surveys, alongside powerful word processing, spreadsheet, and presentation applications.

1. Download and Install WPS Office: Visit the official WPS website to download the free suite. Installation takes just a few minutes.
2. Create a New Form: Open WPS Office and select 'Form' from the newly integrated dashboard to start building your surveys or data collection forms immediately.
3. Collect and Analyze Data: Share your form via a simple link. Responses are automatically compiled into a WPS Spreadsheet for easy tracking and analysis.

Fully compatible with Microsoft Office formats including Word, Excel, and PowerPointFeatures an integrated WPS Form tool for intuitive data collection and sharingLightweight installation with a tabbed interface to manage all files in one windowFree to use with built-in PDF editing capabilities

microsoft office alternative - wps office

Frequently Asked Questions

Can I route Microsoft Forms responses to multiple emails at once?

Yes. In your SharePoint lookup list, you can input multiple email addresses separated by semicolons into the Email Address column. Power Automate will read this string and send the notification to all included addresses.

Does Microsoft Forms have native email routing rules?

No, natively Microsoft Forms only supports sending generic email receipts to respondents or a standard notification to the form owner. Conditional logic routing requires an integration like Power Automate.

Do I need a premium license to use Power Automate for Forms notifications?

Standard Microsoft Forms, Office 365 Outlook, and SharePoint connectors are included in most base Microsoft 365 business plans. Premium licenses are only required if you route data to premium third-party databases.

Office Quick Solutions