How to download Excel file from the SharePoint using Power Automate Desktop

(0) Share

Report

Posted on by NeerajYadav Microsoft Employee

Hi All,

How to download Excel file from the SharePoint using Power Automate Desktop.

Is it possible by using python or VB Script ?

Thanks in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @NeerajYadav

From browsing , i think you can try using python, but in python they had api request it seems which u can do via Invoke web service in PAD.

For more information, you can refer this link
https://stackoverflow.com/questions/53829079/download-excel-files-from-sharepoint-document-library-using-python

Mark it as solution if it helps you

Regards,
Nived N
Happy Automation

Was this reply helpful? Yes No
amamidwar23 62 on at

Like (0)

Report
Copy link

Link copied!

hi @NeerajYadav

you use these two approaches.

1) can be achieved using VBA , execute vba scripts from PAD .
https://stackoverflow.com/questions/42419486/how-to-download-a-file-from-sharepoint-with-vba
2) use Power Automate actions, (drag the SharePoint action --> download file) and use the downloaded contents in PAD using a cloud flow.

Thanks,

AR
Please consider marking my post as a solution! to guide others, if this helps .

Was this reply helpful? Yes No
NeerajYadav Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for reply.
This is not working.
Can anyone share tested code Please

Was this reply helpful? Yes No
Riyaz_riz11 4,048 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @NeerajYadav

If api available for sharepoint you can try for that method. There is no other options i think.

Regards
Ahammad Riyaz

Was this reply helpful? Yes No
firmor 2 on at

Like (0)

Report
Copy link

Link copied!

One option is to use URI schema.
You open the link to your file in a Browser, like the example below:
ms-excel:ofe|u|https://[add the address of your file here]/Excel_file.xlsx

This will open the file in the Excel Desktop version. From there you do a regular save as.

Was this reply helpful? Yes No
koltregaskes-wk 6 on at

Like (0)

Report
Copy link

Link copied!

Hi firmor,

I'm trying to do a similar thing. I couldn't get that to work. Is this limited to SharePoint? I'm trying to download a file from OneDrive to save to our network.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Both SharePoint and OneDrive now have connectors in Power Automate Desktop that allow downloading files. You do need to have a paid license and set up a connection in the cloud flows. But once you have that, it is fairly simple to use the related actions.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No