cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HKocyigit
Regular Visitor

Excel Refresh Data Flow

Hi,

I am quite new on Power Automate and trying to do some things,

My challenge is to create desktop flow so that an excel file refresh data queries then save data in invisible mode.

Thanks your helps,

Best regards, 

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @HKocyigit,

 

Here is a tutorial on how to operate Excel table in power automate desktop, you could refer to it firstly:

(548) How to use Excel in Power Automate Desktop - YouTube

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi @v-litu-msft,

Thanks for this video, but it cannot 100% help my case. it is useful for many things on excel.

I could be more specific;

I tried to use desktop recorder to click "Refresh All" then close excel command, the issues are 1- Close excel command does not wait for finalising refresh queries, just save and close the file (I will create flow for 30 different excel reports, each reports refresh time is different, I cannot find the solution for waiting until end of the refresh process...) 2- Using desktop recording excel has to run visible, I want everything will be done invisible...

   

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,303)