Skip to main content
Community site session details

Community site session details

Session Id : H+z7JlGvwIBsAMV7/QhXF7
Power Apps - Building Power Apps
Unanswered

Navigate Based on User and Record Value

Like (0) ShareShare
ReportReport
Posted on 27 Jul 2023 14:17:19 by

Hi Experts,

 

I've got a gallery (Gallery2) and a button which i've set the OnSelect to the below which doesn't work and i'm not sure where i've gone wrong, please help to advise as if the ChangeStatus for the Gallery2.Selected is "1st Stage Approved" and the user is listed in one of many textboxes then Navigate to Screen1 BUT if the ChangeStatus for the Gallery2.Selected is "Submitted" and the user is listed in one of four textboxes then Navigate to a screen called Stage1Approval

 

Gallery2.Selected;
Navigate(
 If(
 LookUp(ChangeRequests, ChangeStatus = "1st Stage Approved",
 With(
 {wEmail: User().Email},
 wEmail in TechSales1.Text || wEmail in TechSales2.Text,
 wEmail in Commercial1.Text || wEmail in Commercial2.Text,
 wEmail in Sales1.Text || wEmail in Sales2.Text,
 wEmail in 'R&D1'.Text || wEmail in 'R&D2'.Text,
 wEmail in QHSE1.Text || wEmail in QHSE2.Text,
 wEmail in Production1.Text || wEmail in Production2.Text,
 wEmail in Compliance1.Text || wEmail in Compliance2.Text,
 wEmail in IT1.Text || wEmail in IT2.Text,
 'Screen1'
 ))),
 LookUp(ChangeRequests, ChangeStatus = "Submitted",
 With(
 {wEmail: User().Email}, 
 wEmail in TechSales1.Text || wEmail in TechSales2.Text,
 wEmail in Commercial1.Text || wEmail in Commercial2.Text,
 'Stage1Approval'
))))

 

Thanks in advance! 

Dave

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1