Unanswered

Update files Excel in my onedrive

(0) Share

Report

Posted on by JonathanFr

Hi, Every morning I receive several files with data that I compile in an Excel file that I name "Follow-up". currently I have to open the "tracking" file every day to click on "update" in order to have my latest data.
I would like to update my Excel file automatically in my OneDrive every morning at 7 a.m.
can power automate do this action?

thanks for your help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Caspar_Rubin 831 on at

Like (0)

Report

Hey

Yes, you can automate that but if you have to click on something inside an Excel file, you should maybe user Power Automate Desktop, not Power Automate Cloud Flows... This way you don't have to change the update process or whatever is behind it...

Power Automate Desktop is a Program you can download and install on your local machine and create a simple scheduled Flow that opens the file at 7am and clicks the button for you. It's like a robot and you tell it what to click and when...

You can find the installer and setup guide here: https://learn.microsoft.com/en-us/power-automate/desktop-flows/install

Was this reply helpful? Yes No
JonathanFr 10 on at

Like (0)

Report
thank you for your return, but as you advise meto leave the computer on?

Was this reply helpful? Yes No