How to Trigger a Rule When a Calculated Column Changes in Microsoft Lists
Question details
The user needs to trigger an automated email to the item creator when a calculated date column changes, but the calculated column is not available in the rules menu.

- Product
- Microsoft Lists / SharePoint
- Device & OS
- not provided
- Scenario
- Creating an automation rule in Microsoft Lists to notify users based on calculated date changes.
- Observed behavior
- Calculated columns do not appear in the list of available columns when setting up a 'column value changes' rule natively in Microsoft Lists.
Ensure you have access to Microsoft Power Automate with the appropriate permissions to create and manage workflows for your specific SharePoint site or Microsoft List.
Use Power Automate to Trigger the Email Notification
Since native list rules do not support calculated columns as triggers, building a simple Power Automate flow provides a reliable workaround.
Calculated columns derive their values dynamically on the fly, meaning they do not generate standard update events in the background that Microsoft Lists rules can detect natively. To solve this, Power Automate can monitor the underlying fields that make up the calculation and send the email when those base columns change.
Open Microsoft Power Automate, click on 'Create' from the left sidebar, and select 'Automated cloud flow'.
Choose the SharePoint trigger 'When an item or a file is modified'. Enter your Site Address and select your specific List Name from the dropdown menu.
Click 'New step' and add a 'Condition' control. Set the condition to evaluate the base columns that affect your calculated date (for example, monitor if 'Work start date' has changed).
In the 'If yes' branch, add the 'Send an email (V2)' action. Click inside the 'To' field and use the dynamic content menu to select the 'Created By Email' token.
Save your flow. Go back to your Microsoft List, modify the base date to force the calculated column to change, and verify that the creator receives the automated email.

Verify Column Types in a Test List
Determine if the issue is a list-corruption problem or a strict platform limitation by testing standard vs. calculated columns in a blank list.
Enhance Your Daily Productivity with WPS Office
While Microsoft Lists and Power Automate handle complex web automations, WPS Office provides a free, lightweight, and incredibly fast alternative for your everyday document, spreadsheet, and presentation needs. Enjoy full compatibility with Microsoft Office formats in a familiar, user-friendly interface.

Frequently Asked Questions
Why do calculated columns not trigger Microsoft Lists rules natively?
Calculated columns are evaluated on the fly when the list is viewed. Because their values aren't strictly updated in the database the way standard text or date columns are, they do not fire the background system events required to trigger standard list rules.
Can I send an email alert based on a date in SharePoint without Power Automate?
Yes, to a limited extent. While standard list rules may not support calculated triggers, you can set alerts natively using the 'Automate' > 'Set a reminder' feature on standard date columns to notify users before a deadline.
What permissions are needed to create a Power Automate flow for a Microsoft List?
You need 'Edit' or 'Design' permissions on the specific Microsoft List or SharePoint site to create and attach a Power Automate flow that monitors list item changes.
Will modifying the source column update the calculated column instantly?
Yes, when you modify the underlying base columns (like a 'Start Date'), the calculated column updates immediately in the view. Power Automate can detect this item modification and evaluate the new result.




