Others

How to Use Power Automate to Send Emails Based on SharePoint Choice

Maira Mehtab Sep 24, 2026 869 views

Question details

The user needs to configure a Power Automate flow to send emails to different recipients depending on the selection in a SharePoint choice column.

Product: Power Automate
Device & OS: not provided
Scenario: Automating email notifications based on specific criteria or selections made in a SharePoint list choice column.
Observed behavior: The user wants to dynamically route emails to different recipients based on specific choice values such as Red, White, or Blue.

Before you start

Ensure you have owner or edit permissions for the SharePoint list and a valid Power Automate license to create automated cloud flows.

Solution 1Recommended

Create a Conditional Power Automate Cloud Flow

Set up a flow triggered by SharePoint item creation or modification, routing emails using condition checks.

By utilizing the 'Condition' or 'Switch' actions in Power Automate, you can evaluate the exact value chosen in your SharePoint choice column and execute specific email actions for each branch.

Create an automated cloud flow

Configure the SharePoint trigger

Choose the SharePoint trigger 'When an item is created or modified'. Connect it to your target Site Address and select the specific List Name.

Add a condition or switch

Click 'New step' and add a 'Condition' or 'Switch' action. Set it to evaluate the choice column value (e.g., verify if the Choice Column Value is equal to Red, White, or Blue).

Configure the email action

Inside the corresponding matching branch, add the 'Send an email (V2)' action. Specify the unique recipient address for that specific choice value and customize the email subject and body.

Save and test

Repeat the email setup for any remaining choice branches. Click 'Save' in the upper right corner, then select 'Test' to manually trigger the flow by adding a new item to your SharePoint list.

Select the Choice Value: When setting up your condition, ensure you select the 'Value' property of the choice column from the Dynamic Content menu rather than just the column name itself to ensure accurate comparisons.

Free Microsoft Office alternative

Enhance Your Productivity with WPS Office

While Power Automate handles your SharePoint workflows, consider WPS Office as a free, lightweight, and easy-to-use alternative for managing your daily documents, spreadsheets, and presentations.

1. Download the software: Visit the official WPS Office website and click on the free download button.
2. Install and launch: Run the installer package and open WPS Office once the installation is complete.
3. Open your documents: Easily open, edit, and save your existing Microsoft Office files without formatting issues.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation with a familiar, easy-to-navigate user interface.Seamless migration for all your daily office documentation tasks.Free access to essential office tools, including advanced PDF editing.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use a Switch control instead of nested Conditions in Power Automate?

Yes, using a 'Switch' action is often more efficient than nested conditions when checking a single variable against multiple specific values, like a SharePoint choice column with Red, White, and Blue options.

Why isn't my Power Automate condition recognizing the SharePoint choice value?

Ensure you are using the Choice Column 'Value' from the dynamic content list rather than the object itself. Choice columns return an object, so comparing the raw object to a text string will fail.

Do I need a premium license to use the 'Send an email (V2)' action?

No, the standard 'Send an email (V2)' action via Office 365 Outlook is included in most standard Microsoft 365 plans and does not require a standalone premium Power Automate license.

Office Quick Solutions