Copy SharePoint List to the another new site

%3CLINGO-SUB%20id%3D%22lingo-sub-1843245%22%20slang%3D%22en-US%22%3ECopy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843245%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20copy%20the%20existing%20SharePoint%20online%20list%20to%20another%20site.%20Can%20someone%20help%20me%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1843245%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1843346%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808107%22%20target%3D%22_blank%22%3E%40sbhan4%3C%2FA%3E%26nbsp%3BWhich%20site%20templates%20are%20you%20using%3F%20Communication%20site%20or%20teams%20site%3F%3C%2FP%3E%3CP%3ETry%20following%20the%20solution%20given%20in%20below%20link%20(using%20site%20templates)%3A%3CBR%20%2F%3E%3CA%20title%3D%22Copy%20list%20to%20another%20site%22%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_sharepoint-mso_win10-mso_o365b%2Fcopy-list-to-another-site%2Fd718aa1c-a211-4f13-9ffb-c0d4a9cd3453%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECopy%20list%20to%20another%20site%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1843430%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843430%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808107%22%20target%3D%22_blank%22%3E%40sbhan4%3C%2FA%3E%26nbsp%3Byou%20can%20add%20a%20new%20list%20via%20%22Site%20Contents%22%20referencing%20the%20list%20from%20the%20other%20site.%26nbsp%3B%20This%20will%20being%20over%20the%20structure%20and%20any%20dependent%20lists.%26nbsp%3B%20Then%2C%20export%20all%20of%20the%20data%20from%20the%20other%20list(s)%20out%20to%20Excel%20and%20then%20import%20it%20into%20the%20new%20list(s).%26nbsp%3B%20You'll%20lose%2C%20history%2C%20etc.%20but%20at%20least%20you%20have%20your%20data.%26nbsp%3B%20There%20may%20very%20well%20be%20cleaner%2Fbetter%20ways%20but%20it's%20simple%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2206843%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2206843%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808107%22%20target%3D%22_blank%22%3E%40sbhan4%3C%2FA%3E%26nbsp%3BThere%20appears%20to%20be%20no%20way%20to%20%22move%22%20a%20list%20from%20one%20Sharepoint%20site%20to%20another%20within%20the%20tenant.%20This%20is%20a%20major%20design%20flaw.%20Luckily%20I%20discovered%20this%20issue%20early%20on%20and%20only%20%26nbsp%3Bspent%20a%20few%20hours%20trying%20to%20find%20the%20answer.%20%26nbsp%3BBack%20to%20using%20Excel.%20It's%20bizarre%20that%20you%20can%20move%20documents%20but%20not%20lists.You%20can%20move%20list%20templates!%20%26nbsp%3BAren't%20documents%20stored%20as%20lists%3F%20Is%20there%20a%20Powershell%20command%20to%20copy%20lists%3F%20no%20one%20seems%20to%20know.It%20does%20not%20seem%20to%20be%20in%20the%20PS%20documentation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2207170%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2207170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F453062%22%20target%3D%22_blank%22%3E%40Al_B_inPT%3C%2FA%3E%26nbsp%3Bafter%20you%20have%20created%20the%20structure%20of%20the%20new%20list%20from%20the%20previous%20one%20you%20can%20copy%20all%20the%20items%20into%20the%20new%20list%20with%20a%20flow%20in%20Power%20Automate%2C%20then%20delete%20the%20old%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2207702%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2207702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3Ethanks%20Rob.%20While%20I%20appreciate%20that%20there%20*is*%20a%20way%20to%20do%20it%2C%20however%20convoluted%2C%20it%20would%20be%20so%20much%20simpler%20to%20have%20a%20%22move%22%20function%20built%20into%20the%20List%20product.%20It's%20all%20stored%20in%20SP%2C%20I%20assume.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20usually%20go%20looking%20in%20%26nbsp%3BPowerAutomate%20because%20that%20is%20more%20%22sold'%20to%20us%20as%20a%20boolean%20logic%20trigger%20mechanism%20of%20if%20then%20statements.%20I%20took%20a%20peek%20before%20I%20posted%20the%20OP%2C%20but%20didn't%20see%20anything%20that%20jumped%20out%20at%20me%20from%20a%20cursory%20search.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again.%20I'll%20try%20it%20out%20at%20some%20point%20soon.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2208252%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2208252%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F453062%22%20target%3D%22_blank%22%3E%40Al_B_inPT%3C%2FA%3E%26nbsp%3B%3CEM%3E%22boolean%20logic%20trigger%20mechanism%20of%20if%20then%20statements%22%3C%2FEM%3E%20%3A%20streuth%2C%20that's%20wide%20of%20the%20mark%2C%20it's%20so%20much%20more%20than%20that.%20A%20simple%20example%20of%20the%20flow%20is%20shown%20below%3A%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%22copyListItems.png%22%20style%3D%22width%3A%20593px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263467i46D0DA533C6873EB%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22copyListItems.png%22%20alt%3D%22copyListItems.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2209242%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20SharePoint%20List%20to%20the%20another%20new%20site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2209242%22%20slang%3D%22en-US%22%3EThanks!%20I%20was%20just%20being%20a%20little%20tongue%20in%20cheek.%20Obviously%20Power%20Automate%20can%20do%20a%20lot%20of%20more%20stuff%20than%20simple%20Boolean.%20Thanks%20for%20the%20example!%20I'll%20try%20it%20out%20tomorrow%20!%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello everyone!

 

I am trying to copy the existing SharePoint online list to another site. Can someone help me with this?

12 Replies

@sbhan4 Which site templates are you using? Communication site or teams site?

 

You can create a list from an existing list in SharePoint Online. Check the documentation at:
Create a new list based on the columns in another list 

 

When you do this, the entire list structure is copied, including views, formatting, and columns. However, the actual content of the original list isn't be copied.

 

You can also try following the solution given in below link if you are not using the O365 group connected site (using site templates):
Copy list to another site 


Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

 

@sbhan4 you can add a new list via "Site Contents" referencing the list from the other site.  This will being over the structure and any dependent lists.  Then, export all of the data from the other list(s) out to Excel and then import it into the new list(s).  You'll lose, history, etc. but at least you have your data.  There may very well be cleaner/better ways but it's simple enough.

@BradD 

 

Thank you for your suggestion.

 

Actually, I m using the SharePoint Teams site and don't see an export option. Can you help me where I can find your mentioned option?

@sbhan4 There appears to be no way to "move" a list from one Sharepoint site to another within the tenant. This is a major design flaw. Luckily I discovered this issue early on and only  spent a few hours trying to find the answer.  Back to using Excel. It's bizarre that you can move documents but not lists.You can move list templates!  Aren't documents stored as lists? Is there a Powershell command to copy lists? no one seems to know.It does not seem to be in the PS documentation.

 

 

@Al_B_inPT after you have created the structure of the new list from the previous one you can copy all the items into the new list with a flow in Power Automate, then delete the old list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliottthanks Rob. While I appreciate that there *is* a way to do it, however convoluted, it would be so much simpler to have a "move" function built into the List product. It's all stored in SP, I assume.

 

I don't usually go looking in  PowerAutomate because that is more "sold' to us as a boolean logic trigger mechanism of if then statements. I took a peek before I posted the OP, but didn't see anything that jumped out at me from a cursory search.  

 

Thanks again. I'll try it out at some point soon. 

@Al_B_inPT "boolean logic trigger mechanism of if then statements" : streuth, that's wide of the mark, it's so much more than that. A simple example of the flow is shown below:

 

copyListItems.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thanks! I was just being a little tongue in cheek. Obviously Power Automate can do a lot of more stuff than simple Boolean. Thanks for the example! I'll try it out tomorrow !
How can I automate the process to moving structure of list ??

@RobElliott ,

 

Thanks this was quite helpful and easy to implement.

 

Created new list from existing to maintain the structure.

 

Then created the Flow exactly as you indicated to copy the content.

 

One issue I ran into was a particular field was of type person, and allowed multiple people to be added.  This was causing the flow to add a second "For Each" loop which was failing on run.  I didn't spend the time to debug as it wasn't the most important field to capture, I just removed it from the transfer.

 

Thank you for the comment.

 

Anthony

@RobElliott

 

That worked great. How do I make it copy the attachments as well?

thanks

 

@David2480 in this example we're just going to copy the first item in our list, Abla, from the list Almeria L3 to the list called Almeria L4. It has an attachment:

0-SP-list.png

 

In the flow, the get items action returns a maximum of 100 items by default, so if you are goimng to have more than this you need to go into settings for the get items, switch on the Pagination toggle and set it to the number you need or higher. As I'm only interested on this occasion with 1 item I've added a filter query:

 

1-Flow.png

 

Add an apply to each then add a condition to check wither the item has attachments or not, so the condition is HasAttachments is equal to true

2-Flow.png

 

If the item doesn't have attachments you can just add the create item action into the red if no channel:

 

3-Flow.png

 

But if the item has attachments, in the green if yes channel and a get attachments action

4-Flow.png

 

Next, add a get attachment content action - it will wrap itself in another apply to each.

5-Flow.png

 

Still inside this second apply to each add the create item action. Finally add an add attachment action

6-Flow.png

 

The result is as folllows:

7-SP-list-result.png

 

Hope that helps.

Rob
Los Gallardos
Microsoft Power Automate Community Super User