How to Create Customized SharePoint Status Change Email Alerts
Question details
The user needs to automatically send customized email notifications to specific individuals when a SharePoint list item's status changes (e.g., to Quote Ready), with dynamic email subjects based on the item name and new status.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Managing workflow statuses in a SharePoint list and needing targeted communication based on specific status updates.
- Observed behavior
- The user wants to automate customized email generation with dynamic content based on specific SharePoint list triggers, replacing the limited default SharePoint alert functionality.
Ensure you have appropriate Owner or Member permissions to edit the target SharePoint list and have access to Microsoft Power Automate with an active Microsoft 365 account.
Use Microsoft Power Automate to Build a Status-Triggered Flow
Power Automate is the standard Microsoft 365 method for capturing SharePoint list changes and sending highly customizable emails based on complex conditional logic.
By connecting your SharePoint list to Power Automate, you can create a background flow that continuously listens for item modifications. You can then use a Condition control to check if the status column has changed to a specific value, like 'Quote Ready', and utilize dynamic content to populate the email subject and body dynamically.
Log into Microsoft Power Automate, go to 'Create' on the left sidebar, and select 'Automated cloud flow'.
Name your flow, search for and select the trigger 'When an item or a file is modified' (SharePoint), then click Create. Enter your specific SharePoint Site Address and select the List Name from the dropdowns.
Click 'New step' and choose 'Condition'. In the condition settings, choose the 'Status Value' dynamic content, set the operator to 'is equal to', and type 'Quote Ready' (or your required status) in the right field.
In the 'If yes' branch, click 'Add an action' and search for 'Send an email (V2)'. Enter the specific recipient's email address in the 'To' field.
Click into the 'Subject' field and use the dynamic content pane to insert the 'Item Name' and 'Status Value' variables, combined with your custom text. Fill out the email body with any other relevant dynamic list data, then save the flow.
Seamlessly Manage Your Documents with WPS Office
While SharePoint and Power Automate handle complex backend workflows, you still need a robust, reliable suite to create, edit, and review the actual documents (like Quotes and Invoices) attached to those lists. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office for all your document processing needs.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open SharePoint Documents: Open your synced SharePoint local folders or download the specific document attached to your SharePoint list.
- 3. Edit with Ease: Make adjustments to your quotes, spreadsheets, or presentations using the familiar WPS interface.
- 4. Save and Sync: Save your work in standard Microsoft formats directly back to your synced SharePoint directory.
Frequently Asked Questions
Can I send different emails to different people based on the exact status?
Yes. In Power Automate, you can use a 'Switch' control instead of a simple 'Condition'. A Switch allows you to create multiple branches for different status values (e.g., 'Quote Ready', 'In Review', 'Approved') and specify entirely different recipients and message templates for each branch.
Why is my Power Automate flow triggering in a continuous loop?
This usually happens if your flow updates the SharePoint item itself (e.g., changing a field after sending the email), which inadvertently triggers the 'When an item is modified' event all over again. To prevent this, use Trigger Conditions in the settings of your trigger step to only fire when specific fields change.
How do I get the previous status value to compare it with the new one?
To compare the old and new status, you need to turn on Versioning in your SharePoint list settings. Then, in Power Automate, use the 'Get changes for an item or a file (properties only)' action right after your trigger to determine exactly which columns were changed before sending the customized email.
Are SharePoint out-of-the-box alerts sufficient for this task?
No. While SharePoint's built-in 'Alert Me' feature can notify users of general list changes, it does not allow for deep customization of the email subject, dynamic insertion of item names, or complex conditional routing based on specific status values. Power Automate is required for this level of customization.
