Forum Discussion

jonboylib's avatar
jonboylib
Iron Contributor
Aug 04, 2022
Solved

Share SP List with Teams

I have created a SP list in my Team A. The list is populated with thousands of records and contains custom formatting etc.   I now want to share this list with Team B.   How can I achieve this?
Lists
  • ganeshsanap's avatar
    ganeshsanap
    Aug 04, 2022

    jonboylib Ah, formatting will not be applied to new list when using import excel option.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Aug 04, 2022

jonboylib You can export the SharePoint list in Team A to excel & create a new list in Team B using import excel/spreadsheet option.

 

Follow these documentations:

  1. Export to Excel from SharePoint or Lists 
  2. Create a list based on a spreadsheet 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Aug 04, 2022

jonboylib Additionally, you can refer to below article as well for excel approach if it helps:

3 ways to import Excel to SharePoint 

 

Alternatively, you can achieve something similar using PnP provisioning as well (developer experience required): How to Provision a list with data using SharePoint Online PnP C#? 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources