Others

How to Create a Power Automate Reminder for Overdue SharePoint Reviews

Nimra Malik Sep 28, 2026 870 views

Question details

The user wants to create a scheduled Power Automate flow that automatically sends email notifications to risk owners when a SharePoint risk review date is seven days overdue.

How to Create a Power Automate Reminder for Overdue SharePoint Reviews

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Setting up an automated email notification system for tracking overdue items within a SharePoint list.
Observed behavior: The user aims to trigger an automated email when a review is seven days past due, but often encounters setup issues such as failing OData filters, missing row limits, or unavailable dynamic content.

Before you start

Ensure you have the appropriate permissions to edit the target SharePoint list and create scheduled flows in Power Automate. Verify that your list contains a valid Date/Time column for the review date and a Person/Group column for the risk owner.

Solution 1Recommended

Create and Configure the Scheduled Flow in Power Automate

Set up a scheduled cloud flow using the 'Get items' action with an OData filter to identify overdue risk reviews and send an automated email reminder.

By configuring a scheduled flow to run daily, you can automatically query your SharePoint list for overdue items. Utilizing an OData filter ensures that only the relevant records are processed, significantly improving flow efficiency and preventing unnecessary API calls.

Trigger the Flow

Open Microsoft Power Automate, click on 'Create', and select 'Scheduled cloud flow'. Name your flow and set the recurrence to run once every day.

Get SharePoint Items

Add the 'Get items' action to your flow. Select your SharePoint Site Address and List Name from the dropdowns. Click on 'Show advanced options' to reveal additional query fields.

Configure the OData Filter

In the 'Filter Query' field, enter an OData expression to check if the review date is exactly 7 days ago. For example: ReviewDate eq '@{addDays(utcNow(), -7, 'yyyy-MM-dd')}'. Adjust 'ReviewDate' to match the internal name of your SharePoint column. Set a 'Top Count' limit to restrict the number of rows if your list is exceptionally large.

Send Email Notification

Add an 'Apply to each' control and select the 'value' dynamic content from the 'Get items' step. Inside this loop, add the 'Send an email (V2)' action. Populate the 'To' field using the risk owner's email address from the dynamic content, and customize the subject and body.

Create and Configure the Scheduled Flow in Power Automate

Troubleshooting Dynamic Content: If dynamic content fields are missing when setting up your email, ensure your SharePoint list columns are correctly formatted. You may need to save the flow and refresh the page to force the designer to reload the list schema.

Solution 2

Troubleshoot Flow Design in the Power Automate Community

If your flow fails to run or complex dynamic content issues persist, seek expert troubleshooting help in the official community forums.

Free Microsoft Office alternative

Boost Your Daily Productivity with WPS Office

While Power Automate and SharePoint handle your enterprise automated workflows, you still need a reliable suite for your daily document management. WPS Office is a free, lightweight, and highly compatible alternative that seamlessly supports all standard Microsoft Office formats.

1. Download and Install: Get the free WPS Office installer from the official website and run it on your PC or Mac.
2. Open Microsoft Formats: Directly open your existing .docx, .xlsx, and .pptx files exported from SharePoint without losing formatting.
3. Edit and Collaborate: Use the familiar interface to edit documents, analyze data, or prepare presentations instantly without a heavy subscription.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation with blazing-fast startup times for everyday productivity.Familiar user interface ensuring a seamless, zero-learning-curve transition.Built-in, comprehensive PDF editing tools to easily manage your reports and documentation.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my OData filter in Power Automate returning an error?

OData filter errors commonly occur due to syntax mistakes, such as missing single quotes around dates or using incorrect column names. Ensure your column names in the filter query exactly match the internal SharePoint column names, which may differ from their display names.

How do I fix missing dynamic content in my Power Automate email action?

If dynamic content from the 'Get items' action is not showing up, the flow designer might not have recognized the SharePoint list schema. Try saving your flow, refreshing the browser, or utilizing a 'Parse JSON' action to explicitly define the expected fields.

Can I send one summary email instead of individual emails for each overdue review?

Yes. Instead of placing the 'Send an email' action inside an 'Apply to each' loop, you can add a 'Create HTML table' action to compile all returned items from the 'Get items' step into a single table. You can then insert this table into a single 'Send an email' action outside the loop.

Why does my flow run successfully but no emails are sent?

This typically happens if the 'Get items' action returns zero results. Check your OData filter query to ensure the calculated date exactly matches the data format stored in your SharePoint list. You can remove the filter query temporarily to test if the connection and email actions are working correctly.

Office Quick Solutions