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?.
Solved! Go to Solution.
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?
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.