cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
smerchant
Level: Powered On

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
Community Support Team
Community Support Team

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.
smerchant
Level: Powered On

Re: Continuous Reminder Until Status Change

.  

smerchant
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 212 members 3,560 guests
Please welcome our newest community members: