Answered

Filtering Gallery with Multiple Comboboxes

(0) Share

Report

Posted on by BadCode

Good morning! I am attempting to filter a gallery with 4 different comboboxes. One is multiselect and the other 3 are single select. I cannot for the life of me figure out how to add the other 3 single select comboboxes to the filter function.

The working code I have for the multiselect combobox is listed below:

Filter('ListName',

Or(

IsBlank(ComboBox1.SelectedItems),

IsEmpty(ComboBox1.SelectedItems),

'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,1)).Value,

'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,2)).Value,

'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,3)).Value,

'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,4)).Value

)

Any help on how to add the remaining 3 single select comboboxes would be very appreciated. Thank you in advance!

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
It would look something like this (depending on your data):

Filter('ListName', Or( IsBlank(ComboBox1.SelectedItems), IsEmpty(ComboBox1.SelectedItems), 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,1)).Value, 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,2)).Value, 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,3)).Value, 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,4)).Value, 'Column 2'.Value=Combobox2.Selected.Value ) )

The key bit is that you access the properties from your single select combobox by using combobox.Selected.COLUMN
BadCode 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately this did not work. 😞

Thanks.
charlessexton 11 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I showed you how to add a single select combobox to your code. What's the bit you're struggling to figure out?
BadCode 29 on at

Like
a
(0)

Report
Copy link

Link copied!

I added the code for the single select combobox and when filtering it did not work. It still showed all the other options as well. For example I filtered to a certain location with the single select and the gallery still showed all the locations.
Verified answer

SolTeferi on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @BadCode ,
Please try this.
Filter('ListName', (IsBlank(ComboBox2.Selected.Value) || 'Column 1'.Value = ComboBox2.Selected.Value) && (IsBlank(ComboBox3.Selected.Value) || 'Column 1'.Value = ComboBox3.Selected.Value) && (IsBlank(ComboBox4.Selected.Value) || 'Column 1'.Value = ComboBox4.Selected.Value) && Or( IsBlank(ComboBox1.SelectedItems), IsEmpty(ComboBox1.SelectedItems), 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,1)).Value, 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,2)).Value, 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,3)).Value, 'Column 1'.Value=Last(FirstN(ComboBox1.SelectedItems,4)).Value ) )
BadCode 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Duuuuuude... Thanks man, nailed it!
Nand_Basto 64 on at

Like
a
(0)

Report
Copy link

Link copied!

That's Awesome buddy,

Can you also tell me the code when I have all 4 as multi-select-ComboBoxes?

Thanks in advance!😌
SolTeferi on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Nand_Basto ,

This topic is closed. If we put multiple solutions for one topic (but, in reality for multiple cases) , it will confuse folks who search and land here to find similar solutions. So, would you please post a new topic with your question. I will try to keep an eye and give you a solution there. Thanks!