filter gallery with multi select combobox

(0) Share

Report

Posted on by nicklimcs

hi everyone,

This was the formula that I used to filter the gallery and it works fine. As you can see in the 2nd figure, when I select "Dog" in the CBX, the gallery is showing the expected results.

Figure 1

Figure 2

Now, I enable multi select on the CBX, and changed the formula as below, however it is only returning the first and last row, 2nd row has been skipped.

Can someone point me to the right direction please. Many thanks

Categories:

General Comment

All responses (5)

Answers (0)

nicklimcs 77 on at

Like (0)

Report

filter gallery with multi select combobox

@AndrianaO

I thought I did by checking this checkbox will mark it as "answered". Is there another button for me to click on?
AndrianaO 187 Super User 2025 Season 1 on at

Like (0)

Report

filter gallery with multi select combobox

@nicklimcs Happy to help! I would appreciate it if you verify my answer :)
nicklimcs 77 on at

Like (0)

Report

filter gallery with multi select combobox

@AndrianaO

Thank you. It is working fine.
ronaldwalcott 3,820 on at

Like (0)

Report

filter gallery with multi select combobox

What is the items type of the combo box?
Suggested answer

AndrianaO 187 Super User 2025 Season 1 on at

Like (1)

Report

filter gallery with multi select combobox

Hi! Your formula is not working because you are checking if Animal is in cbx.Selected items, so "Dog;Cat" is neither in "Dog" nor in "Duck".

You can try this formula:

Filter(AddColumns(colTest As outerTable, test, Sum(ForAll(cbx.SelectedItems As innerTable,innerTable.Animal in outerTable.Animal),Value)),test>0)

Let me know if this works!