Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Opening files and uploading to SharePoint

(0) ShareShare
ReportReport
Posted on by 2
Hi all,
My situation is that I have an excel file with hyperlinks to files saved to a server (not SharePoint). I was notified that the server is going dark this week and need to save all the files on that server. There are approximately 2,500 pdf files.
 
Is there any way that
1) I can utilize Power Automate to 'click' each link and open (and/or download) the files
2) have Power Automate upload the files to SharePoint
 
Please let me know your thoughts. Thanks.
 
  • narayan225 Profile Picture
    narayan225 2,390 on at
    Opening files and uploading to SharePoint
     
    You can use Power Automate Desktop in that case.
     
     
    Hope this helps.
     
    Cheers!
  • Suggested answer
    CU13011524-1 Profile Picture
    CU13011524-1 2 on at
    Opening files and uploading to SharePoint
    thanks arayan225 for your suggestion. I was not able to figure it out, but will keep investigating. To answer your question about the server, it is a CDN server that houses pdf files. Each file is accessible via a CDN link. The links are in a table in a spreadsheet and all I have to do to open a url where the file is, is to click the CDN link.
     
    So the action I would need Power Automate to take is to click each link individually to open a url where the file is. Then it would need to download that file to SharePoint (or my computer) from that url.
     
    I'll keep playing with it. Thanks again.
  • narayan225 Profile Picture
    narayan225 2,390 on at
    Opening files and uploading to SharePoint
    You can do this using two ways:
    1. Create a HTTP action in Power Automate and use HTTP request to get the file information and data and create them in SharePoint.
    2. Use Power Automate desktop to record the steps to download all the files in the server, upload them to SharePoint and then delete them from your device.
    I am not sure about the type of server you have and not sure what your capabilities are.
    Hope this helps.
    Cheers!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard