Answered

Copy files from sharePoint to local system at specific time (once per day)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Experts,

I am completely new to Power Automate, I need help to copy the files from the SharePoint site to the local system it has to all the files (.xlsx, .csv, .txt files) and load them to the local server folder path.

I see some examples for when a file created there is a download option, however, I don't anything to download from SharePoint based on the specified time (for example 2 pm every day the files have to download).

Any help will be greatly appreciated.

Categories:

Building flows

I have the same question (3)

All responses (10)

Answers (1)

fchopo 8,003 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hello @Anonymous

You could do the following steps:

1) For each day at 2PM.

2) SharePoint Get files

3) For each file

4) File System -> Copy File

Hope it helps!

Ferran

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ferran,

Thank you for your quick response. Since I am very new to this Power Automate.
for this step
4) File System -> Copy File

Please give me the step by step screenshot. I am failing to fill in the details for a copy.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

In the following article there is an excellent example of wha you want to do: Microsoft Flow Example: Copy Files from SharePoint to PC - SPGuides

You should install On-Premise Gateway on the local computer where the files are going to be stored, since it will allow Power Automate to copy those files from SharePoint. In the following link you will find a step by step on how to install the On-Premise Gateway: On-premises Data Gateway Installation and Configuration for Microsoft Flow - EnjoySharePoint

Hope it helps!

Ferran

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry again,

I tried everything but nothing is working for me

Please advise what I am doing wrong here, also this flow is running but it only copies the files which the header, doesn't have any content in it (all are 1kb files). Also, I don't any folder to be copied, how to do stop and copy only the rest of all other files

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

Before creating the file in the file system, you should get the file content of the SharePoint item:

You could create the file in the file system with the file content.

Hope it helps!

Ferran

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you, Ferran, It works as expected and I am able to download the files. However one thing the flow is failing with the below error

Error
Action 'Get_file_content' failed

File not found
clientRequestId: 2dc119ce-ef97-4d57-8ef7-c0445bc5a3cc
serviceRequestId: 2dc119ce-ef97-4d57-8ef7-c0445bc5a3cc

Please guide me if any additional steps am I missing.

Thanks for having so much patience to help with this request. I really appreciate it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I just further checked it, that out of 22 files, out of 2 are folders that are showing an error. How to ignore folder and consider only listed files it may any format

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

You should check if the item is a folder or not:

Hope it helps!

Ferran

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you Ferran, wonderful, my first project was finally successful. Indeed it wasn't possible without your help and guidance.

Thanks again.

Was this reply helpful? Yes No
rem_o 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Ferran @fchopo,

Thank you for your solution. It helped me with my problem as well.

I just wanted to ask if there's a workflow we can use to download files from different folders in SharePoint? Or do we have to use multiple workflows for each file located in a different folder?

TIA 🙂

Rem

Was this reply helpful? Yes No