cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
farnybasti
Regular Visitor

Dataverse permissions managed in custom 'user table'

Is it possible to have a permission structure in dataverse based on table data?

Let's say we have two tables with two columns each:

 

Table 1: Users

Columns: Email, Team

 

Table 2 Projects

Columns: Created by Email, Project name

 

Each user should have access to all projects he has created plus all projects any team member has created. I know I could create Business Units to solve this but to better manage the users I rather want to solve this using a separate table in dataverse. 

 

farnybasti_1-1632831672582.png

I have a rough idea about the security concept in Dataverse but this is something I'm really struggling with. Any help is much appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @farnybasti :

You could try something like this :

With({UserTeam:LookUp('User Table',Email=User().Email).Team},
 Filter(
   'Projects Table'
   'Created by'.Email in LookUp('User Table',Team=UserTeam).Email
  )
)

Best  Regards,

Bof

View solution in original post

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @farnybasti ,

 

You can assign ownership of table records to Teams so I would create teams, assign appropriate users to them and then assign ownership of the records to those teams.  

 

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-access-teams-owner-teams-coll... 

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
v-bofeng-msft
Community Support
Community Support

Hi @farnybasti :

You could try something like this :

With({UserTeam:LookUp('User Table',Email=User().Email).Team},
 Filter(
   'Projects Table'
   'Created by'.Email in LookUp('User Table',Team=UserTeam).Email
  )
)

Best  Regards,

Bof

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,806)