Answered

How to display the most recent rows in a SharePoint List in a Gallery

(0) Share

Report

Posted on by Greg27

782

I have an app with a Gallery and am using the following function to pull data from my SharePoint List into a Power Apps Gallery:

SortByColumns(Switch(varGalleryFilter,
1, Filter(VehicleRegistration, VehicleOnCampus="Yes" && Status="New"),
2, Filter(VehicleRegistration, VehicleOnCampus="Yes" && (Status="Rejected" Or Status="Completed")),
3, Filter(VehicleRegistration, VehicleOnCampus="Yes" && Status="New")
), "Created", SortOrder.Descending)

varGalleryFilter is set to 2 if the user clicks the "Archive" button. Currently, it only displays the first 500 rows in my SharePoint List. If I change the Data row limit to 2,000, I get all of my rows, but when I surpass 2,000 rows, I will run into the same problem. It was my understanding that using the "Descending sort order, I would get the most current rows, but it seems that I am getting the first 500. How can I get the most recent rows?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Greg27,

In this case you could Sort the datasource before Filtering. Currently you will sort the returned output of your Filter() function.

Filter( Sort( VehicleRegistration, Created, SortOrder.Descending ), VehicleOnCampus = "Yes", (Status = "New" && (varGalleryFilter = 1 || varGalleryFilter = 3)) || ((Status="Rejected" || Status="Completed") && varGalleryFilter = 2) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Greg27 782 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM
Thanks so much for your help. It worked perfectly!!

Was this reply helpful? Yes No