web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Auto-direct user to sp...

Power Apps

Answered

Auto-direct user to specific screen upon app start based on role

(0) Share

Report

Report

Posted on by kriggo15

526

I have a SQL table that has a list of users and their roles. Is it possible upon start to lookup the user's role and auto-direct them to a specific screen? Instead of the user having to click a button on a generic home screen, I'd like for them to automatically be taken to the appropriate screen.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@kriggo15

For example, let's say you have a table like this is SQL called 'UserRoles'

UserEmail Role

jsmith@yourcompany.com admin

twest@yourcompany.com manager

plane@yourcompany.com user

Connect your app to the UserRoles datasource.

Then put this code in the OnStart property of your app. When the app starts it will redirect to the proper screen.

Switch( LookUp(UserRoles, UserEmail=User().Email, Role), "admin", Navigate(your_admin_screen), "manager", Navigate(your_manager_screen), "user", Navigate(your_user_screen) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
kriggo15 526 on at

Like (0)

Report
Copy link

Link copied!

Awesome, this will be very helpful going forward! Thanks

Was this reply helpful? Yes No

Join the conversation