Automate PowerAutomate flow activation
/ 1 min read
Table of Contents
The problem
Came back from holidays and lots of your hashtag#PowerAutomate workflows have been turned off due to 14 days of inactivity? Donโt activate them manually, solve the problem withโฆ another automation ๐คช
Note
In this case Iโll show a solution based on an environment with Dataverse.
Solution
1- List rows from the โ๐ฆ๐ผ๐น๐๐๐ถ๐ผ๐ป๐โ table and filter ๐๐ผ๐๐ฟ๐ฆ๐ผ๐น๐๐๐ถ๐ผ๐ป๐๐จ๐๐ and the component type (๐ฎ๐ต is a Cloud Flow).
2- For each result โ๐๐ฒ๐ ๐ฎ ๐ฟ๐ผ๐ ๐ฏ๐ ๐๐โ from the selected environment and the table โProcessesโ; where the Row ID is the โ๐ผ๐ฏ๐ท๐ฒ๐ฐ๐๐๐โ obtained from the previous step.
3- Check with a condition if the โ๐ฆ๐๐ฎ๐๐ฒ ๐ฐ๐ผ๐ฑ๐ฒโ obtained from the previous step is not equal to 1 (1 equal to โActiveโ) and if not activate the flow using the โTurn on flowโ.
Tech tip
In the โTurn on flowโ action use the flow ID (aka โobjectIDโ) instead of the Flow name ๐