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.
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.
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!