Forum Discussion
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?
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.
jonboylib Try this:
- Team B must be having a M365 group associated with it.
- Grant permissions to Team B group on Team A list (or site) as per your requirements (Read/Edit, etc.).
- If you want to share just this list, you can break the permissions inheritance on list & then grant permissions. Go to List settings > Permissions for this list > Stop Inheriting Permissions > Grant Permissions.
- Add new tab in Teams B channel with list in Team A (using list URL). This way Team B can access the list in Microsoft Teams itself. Alternately, you can also share the URL of list with Team B.
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.
Just to verify that I have understood your need:
- You have a Microsoft Teams team (here called Team A). On its associated SharePoint site, you have created a Microsoft List.
- There is a Microsoft Teams team (here called Team B). The members of Team B do not have access to Team A.
- In Team B, you want the list from Team A to be displayed in a tab.
Is this understood correctly?
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.
