You’re offline. This is a read only version of the page.
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
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)
Share
Report
All responses (
Answers (
12,908
