Answered

Sort by two colums

(0) Share

Report

Posted on by ReeX

Hi,

I have two buttons above the gallery. One sets the SortDatum value and the other sets SortFehlerDatum. Why in this case does sorting work for the first value Datum?

How could I make it sort by both values?

SortByColumns(
 Filter(
 DataFB,
 And(
 Or(
 IsBlank(dpStartDate.SelectedDate),
 Datum >= dpStartDate.SelectedDate
 ),
 Or(
 IsBlank(dpEndDate.SelectedDate),
 Datum <= dpEndDate.SelectedDate
 ),
 Bauteile.Value = varBauteile
 )
 ),
 "Datum",
 If(
 SortDatum,
 SortOrder.Descending,
 SortOrder.Ascending
 ),
 "FehlerBild",
 If(
 SortFehlerBild,
 SortOrder.Descending,
 SortOrder.Ascending
 )
)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hey @ReeX

can you try this please:

If( SortDatum, SortByColumns( Filter( DataFB, And( Or( IsBlank(dpStartDate.SelectedDate), Datum >= dpStartDate.SelectedDate ), Or( IsBlank(dpEndDate.SelectedDate), Datum <= dpEndDate.SelectedDate ), Bauteile.Value = varBauteile ) ), "Datum", If( SortOrderToggle, // Assume SortOrderToggle is a toggle for ascending/descending SortOrder.Descending, SortOrder.Ascending ) ), SortByColumns( Filter( DataFB, And( Or( IsBlank(dpStartDate.SelectedDate), Datum >= dpStartDate.SelectedDate ), Or( IsBlank(dpEndDate.SelectedDate), Datum <= dpEndDate.SelectedDate ), Bauteile.Value = varBauteile ) ), "FehlerBild", If( SortOrderToggle, // Reuse the same toggle or use another one if different sorting orders are needed SortOrder.Descending, 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
ReeX 49 on at

Like
a
(0)

Report
Copy link

Link copied!

hey @mmbr1606

what is SortOrderToggle?
Sanshubhs 98 on at

Like
a
(0)

Report
Copy link

Link copied!
SortByColumns( Filter( DataFB, And( Or( IsBlank(dpStartDate.SelectedDate), Datum >= dpStartDate.SelectedDate ), Or( IsBlank(dpEndDate.SelectedDate), Datum <= dpEndDate.SelectedDate ), Bauteile.Value = varBauteile ) ), If( SortDatum, "Datum", "FehlerBild" ), If( varSort, SortOrder.Descending, SortOrder.Ascending ) )