Others

How to Send a SharePoint Reminder Before a Calculated Date

Steven ParkerSteven Parker Nov 4, 2026 869 views

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.

How to Send a SharePoint Reminder Before a Calculated Date
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.
Before you start

Ensure you have the necessary permissions to create flows in Power Automate and edit columns within your target SharePoint list.

Solution 1Recommended

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.

1
Create a Scheduled Flow

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.

2
Get Items from SharePoint

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.

3
Check the Target Date

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.

4
Send the Email Reminder

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.

5
Prevent Duplicate Notifications

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

Create a Power Automate Scheduled Cloud Flow
Date Format Consistency: Ensure that the date format returned by your SharePoint calculated column matches the date format used in your Power Automate expression (e.g., 'yyyy-MM-dd') so the condition triggers properly.
Free Microsoft Office alternative

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.

Free and lightweight Office suiteFully compatible with Microsoft Word, Excel, and PowerPoint formatsRich built-in templates for business reporting and list trackingFamiliar user interface with a seamless migration experience
microsoft office alternative - wps office

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.