web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps filtering by logged in...

Power Apps

Unanswered

filtering by logged in user email

(0) Share

Report

Report

Posted on by joel914823

557

I'm trying to create a button that when I click on it, it will filter these 5 galleries - if the user().Email is equal to the email of the created by field. Nothing is happening when I click on it, nor do I have errors within the formula.

I have this on the OnSelect property

Filter('eCom Intake','Created By'.Email=User().Email)

Screenshot 2024-04-29 142922.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@joel914823 - I would recommend replacing the Button control with a Toggle control, and then apply the below to the Items property of the Gallery control:

Filter( 'eCom Intake', !Toggle1.Value || 'Created By'.Email = User().Email )

If you must use a Button control, apply the below to the OnSelect property to create a Local Context Variable:

UpdateContext({ctx_myrecords: !ctx_myrecords})

Then apply the below to the Items property of the Gallery control:

Filter( 'eCom Intake', ctx_myrecords || 'Created By'.Email = User().Email )

Optional:

On the Text property of the Button control, enter:

If( ctx_myrecords, "Show My Records", "Show All Records" )

Was this reply helpful? Yes No

Join the conversation