web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sorting By Date (DataV...

Power Apps

Unanswered

Sorting By Date (DataVerse)

(0) Share

Report

Report

Posted on by slng

Hi everyone,

I am having issues sorting a gallery by dates. I am using the current formula for the field "Items" of my gallery:

Sort(

tableName,

DateValue('Created On'),

SortOrder.Descending

)

However, the items are sorted this way:
04 April 2023

03 April 2023

21 April 2023

20 April 2023

19 April 2023

...

10 April 2023 (this is the last record)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @slng,

I unfortunately was not able to replicate this issue but you could omit the DateValue() function (redundant function in this case). Depending on your language/region settings (dd/mm or mm/dd), the functions behaves differently and might be causing the issue. Could you try:

Sort( tableName, 'Created On', SortOrder.Descending //SortOrder.Ascending should you want the oldest first )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No

Join the conversation