Re: Sharepoint Get Items - Not Returning All Records
By default, Get items only returns the first 100 items. In your case you should do two things since you have more than 5000 items.
Set Top Count to 5000. This will return the first 5000 items.
![grantjenkins_0-1679789741088.png grantjenkins_0-1679789741088.png](/_api/msdyn_richtextfiles%28C355D561-6069-4B0C-9636-CC2612D08139%29/msdyn_imageblob/$value?size=full)
Go into Settings and turn on Pagination, then set a Threshold to something greater than the number of items you expect to have over the next few years. If you have around 6000 items in your list and expect there to be around 10000 items within the next few years, then set the Threshold to 15000 (as an example). When you set Pagination on, it will return the Top Count in batches. So if your Top Count is 5000, it will return the first 5000, then the next 5000, and so on until all items are returned or it reaches your Threshold.
![grantjenkins_1-1679789754264.png grantjenkins_1-1679789754264.png](/_api/msdyn_richtextfiles%284894493F-F198-4F7E-9CCC-E3DEAD356025%29/msdyn_imageblob/$value?size=full)
![grantjenkins_2-1679789769387.png grantjenkins_2-1679789769387.png](/_api/msdyn_richtextfiles%288B0BA707-C684-4626-9D07-53DC26BBB115%29/msdyn_imageblob/$value?size=full)