web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How do I sort a galler...

Power Apps

Answered

How do I sort a gallery by Time (hours and minutes)?

(0) Share

Report

Report

Posted on by Brian-M

437 Super User 2024 Season 1

How do I sort this gallery so that the 6:30 rows comes after the 6:00 AM row and the 1:30 PM row comes after the 1:00 PM row?

Tried: SortByColumns(colTimeSlots,"BeginningTime",SortOrder.Ascending)

Beginning Time is set as TimeValue: TimeValue(TSBeginningTimeInput.Text)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Brian-M ,

I've made a test and the formula worked well on myside,

1\I assume there is a collection:

ClearCollect( colTimeSlots, {BeginningTime:TimeValue("6:30AM")}, {BeginningTime:TimeValue("6:00AM")}, {BeginningTime:TimeValue("1:30PM")}, {BeginningTime:TimeValue("1:00PM")} )

2\Sort the collection

SortByColumns(colTimeSlots,"BeginningTime",SortOrder.Ascending)

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Turns out my data source (SQL) used the format datetime2 so it wasn't resorting newly add times as the format is:
2023-11-21 07:00. I changed the data source to varchar and used "TimeValue" in Powerapps and it's working properly now.

Was this reply helpful? Yes No

Join the conversation