5 sharepoint user list for 5 screen option Powerapp

(0) Share

Report

Posted on by Shef1192

Hi,

I created a power app with 5 screens and 5 user list and home page have 5 buttons. and when someone login based on app, they supposed to access screen.

1 user list is admin and rest 4 are different department, who shouldn't be able to see other 4 option and screen and data.

I written this query on "Onstart" parameter, but I cannot be able to executive it properly.

If(
 !IsBlank(
 LookUp(
 'Admin List',
 Title = User().Email
 )
 ),
 Set(
 is_admin,
 true
 ),
 If(
 !IsBlank(
 LookUp(
 Assurance_1,
 Title = User().Email
 )
 ),
 Set(
 is_Assurance,
 true
 ),
 If(
 !IsBlank(
 LookUp(
 Consulting_1,
 Title = User().Email
 )
 ),
 Set(
 is_CNS,
 true
 ),
 If(
 !IsBlank(
 LookUp(
 PAS_1,
 Title = User().Email
 )
 ),
 Set(
 is_PS,
 true
 ),
 If(
 !IsBlank(
 LookUp(
 Tax,
 Title = User().Email
 )
 ),
 Set(
 is_TX,
 true
 ),
 If(
 !IsBlank(
 LookUp(
 SaT,
 Title = User().Email
 )
 ),
 Set(
 is_ST,
 true
 ),
 Set(
 is_ST,
 false
 )
 )
 )
 )
 )
 )
)

Categories:

Building Power Apps

I have the same question (0)