cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MatthewFalcao
Level: Powered On

how to implement row level security within Power Apps

I need to limit what data logged in users can access through galleries for example.my manager should be able to see what users he can delete from the table and what the current sales are , while I should only be available to see what the products are that we are selling 

 

 

We pull our info from SQL databases on Azure so I am assuming the change is going to have to come from SQL side because I doubt PowerApps has a function aside from filter that will be able to do this functionality?.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: how to implement row level security within Power Apps

Hi @MatthewFalcao 

 

If you are looking for a solution where only records specific to a person gets displayed, you can use Filter() or Lookup() queries to do so. To get the info for the current loggedin user, you can use User().Email or User().FullName functions. The data that gets filtered after these queries will get displayed in the app, so field level security is set in such a way through this. This means you only get the specific data and not the whole data using the query functions. For more details, please refer: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
 
If you are looking for a specific formula/query, then please share more details so that we might be able to help you better.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2
Dual Super User
Dual Super User

Re: how to implement row level security within Power Apps

Hi @MatthewFalcao 

 

If you are looking for a solution where only records specific to a person gets displayed, you can use Filter() or Lookup() queries to do so. To get the info for the current loggedin user, you can use User().Email or User().FullName functions. The data that gets filtered after these queries will get displayed in the app, so field level security is set in such a way through this. This means you only get the specific data and not the whole data using the query functions. For more details, please refer: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
 
If you are looking for a specific formula/query, then please share more details so that we might be able to help you better.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

kkandral
Level: Power Up

Re: how to implement row level security within Power Apps

So, we have to filter everything on item formula based to user() let's say and then useing that results as parents to view and/or edit records. 

But how can we also use lookup functions with filters or searches with filters ... Or how to search/or lookup within the initially filtered items? Basically the main question has to do how to handle the filtered items as parents within the app afterwars

I mean is there something or a trick when someone user() enters to the app will filter every item (let's say dbo.customers and dbo.projects) like a "monkey" row-level security?    

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,744)