Continuous Reminder Until Status Change

[smerchant]

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?

Thanks,

S

[v-xida-msft]

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:

   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:

   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,

Kris

[smerchant]

.  

[smerchant]

@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?