web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Overdue item reminder

(0) ShareShare
ReportReport
Posted on by

I'm needing to create a flow in my SharePoint list to send a reminder after the date in the "Feedback Review Due Date" has passed if the "Contact Centre Submitter" column is blank I'm wanting the flow to run/send a reminder every 2 days until the "Contact Centre Submitter" column is filled 

I have the same question (0)
  • David_MA Profile Picture
    12,497 Super User 2025 Season 2 on at
    Re: Overdue item reminder

    This isn't too difficult. You would use a scheduled flow that runs every two days. Then the first action will be to get the items from your SharePoint list. You will want to use a filter query, so it only pulls the items that meet your criteria (review date is less than (lt) the current date and the contact submitter is empty). If you don't know about filter queries, there are plenty of posts on how to use them including Every Power Automate (MS Flow) Filter Query You Ev... - Power Platform Community (microsoft.com).

     

    After the get items action you'll want to include a condition to make sure that items were found meeting the criteria. You can use the length expression on the items from the get items action. The condition would be where the length expression is greater than 0 (zero).

     

    Then on the yes side, add an Apply to each action with the items from the Get items action and send the reminder.

     

    If you need more information, this is a good post from @ScottShearer on how to do this: Sending a Reminder Email from a SharePoint List - Power Platform Community (microsoft.com)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard