Unanswered

Use checkbox to filter gallery based on current user

(0) Share

Report

Posted on by starnewc060708

I have a gallery called Gallery2 in a ticketing system. I want to create a checkbox that will allow the gallery to be filtered based on the current user. The name in SharePoint is 'Assigned to' and it is by UserName. So when the user clicks that checkbox, it will filter the tickets so it shows only ones that are assigned to them.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

wolenberg_ 1,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @starnewc060708

You can do a conditional filter:
If(CheckBox.Checked, Filter(YourList, 'Assign To'.Email = User().Email),YourList)
-------------------------------------------------------------------
If my reply helped you, please give a 👍
If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it.
starnewc060708 35 on at

Like
a
(0)

Report
Copy link

Link copied!

That just threw me an error. I don't want to display by email. Want to by DisplayName.
wolenberg_ 1,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
So just do it the adjusment for DisplayName :
If(CheckBox.Checked, Filter(YourList, 'Assign To'.DisplayName = User().DisplayName),YourList)
starnewc060708 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Still get an error. Not just one piece, it's the whole formula.
wolenberg_ 1,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Here it an example that i did with my list:

There is a gallery with no filters, and when I hit Check the box "My Itens" that was the result:

So the formula still the same:

If( Checkbox1.Value, Filter( 'Your List', Approver.DisplayName = User().FullName ), 'Your List' )
-------------------------------------------------------------------
If my reply helped you, please give a 👍
If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @starnewc060708,

It won't display by email, it's just a filter parameter because sometimes DisplayName from SP Person column is not the same one as the Full Name from User() function.

So, filter by Email is relatively safe.

If(CheckBox.Value, Filter(YourList, 'Assign To'.Email = User().Email),YourList)