Sunday, 14 Jul 2024
Technology

How to Duplicate a List in SharePoint Online?

If you’re working in SharePoint Online, there may come a time when you need to duplicate a list. Whether it’s for testing purposes or to create multiple lists with similar information, duplicating a list in SharePoint Online is a quick and easy process. In this article, we’ll show you step-by-step how to duplicate a list in SharePoint Online.

sharepoint duplicate list

How to Duplicate a SharePoint Online List?

The modern SharePoint Online sites provide a convenient way to create a list from existing lists. Here’s how to make a copy of a list in SharePoint Online:

  1. Go to the Microsoft SharePoint site where the source list is located.

  2. From the Home page, click on the “New” button and then choose “List” in the toolbar at the top of the page. Alternatively, you can go to the “Site Contents” Page (Click on “Settings” gear >> Choose “Site Contents”), click on the “New” menu, and choose “List”.

how to copy sharepoint online list to another site

  1. This opens a new list creation page, which provides an option to create a new list from an existing list. Click on the “From existing list” button on the page.

how to copy list sharepoint online

  1. Select the existing custom list to clone and click the “Next” button at the bottom to copy the existing list structure. You can even pick a list from different site collections!

sharepoint online copy list to another site collection

  1. Provide a name for your new list and click on “Create” to complete the process.

copy list from one sharepoint online site to another

The new list will be created with the same fields as the original list. It’s important to note that this method only copies the structure of the list without copying any data from it. If you need to copy lists between sites with data, you can use the “Content and Structure” page (/_layouts/15/sitemanager.aspx) to move or copy items to the destination list.

Tham Khảo Thêm:  What to do if the 10.1 Onn tablet won't turn on

Copying a List or Document Library using PnP PowerShell

If you prefer using PowerShell, you can use the Copy-PnPList cmdlet to copy a list or document library in SharePoint Online. This cmdlet copies the fields, views, and settings of the list but doesn’t copy the list items.

Similarly, to copy a list to another site, you can use the following PowerShell script with admin privileges:

# PowerShell script to copy a list from one site to another
Connect-PnPOnline -Url "https://source-site-url" -Credentials (Get-Credential)
Copy-PnPList -SourceList "Source List" -TargetWeb "https://target-site-url" -TargetList "Target List"

Copying a SharePoint list from one site to another manually can be time-consuming and error-prone. With PowerShell, you can automate the process and save time and effort. If your list uses lookup fields, make sure to copy the parent list first to avoid any errors.

Frequently Asked Questions

  • Can I copy a list in SharePoint Online with its data?
    No, the method described in this article only copies the structure of the list. To copy a list along with its data, you can use the “Content and Structure” page or consider third-party tools like Sharegate.

  • Are there any limitations to copying a list in SharePoint Online?
    There are no specific limitations to copying a list in SharePoint Online using the method outlined in this article. However, it’s always a good practice to test the copied list to ensure its functionality and settings are intact.

  • Can I customize the copied list according to my requirements?
    Yes, once the list is copied, you can customize it by adding or removing columns, changing views, and adjusting settings to meet your specific needs.

Tham Khảo Thêm:  Updating Your Password on LinkedIn and Other Account Security Best Practices

Conclusion

Duplicating a list in SharePoint Online is a straightforward process that can save you time and effort when you need to create multiple lists with similar structures and settings. Whether you choose to use the web browser “From existing list” method or copy a list using PowerShell, you have the flexibility to customize the copied list according to your requirements.

By following the steps outlined in this article, you can easily create a copy of a list in SharePoint Online while preserving its columns, views, and settings. This is particularly useful when you want to create multiple lists with similar configurations or when you need to replicate a list across different sites or site collections.

For more information about SharePoint Online and other technology trends, visit Eireview.