Filter list by value and sort by date

(0) Share

Report

Posted on by wwmn

103

I have an asset checkout app and would like to sort one of my galleries by closest return date. This gallery is filtered to only show me items that are currently issued out. It's currently sorting by the earliest pickup date, I would like to sort by return date with the closest date at the top. I've been trying all sorts of things but nothing ever changes the order.

My current code:

Sort(Filter('IT Asset Scheduler - Reservations', Status.Value="Issued"),'Return Date', SortOrder.Ascending)

Categories:

Building Power Apps

All responses (1)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wwmn ,
Try using below formula -

Sort(AddColumns(Filter('IT Asset Scheduler - Reservations', Status.Value="Issued"),"dateDiff",DateDiff(Today(),StartDate)),dateDiff, SortOrder.Ascending)