Multiple combobox filter with multiple choices each

(0) Share

Report

Posted on by Fernanda

380

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Fernanda 380 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Fernanda 380 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Fernanda 380 on at

Like
a
(0)

Report
Copy link

Link copied!
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!!

Was this reply helpful? Yes No