Forum Discussion
Power Automate scheduled refresh rather than button click
I have a dashboard with some calculated values on cards, I've figured out how to set up a power automate flow and have a button enabled that fills an excel spreadsheet with those values. Is there a way i can update the spreadsheet automatically instead of pressing the button, as the calculated values change everyday? I'm not sure how to set up the flow for it.
2 Replies
Instead of using a power automate flow, wouldn't it be better to use the Service's built-in Scheduled-refresh? If you need the data to refresh after a change is made in the excel spreadsheet, consider running the refresh a dataset action after the end of your existing flow.
Sorry, I should have been clearer in the original message. The report is set to refresh everyday and the values of the cards change. I want to input these new values into a spreadsheet with a table in the following columns: Date, Value 1, Value 2, Value 3 etc. Right now I use the Power Automate button that adds rows into an excel sheet - is there a way to do that automatically rather than having to click the trigger button each time.
