Others

How to Send Different Emails Based on SharePoint Choice Changes

Rana GarciaRana Garcia Nov 3, 2026 869 views

Question details

The user needs to configure an automated workflow that sends distinct email notifications depending on the updated value of a choice column in a SharePoint list.

How to Send Different Emails When a SharePoint Choice Changes
Product
Power Automate
Device & OS
not provided
Scenario
Automating email workflows based on specific item modifications in a SharePoint list.
Observed behavior
Requires a reliable method to trigger separate emails for 'Shared', 'Ended Share', or 'New' choice values.
Before you start

Ensure you have the necessary permissions to edit the target SharePoint list and that you are logged into Microsoft Power Automate with an account authorized to send emails.

Solution 1Recommended

Configure a Power Automate Flow using a Switch Action

The most efficient way to handle multiple choice outcomes in SharePoint is by utilizing a Switch control in Power Automate.

A Switch action evaluates a single variable (in this case, your SharePoint choice column) and executes different branches of logic based on its exact value. This keeps your flow organized and prevents the need for deeply nested conditions.

1
Create an automated cloud flow

Log into Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the 'When an item or a file is modified' SharePoint trigger.

2
Connect to your SharePoint list

Select your target Site Address and List Name from the dropdown menus to connect your flow to the correct SharePoint list.

3
Add a Switch control

Click 'New step', search for 'Switch', and select the Switch control action. In the 'On' field, insert the dynamic content corresponding to your choice column.

4
Set up case branches

Create a separate 'Case' branch for each exact choice value (e.g., type 'Shared' for the first case, add another case for 'Ended Share', and a third for 'New').

5
Add email actions to each branch

Within each case block, add a 'Send an email (V2)' action. Customize the recipient, subject, and body text to match the specific choice value of that branch.

Configure a Power Automate Flow using a Switch Action
Exact Match Required: Ensure the text you type into the 'Equals' field of your case branches matches the SharePoint choice values exactly, including spaces and capitalization.
Free Microsoft Office alternative

Boost Your Daily Productivity with WPS Office

While Power Automate handles your background workflows and SharePoint triggers, you still need a reliable tool to manage your daily documents. WPS Office provides a lightweight, robust, and completely free alternative for handling your spreadsheets, documents, and presentations.

  1. 1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install and launch: Run the installer, follow the on-screen prompts, and open WPS Office to start managing your documents immediately.
Easily open, edit, and review Microsoft Office files generated or downloaded from your SharePoint automations.Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation with a highly familiar, easy-to-navigate tabbed interface.Seamless cross-device synchronization for PC, Mac, iOS, and Android.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Power Automate flow triggering in an infinite loop?

If your flow updates the exact same SharePoint item that originally triggered it, it will trigger the flow again. To prevent this infinite loop, use Trigger Conditions in your flow settings to ensure it only runs when specific criteria are met.

Can I send emails to different users based on the SharePoint choice?

Yes. Within each branch of your Switch or Condition action, you can populate the 'To' field in the 'Send an email' action with different static email addresses, or use dynamic content to pull specific user emails from your SharePoint list.

What happens if the choice column in SharePoint is left blank?

If the choice column is blank, the flow will route to the 'Default' case branch inside a Switch action. You can configure this default branch to send an error notification, alert an administrator, or simply leave it empty to do nothing.