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?
Solved! Go to 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 ] )
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 ] )
User | Count |
---|---|
183 | |
109 | |
88 | |
44 | |
42 |
User | Count |
---|---|
226 | |
108 | |
104 | |
68 | |
68 |