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!
- Move Copy Migrate SharePoint OneDrive files folders to different site collection location
- How to generate client id and secret to register SharePoint App with OAuth
- How to share SharePoint site or document with all users in organization
- Get-ADUser PowerShell - Get AD user details using email address
- error CAML Query containing special characters
- Access URL for SharePoint Tenant Admin Center (Online Office 365)
- Fix SharePoint Error - The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started
- SharePoint - The URL is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.
- How to delete SharePoint List Item programmatically using C#.Net
- How to Share Microsoft SharePoint Site with Users or Groups
- JSON column formatting to preview SharePoint Online file on mouse hover
- SharePoint List redirect user after submitting form NewForm.aspx
- See actual SharePoint error exception modify web.config
- SharePoint Server 2016 IT Preview Deprecated Removed features
- How to create SharePoint Document Library
- How to Get or Set SharePoint Document ID _dlc_DocId using PowerShell
- How to disable SharePoint subsite creation option for owners
- PowerShell - How to use Try Catch Finally blocks for error exception handling (Windows/SharePoint)
- SharePoint error - Your organization doesn't allow sharing with users from this domain. Please contact your IT department for help. (OSE403)
- [Solved] SharePoint Search Internal server error exception
- How to wrap column text in SharePoint Online Modern List Grid View using JSON formatting
- How to extend retiring SharePoint 2010 Workflows and continue with Office 365
- Changed AD user display name showing old name in SharePoint
- How to hide or remove quick launch left navigation from SharePoint Online Modern site page
- How to enable anonymous public access for SharePoint Online site collection, file, folder without login ?
- Convert Java List to Json String using Jackson - Java
- How to find lost AirPods? - HowTos
- Truncate table using Java JDBC Example - Java
- Eclipse : Workspace was written with an older version of the product and will be updated - Eclipse
- Two Buttons next to each other in Android Layout - Android
- How to install Python Specific version (3.8, 3.9 or 3.10) using Brew - Python
- Check if String Contains a Substring - Python - Python
- No connection available Use Connect-SPOService before running this CmdLet - SharePoint