No values shown by combining multiple filters in a gallery

(0) Share

Report

Posted on by roby9390

105

Hi,

I need your help for solve this matter. I have a gallery with the following functions inserted in the Items property:

SortByColumns(
 Filter(
 DB_DettaglioConsegne;
 And(
 DataOraArrivo >= FiltroDataVigilanza.SelectedDate;
 Or(
 IsBlank(FiltroAutoreVigilanza.Selected.Value);
 PortineriaIngresso = FiltroAutoreVigilanza.Selected.Value
 );
 StatoConsegna.Value = FiltroStatoVigilanza.Selected.Value
 )
 );
 "DataOraArrivo";
 SortOrder.Ascending
)

To my eyes, the functions seem to be entered correctly (no errors are highlighted), but the gallery does not show any items even though it should.
The error is on the Filter part but I don't understand where I am going wrong.
Any ideas?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @roby9390

can you try this please:

SortByColumns( Filter( DB_DettaglioConsegne, DataOraArrivo >= FiltroDataVigilanza.SelectedDate && (IsBlank(FiltroAutoreVigilanza.Selected.Value) || PortineriaIngresso = FiltroAutoreVigilanza.Selected.Value) && StatoConsegna.Value = FiltroStatoVigilanza.Selected.Value ), "DataOraArrivo", SortOrder.Ascending )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606 and thank you for the answer.
Just tried it but I have the same problem.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @roby9390,

I think if there is no syntax error, there must be no items mateched with your condition.

Based on your syntax, you want to filter items:

1). with date greater than or equals to selectedDate

2). and with PortineriaIngresso selected from FiltroAutoreVigilanza(blank allowed)

3). and with StatoConsegna selected from FiltroStatoVigilanza

All above conditions must be met at the same time, is this what you want to achieve?
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!
Ok found the error but now I have the following problem. In the below functions of Item property of my gallery I have inserted this code:
SortByColumns( Filter( DB_Leci; 'Data/ora creazione' >= FiltroDataHomePage.SelectedDate; StatoMezzo.Value = FiltroStatoVigilanza.Selected.Value; Autore.DisplayName = FiltriPortineria.Selected.Value ); "DataOraIngresso"; SortOrder.Ascending )
This run correctly but I want add another filter that OnCheck of ToggleButton named "FiltroVisitatori" shown only the record that contains in the multiple choices column named "CaricoScarico" the value "Visitatori".
How can I do?