Answered

Filter for multiple combobox selections in one string

(0) Share

Report

Posted on by Dioz

Hey everyone,

I have the following scenario:
-A combobox with the option for multiple selections enabled. It contains names, but it's not a proper people picker

-A gallery where one item is a string in the form of "Name 1, Name 2, Name 3, Name 4...)

I need to filter my gallery in a way, that every selected item in the combobox is a part of that string.

If I only select one, I can simply use "cmb_Team.Selected.Name in ThisItem.Team" and it works. How could I manage to make it work with multiple names?

I was thinking of using ForAll, but couldn't make it work.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

madlad 2,637 Moderator on at

Like (1)

Report
The ForAll is a good idea. You can use it to check whether each item is in the string, then check whether any of those returns false.

Maybe try something like:

IsEmpty( Filter( ForAll( cmb_Team.SelectedItems, {IsValid: ThisRecord.Name in ThisItem.Team} ), IsValid ) )
This will return a true/false value

Hope this helps!

Was this reply helpful? Yes No
Dioz 61 on at

Like (1)

Report
That sounds like a creative idea, but I couldn't make it work so far.
I only want the filter to apply when something in the combobox is selected, otherwise it should show all. There are additional filters too, but I tried it like this:

If( !IsBlank(cmb_Team.Selected.Name), If( IsEmpty( Filter( ForAll( cmb_Team.SelectedItems, {IsValid: ThisItem.Name in ThisItem.Team} ), IsValid ) ) = false, true, false ), true)

Was this reply helpful? Yes No
Dioz 61 on at

Like (0)

Report

I played around a little more and I think my mistake is that in
{IsValid: ThisItem.Name in ThisItem.Team}
ThisItem.Team refers to the datasource of my Combobox, I just didn't notice because that column exists in both datasources, which aren't the same. Simply changing it to colSampleName.Team doesn't do the trick though. I'm not quite sure what could work for me in this case.

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
If you're using it in a filter statement, and you have multiple datasources, try using an As operator to differentiate.
In the code block you sent, you compare ThisItem.Name and ThisItem.Team - this is comparing one item's 'Name' and 'Team' fields. If you're doing it in a filter function, maybe do something along the lines of:
Filter( *DataSource* As GalData, IsEmpty( Filter( ForAll( cmb_Team.SelectedItems As ComboItems, {IsValid: ComboItems.Name in GalData.Team} ), !IsValid ) ) )

Was this reply helpful? Yes No
Dioz 61 on at

Like (0)

Report

Perfect, that works! Didn't think about using "As" for cases like this in the past, that will come in very handy in other situations too. Thank you so much

Was this reply helpful? Yes No