cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smerchant
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
v-xida-msft
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,

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.

.  

@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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (5,719)