Power Platform Community Forum Thread Details

Thank you for taking the time to read my question.

In my canvas app I need to restrict the data a user can see. In my case User 1 should only see business 1,2,3,5 where as User 2 should only see 1,3,4,5,6

In the past I've done this using IN. I make a column in my User table and store a string which is all the businesses that user should have access to. Then I compare that string with the Business Name field in my data table using the IN function. Of course performance will suffer as my data table grows.

Note: My data is in SharePoint lists.

I read Row Level Security for Dataverse but I'm not really sure that is what I need as the admins of the app could add more businesses and need to assign them to Users.... or maybe remove businesses from users. There is on one role that defines what a User should have access to... there could be as many Roles as Users...

Thanks!

Categories:

Building Power Apps