Gallery Multi filer issue

(0) Share

Report

Posted on by Calcioscacchi

413

Hi there,

I'm following the videos published by @RezaDorrani about filtering items in a gallery.

I'm having some trouble with filtering items from a checkbox.

As you can see I successfull filter my items with a Combobox, selecting my choices from a sharepoint list column values.

But if I check the checkBox values, the Combobox value is correctly updated but the filter doesn't works.

Here's the Items property code of my gallery:

SortByColumns(
 Filter(
 'TEST-GESTIONE CAMPIONI';
 StartsWith(
 Petitioner;
 PetitionerFilter.Text
 ) && ( 'Analysis status' in ComboBox1.SelectedItems || ComboBox1.Selected.Value=Blank())
 );
 "field_7";
 Descending
)

And the properties of my ComboBox:

Do you have some hints?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Calcioscacchi ,

What's the relationship between Check box and Combo box? Why do you use the Check box to select Combo box then filter Gallery?

Please try below if Combo box allows single selection:

SortByColumns( Filter( 'TEST-GESTIONE CAMPIONI'; StartsWith( Petitioner; PetitionerFilter.Text ) && ( 'Analysis status'.Value = ComboBox1.Selected.Value || IsBlank(ComboBox1.Selected)) );//replace ComboBox1.Selected with colAnalysisStatusFilter if using CheckBox to filter "field_7"; Descending )

If you need the Combo box allow multiple selections:

SortByColumns( Filter( 'TEST-GESTIONE CAMPIONI'; StartsWith( Petitioner; PetitionerFilter.Text ) && ( 'Analysis status'.Value in ComboBox1.SelectedItems.Value || IsBlank(ComboBox1.Selected)) );//replace ComboBox1.Selected with colAnalysisStatusFilter if using CheckBox to filter "field_7"; Descending )

Best regards,

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!
The relationship between the Combobox and the gallery containing my checkboxs is the Combobox DefaultSelectedItems property, setted with

colAnalysisStatusFilter.Value

This collection is populated with the Oncheck/OnUncheck properties of each combobox:
Oncheck: Collect(colAnalysisStatusFilter;ThisItem)
OnUncheck: Remove(colAnalysisStatusFilter;ThisItem)

Your code works quite fine but if in the Gallery I have not the element i'm looking for, nothing happens. I desire to have no items at all:

EDIT: my problem was a reset button. I must insert
RemoveIf(colAnalysisStatusFilter;true)
in my reset button in order to clear the collection.

Was this reply helpful? Yes No