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

%3CLINGO-SUB%20id%3D%22lingo-sub-1347620%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Flow%20%E2%80%93%20Copy%20files%20from%20SharePoint%20to%20a%20local%20system%20folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1347620%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F573158%22%20target%3D%22_blank%22%3E%40MadhusudanShettyMS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ESounds%20like%20you%20are%20using%20PowerAutomate%20can%20you%20please%20attach%20the%20screenshot%20of%20the%20Flow%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1344317%22%20slang%3D%22en-US%22%3EPower%20Automate%20%E2%80%93%20Copy%20files%20from%20SharePoint%20to%20a%20local%20system%20folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1344317%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%26nbsp%3B%3CSPAN%3Ecopy%20files%20from%20a%20SharePoint%20Online%20document%20library%20to%20a%20file%20system%20on%20a%20local%20machine.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20using%26nbsp%3BCreate%20File%20action%20to%20create%20files%20and%20move%20to%20local%20machine.%20It%20may%20fail%20sometimes%20because%20of%20large%20file%20size%20and%20length%26nbsp%3Bof%20file%20name%20exceeding%20the%20limit.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHow%20can%20I%20capture%20those%20filenames%20which%20were%20failed%20in%20a%20string%20or%20array%20and%20reason%20for%20failure%3F%20Please%20help%20me%20on%20this%20issue.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1344317%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1348934%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Flow%20%E2%80%93%20Copy%20files%20from%20SharePoint%20to%20a%20local%20system%20folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1348934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70455%22%20target%3D%22_blank%22%3E%40Alireza%20Rahimifarid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20I%20am%20using%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20804px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F187769iFA2EFB4801407BA6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BIt%20works%20and%20file%20is%20copied%20to%20system%20folder.%20After%20Create%20file%20%2C%20I%20want%20to%20capture%20Failed%20Filenames%20in%20a%20String.%20How%20can%20I%20do%20that%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi Team

 

I want to copy files from a SharePoint Online document library to a file system on a local machine.

I am using Create File action to create files and move to local machine. It may fail sometimes because of large file size and length of file name exceeding the limit. 

 

How can I capture those filenames which were failed in a string or array and reason for failure? Please help me on this issue.

 

@Juan Carlos González Martín @Norman Young @Rob Elliott 

Thank you.

2 Replies
Highlighted

@MadhusudanShettyMS 

Hello,

Sounds like you are using PowerAutomate can you please attach the screenshot of the Flow?

 

Highlighted

@Alireza Rahimifarid 

 

Yes I am using Power Automate.

 

Capture.PNG

 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 ?

 

Thank you.