Multiple combobox filter with multiple choices each

[Fernanda]

Hello everybody!

I could use a little help with this topic. I have been reading a lot and watching youtube videos, but I can't get my filter to work properly.

This is my scenario: I have a SP database, and there are 2 columns that are multichoice, rest are texts mostly.

My gallery needs to be filtered by 5 components, they can be combined with eachother, or they can only select one to filter.

I can make this work perfectly when I don't have multichoice columns to filter. At first, I was only using my basic filters and the multichoice I had it applied in the Visible property of the gallery item to avoid delegation, but it runs very slow. But now, my problem got a little more complicated, because I had to add a new multichoice filter.

This is my filtering components, where "Categoría Productos" and "Empresa" are multichoices.

Razón Social: Combobox2, Text type, isSearchable, not multichoice

Nombre Fantasía: Combobox1, Text type, isSearchable, not multichoice

RUT: TextInput1

Empresa: Combobox2_1, Choice type, not searchable, multichoice

"Categoría Productos" create a collection with each selection that are collected in a collection and becomes the input to a hidden combobox (which I use for the filter). Collection name: colCategoria, Combobox 3

So, right now, my gallery is filtered with this formula:

If(
   Len(ComboBox2_1.Selected.Value)=0;
   'Base Proveedores';
   Ungroup(
      ForAll(
         ComboBox2_1.SelectedItems As aSel;
         Filter(
            'Base Proveedores';
            aSel.Value in 'Empresa a proveer'.Value; StartsWith(Title;TextInput1.Text) && IsBlank(TextInput1); (IsBlank(ComboBox2.Selected.Result) || ComboBox2.Selected.Result = 'Razón Social Completa') && (IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = 'Nombre de fantasía')
         )
      );
      "Value"
   )
)

And my item is Visible under this formula:

If(CountRows(ComboBox3.SelectedItems.Value)> 0 ;"yes" in Concat(ForAll(ComboBox3.SelectedItems.Value; If(Value in ThisItem.'Cat. Prod/Serv'.Value;"yes";"no"));Value);"true")

My main filter is not working at all and only filters under the Visible property.

Can you please help me?? I'm pretty sure there's got to be a smarter way to do this, but I just can't see it

[FLMike · Accepted solution]

Hi,

Please take a look here Solved: Filter multiple selection choice column - Power Platform Community (microsoft.com)

It is a ugg thing and way to have to do it, but it works.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Fernanda]

Hello!!

Thank you! I had not seen that thread, and I tried to use that solution, but it is not working entirely for me.

Filter
('Base Proveedores';StartsWith(Title;TextInput1.Text);
(IsBlank(ComboBox2.Selected.Result) || ComboBox2.Selected.Result = 'Razón Social Completa') && 
(IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = 'Nombre de fantasía')&&
IsBlank(ComboBox3.SelectedItems.Value) || IsEmpty(ComboBox3.SelectedItems) || true in ForAll('Cat. Prod/Serv'.Value; ThisRecord in ComboBox3.SelectedItems.Value)&&
IsBlank(ComboBox2_1.SelectedItems.Value) || IsEmpty(ComboBox2_1.SelectedItems) || true in ForAll('Empresa a proveer'.Value; ThisRecord in ComboBox2_1.SelectedItems.Value 
)
)

With this formula, everything works, except for one of the multichoices "Empresa.

[FLMike]

Hi,

gonna give you a little razzing.. You say it doesn't work.. ummm.. and how doesn't it work, show me an error :-P. I did still have my crystal ball but my wife said im on break so she stole it from me 😞 

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Fernanda]

 hahahaha i missed my crystal ball aswell

there is actually no error that I can show you... formula has no mistakes, but it won't filter all comboboxes

[Fernanda]

Hey!

I got it working... i changed the && for ; and now it works!

Filter
('Base Proveedores';StartsWith(Title;TextInput1.Text);
(IsBlank(ComboBox2.Selected.Result) || ComboBox2.Selected.Result = 'Razón Social Completa'); 
(IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = 'Nombre de fantasía');
IsBlank(ComboBox3.SelectedItems.Value) || IsEmpty(ComboBox3.SelectedItems) || true in ForAll('Cat. Prod/Serv'.Value; ThisRecord in ComboBox3.SelectedItems.Value);
IsBlank(ComboBox2_1.SelectedItems.Value) || IsEmpty(ComboBox2_1.SelectedItems) || true in ForAll('Empresa a proveer'.Value; ThisRecord in ComboBox2_1.SelectedItems.Value 
)
)

thanks for taking the time to help me!!