Clear all filters button not working

(0) Share

Report

Posted on by T_T00

Hello,

I have a "Category Gallery" that shows product categories and a "Product Gallery" that shows all products.

When I click on a product category in the "Category Gallery", the "Product Gallery" will filter all products to that selected product category.

To do that, I have set a filter on the "Product Gallery" Items = Filter('Product Inventory',ProductCategory = ProductCategoriesGallery.Selected.ProductCategory).

I am now searching for a way to reset the filter, so that all products show, irrespectively of their category.

I've tried a Button control with OnSelect = Reset(ProductCategoriesGallery), but that isn't working.

I find solutions for dropdown or text filters, but nothing to help me to get this requirement working.

Many thanks for any advise.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

asdasdasdasdasd 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi There,

Some logic you could use is to set a context variable or a standard variable that checks if the data is currently filtered.

Lets assume your variable is called "is_fitlered" then use set(is_filtered,true) which is applied on the on change property of the category filter. You can use set(is_filtered,false) which is applied to the on select of your reset button.

Your syntax on the product inventory will be:

If(is_filtered, //this validates if your is_filtered variable is true and requires your dataset to be filtered
Filter('Product Inventory',ProductCategory = ProductCategoriesGallery.Selected.ProductCategory), //if is_filtered is true then show the filtered value
Your_Unfiltered_Field) //if is_filtered is false then show your dataset unfiltered (the default state of your dropdown, something like Choices('Product Inventory'.ProductCategory)

Was this reply helpful? Yes No
T_T00 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @asdasdasdasdasd,

Sorry, but I am now confused. Mind you, I am pretty new to Power Apps!

There are no choice columns in my tables and I am not using dropdowns.

Can you please elaborate, be more explicit as to what I need to do where? Many thanks 🙂

Was this reply helpful? Yes No
Verified answer

asdasdasdasdasd 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies, I misread and will delete the previous response.

Just clarifying, You have 2 galleries, one that filters the other, but would like a button to reset the filtered gallery.

On your clear filter button's onSelect property you can use context variables to remove the filter on your gallery:
UpdateContext({is_filtered:false})

On your Product Gallery items use this syntax which checks to see if a Category is selected and will apply the filter:

If(is_filtered,
Filter('Product Inventory',ProductCategory = ProductCategoriesGallery.Selected.ProductCategory),
'Product Inventory')

On your Category Gallery onSelect property use this:

UpdateContext({is_filtered:true})

Was this reply helpful? Yes No
T_T00 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks for looking at this again. That worked 🎆

Was this reply helpful? Yes No