Forum Discussion
sbhan4
Nov 02, 2020Copper Contributor
Copy SharePoint List to the another new site
Hello everyone! I am trying to copy the existing SharePoint online list to another site. Can someone help me with this?
sbhan4
Nov 02, 2020Copper Contributor
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?
Al_B_inPT
Mar 13, 2021Brass Contributor
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.
- RobElliottMar 13, 2021Silver Contributor
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- Ankur115May 21, 2021Copper ContributorHow can I automate the process to moving structure of list ??
- Al_B_inPTMar 13, 2021Brass Contributor
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.
- RobElliottMar 14, 2021Silver Contributor
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:
Rob
Los Gallardos
Microsoft Power Automate Community Super User