How To Refresh An Excel File In Sharepoint With Power Automate Desktop

For today’s tutorial, Jarrett is going to demonstrate how you can create a Power Automate Desktop flow using an Excel file in Sharepoint.

***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Creating a new flow
02:57 Opening Excel in Sharepoint
05:58 Running the flow
06:27 UI automation
09:35 Test run

***** Learning Power BI? *****

#EnterpriseDNA #PowerAutomate #PowerAutomateTutorial #PowerBI #PowerBIDesktop #PowerBITutorial

[cbrook]

Thank you! I've been searching for a long time to include a process just like this in my flow.

[Educasag]

Amazing! with a wait action really works fine. Thanks!!

[dedyhermawan]

Thank Bro..,
it's good tutorial, very useful for me

[PradeepKumar-mhht]

After adding wait function it is working so good. Thanks for introducing this automation.

[MohanYGK]

ufff you made my life very easy. Can we automatically refresh this file twice in a day at 12 noon and 12 midnight (even after closing my laptop). Thanks once again brother.

[purple_powder]

It actually doesn’t refresh the data (which is not checked in the video) as the file is saved and closed immediately after hitting the Refresh button. You need to add a “Wait” step before closing for the refresh to come through.

[RichardOliver]

Could you do this in Power Automate online, rather than in PA Desktop, so the user's machine doesn't have to be on?

[KeyserTheRedBeard]

nice video Enterprise DNA. I broke that thumbs up on your video. Maintain up the terrific work.

[dev]

Thanks for the video how can i scheduled

[ValoKicks]

Hello and thank you for the nice tutorial. Really easy to understand.
Could you make the same thing using Power automate (but not the Power automate desktop)?
Thanks in advance :)

[greg]

Hello, How to automate the launch of flows in PowerAutomat?
I would like the streams to run at midnight everyday for example.

[skylightorder]

Hi !! How do you add a delay to that ? Cheers !!

[aydeediaz]

Hi! How can we paste the data from another excel and refresh when having multiple worksheets. Because everything is working in the same worksheet, even if I define them

[prashanth]

Hi, I have a an excel file with predefined sheets, i would like to delete if there are any other sheets added other than predefined sheets and then refresh. How do i define this?

[carlslate]

This was extremely helpful! Now... if I can solve for how to automate our VPN connection (we use FortiClient) prior to opening the workbook.... I'll be set lol

[brijendraydv]

Pls also show how to schedule it in unattended mode else its.of no use for most of Business users however great tutorial loved it.

[johnbrophy-jknv]

Send Keys function with CRTL ATL F5 works as well instead of all the UI elements.

[roomurray]

Is there anyway to bypass the MFA issues when they are in place when using PA.

[reysombi]

And the last question, sorry about i AM new in power automate.. the flow run even if the pc is turn off? I need update the excel file even sundays

[hazel-hanavu]

Hi, for anyone who is wondering how much time is needed for your file to refresh. I have the same situation and the way I go about having excel finishes the refresh first then save and close is to use a Power Automate to run a Marco script within the Excel file in which is instructed to refresh, wait for it to finish and only when the refresh is completed then move on to execute the next line of code.