Power Platform Community Forum Thread Details

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

Categories:

Using Apps Using Formulas

Connecting to Data