Ever came across a need to create a similar list in SharePoint based on an already existing list, with same structure, columns. Legacy SharePoint versions have provided a way to save list as a template and reuse it for new list creation.
With SharePoint Online, you can duplicate a list more easily and quickly!
For creating similar lists, SharePoint Online Modern interface gives you a way to create it from an existing list. The entire list structure is copied, including views, formatting, and columns in this approach. However, the actual content is not copied from the original list.
Select a list to use as a template for a new empty list on this site.
Columns, views and formatting will copy over to the new list.
Steps to create new SharePoint list based on an existing list
- Navigate to your SharePoint site.
- Go to Settings --> Site Contents.
- Click New --> List.
- Enter a name for your list.
- Check/Uncheck 'show in site navigation'.
- Click 'From an existing list'.
- Select a Team or Site - select this site or any other site collection. All sites where you have access are listed here.
- Choose a list from your selected site.
- Click Create.
The great part is, you can even refer to lists from different SharePoint Site Collection. The same approach can be used from within Microsoft Teams by opening corresponding SharePoint Site by clicking Files --> 3 dots (...) --> Open in SharePoint.
Comments:
- This works great, but I observed the permissions do not copy over. Setting up the permissions again is a pain. I prefer saving list as a template, import-export and then create new one using template.
anon 29 Aug 2020 17:01:32 GMT
- How can I copy all list items to new list ?
anon 20 Aug 2020 07:54:11 GMT
- Further comments disabled!
- SharePoint error - An exception occurred when trying to issue security token: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms..
- PowerShell iterate and get all SharePoint sites and sub sites
- SharePoint Online: Editing session has ended Message
- How to Share Microsoft SharePoint Site with Users or Groups
- How to delete SharePoint Online List Item using REST API
- SharePoint List excel import - This table exceeds the maximum number of supported rows
- How to disable SharePoint subsite creation option for owners
- SharePoint 2010 August 2015 Update KB3055049 - Duplicate Document ID issue bug fixed
- SharePoint Server 2016 Preview installation error - This Product Key isn't a valid Microsoft Office 2016 Product Key. Check that you've entered it correctly.
- How to upload file programmatically to SharePoint Document Library using Server Object Model C# .Net
- Access URL for SharePoint Tenant Admin Center (Online Office 365)
- Error when deleting SharePoint Online folder or file
- How to extend retiring SharePoint 2010 Workflows and continue with Office 365
- How to generate client id and secret to register SharePoint App with OAuth
- How to delete SharePoint List Item programmatically using C#.Net
- How to retrieve all SharePoint Online List Items using Rest API
- [Solved] SharePoint Search Internal server error exception
- Create SharePoint Site Collection using PowerShell New-SPSite
- Fix SharePoint PowerShell error - The term Get-SPweb is not recognized as the name of a cmdlet function script file or operable program
- How to enable anonymous public access for SharePoint Online site collection, file, folder without login ?
- SharePoint Server 2016 installation System Hardware requirements
- How to create SharePoint Online List Item using REST API
- Changed AD user display name showing old name in SharePoint
- Recommended size and resolution for SharePoint Online Site logo
- Microsoft 365: How to Turn Off Delve in SharePoint Online for All Users
- SharePoint installation error - Setup is unable to proceed due to the following error This product requires Microsoft .Net Framework 4.5 - SharePoint
- [Fix] reCAPTCHA not working in Web Browser - Google
- Convert Java Object to JSON using Jackson Library - Java
- Fix Microsoft Teams Error code - 107 - Teams
- [Fix] Microsoft Teams No Network Connection Please check your network settings and try again. [2603] - Teams
- How to revert a single file from Git Repo - Git
- How to stop MongoDB Server running on Ubuntu - Ubuntu
- Can we move apps like WhatsApp, Facebook to external MicroSD card - WhatsApp