Opening files and uploading to SharePoint

(0) Share

Report

Posted on by CU13011524-1

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!
You can do this using two ways:

Create a HTTP action in Power Automate and use HTTP request to get the file information and data and create them in SharePoint.

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!

Was this reply helpful? Yes No
Suggested answer

CU13011524-1 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

@CU13011524-1

You can use Power Automate Desktop in that case.

https://powergi.net/blog/power-automate-upload-file-to-sharepoint/

Hope this helps.

Cheers!

Was this reply helpful? Yes No