Answered

Sort a gallery based on a date condition in ascending order

(0) Share

Report

Posted on by Kriszta

Hi,
I would like to ask for your help. What and where should I set in order to I can sort a gallery with a pre-defined date condition. I need it in ascending order. I use sharepoint list in the background that contains Final_Deadline field based on that I would sort the gallery.

Thank you for your help in advance,

Kriszta

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kriszta - what do you mean by "pre-defined" date condition? Do you you simply want to sort on the "Final_Deadline" column?
Kriszta 88 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Amik, I need a simple solution for a simple ascending order but it also would be good to know how I can define that if I need final_deadline between today-14 days and today+14 days in the gallery for example. Is it possible to pre-define it somehow?
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Kriszta - basic syntax to sort:

Sort( 'Your List', Final_Deadline, SortOrder.Ascending )

By "pre-define", I think you mean Filter:

Sort( Filter( 'Your List', Final_Deadline>= DateAdd( Today(), -14, TimeUnit.Days ) && Final_Deadline <= DateAdd( Today(), 14, TimeUnit.Days ) ), Final_Deadline, SortOrder.Ascending )
Kriszta 88 on at

Like
a
(0)

Report
Copy link

Link copied!

It works. Thank you 🙂