StartScreen Role Based Navigation

(1) Share

Report

Posted on by CU17122216-0

I'm using StartScreen to add some deep linking to my app. I want to provide a link to the admin page but need it to navigate to the home screen if the current user is not on the user SharePoint list I have setup. I have tried various different formulas to no avail. This is the one that seemed most promising but still only wants to navigate to the admin screen.

Switch(

Param("screenname"),

"viewedit",

'scrn_ViewReq',

"admin",

If(

!IsBlank(

Filter(

'User List', User.Email = User().Email

)

'scrn_Admin',

'scrn_Main'

)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 154,534 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @CU17122216-0

Try this - If you use Filter, you need to test for Empty as it is a Table
Switch( Param("screenname"), "viewedit", 'scrn_ViewReq', "admin", If( !IsBlank( LookUp( 'User List', User.Email = User().Email ) ), 'scrn_Admin', 'scrn_Main' ), 'scrn_Main' )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
CU17122216-0 6 on at

Like (0)

Report
Copy link

Link copied!

I tried LookUp as well. I'll try it again tomorrow to be sure. Thank you for your response!

Was this reply helpful? Yes No
Suggested answer

Mehmet_Powerapps 26 on at

Like (1)

Report
Copy link

Link copied!

I found this solution,

Switch(
Param("screenname"),
"viewedit",
'scrn_ViewReq',
"admin",
If(
CountRows(
Filter(
'User List',
User.Email = User().Email
)
) > 0,
'scrn_Admin',
'scrn_Main'
),
'scrn_Main'
)

Was this reply helpful? Yes No
CU17122216-0 6 on at

Like (0)

Report
Copy link

Link copied!

I figured out the problem. At my organization, we technically have two emails; one with our name and one with our employee ID. Turns out the User().Email pulls our employee ID email and the people picker field in SharePoint is our name email.

This is what I ended up doing:

If(!IsBlank(LookUp('User List',Employee_ID = Left(User().Email,5)

Was this reply helpful? Yes No