Aug 04 2022 02:19 AM
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?
Aug 04 2022 02:52 AM
Just to verify that I have understood your need:
Is this understood correctly?
Aug 04 2022 02:56 AM
@MagnusGoksoyrOLDProfile I would like Team B to have access to the list I created in Team A.
Doesn't necessarily have to be within teams, If I can share a URL that would suffice.
I don't want to add members manually as there are hundreds, and keeping these in sync would be a lot of effort.
Aug 04 2022 02:59 AM - edited Aug 04 2022 03:04 AM
@jonboylib Try this:
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.
Aug 04 2022 03:11 AM
Aug 04 2022 04:56 AM - edited Aug 04 2022 05:02 AM
Thanks for the suggestions, seems like it's difficult to accomplish such a simple task.
I think it may be easier if I duplicate my current list (inc all contents) and import it into Team B - is this possible?
Aug 04 2022 05:12 AM
@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:
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.
Aug 04 2022 05:17 AM
Aug 04 2022 05:17 AM
@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.
Aug 04 2022 05:19 AM
If I export the list in Team A to Excel, then create a new list Team B using import excel/spreadsheet option... will the formatting of my list also copy over? e.g. I have conditional formatting setup in every column of my list in Team A.
Presumably I don't have to set all of this formatting up again..
Aug 04 2022 05:22 AM
Yes, I understand that there will be two lists that need to be maintained. But, I really don't want to setup another site for the sole purpose of sharing one single list, seems a bit excessive.
I can't believe there's no easy way of duplicating an existing SP list, contents and formatting.
Aug 04 2022 05:26 AM
Solution@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.
Aug 04 2022 05:26 AM
Solution@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.