Hi,
To achieve the visibility matrix you need, you can set up a Power Automate flow. Keep the current ownership of the records based on who creates them, and use the flow to share the records with the relevant business units based on the product.
Create a Power Automate flow that triggers when a new record is created. Use a switch action to decide which team or business unit to share the record with. This can be achieved using the Dataverse unbound action.
Here’s an example of what the flow might look like:
For instance, if a user from the North business unit creates a record for Product A, the flow will share the record with the manager of the business unit responsible for Product A.
You can find more information on how to implement this using the Dataverse unbound action in this article.
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional