cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
_tao_
New Member

Downloading SharePoint Excel File

Self-identified noob user here. I'm trying to create a flow where I download a SharePoint file (a file our team is using to track project items) and automatically upload it to my PowerBI display. Unfortunately, I'm getting stuck on the first task of automating the download of the Excel file from SharePoint.

I've tried using O365 PowerAutomate to no avail. So I switched to trying PowerAutomate Desktop, with which I am a bit more familiar. I've tried various iterations of "Download from web" to get it from our SharePoint site. No luck.

I've switched to trying to launching the document then using "Click link on webpage" and creating UI elements for File > Save As. However, it looks like MS does not want us to do this as no red boxes identifying CSS elements appear.

I'm getting a bit frustrated at what I thought would be a quick and simple morning automation project turning into a 1 day+ project.

Does anyone have advice on what I could be missing? Has anyone got similar flows to work? Again, I am a PowerAutomate noob, so I very well may be missing something obvious.

1 ACCEPTED SOLUTION

Accepted Solutions
Ankesh_49
Super User
Super User

@_tao_ Try this in Power automate cloud: 

Transfer file from SharePoint to OneDrive

refer this: https://www.youtube.com/watch?v=FR14CErPZ3w

View solution in original post

3 REPLIES 3
Ankesh_49
Super User
Super User

@_tao_ Try this in Power automate cloud: 

Transfer file from SharePoint to OneDrive

refer this: https://www.youtube.com/watch?v=FR14CErPZ3w

Thank you for the comment! I would add that I needed a one additional steps to get it to work in my case:

I needed to make sure the file it created had the same file type extension in the File Name as the file I downloaded. In my case, it's a .xlsx file type. First I tried the File Name with no extension and it created a plaintext "File" that was unusuable for my purposes, I needed and Excel file at the output. Then I tried a .xlsm file type and that failed too. 3rd try was a .xlsx, same as the original file type, and it worked! Wahoo!

_tao__0-1656700752510.png
Many, many thanks for your comment! Now I can move on to the next steps in my automation today! Wahoo!

 

Ankesh_49
Super User
Super User

@_tao_  Glad it helped. 
Have a great weekend. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Top Solution Authors
Top Kudoed Authors
Users online (3,731)