Answered

Show all gallery items until filters are applied

(1) Share

Report

Posted on by enlitzinger

I have a gallery that is correctly filtering when I have 1 or multiple things selected (things = 2 combo boxes and 1 text search box). However, I would like to have the gallery display everything when nothing is selected in the combo boxes and the text box. Basically, start with the full list of items in the gallery, and whittle it down as items/values are selected in the combo boxes and text box. The below formula starts with all blanks and brings in the appropriate values as combo box and text inputs are selected.

Gallery Items Property:

Filter('Standards, Disclaimers & Disclosures', 'Review Element(s)' in ComboBox1.SelectedItems.Result || 'Subject Matter ' in ComboBox2.SelectedItems.Result || TextInput1.Text in 'Required Language')

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(2)

Report
Copy link

Link copied!

If(IsBlank(TextInput1) &&IsEmpty(ComboBox1.SelectedItems)&&IsEmpty(ComboBox2.SelectedItems),
Standards,
Filter('Standards, Disclaimers & Disclosures', 'Review Element(s)' in ComboBox1.SelectedItems.Result || 'Subject Matter ' in ComboBox2.SelectedItems.Result || TextInput1.Text in 'Required Language'))

I assume you Datasource is standards
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
enlitzinger 88 on at

Like
a
(0)

Report
Copy link

Link copied!

Edited: Thanks for the help, regrettably the same issue remains. But, I think it is related to a button I embedded:

OnSelect: Reset(ComboBox1);Reset(ComboBox2);Reset(TextInput1)

If I manually remove the selections in the comboboxes the gallery resets normal..so I think the button is the issue. How do I clear the comboboxes and textbox with a click of a button?

You are correct, Standards, Disclaimers & Disclosures is my Datasource.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please I used only standard as the Datasource, did you correct to
'Standards, Disclaimers & Disclosures'

The formula should not be inside the Gallery but on the ITEMS property of the Gallery.

Can you show a screenshot
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
enlitzinger 88 on at

Like
a
(0)

Report
Copy link

Link copied!

you beat me to the punch on responding. I tinkered with it and found the issue resides on my 'clear' button. The formula you provided does in fact work. When I manually remove the selections in the comboboxes or text box the gallery does reset to all items.

My button property is:

OnSelect: Reset(ComboBox1);Reset(ComboBox2);Reset(TextInput1)

I will need to rewrite that action. Thanks for your help.

Was this reply helpful? Yes No