Unanswered

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

BhargavPatel 660 Moderator on at

Like (0)

Report
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))

Was this reply helpful? Yes No
Chris Ludwig 34 on at

Like (0)

Report

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

Was this reply helpful? Yes No
BhargavPatel 660 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chris Ludwig 34 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No