Power Automate – Copy files from SharePoint to a local system folder

Question

Hi Team&nbsp;I want to&nbsp;copy files from a SharePoint Online document library to a file system on a local machine.I am using&nbsp;Create File action to create files and move to local machine. It may fail sometimes because of large file size and length&nbsp;of file name exceeding the limit.&nbsp;&nbsp;How can I capture those filenames which were failed in a string or array and reason for failure? Please help me on this issue.&nbsp;jcgonzalezmartin&nbsp;Norman Young&nbsp;RobElliott&nbsp;Thank you.

alireza rahimifarid · Answer

MadhusudanShettyMS&nbsp;Hello,Sounds like you are using PowerAutomate can you please attach the screenshot of the Flow?&nbsp;

madhusudanshettyms · Answer

Alireza Rahimifarid&nbsp;&nbsp;Yes I am using Power Automate.&nbsp;&nbsp;It works and file is copied to system folder. After Create file , I want to capture Failed Filenames in a String. How can I do that ?&nbsp;Thank you.

foreverlearner · Answer

MadhusudanShettyMS&nbsp;What if the sharepoint folder has many sub folders, Do we need List Folder step in between Sharepoint and Local folder ?

harry_g · Answer

Did you get any solution? or any other work around to tackle large files?

ian11230 · Answer

Yes, simply create a "Append to string" command right after the create file command. Set it to append the "Name" variable and set it to only run if the last command failed. (The three dots in the upper right =&gt; Configure run after)

Forum Discussion

Power Automate – Copy files from SharePoint to a local system folder

7 Replies

Resources