Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Continuous Reminder Until Status Change

I am trying to build a flow which will send continuous reminders until condition/status is changed.  For example, If status is 'Out"  I want to send first reminder based on the due date provided in the sharepoint list, but after the due date is passed, every 8 hours a reminder should be sent until the status is changed to 'IN'. 


In the SharePoint Designer we have 'Wait for the status to change' Can I achieve something similar here?

Is there any limit until the flow will continue to run e.g. Delay until return date (could be 30 days after flow actually started) and then continue to run until status is changed which could be another 30 days?




Community Support
Community Support

Hi @smerchant,


Could you please share a bit more about your SharePoint list?

Could you please explain a bit more about “Wait for the status to change”?

Further, do you want to send only one reminder if the due date is not passed?

I afraid that there is no way to achieve this within one flow in Microsoft Flow currently. You could consider create two separated flows:

  • Status is “Out” and due date is not passed:12.JPG

     Within Condition box, click “Edit in advanced mode”, type the following formula:

@and(equals(items('Apply_to_each')?['Status']?['Value'], 'Out'),lessOrEquals(formatDateTime(items('Apply_to_each')?['Due_x0020_Date'], 'MM/dd/yyyy'), utcNow('MM/dd/yyyy')))


  • Status is “Out” and due date is passed:13.JPG

     Within Condition box, click “Edit in advanced mode”, type the following formula:

@and(equals(items('Apply_to_each')?['Status']?['Value'], 'Out'),greater(formatDateTime(items('Apply_to_each')?['Due_x0020_Date'], 'MM/dd/yyyy'), utcNow('MM/dd/yyyy')))


There are some limits for a single flow run, please check the following document:

Run duration and retention



Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


@v-xida-msft Thanks Kris.  I think I can compare my scenario to: equipment loan process.  Let's say if the item is on Loan. First reminder after it reaches Return Date/Time given in the SharePoint list. However, if the item is not returned (status is still 'on Loan') by the specified date it should send reminders every other day until the item is returned i.e. status changed to 'returned'.   Here is a screenshot.  The Do Until action only run once and get successful.  I want to repeat the actions as long as the status is 'On Loan'.  I am not  sure what it is wong with this?



Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (38,184)