How to Send a SharePoint Reminder Before a Calculated Date
Question details
The user needs to trigger an automated email reminder 14 days before a specific date that is generated by a SharePoint calculated column.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Automating email notifications based on a dynamically calculated date within a SharePoint list.
- Observed behavior
- SharePoint does not natively offer a built-in reminder option for calculated date columns, requiring an external automated flow to achieve the goal.
Ensure you have the necessary permissions to create flows in Power Automate and edit columns within your target SharePoint list.
Create a Power Automate Scheduled Cloud Flow
Build a daily scheduled flow in Power Automate to check the calculated column and send an email if the target date is exactly 14 days away.
Since SharePoint's native reminder feature does not support calculated columns, you must use Microsoft Power Automate. By creating a flow that runs once a day, you can check every item in your list and send a notification when the condition is met.
Go to Power Automate, click on 'Create' in the left menu, and select 'Scheduled cloud flow'. Name your flow and set it to repeat every 1 day.
Add a new action and search for 'Get items' (SharePoint). Select your Site Address and List Name. To optimize the flow, you can use an OData Filter Query to exclude items that already had a reminder sent.
Add an 'Apply to each' loop using the 'value' dynamic content from the previous step. Inside the loop, add a 'Condition' action to check if the calculated date equals today plus 14 days. Use the expression addDays(utcNow(), 14, 'yyyy-MM-dd') for the comparison.
In the 'If yes' branch of your condition, add the 'Send an email (V2)' action. Fill in the 'To', 'Subject', and 'Body' fields using dynamic content from your SharePoint list to customize the message.
To avoid sending the same email every day, add an 'Update item' action immediately after the email action. Update a dedicated Yes/No column in your list (e.g., 'ReminderSent') to 'Yes'.

Boost Your Productivity with WPS Office
While SharePoint and Power Automate handle your complex automated lists, you can manage your daily documents, spreadsheets, and presentations efficiently with WPS Office—a lightweight and free alternative fully compatible with Microsoft Office formats.

Frequently Asked Questions
Why doesn't the built-in 'Set a reminder' work for calculated columns?
SharePoint's native 'Set a reminder' feature only works with standard Date and Time columns. It does not support calculated columns because their values are computed dynamically, which is why a Power Automate flow is required to bridge the gap.
How do I prevent Power Automate from sending duplicate emails every day?
You can add a Yes/No column (e.g., 'Reminder Sent') to your SharePoint list. After the email is sent in your flow, use an 'Update item' action to change this column to 'Yes', and then filter out 'Yes' items at the beginning of the flow.
Can I customize the number of days before the reminder is sent?
Yes. In your Power Automate flow condition, you can easily change the addDays() expression to match your desired timeframe, such as changing it to addDays(utcNow(), 30) if you need a 30-day reminder.




