How to Send Different Emails Based on SharePoint Choice Changes
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.

- 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.
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.
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.
Log into Power Automate, click 'Create', and select 'Automated cloud flow'. Choose the 'When an item or a file is modified' SharePoint trigger.
Select your target Site Address and List Name from the dropdown menus to connect your flow to the correct SharePoint list.
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.
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').
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.

Use Multiple Condition Actions
Alternatively, you can use standard 'Condition' statements if your workflow requires more complex logic alongside checking the choice value.
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. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and launch: Run the installer, follow the on-screen prompts, and open WPS Office to start managing your documents immediately.

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.




