Unanswered

Displaying Data Range In Powerapps Gallery

(0) Share

Report

Posted on by Virikefe

Hello,

I have a Sharepoint List that has grown over 5k in the sharepoint but I want to display only items within the ID range of 0 to 500, 501 to 1000 and so forth in each gallery to form pagination.

Any formular to display IDs within the number range to display in the gallery?

I applied this code below and it's showing me only 500 items, which is cool but I need to display ranges.

Sort(Filter('SP List',ID < 500 ), SortOrder.Descending)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Virikefe ,

The issue is that ID is not Delegable other than equals (not for greater/less than). You could create a "shadow ID" number field, but would need to populate this when the item is created.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Virikefe 31 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz
I think IDs are Delegable from the result I'm having from this:

Sort(Filter('SP List',ID > 599 && ID < 1000 ), SortOrder.Ascending)

Only problem now is, the gallery is not obeying neither the SortOrder.Ascending or SortOrder.Descending as the value keeps showing the Ascending order.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Virikefe ,

I can assure you that ID is not Delegable in SharePoint other than for = (equals). If your Delegation limit is set to 2,000, then your query will work as it is within that dataset.