You’re offline. This is a read only version of the page.
Hello everyone! I am a fairly new person, who has only started to use the Power Platform recently. I am building an app in PowerApps, and i came across an issue. Due to license limitations, (and with me not having Office 365) i store data in CDS. What i would like to do for my app, is to have a login, that'd based on the users role, navigate them to different screens. I've managed to do this sort of by hard coding their full name and email into 3 different collection groups, that corresponds to the roles as well assigns a value to those groups (user, admin, head admin). I looked around but so far not found a working solution for it, and im curious.: Is it possible to have a collection that would dynamically update each time the app starts, and grab the users from the source column (felhasznaloks) based on their role? The email and fullname columns are both set to be text types, with the fullname being a rollup column that combines first name and last name columns.
Rather than loading a table of all possible users into the app, I've done what you're describing simply by doing a LookUp() to the permissions/role table using User().Email to return either a boolean value or some sort of string to indicate role. Then, I Set() a global variable as appropriate based on the LookUp() and control screen logic from there.
Would that work for your case?
Bryan
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
