Requirement: Create a list from an existing list in SharePoint Online.
SharePoint Online: Create a List from an Existing List
Creating a list similar to the existing list structure is a common requirement in SharePoint. We used the “Site list as Template” approach in previous versions of SharePoint and in the Classic experience of the SharePoint Online site. Now, in modern sites, this approach is not supported.
The modern SharePoint Online sites provide a nifty way to create a list from existing lists. Here is how:
- Go to Site Contents Page (Click on “Settings” gear >> Choose “Site Contents”), click on the “New” menu and choose List.
- This opens a new list creation page which provides an option to create a new list from the existing list. Not just a list from the same site, but you can select different site collections even!
- Provide a name to your new list, select the source list to clone, and click on the “Create” button on the bottom to copy the existing list structure in SharePoint Online.
Unlike the “Save List as Template” approach, this method uses the “Site Script” method to get the list schema and create a new list. With this approach, All fields, Views, formatting, and content types will be copied from the source list is copied into the new list you create. It also maintains the lookup column relationships by creating parent lists.
Please note, We don’t have an option to copy a list with its content in this approach. Also, Document Library and Discussion Board list types are not supported as of today. Also, creating a new list with this approach discards most of the list settings and permissions on the source list.