Answered

Filter Gallery Issue

(1) Share

Report

Posted on by bwebmasta

Hi all,

I have a gallery that I want to filter by the user that created the items, and the status value that was clicked on the buttons shown. Currently, I have that working, but I want to show all items or show all items with the "Pending" status by default. How do I update my gallery filter for that?

The items filter for my gallery:

Sort(Filter(ListeningCenterDG, 'Created By'.Email=User().Email && FilterValue = Status.Value ),Created,SortOrder.Descending)
 
The OnSelect code for the context on each button: UpdateContext({FilterValue: "Pending"})

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @bwebmasta,

Just add this to the Screen’s Visible property. That way, whenever you redirect to this screen, the value will be filled automatically.
UpdateContext({FilterValue: "Pending"});

Filter Code:

Sort( Filter( ListeningCenterDG, 'Created By'.Email = User().Email && Status.Value = FilterValue ), Created, SortOrder.Descending )

Hope that helps!

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

1 people found this reply helpful.

Was this reply helpful? Yes No
bwebmasta 87 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Kalathiya, that works for the pending! If I wanted to display all items by default, how to adjust for that? What I tried has given me errors thus far.

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @bwebmasta,

Please update below code:

Just add this to the Screen’s Visible property.

UpdateContext({FilterValue: Blank()});

Update Filter Code:

Item Property

Sort( Filter( ListeningCenterDG, 'Created By'.Email = User().Email && (IsBlank(FilterValue) || Status.Value = FilterValue) ), Created, SortOrder.Descending )

Now, by default it will show all the items.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

1 people found this reply helpful.

Was this reply helpful? Yes No
bwebmasta 87 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya Thank you! I was missing that part with the context. I also created an "All" button in case users want to reset back to all.

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @bwebmasta,

Updated Code:

Sort( Filter( ListeningCenterDG, 'Created By'.Email = User().Email && (IsBlank(FilterValue) || Status.Value = FilterValue || FilterValue = "All") ), Created, SortOrder.Descending )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No