Multiple Choices HELP in Combobox

[swoodall123]

I am trying to get my combobox to be able to filter multiple choices in my combobox , below is what is in my item box fr

SortByColumns(Filter(
Scope5,
StartsWith(
DOJMNumber,
TextInput1.Text
)&& (DesignCenter = ComboBox4.Selected.Value || ComboBox4.Selected.Value = Blank()) && (Utility = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank()) && (Jobtype= ComboBox5_2.Selected.Result || ComboBox5_2.Selected.Result = Blank())), varSortColumn,varSortDirection)

[AmDev]

Hi @swoodall123 

I am assuming you are trying to filter  Gallery with multiple combo boxes. If so, try:

SortByColumns(

Filter(

Scope5,
StartsWith(DOJMNumber,TextInput1.Text),

DesignCenter = ComboBox4.Selected.Value || IsBlank(ComboBox4.Selected.Value) || IsEmpty(ComboBox4.SelectedItems),

Utility = ComboBox1.Selected.Value || IsBlank(ComboBox1.Selected.Value) || IsEmpty(ComboBox1.SelectedItems),

Jobtype = ComboBox5_2.Selected.Result || IsBlank(ComboBox5_2.Selected.Result) || IsEmpty(ComboBox5_2.SelectedItems)

),

varSortColumn,

varSortDirection

)

[swoodall123]

@AmDev -It let me pick 2 but it won't combine the total. it is still only showing 1 choice and i need it to show multiple. I saw something about concat but i can't figure how to put that in there with sort and filter

[AmDev]

@swoodall123 - Can you share a screenshot to help illustrate the issue you are having and more info on what you are trying to achieve and I will have a look?

[swoodall123]

@AmDev 

[AmDev]

Thanks @swoodall123 - How many different job types do you have in that combo box and is this nr likely to change at any time?

Also I see the jobtype combobox items ends with .result - is this because you are using the distinct function on the jobtype column in your main list?

How many items are in your main list and how large is this likely to grow to?

Sorry a few more questions, but I want to make sure I give you the right advice in the context of delegation etc.

Cheers

[swoodall123]

@AmDev - there are about 9 choices in Job Type. I have a FLOW that work into the gallery so my dataset it large... i shouldn't have more them 400 . 

[AmDev · Accepted solution]

@swoodall123 - the following logic should deal with the multiselect filter for JobType.

SortByColumns(

Filter(

Scope5,
StartsWith(DOJMNumber,TextInput1.Text),

DesignCenter = ComboBox4.Selected.Value || IsBlank(ComboBox4.Selected.Value) || IsEmpty(ComboBox4.SelectedItems),

Utility = ComboBox1.Selected.Value || IsBlank(ComboBox1.Selected.Value) || IsEmpty(ComboBox1.SelectedItems),

Jobtype = Index(ComboBox5_2.SelectedItems,1).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,2).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,3).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,4).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,5).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,6).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,7).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,8).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,9).Result ||

Jobtype = Index(ComboBox5_2.SelectedItems,10).Result ||

IsBlank(ComboBox5_2.Selected.Result) || IsEmpty(ComboBox5_2.SelectedItems)

),

varSortColumn,

varSortDirection

)

Hope this helps

[swoodall123]

@AmDev THANK YOU SO MUCH