Collect most recent sharepoint list items if over 2000 etc

[Questionasking]

Hi,

I have an app that collects from a huge list however when i use the collect function it only collects the oldest entries, i wish to just collect the most recent 200 entries?

ive tried 

ClearCollect(colsharepointlist,LastN(sharepointlist,200))

however it just gives me the last 200 from the 500 of the delegation? 

[leyburn19 · Accepted solution]

Simply sort descending:

ClearCollect(colsharepointlist,Sort(sharepointlist,ID,Descending)

This will change the 200 to the most recent 2000

[leyburn19]

Also change your delegation threshold in Settings to 2000