Answered

How to retrieve last 10 items from 1000 items SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have more than 1000 items on the SP list, and I want only retrieve the last 10 items from that list. Any suggestion? Any Filters, Operators, Collection I used, none of them giving me the result. I don't want to change app delegation Settings to more than 500 items.

Thanks,

-Sal

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Here’s what I would suggest. It works because SORT is a delegable function and we only need the first 10 records it returns.

FirstN(Sort(your_datasource_name,ID,Descending),10)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

that worked like a charm. I was wasting my time to invent some new formula.

Was this reply helpful? Yes No
Samnang 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh wowww I was trying to look for this for a long time, Like the other says, It wasted the time in inveting for another formula.

Was this reply helpful? Yes No