Hello,
I am curious how long users would need to wait for the SQL connection in power apps takes to refresh.
When users enter our app for the first time they are prompted to select which group they are apart of.
In the backend this adds them to a security group. The sql server grants access to tables based on the security group they are in. However since they have already entered the app the sql connection does not update and users are unable to access the tables.
This can be fixed by clearing cookies but most users don't want to do that.
Thanks for any info anyone can provide.

Report
All responses (
Answers (