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?
Solved! Go to Solution.
Simply sort descending:
ClearCollect(colsharepointlist,Sort(sharepointlist,ID,Descending)
This will change the 200 to the most recent 2000
Simply sort descending:
ClearCollect(colsharepointlist,Sort(sharepointlist,ID,Descending)
This will change the 200 to the most recent 2000
Also change your delegation threshold in Settings to 2000
User | Count |
---|---|
261 | |
130 | |
99 | |
48 | |
47 |