Answered

SortByColumns only sorting by days instead of months

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I have this code in a gallery and it filters everything correctly until I add records in different months. Instead of sorting by months and then by days inside each month, it filters ONLY by days and completely ignores the months, just like the attached image. What can I do to solve this?

 SortByColumns(
 Filter(Table1_2, 
 DateValue(Text(DATA, "[$-pt-PT]dd/mm/yyyy", "pt"), "fr") >= DateValue(Text(HOJE.SelectedDate, "[$-pt-PT]dd/mm/yyyy", "pt"), "fr") &&
 Estado = "A" &&
 //DateValue(Text(DATA, "[$-pt-PT]dd/mm/yyyy", "pt"), "fr") <= DateValue(Text(FUTURO.SelectedDate,"[$-pt-PT]dd/mm/yyyy", "pt"), "fr") &&
 If(!IsBlank(dpSearchDate.SelectedDate), DateValue(Text(DATA,"[$-pt-PT]dd/mm/yyyy", "pt"), "fr") >= DateValue(Text(dpSearchDate.SelectedDate, "[$-pt-PT]dd/mm/yyyy", "pt"), "fr"), true)
 ),
 "DATA",
 If(SortDescending1,Descending,Ascending)
 )

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The problem you are experiencing is probably due to the fact your data source sees is a a text field.
a string/text field is sorted in a different way than number/date field are.
try to make a local collection of it, add a AddColumn to it in which you set your date field as a datevalue DateValue.

then filter on the new column.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
Thank you for the answer, but how do I do that?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Solved it by changing the SortByColumns to a Sort function and the "DATA" to DateValue(DATA).

Was this reply helpful? Yes No