Role based Screen Navigation on click of a button

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I am developing an app where there are 3 screens.

Home
Screen A
Screen B

In the Home screen, there is a single button which is used for navigating to Screen A and Screen B.

I have a SharePoint List which is connected to this app which has information of all the users of this system. In that list, there is a column named Role. There are 2 types of role.

Role A
Role B

My query is- whenever an user clicks on the button in the Home, if the user is of Role A, it should navigate to Screen A and vice-versa. I am struggling with the function which I should write in the button. Is there anyone who is facing similar issue or have the answer to this?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Hi @Anonymous

In the App Onstart set the current user as a variable:

Set(varUser, Lower(User().Email)).

Then in the navigate button use the following

Navigate(
If(Lookup(YourList, varUser = ListPersonColumn.Email, RoleColumn) = "RoleA",
'ScreenA',
'ScreenB')

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for the answer. But, I can't quite figure out what is wrong here. I am attaching screenshot of my SharePoint List and the formula that I used in the button.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Looks like you are missing a ')' at the end to close the navigate function

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

My bad. But it is still not working. The User.Email is not working.

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

Sorry, I think it was my bad as I had left it out in my original post...

I see the red x - what error message are you getting?

Have you ran app onstart to generate varUser? - Can you show me that formula?

Cheers

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

@Anonymous - also I see your role field is a choice? - if so if should be..

...Role.Value

inside your lookup

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, I have initialized varUser on start.

The error says-
Invocation of unknown or unsupported function.
Invalid use of '.' .

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

I added a further thought abov on your role choice field, not sure if you have seen it?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, I applied Role.Value. It’s still the same.

Was this reply helpful? Yes No
Verified answer

Gerard Simpson 2,987 Moderator on at

Like (0)

Report

I have dipped in to check this and by using the following code in the button it works fine. My app onstart is the exact same as yours.

Point to note though - when I tried writing this code initially it was a bit temperamental and wouldnt find/predict my person field when trying to write out the lookup function - I ending up testing the lookup result in a separate label first, then copied it in and built the remainder of the expression around it and it was fine. Try that.

Also you could just drop the variable and plug Lower(User().Email) directly into the expression.

Last (first I should say..) thing is to make sure your person / choice fields are not set to allow multiselect in your SharePoint list.

Good luck!

Was this reply helpful? Yes No