SharePoint Document Issues

How to Trigger a Rule When a Calculated Column Changes in Microsoft Lists

Elise WilliamsElise Williams Nov 4, 2026 869 views

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.

How to Trigger a Rule When a Calculated Column Changes in Microsoft Lists
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.
Before you start

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.

Solution 1Recommended

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.

1
Create an automated cloud flow

Open Microsoft Power Automate, click on 'Create' from the left sidebar, and select 'Automated cloud flow'.

2
Set the trigger

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.

3
Add a condition

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).

4
Configure the email action

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.

5
Save and test

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.

Use Power Automate to Trigger the Email Notification
Alternative Automation: If you strictly need to check the date itself, you can create a 'Scheduled cloud flow' that runs daily, uses 'Get items' to find records where the calculated date matches your criteria, and emails the creators.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight design ensures fast loading times even on older devices.Built-in robust spreadsheet formulas to calculate dates and manage tabular data easily without complex list setups.Free to use with a familiar UI, requiring zero learning curve for easy migration.
microsoft office alternative - wps office

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.