Duplicating Microsoft Lists

Question

This was someone else's question from 2021, but I am having the same issue and hope that we can now duplicate Lists with formatting:

I have created an onboarding list using the Microsoft Lists app that has specific tasks and I'm looking to create almost the exact same list but assigned to another team. But I can not figure out a way to duplicate the columns, tasks, etc. so I don't have to recreate every time. I've tried exporting and importing the excel files - the formatting didn't stick. I've tried creating a custom template out of the existing list and my custom template wasn't showing up when I went to create a new list.

I hope this significant gap in the Microsoft Lists app is resolved by now.

Please advise.

Thank you,

Lindsay

Answer 1

Dear Lindsay,

I may need some time to see if there is a way to meet your requirement.

I'll update here as soon as possible.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 2

Dear Lindsay,

You can use SharePoint Online PnP to save the list with its content as a template to save the template to the app gallery and then the users who can access the site or you can create the same list with the content from the template. You may enable Custom Script on the site first.

Allow or prevent custom script - SharePoint in Microsoft 365 | Microsoft Learn

PnP PowerShell Overview | Microsoft Learn

Here is a demo for your reference. Choice1 is a choice column and Text1 is a single-line text column.

To create the copy list, click on Site Content>+ New>App>classic experience>select the template.

The sample script is as follows for your reference. #Parameters$SiteURL= "https://contoso.sharepoint.com/sites/sitename"$ListName = "DemoList1"$TemplateFileName = "Domolist1CopyTemplate.stp"$TemplateName = "Domolist1CopyTemplate"$TemplateDescription=""$IncludeData = $True#Connect to PnP OnlineConnect-PnPOnline -Url $SiteURL -Credentials (Get-credential)$Context  = Get-PnPContext#Get the List$List = Get-PnpList -Identity $ListName#Save List as template$List.SaveAsTemplate($TemplateFileName, $TemplateName, $TemplateDescription, $IncludeData)$Context.ExecuteQuery()

Sincerely

Cliff | Microsoft Community Moderator