Power Platform Community Forum Thread Details

Hello,

I am building now one data collect application, where the line managers needs to provide data.

I have two table: Team and Data.

[Team]

Team ID (Key)

Team Name

Manager Mail address

Assigned to (Mail address)- Optional

[Data]

Team ID (Foreign Key)

Field 1,2,3.....

This tables are used in one Canvas App. Where the line manager can log in, and fill the data. OR they can assign they work for another person.

My problem is, how can I solve the "Assigned" function. After selection another mail address they need to see the data.

1 Dataverese record two editor. ( I cannot create teams in dataverse, we have 2000 team). The function is working in Canvas app (filtering), )

Thank you

Categories:

Microsoft Dataverse with Power Apps

Hi @frantyi1 ,

Dataverse utilizes a security model for dynamically filtering data based on ownership of records. You can assign teams or users to the records and then utilize Roles to determine who can see what records. Example is you might have some users that can see all the records (or even edit / delete / etc.) while others can only view the records assigned to them only. Utilizing the Dataverse out-of-the-box security architecture should assist with your assignment / view issues.

Some thoughts here...

You could setup Owner Teams that actually relate to Groups in Azure Active Directory for the departments. https://learn.microsoft.com/en-us/power-platform/admin/manage-group-teams. Setting this up would provide the ability to assign users to the groups in AAD and this would automatically assign them to the respective teams in Dataverse. You can then assign the ownership of the table's records to the Team.
Assigning ownership of the records will then apply the appropriate user level security and you can then utilize role based security to define what you want to have happen with the table's records. Example is you could have some users in a role where they will only be able to view, edit etc. records they own (or their team owns) and create other roles that will allow the users in that role to view, edit, etc. all records. https://learn.microsoft.com/en-us/power-platform/admin/wp-security-cds#tablerecord-ownership

There are many additional advanced features around security including: