Answered

Gallery Filter from Multiple combo box selection

(0) Share

Report

Posted on by SENDAN

Hello,

I hope someone here will be able to help me out. I have a gallery filtering based on a few combo boxes. I would like these combo boxes to allow multiple selections. However, I noticed that my gallery is currently only filtering based on a single selection and not all selected values. The combo boxes are linked to an Excel spreadsheet, and they aren't choices columns. Please see my gallery formula below

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

renatopc84_ch 228 on at

Like (0)

Report

Hi @SENDAN
the problem here is in the Filter formula.
The point is you have all OR conditions also between the 3 Comboboxes.

The Filter should be set differently.

Example:

Filter(
Source,
(Combobox 1 conditions) && // Same as AND
(Combobox 2 conditions) &&
(Combobox 3 conditions)
)

The ; is like a OR in the Filter

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Can the user select multiple options inside each combo box?

Was this reply helpful? Yes No
SENDAN 65 on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @SENDAN,

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

When the user selects multiple items in the combo box for filtering, do they want the query to:
- match any of the selected items (OR)
- match all of the selected items (AND)

Was this reply helpful? Yes No
SENDAN 65 on at

Like (0)

Report

Great, the multi selection now works 🙂

Was this reply helpful? Yes No