Forum Discussion
How to update running Power Automate Flows
- Dec 04, 2019
WHSteve I would create a flow using a trigger of reoccuring, and set the flow to run once/day.
First step - have it get all items that were created 7 days ago that aren't completed, and send the reminder if the modified date is the same as the created date
Then next step, maybe get all non completed items again for 10 days in the past, check for changes/completions and escalate.
Or something along those lines...
Totally agree with you ChrisWebbTech and Damien_Rosario ! And we do avoid using perma-run flows where possible. I guess the better question is: Is there a way to trigger a Power Automate Flow a week after creation of a record (and then again 3 days after that) without it actually running in the intervening time... this would avoid the issues caused by "perma-running" workflows.
Please consider this use case for your consideration... Reminders - This is the actual use case that drove the question:
- When a user is added to the TrainingTracker list, we kick off a workflow that tells the user where to access the training and when it must be completed by
- Then the workflow sleeps for a week
- When the workflow wakes up, it checks the status. If training is completed, it ends. If there have been no changes, it sends a reminder/escalation email
- Then the workflow sleeps for 3 days
- When the workflow wakes up, it checks the status. If training is completed, it ends. If there have been no changes, it sends an escalation email
- etc. (there are more steps, but it will send reminders until the training is completed
The above workflow works great and has been effective in getting training rates up... particularly important as we have to re-cert on training annually and there are several thousand employees in scope for the training.
The only problem is when we need to make changes to the workflow code.... hence the question. No changes to the record means we can't trigger "on update" events, which is why we resorted to perma-run workflows.
- Robin NilssonDec 04, 2019Bronze Contributor
WHSteve I would create a flow using a trigger of reoccuring, and set the flow to run once/day.
First step - have it get all items that were created 7 days ago that aren't completed, and send the reminder if the modified date is the same as the created date
Then next step, maybe get all non completed items again for 10 days in the past, check for changes/completions and escalate.
Or something along those lines...
- WHSteveDec 04, 2019Copper Contributor
THANK YOU Robin Nilsson! That is an excellent idea... and one that isn't an option in SPD 2013 workflows so I didn't realize it would work in Power Automate. So much to learn in the new Power tools... I've been focused on PowerApps and haven't been able to start plumbing the depth of Power Automate. Much appreciated.