Powerapps with CDS, collection of most recent records

[morall]

I have a CDS with 10,000+ records stored in a random order

I want to insert the first 500 most recently created results into a collection. How do I do that?

[flugaoveltem · Accepted solution]

Hi @morall 

You can use FirstN to filter your set of records: 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last

FirstN( Table, [ NumberOfRecords ] )