Announcements
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?
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))
I used the "in" operator and unfortunately it didn't work. My formula looks like this
Can you hover over the squiggly line over in and || to see what error are you getting?
Also, what is your data source?
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 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 494
WarrenBelz 352 Most Valuable Professional
11manish 323
