Forum Discussion
Using PowerAutomate to refresh a Dataset
let's assume you have four dataflows. You have an excel file where each dataflow adds a row once finished. Then you have a separate flow that runs periodically (or on a file change trigger) and checks if that table has four rows. If yes - initiate the dataset refresh.
So lets say I'm using Excel, which is what I'm trying in this case. How do I set up an automated cloud flow monitor that excel file?
I currently have the flow set up to add new rows into an Excel document with all of the dataflow information, as well as a variable set to "1" if it was a successful flow. I don't understand what the next step would be here.
let's assume you have four dataflows. You have an excel file where each dataflow adds a row once finished. Then you have a separate flow that runs periodically (or on a file change trigger) and checks if that table has four rows. If yes - initiate the dataset refresh.
Ok that worked, using the file-change trigger. There were some nuances with the variables converting from string to float, but otherwise was able to get it to run successfully. Also added an action to clear out the excel file after successful completion so that it starts fresh each time it succeeds.