web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sort by date and time

Power Apps

Answered

Sort by date and time

(1) Share

Report

Report

Posted on by Wagemans_Frank

63

Hi

I want to sort my column, depend on datepicker (start) and datepicker (end).
Also the dates have time, so it must be sort ascending by time.

Thx

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

jpespena 335 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

If you want to sort by your Date and Time column, try:
SortByColumns( 'YourDataSource', "DateTimeColumnName", SortOrder.Ascending )

If you want to consider your start and date range picker and sort only items that falls inside the date range, add a filter like this:

SortByColumns( Filter( 'YourDataSource', Or(IsBlank(startdatepicker.SelectedDate), DateTimeColumnName >= startdatepicker.SelectedDate), Or(IsBlank(enddatepicker.SelectedDate), DateTimeColumnName <= enddatepicker.SelectedDate), ) "DateTimeColumnName", SortOrder.Ascending )

If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Was this reply helpful? Yes No

Join the conversation