Answered

Power Apps modern combobox filter

(0) Share

Report

Posted on by Chris Ludwig

Hello everyone,

I am currently building a new Power App and have discovered the modern controls for myself. Unfortunately, I can't build a filter using a modern combobox. The filter should work similarly to the conventional comboboxes so that I can select several values and filter according to these. If I do not select any values, all entries should be displayed. I ran into the problem that I only get the last selected value of the combo box displayed. Does anyone have experience with this and can help me?

All responses (4)

Answers (1)

Chris Ludwig 34 on at

Like (0)

Report

Re: Power Apps modern combobox filter

It looks like it was just a bug. After restarting Power Apps several times, the formula no longer displayed an error and shows no error. The warning on the screenshot was only about large datasets.
How would you have to rewrite the formula if you want to filter a multivalue field of a SharePoint list? If I see it correctly, a table is compared with a table?

Items of the combo Box:

Filter of the Gallery:

Current Error Message:
Some types are incompatible for comparison. These types cannot be compared: Table, Table

Many thanks for the help 🙂
BhargavPatel 628 Super User 2025 Season 1 on at

Like (0)

Report

Re: Power Apps modern combobox filter

Can you hover over the squiggly line over in and || to see what error are you getting?
Also, what is your data source?
Chris Ludwig 34 on at

Like (0)

Report

Re: Power Apps modern combobox filter

I used the "in" operator and unfortunately it didn't work. My formula looks like this
Verified answer

BhargavPatel 628 Super User 2025 Season 1 on at

Like (0)

Report
Re: Power Apps modern combobox filter

Are you using "in" operator and not "=" in the filter condition? I used the below formula and it worked with a delegation warning for SharePoint List as "in" operator is not delegable for SP List, but if you are using Dataverse that will not be an issue.
Filter(<DataSource>, <ColumnName> in ComboboxCanvas1.SelectedItems||IsBlank(ComboboxCanvas1.SelectedItems)||IsEmpty(ComboboxCanvas1.SelectedItems))