Answered

Sort Not working, showing blank gallery

(0) Share

Report

Posted on by RussMan9O4

I have a vertical gallery in my app to show items from a SP List called TLStatus, the list has around 8,000 items in it. One of the columns is "Due" which is a date column in SP, all of the lines have dates on them.

This is my "items" event for the gallery, It is supposed to filter by SF_PROJECT_ID and Status, and sort by Due date-

Sort(Filter(Filter(TLStatus,SF_PROJECT_ID=sfProjectID),Status="Not Started"||Status="In Progress" || Status="Complete" ||Status="Incomplete"),Due)

If I remove the Sort() function, it loads the items as it should. If I sort by another column, ex customerTasks which is a text column, it works correctly.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

SebS 4,876 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@RussMan9O4

Can You try this one:

Sort( Filter( TLStatus, SF_PROJECT_ID = sfProjectID, Status = "Not Started" || Status = "In Progress" || Status = "Complete" || Status = "Incomplete" ), Due )
RussMan9O4 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Same thing happening, Here is with that code-

And removing the sort-
SebS 4,876 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@RussMan9O4

What Type is the "Due" column? Is it normal single text or by any chance it's complex type?
RussMan9O4 15 on at

Like
a
(0)

Report
Copy link

Link copied!

It's a date/time column

One thing I have noticed is if I use PowerAutomate and a Get Items action, it's showing the name of the column as Notes, I may have repurposed and renamed an old column at some point,

but in PowerApps it sees that column as Due, my Items value for the date picker is ThisItem.Due.
SebS 4,876 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@RussMan9O4

i think they already removed "" but you can check

SortByColumns( Filter( TLStatus, SF_PROJECT_ID = sfProjectID, Status = "Not Started" || Status = "In Progress" || Status = "Complete" || Status = "Incomplete" ), "Due", SortOrder.Descending )
Verified answer

RussMan9O4 15 on at

Like
a
(0)

Report
Copy link

Link copied!
That didn't work either, but I did end up finding a solution, Not sure why, but I had to wrap a DateValue() tag around it-

Sort( Filter( Filter( TLStatus, SF_PROJECT_ID = sfProjectID ), Status = "Not Started" || Status = "In Progress" || Status = "Complete" || Status = "Incomplete" ), DateValue(Due) )