cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swoodall123
Helper II
Helper II

Multiple Choices HELP in Combobox

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)

1 ACCEPTED SOLUTION

Accepted Solutions

@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

 

View solution in original post

8 REPLIES 8
AmDev
Super User
Super User

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
Helper II
Helper II

@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

@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
Helper II
Helper II

@AmDev 

swoodall123_0-1658404995584.png

swoodall123_1-1658405026830.png

 

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
Helper II
Helper II

@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 . 

@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
Helper II
Helper II

@AmDev THANK YOU SO MUCH 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,169)