Others

How to Send Reminders After 10 Days Using Power Automate Date Formulas

Kushani Nimanthika Oct 1, 2026 868 views

Question details

The user needs to configure a Power Automate flow to send automatic reminders based on specific date conditions in a SharePoint list.

How to Send Reminders After 10 Days Using Power Automate Date Formulas

Product: Power Automate
Device & OS: not provided
Scenario: Setting up a scheduled workflow to find SharePoint list items where a primary date is at least 10 days old and a secondary review date field is still empty.
Observed behavior: The user requires an exact formula syntax to filter items that are exactly 10 days old, or 10 or more days old, without triggering on items that have already been reviewed.

Before you start

Ensure you have active connections to your SharePoint list and your email provider in Power Automate, and double-check the exact internal names of your date columns.

Solution 1Recommended

Use an Advanced Filter Array Formula

Combine multiple conditions into a single Filter array action using logical expressions to accurately evaluate empty fields and calculate the 10-day difference.

Instead of chaining multiple Filter array actions together, you can optimize your flow by using a single Filter array in advanced mode. This approach uses the '@and' logical function to check both conditions simultaneously: whether the secondary date is empty, and whether the primary date matches the 10-days-ago calculation.

When comparing dates, it is critical to strip the timestamp down to just the date format ('yyyy-MM-dd'). Comparing full timestamps (including hours and minutes) will almost never yield a perfect match.

Retrieve SharePoint List Items

Add a 'Get items' action pointing to your specific SharePoint site and list where the dates are stored.

Add a Filter Array Action

Add a 'Filter array' step. In the 'From' field, insert the dynamic 'value' array output from the 'Get items' step.

Insert the Exact Date Match Formula

Click 'Edit in advanced mode' in your Filter array and paste the following expression: @and(equals(empty(item()?['PSReviewDate']), true), equals(formatDateTime(item()?['ReturntoPMDate'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), -10), 'yyyy-MM-dd')))

Modify for '10 or More Days' (Optional)

If you need reminders for items that are 10 OR MORE days old, replace the second 'equals' function with a 'lessOrEquals' function to evaluate if the SharePoint date is older than your 10-day benchmark.

Configure the Reminder Action

Add an 'Apply to each' loop using the Body output from the Filter array, and place your 'Send an email' action inside it to notify the relevant managers.

Time Zone Considerations: The utcNow() function uses Coordinated Universal Time. Depending on your geographic location, you may need to use the convertTimeZone() function to prevent date calculation errors around midnight.

Free Microsoft Office alternative

Analyze Exported SharePoint Data Seamlessly with WPS Office

While Power Automate runs your background reminders, managing complex SharePoint list exports and drafting professional communication is easier with WPS Office. As a free, lightweight alternative to Microsoft Office, it handles your project spreadsheets and reminder templates with perfect compatibility.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the Suite: Run the setup file and follow the standard installation prompts to install the suite on your device.
3. Open Your Project Data: Export your SharePoint list to CSV or Excel, and instantly open it in WPS Spreadsheet to analyze overdue reviews effortlessly.

Completely free and lightweight Office suite alternativeFully compatible with Microsoft Excel, Word, and PowerPoint file formatsFamiliar ribbon user interface allows for a seamless transitionBuilt-in PDF tools for comprehensive document generation and management

microsoft office alternative - wps office

Frequently Asked Questions

How do I check if a SharePoint date column is empty in a Power Automate expression?

You can use the empty() function. For instance, writing empty(item()?['YourColumnName']) will evaluate to 'true' if the field has no data in it.

Why is my Filter array not catching items that are exactly 10 days old?

This is usually caused by comparing full datetime strings. Ensure you are using formatDateTime() to strip the time components, comparing only 'yyyy-MM-dd' for both the SharePoint column and your 10-day calculation.

Can I use OData filter queries directly in the 'Get items' action instead of a Filter array?

Yes, using OData filters directly in 'Get items' is a best practice for performance because it limits the data retrieved. However, OData date calculations and empty field checks can be syntactically complex, which is why a separate Filter array is often preferred for advanced multi-condition logic.

How can I adjust my automated date formula for my specific time zone?

Instead of relying solely on utcNow(), wrap it in the convertTimeZone() function within your expression. This ensures the 10-day subtraction accurately aligns with your local calendar days.

Office Quick Solutions