Unanswered

How to Filter a Gallery using a Combo Box

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a basic Gallery on a screen and need to filter it based on the (possibly) multiple selections in the Combo Box control (not the drop-down).

I can't find a working solution for this. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!
You can use the in operator to check if one of the properties of the element in the collection that is being filtered was selected in the combobox, using the combobox SelectedItems property. For example, if you have a combobox with the following expression for the Items element:
["Produce", "Dairy", "Household Items", "Bakery", "Meats", "Pantry"]
And a data source (Products) with a column named "Department". If you want to show in a gallery the items for the selections, you can use this expression:
Filter(Products, Department in ComboboxDepartments.SelectedItems.Value)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Thanks, Carlos, but it's not working. I might be missing something obvious. Here are the details.

This is my Combo:

And this is my Gallery's formula on Items. The Inventory data source is a SharePoint List, and ItemType is a Choice column.

And the resulting error:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Any thoughts, this is holding up our project. Thank you for your help!

Was this reply helpful? Yes No
drawser 121 on at

Like
a
(3)

Report
Copy link

Link copied!
Hi,
I was having the same issue as well, after tinkering with varoius ways of doing this,
found that the formula mentioned before works with just a bit of a minor change.

You have to add .Id to Departments and change the SelectedItems.Value to
SelectedItems.ID

Filter(Products, Department.Id in ComboboxDepartments.SelectedItems.ID)

At least this works on my end, my data is from SharepointLists.

Was this reply helpful? Yes No
XenophonD 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I am having the same problem and haven't seen a clear answer anywhere on this either. Anybody have any answers for this issue?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
I have data in SQL Server and am using this equivilant to allow multiple selections.

Filter(Products, Id in ComboboxDepartments.SelectedItems.ID)

Was this reply helpful? Yes No
GarrySun 22 on at

Like
a
(10)

Report
Copy link

Link copied!
In case anyone else experience this issue, the formula should list the column name after the SelectedItems.
Example:
Filter(DataSource, ColumnName in ComboBox.SelectedItems.ColumnName)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

This worked great!

As a potential bonus for functionality, I set up my Gallery to change based on the search text until a user selected an item, then it switches to display only selected items:

If(CountRows(ComboBox.SelectedItems) = 0 || IsBlank(ComboBox.SelectedItems) , Search(DataSource, ComboBox.SearchText, ColumnName, Filter(DataSource, ColumnName in ComboBox.SelectedItems.ColumnName))

Edit: Had to add an 'Or' condition for initial loads where the ComboBox.SelectedItems is blank.

Was this reply helpful? Yes No
Aleks 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hero, after lots of tinkering and frustration... this was exactly the thing I was looking for.

Was this reply helpful? Yes No
aamir 52 on at

Like
a
(1)

Report
Copy link

Link copied!

Is the IN() function giving delegate error (yellow triangle)? If so, what should be the correct comparison operator for the Combobox?

Was this reply helpful? Yes No