The Flow that is triggered is based on a status value field. On status of Complete, I have it send an email to the user then delay for 7 days before archiving the list item and deleting. A requirement is needed to be able to change the status to Reopened. If I do this, a new Flow run happens as expected. What I would like to be able to do is cancel the previous Flow based upon the status value of Reopen.
Insert a Get Item action after the delay in your Flow and retrieve current data from the list item. If the value of the Status is Reopen, use a control terminate action (with success) and end the Flow. Otherwise, proceed and archive/delete the item.
Let me know if you need an example.
@ScottShearer I get what you are saying here, I just don't believe it is going to work for my situation. I've setup a switch step for the status value to run on Complete. The delay step is there to write a value to another list after 7 days and then delete this item. If someone changes the status from Complete to Reopen, the Flow will not know about that and will run a new instance leaving this one running the delay. The thing with this one is that the status will go from Reopened back to closed which will trigger this process again.
Will this work in a switch case? It's looking at Completed, not Reopened. I might be just overthinking this. If you still have an example, please send it to me. This it what my steps look like.
Please take a look at the screen shots below and let me know if you have additional questions.
I added this step but it still will not work. What happens is that when the status goes from Reopend back to Closed, a new Flow process kicks off and the old Flow is still running. I need to have it check an ID somewhere and terminate the orininal Flow.
Please post a screen shot of your Flow in Design view as currently configured.
Thanks for all of the assistance with this. I decided to punt and just remove all of the steps from the schedule to deletion of the list item. I created a new Flow that will run a daily check to see if there are any 'Completed' list items older than 7 days and it will copy those to a secondary list and delete the source items. Thanks again for your responses.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!