Problem with filtering by multiple select values in combobox

[Piter_D]

Hi, i have problem with filtering gallery by few values in combobox4_1

This is my code, which are created with support @RandyHayes :

With(
    {
        _preFilter: Filter(
            TabCrysisSP,
            StartsWith(
                Item,
                TextSearchBox1.Text
            ),
            StartsWith(
                MCO,
                TextSearchBox2.Text
            ),
            StartsWith(
                'Type no',
                TextSearchBox4.Text
            ),
            IsBlank(ComboBox2_1.Selected.Result) || Vendor = ComboBox2_1.Selected.Result,
            IsBlank(ComboBox2.Selected.Value) || CFT.Value = ComboBox2.Selected.Value,
            IsBlank(ComboBox1.Selected.Value) || Status.Value = ComboBox1.Selected.Value,
            IsBlank(ComboBox3.Selected.Value) || Action.Value = ComboBox3.Selected.Value,
            IsBlank(ComboBox4.Selected.Value) || Criticality.Value = ComboBox4.Selected.Value
        )
    },
    SortByColumns(
        Filter(
            _preFilter,
            IsBlank(ComboBox4_1.Selected.Result) || ComboBox4_1.Selected.Result exactin 'Production Line'
        ),
        "Created",
        If(
            SortDescending1,
            Descending,
            Ascending
        )
    )
)

 and i have problem with this function exactly:

IsBlank(ComboBox4_1.Selected.Result) || ComboBox4_1.Selected.Result exactin 'Production Line'

i allow multiple selections, but when someone chooses 2 values, then only one is return in gallery 

[Mister_Shaik]

Hi @Piter_D ,

Assuming that 'Production Line' is a string, the condition you wrote is checking if a set of choices (the multiple inputs from ComboBox) exists in a string, which is not correct.

Try replacing the ComboBox4_1.Selected.Result with 'Production Line'

IsBlank(ComboBox4_1.Selected.Result) || 'Production Line' in ComboBox4_1.Selected.Result

Please let me know if this works or if my assumption is wrong.

Kind Regards,

Shaik Sha
________________________________________________________________________

If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Mister_Shaik]

Kind Regards,

Shaik Sha
________________________________________________________________________

If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Piter_D]

unfortunately it does not work, if I choose two values, it filters on the second value

[Piter_D]

maybe something would work that after each onchange I would save the value of the selected value in a variable and then filter by this variable?

[Mister_Shaik · Accepted solution]

My bad, I've just noticed that you're using ".Selected" instead of ".SelectedItems"

Please try changing the code to below and try again:

IsBlank(ComboBox4_1.Selected.Result) || 'Production Line' in ComboBox4_1.SelectedItems.Result

Kind Regards,

Shaik Sha
________________________________________________________________________

If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Mister_Shaik · Accepted solution]

Kind Regards,

Shaik Sha
________________________________________________________________________

If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Piter_D]

Yaaas, thank you very much! 😄