Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 w...
Dataflow
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.