Answered

Issue with comparison user value

(0) Share

Report

Posted on by Shreya308

I have a SharePoint table which has a column posted by (data type people). And my app has a email address variable.

I want to set a condition on a button that if the email variable is in the posted by column navigate to page 1 otherwise navigate to page 2,

Can anyone please help me with this I am new to power app and learning through small app of my own

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

madlad 2,637 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
You should be able to do something along the lines of:

If( *EmailVariable* in AddColumns(*YourList*, "Emails", *PostedByColumn*.Email).Emails, Navigate(*Page 1*), Navigate(*Page 2*) )

Just make sure to sub in the appropriate names where I've surrounded with Asterisks*, based on your data.

Hope this helps!

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Shreya308 ,

Set the OnSelect property of the button to:

Navigate( If( varEmail in ThisItem.'posted by'.Email, Page1, Page2 ) )

This works under the assumption the button is inside a gallery and the 'posted by' column has multi-select enabled. If any of these assumptions are wrong, please provide the relevant details.

Was this reply helpful? Yes No
stuermer 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey! To achieve that you can use the OnSelect property in combination with an "if-statement". How you are displaying the data from SharePoint? In a Gallery? If so, you can try something like this:

If the button is part of your Gallery item: If(yourEmailVariable = ThisItem.'Posted By'.Email, Navigate(Page1), Navigate(Page2))

If the button is not part of your Gallery: If(yourEmailVariable = YourGalleryName.Selected.'Posted By'.Email, Navigate(Page1), Navigate(Page2))

Instead of using a variable for the email you could also user user().email to get the currents user's mail address.

Let me know if this helps you.

Was this reply helpful? Yes No