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

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
JasonCastro 111 on at

Like (0)

Report

@WarrenBelz Thx for the help, but, It looks like I can't use the ".Value" with the Equips column, give a error.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@JasonCastro ,

Then leave it off if EQUIPS is a Text column (as I noted)

Was this reply helpful? Yes No
JasonCastro 111 on at

Like (0)

Report
@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);;

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No