cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

 

Thanks,

S

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Continuous Reminder Until Status Change

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,

Kris

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.
Highlighted
Helper I
Helper I

Re: Continuous Reminder Until Status Change

.  

Highlighted
Helper I
Helper I

Re: Continuous Reminder Until Status Change

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

 

Screenshot_5.png

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (8,487)