Forum Discussion
Share SP List with Teams
- 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.
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.
- You can give the Team B group read rights on the SharePoint site that belongs to Team A, but then they have read access to all the content on that SharePoint site unless you break the inheritance of individual lists and libraries and set unique rights on them. (However, this is something I advise against because the SharePoint site belongs to Team A and such changes can affect the overall functionality and in the long run bring unwanted challenges.) Then you can add the list to a tab on Team B.
- Alternatively, you CAN (if that's OK) add the rights group for Team B as a member of Team A but then it is an advantage if the rights group for Team B is a dynamic AAD group so that you don't have to worry about future rights administration.
- A third option is that you migrate the list to a new, independent, SharePoint site where both Team A and Team B have rights and then you can link to this "central" list both from Team A and Team B as tabs. I think this is the most correct solution.
- jonboylibAug 04, 2022Iron Contributor
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?
- MagnusGoksoyrOLDProfileAug 04, 2022Bronze ContributorYes it is technically possible but then you will have two places to maintain the information. Therefore i think it would be better to have and maintain this common list one place as i suggested in option 3 above.
Regards, Magnus- jonboylibAug 04, 2022Iron Contributor
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.
- ganeshsanapAug 04, 2022MVP
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.
- jonboylibAug 04, 2022Iron Contributor
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..