Filter CDS collection with multiple dropdowns

[bd528]

I have created a collection from a CDS table, and using multiple dropdowns, I'd like to filter it using something like :-

Filter(
'CollApps',
Column1 = Dropdown1.Selected.Value,
Column2 = Dropdown2.Selected.Value,
Column3 = Dropdown3.Selected.Value,
Column4 = Dropdown4.Selected.Value,
Column5 = Dropdown5.Selected.Value
)

Some of the columns are optionset type, and I can't figure out how to translate this from the dropdown values.

This filter works :-

Filter(collApps, 'App Deleted' = 'App Deleted'.No))

but this doesn't

Filter(collApps, 'App Deleted' = "No"))

[CNT]

@bd528 You are right,

This will work,

Filter(collApps, 'App Deleted' = 'App Deleted'.No))

This will not work, b'coz here you are trying to compare Choices (previously called Option Set) to a Text

Filter(collApps, 'App Deleted' = "No"))

If you are using a DropDown your formula will be something like,

Filter(
'CollApps',
Column1 = Dropdown1.Selected.Value,

.....

.....
)

If you are using a ComboBox your formula will be something like,

Filter(
'CollApps',
Column1 in Combobox1.SelectedItems,

.....

.....
)

Hope this helps!

[bd528]

Filter(
'CollApps',
Column1 = Dropdown1.Selected.Value,

.....

.....
)

This doesn't work. PowerApps says the left value is optionset, and the right is text.

[CNT]

@bd528 What is the Items property for the Dropdown?

[CNT]

@bd528 The Items property for the Dropdown/Combobox must be,

Choices('your option set')

[bd528]

[true, false]

[CNT]

@bd528 That won't work.

The Items property for the Dropdown/Combobox must be,

Choices('your option set')

[bd528]

I've changed item for the dropdown to  Choices('App Deleted') and I'm still getting the optionset/text mismatch.

[CNT]

@bd528 Is the Data Type for this Column Choices or Yes/No?

Could you share a screen shot of the error.

[CNT · Accepted solution]

@bd528 If you are using Choices, the Items property will be,

Choices('your option set')

If you are using Yes/No, the Items property will be,

Choices('column name (your table)')