Wanting to know if it's possible to create a SharePoint List (SharePoint Online) that multiple Teams can contribute to, however that can only see their information.
Requirements:
- An overarching SharePoint List to capture all data from multiple Teams
- Multiple Teams to contribute multiple items to the list via a Teams tab (no need to see SharePoint)
- Individual Teams can only see their data, not other Teams
- Individual Teams will have a unique ID associated with them, located in a SharePoint Master List of Teams
- Any changes to the overarching SharePoint List would reflect in all Teams views (for example adding a new column/ field and any custom settings). This is an important difference as it means we cannot (at least I don't think we can) make individual lists for each Team and use a Flow to push to a master list.
Example:
- A Risk Register as an overarching SharePoint list to capture all risks from all projects
- Each project has a Teams structure set up for it, with a view of the Risk Register & all its fields via a tab - not requiring to open SharePoint, all data can be added directly through Teams.
- Individual projects add their risks to the register in Teams, populating the overarching Risk Register in SharePoint
- Individual projects cannot see data from other projects, only their own risk data
- Each project has a unique ID in a Master List in SharePoint (if unique IDs help with a solution)
- Any change to the Risk Register structure in SharePoint is reflected immediately in all project view through their Teams tab. e.g. adding a new field to the SharePoint list will show that new field in all Teams
- On the back-end in the Risk Register SharePoint List, admins can see all risks raised by all projects
Hopefully this is quite simple and there's an out-of-the-box solution!
Thanks in advance