Answered

Filter two Comboboxes

(0) Share

Report

Posted on by luwu_7100

Hello together,

I try to built a gallery that can be filtered with two comboboxes ("ComboBoxStatus", "ComboBoxName").
Datasource is "List 1" and filtered columns are "status" and "name".
Multiple selections in each dropdown should be possible.

Can anyone help me with the function for filtering?

Thank you,

Lukas

All responses (13)

Answers (1)

luwu_7100 on at

Like (1)

Report

Re: Filter two Comboboxes

Hey @victorcp,
thank you so much for your help, now it works perfectly like I need!
Verified answer

victorcp 2,347 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter two Comboboxes

I was a bit concern about this error and just test it form my side and got the same error. Apparently there was an update that make it not work as it should.

so here it is how I make it work:

Filter( 'List 1', status.Value in ForAll(ComboBoxStatus.SelectedItems,Value).Value || IsBlank(ComboBoxStatus.Selected.Value), name in ForAll(ComboBoxName.SelectedItems,Value).Value || IsBlank(ComboBoxName.Selected.Value) )

Please let me know if it works
TikshaAggarwal 158 on at

Like (0)

Report
Re: Filter two Comboboxes

Hi @luwu_7100 ,
Please replace ; by ,
Filter(Datasource,Status.Value in ComboBox3.SelectedItems.Value)
Also please confirm "ComboBoxStatus", "ComboBoxName are choice types column and mutli-selection if off from SharePoint list

Please click Accept as solution if this helped you solve your issue. This will help others find it more readily. It also closes the item. Please consider giving it Thumbs Up.
luwu_7100 on at

Like (0)

Report

Re: Filter two Comboboxes

Hey, here is the error message. In my question I wrote "List 1" and "ComboBoxStatus" to make it easier to understand, thats why the names are a bit different here.
I tried it at first just with only one condition to make sure this works before i add the second ComboBox. Sorry for German syntax. The error means "This datatype can't be converted. PowerApps can't convert this data from "text" to "record".
victorcp 2,347 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter two Comboboxes

Hello!

as you mention before, status is a 'Choice' column so to access the information stored in this column you have to select the property 'Value' and for 'Sigle Line of Text' columns it is not necessary that's why name is without 'Value'.

Regarding the error could you please take a screenshot of the formula and place it here? because I never see that error in this context
luwu_7100 on at

Like (0)

Report

Re: Filter two Comboboxes

Hey @victorcp ,
I tried your formular, but ".value" from "status.value" is underlined with the information that powerapps can not convert datatyp from type text to type record.
And why du you use "status.value" for the first condition and just "name" without .value in the second?
Thanks,
Lukas
victorcp 2,347 Super User 2025 Season 1 on at

Like (0)

Report
Re: Filter two Comboboxes

Hello,

so the formula will be this:

Filter( 'List 1', status.Value in ComboBoxStatus.SelectedItems.Value || IsBlank(ComboBoxStatus.Selected.Value), name in ComboBoxName.SelectedItems.Value || IsBlank(ComboBoxName.Selected.Value) )

I hope it helps 🙂
luwu_7100 on at

Like (0)

Report

Re: Filter two Comboboxes

I set the combobox items with
Distinct('List 1', Status)
And in my sharepoint list its a choice column that does just allow one choice in each row.
victorcp 2,347 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter two Comboboxes

it will depend on how you set the combobox items, could you share it here please? and also the columns types?
luwu_7100 on at

Like (0)

Report

Re: Filter two Comboboxes

Hey Tiksha,
thanks for your idea. Unfortunatley it doesnt work because ".Value" in Status.Value is underlined red and says that text cant be used in this context.