Answered

Navigate to the Two Screen, based on User in Two SP List

(0) Share

Report

Posted on by dylandavis09

438

I am trying to navigate users to a screen based on their lookup of User().FullName in two SharePoint lists. Students or staff who click the 'PBiS' icon will be directed to one of two screens, depending on their access in the SharePoint lists.

1. DHS Student Users will be directed to the 'PBiS Student Portal.'

2. DHS Staff Users will be directed to the 'PBiS Staff Portal.

How it's work with that?

If(LookUp('DHS Students Users', 'Full Name' = User().FullName, Navigate('PBiS Student Portal') || 'DHS Staff Users', 'Full Name' = User().FullName, Navigate('PBiS Staff Portal')

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 154,496 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @dylandavis09 ,

You need to compare a field in that list with a value - something like this

If( LookUp( 'DHS Students Users', 'Full Name' = User().FullName ).FieldName = "SomeValue", Navigate('PBiS Student Portal'), Navigate('PBiS Staff Portal') )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz, this may be working, but I have two SharePoint lists. For example, I have shown you what I look like I want.

Otherwise, if neither of the SharePoint lists has 'lookup user().fullname,' it means you can't click the icon.

Was this reply helpful? Yes No
WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@dylandavis09 ,

Sorry, but a bit lost here. What is the field in these lists you are matching the logged-in user with and are you simply seeing if they exist in that list ?

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

It's okay. I'm using the 'Full Name' field in SharePoint lists.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@dylandavis09 ,

I am going to take a guess that my second question is correct - you are looking to see if they exist in either list

If( !IsBlank( LookUp( 'DHS Students Users', 'Full Name' = User().FullName ).Full Name ), Navigate('PBiS Student Portal'), !IsBlank( LookUp( 'DHS Staff Users', 'Full Name' = User().FullName ).Full Name ), Navigate('PBiS Staff Portal') )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

It's worked! Thank you so much for help!

Was this reply helpful? Yes No