Filtering a Gallery with multiple options selected uisng a ComboBox

[jslsmithyx]

Hi Community, 

I was wondering whether there is any existing guidance for filtering a gallery with multiple options selected using one Combobox? 

I currently have a simple gallery set up, where I can filter my data source (SharePoint list) by selecting a 'Proposal Status' via a drop-down. I also have another dropdown & search box built-in for additional filtering.

I'd like to be able to filter by multiple Proposal Status' at any one time. 

This is the current code that works fine using the dropdown to filter: 

Search(
If(SDMDD2.Selected.Result ="All" And PROPSTATDD.Selected.Value = "All", 'Release Dashboard',
SDMDD2.Selected.Result ="All" And PROPSTATDD.Selected.Value <> "All",
Sort(Filter('Release Dashboard', 'Proposal Status'.Value = PROPSTATDD.Selected.Value), 'Impacting Due Date', Ascending),
SDMDD2.Selected.Result <> "All" And PROPSTATDD.Selected.Value = "All",
Sort(Filter('Release Dashboard','Receiving SDM' = SDMDD2.Selected.Result), 'Impacting Due Date', Ascending),
SDMDD2.Selected.Result <>"All" And PROPSTATDD.Selected.Value <> "All",
Sort(Filter('Release Dashboard','Receiving SDM' = SDMDD2.Selected.Result And 'Proposal Status'.Value = PROPSTATDD.Selected.Value), 'Impacting Due Date', Ascending)),
TextInput1.Text, "PR_x0020_Number", "CR_x0020_Number_x0020__x002f__x0", "Project_x0020__x002f__x0020_CR_x")

PROPSTATDD.Selected.Value represents the dropdown I'd like to convert to a ComboBox. 

I have attempted this using '*ComboBoxName*.SelectedItems.Value' in place of 'PROPSTATDD' but have had no luck so far. 

Any help would be appreciated. Thank you! 

Joe 

[eka24 · Accepted solution]

Try

Status.Value in 

ComboBoxName.SelectedItems

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[jslsmithyx]

Thanks for the quick response. 

I have tried the recommended (attached) & my gallery is not returning any values

Any ideas? 

Joe 

[WarrenBelz]

@jslsmithyx ,

You have several delegation warnings in that code - how many items are in your data file?

[jslsmithyx]

@WarrenBelz , @eka24 , 

Apologies for taking so long to respond - I have just returned off leave. 

Happy to confirm I've managed to get the filtering with multiple selections using multiple ComboBoxes resolved! 

I was using the wrong combination of 'Selected.Value', 'in' & 'SelectedItems', so thanks for pointing me in that direction. 

For anyone else viewing this post struggling with the same problem, I found this PowerApps forum page really helpful. 

@WarrenBelz - I do have lots of delegation warnings. I'm not sure why as my data source (SharePoint list) only has 100 or so entries. As it's not currently causing me any issues, I'm going to pretend they don't exist 😄 

Cheers again, 

Joe 

[WarrenBelz]

Hi @jslsmithyx ,

You might have a read of my blog on using the With() statement to avoid these - it may be useful to you.

[jslsmithyx]

@WarrenBelz - Very useful information. Thank you.