Filter gallery based on ComboBox choices

(0) Share

Report

Posted on by Joaoandrebs

361

I have a gallery to make a filter, but I don't know how to make the second filter, the first one already worked.

I have two options, "Turno 1" or "Turno 2" to filter in ComboBox2.

If the user selects Turno 1, it will display the records that have "Ambos" - Column - and "1" in the column.

Ambos would equal Both.

Now if the user selects Turno 2, the gallery will display the records that have "Ambos" and "2". How can I do it?

Filter(
 ListaEditavelOperacoes;
 Len(ComboBox1.Selected.Value) = 0 || Time = ComboBox1.Selected.Value;
 (ComboBox2.Selected.Value) = "Turno 2" & Turno = "2" && "Ambos";
 (ComboBox2.Selected.Value) = "Turno 1" & Turno = "1" && "Ambos")

##my code ...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

developerAJ 4,763 on at

Like
a
(1)

Report
Copy link

Link copied!
@Joaoandrebs

please use this code . i edited code in notepad so i did not check the syntax.
Filter( ListaEditavelOperacoes; Len(ComboBox1.Selected.Value) = 0 || Time = ComboBox1.Selected.Value; if(ComboBox2.Selected.Value= "Turno 2"; Turno = "2" ||Turno ="Ambos";ComboBox2.Selected.Value= "Turno 2"; Turno = "1" ||Turno ="Ambos")

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like
a
(1)

Report
Copy link

Link copied!

@developerAJ thanks, that was the logic, I had to adapt some things but it worked.

Was this reply helpful? Yes No