
Hi All,
I have a question about Row Level Security in Power apps
If I have already restrict the data in the SQL server the how to restrict the data that comes into the Power App - based on the logged on User, and the Directorate they sit in.
1) How can I do this on Entry, rather than filtering?
2) Is there an AD connector - to read AD groups?
3) Can I use Flow to talk to the database, and run store procedures to restrict the view?
Is there any advice/links anyone can provide me, as I am very stuck.
Please and thank you
Since the SQL connector uses a connection account you can't really impose Row level security on the data from PowerApps using SQL. Everyone who uses the PowerApp will see whatever data the connection account in the connector has access to,