Copy SharePoint Library Files Including Nested Folders Structure using Power Automate

In this video, I will show you how to copy the SharePoint library documents with nested folder structure from one SharePoint site to another. This can be useful if you need to move documents or data between different sites as part of SharePoint template provisioning to include contents/files automatically or purely for testing purposes.
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerAutomate
#SharePoint
#DocumentLibrary

[@shakesbeer23]

This was exactly what I was looking for and you laid it out so clearly! Thank you so much!!

[@KeaPointTechTips]

Glad it was helpful!

[@karolinaunderwood1039]

Very useful and that's exactly what I needed for my Project as a solution to complex JSON coding. Thank you so much

[@KeaPointTechTips]

You are welcome Karolina!

[@gazelle2016]

Honestly this helped me a lot. Many many thanks

[@KeaPointTechTips]

Glad to hear it!

[@darranpage9569]

Thank you ! I had an task where i needed to copy nested folders from SharePoint to Azure Blob Worked really well as SharePoint doesn't have a default connector.

[@KeaPointTechTips]

You are welcome Darran!

[@1tucos145]

hey, im working on a similar project any chance you could help me?

[@ChrisDewey-wl6id]

Very useful, Thank you :) quick question. If there away to get it to skip if the file/folder is there already rather than replacing?

[@mastalayne]

awesome!

[@stewartmcgovern2k10]

Hi, thanks for this it's really useful, but when I run the flow again it only copies the folders and not the files, it does not replace them?

[@mohammadshoaibsidiqi6251]

Very good video, I tried to run it on a Document library which has 14 folders but it only copied 5 folders and not the rest, it does not show any errors and in the video you have not mentioned anything about number of folders, is there anything in this flow that limits the number of folders within the document library?

[@SensiVybz]

Hi i am trying to copy data from a source library A to another tenant B I have setup the flow on the destination tenant B and set the get files and copy folder connections for both Tenant A and B (A being the files needed and B being the destination) However should I be running this flow on the source tenant (A) or should it work if i was "pulling" the data using the destination tenant B? As everything works on the flow when tested other than the "copy folder" part at the end throws an error or "Unauthorised"

[@cubaseproducer]

Could it be possible to fetch recursively a SharePoint document library in Power automate and moving (not copying) the files to Azure blob storage or Azure Files service? Many thanks for the content

[@andrewhall9581]

Thanks, very useful. If I was creating a new MS Team Channel from a new item on a Sharepoint List. The new team is created and then I would like populate with some standard folders and documents using your technique. I can do both parts separately but cannot seem to work out how to create both from a single flow.

[@KeaPointTechTips]

You can create a single flow which will first create teams and channels and then you can get channel folder path (SharePoint library channel folder path) and can create sub folder structure.

[@andrewhall9581]

@@KeaPointTechTips thanks, I'll give that a go

[@andrewhall9581]

@@KeaPointTechTips Ok I managed to solve this but had to use two Power Automate flows. If I tried copying the folders in the same flow that created the new MS Team it always failed with an issue relating to folder path or permissions. It seems the new Teams resource was locked in some way as a delay didnt work either. The simple solution was to get the first flow to update the list once it had created the new team. The second flow then tracked the same list for a modification of a status column. If it is changed to authorised itthen I ran your copy folder flow with the Teams name being passed as variable from the list.

[@joezajac2156]

Does this work if the subfolders dont use the same lengths?

[@jayatirthajoshi]

Can this flow be used to Copy Folder to Share point of two Different Tenants ?

[@francoislejoyeux5995]

Great script ! Is it possible to process large library (i have 400 folder and 4000 files) ?

[@victordauden9173]

Thx very useful. Is it possible to something similar from Sharepoint to One drive?

[@KeaPointTechTips]

Thanks. Yes, possible. the destination is onedrive in your case instead of a SharePoint document library

[@andrewmaybir352]

Nice work as always. A few quick question, if I edit a document in the source Document Library, will this copy the edited version of the document replacing the old one?... Also, this flow will only copy across new documents and folder and skip other folders and files if they exist in the destination DL, is that correct?

[@KeaPointTechTips]

Thank you. I have not tested this scenario.

[@yusufvohra4449]

Wonderful video. Can you make such video for moving folders instead of copying? Or let me know how to do it

[@KeaPointTechTips]

Thanks, I will add that to my to do list.

[@milan23584]

@@KeaPointTechTips have you created any video on copy folder from default sharepoint library to other tenant ? if yes please let us know

[@decentmendreams]

Hello, I need help with PA. How can I reach out to you ?

[@0xac829]

This is awesome, however, I need to do this for an Azure Blob.

[@KeaPointTechTips]

I have done a video on copying documents on Azure Blob storage. Have a look.

[@bhushanmittal7842]

How about the case if workflow got errors in between and how if use move to and flow breaks in between

[@KeaPointTechTips]

You can add a parallel condition and run a different action when a step fails.

[@downtownsudiebrown]

If I have a description field for each folder, is it possible for that to copy to a different SharePoint library, too?

[@KeaPointTechTips]

You should be able to copy metadata too.

[@harsh_36]

So will this replace the files if it's already present in the destination. Note: I am thinking to use this flow to take a backup.

[@KeaPointTechTips]

Yes, it will replace. if it already exists.

[@harsh_36]

@@KeaPointTechTips I had created a flow which would fail after generating similar output. Thank you for the solution.

[@classicjambhale7033]

Can we copy document library with the help of powerautomate flow with content tupe

[@KeaPointTechTips]

You can not copy document library with power automate. You can use PowerShell or third party tool to copy document library. If you have created the content types then you can create a new document library and assign the content type to have all the metadata properties available in the new library.

[@EricEgwiko]

Can this flow be used to Copy Folder between Share point of two Different Tenants ? It seems not for me.

[@KeaPointTechTips]

Yes you can, You just need to use target tenant account login for the flow action that is adding file and folders to new location.

[@halvadandu]

​@@KeaPointTechTipsThank you for your video. It is really helpful. I want to copy folders to different tenant, can you please help or elaborate how to use "copy folders" function?

[@halvadandu]

Hi Eric - Did you accomplish this task to migrate folders to another SharePoint tenant? Can you help me how?