Answered

Clear Gallery filter with button

(0) Share

Report

Posted on by Fred1411

I use below filter to filter gallery based on 2 dropdown selection. I am try to set a button "OnSelect" to clear this filter and show all items in gallary. Here is filter currently in galary:

Sort(Filter(KPI, Unit.Value = Dropdown1.Selected.Value, KRA.Value= Dropdown2.Selected.Value),Title, Ascending)

I would appreciate some help to implement this button. By the way, i am a rookie 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,910 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Fred1411 ,

Put this on the OnSelect of the button

UpdateContext({varAll:!varAll})

then your Filter

Sort( Filter( KPI, If( varAll, true, Unit.Value = Dropdown1.Selected.Value && KRA.Value= Dropdown2.Selected.Value ) ), Title, Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Fred1411 19 on at

Like (0)

Report
Copy link

Link copied!

Thank you Warren. It works well as expected but with a delegation warning. Also when i click button, (shows all records) but if i select any comboboxes, it wont filter on its own until i click the button again. Therefore, i would need to find a way if this button's display name can be renamed after clicking, for example, from "show all" and then to "enter" maybe. Thank you very much for your time.

Was this reply helpful? Yes No
WarrenBelz 154,910 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Fred1411 ,

I am not sure what the Delegation warning is as these are text values, however to your question - put this on the Text of the Button

If( varAll, "Select to use Filter", "Select all records" )

or whatever message you want - basically the text is the opposite of the setting and clicking the button then produces what is shown on it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No