Filter a gallery using a combobox with multiple values

(0) Share

Report

Posted on by JasonCastro

111

In my combobox, multiple values are selected, how to select the values that are in the combo and filter the gallery?

I need to select all lines where there are values selected in the combobox

The error I receive is that they are incompatible types: Txt, Table, how to resolve it?

My code that doesn't work when I compare the EQUIPS column with the values that are in the combobox

My Gallery

SortByColumns(
 Filter(
 TBL_CONTROLE_DIESEL;
 ID=txtAtendimento.Text || IsBlank(txtAtendimento.Text);
 EQUIPS= ComboBox3.SelectedItems || IsBlank(ComboBox3.SelectedItems)
 );
 "ID";
 SortOrder.Descending
)

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JasonCastro ,
Assuming you are selecting multiple records in the Combo Box and EQUIPS is a Choice field (if Text you do not need .Value)

SortByColumns( Filter( TBL_CONTROLE_DIESEL; ID=txtAtendimento.Text || IsBlank(txtAtendimento.Text); EQUIPS.Value in ComboBox3.SelectedItems || IsBlank(ComboBox3.SelectedItems) ); "ID"; SortOrder.Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
JasonCastro 111 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thx for the help, but, It looks like I can't use the ".Value" with the Equips column, give a error.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@JasonCastro ,

Then leave it off if EQUIPS is a Text column (as I noted)
JasonCastro 111 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz wrote:
@JasonCastro ,
Then leave it off if EQUIPS is a Text column (as I noted)
A new erros appears, now in the selectedItems: "Invalid schema, Expected a one-column table". Any ideas?

Yes, the "EQUIPS" collum is a Text, and the combobox items are from a lookup column

This is how I enter the data in the combo box:

Set(varUserItens;LookUp(TBL_PERFIL_USUARIO; E_MAIL = userEmail).EQUIPAMENTS);;
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@JasonCastro ,

If the Combo Box is Single Selection

SortByColumns( Filter( TBL_CONTROLE_DIESEL; ID = txtAtendimento.Text || IsBlank(txtAtendimento.Text); EQUIPS = ComboBox3.Selected.Value || IsBlank(ComboBox3.Selected.Value) ); "ID"; SortOrder.Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps