Solved: Refresh All Dataflows and Datasets With Power Auto...

snayff · ‎11-04-2022

We have scheduled refreshes set up for our dataflows and datasets, but due to a regular outage of one of the sources we often need to manually retrigger all of the 'flows and 'sets, so I'd like to set up some automation that handles this. We can trigger a Power Automate flow on demand and there's a connector to allow refreshing a specified dataset, but I am not sure how to get the list of existing 'flows/'sets. We would also need to run the flows first, so I'd need to identify those and loop over them first. I suppose I could manually type out each 'set/'flows details into a sharepoint list and pull from there, but dynamic is preferred.

Any suggestions on what to look at or how to approach this would be appreciated!