@abm I didn't quite say the correct thing in my previous post. List rows (Dataverse) and Get items (SharePoint) both retrieve the first 100 items by default (if left blank). You can increase this up to 5000 using Top Count.
If you then turn on Pagination, it will start to return your items in batches of what you've set for Top Count, up to the Threshold you specified. Some examples below.
Example 1:
Settings:
- Top Count = blank
- Pagination = Off
Result:
- You will get up to 100 items returned.
Example 2:
Settings:
- Top Count = 5000
- Pagination = Off
Result:
- You will get up to 5000 items returned.
- In order to get more than 5000 items you need to turn on Pagination so it will retrieve the items in batches up to the Threshold you set. This is why it's stated that the maximum is 5000 (5000 per batch).
Example 3:
Settings:
- Top Count = blank
- Pagination = On
- Threshold = 15000
Result:
- You will get up to 15000 items returned in batches of 100.
- If you had a total of 12000 items that would be returned, then this would go back to your SharePoint list 120 times (120 x 100 = 12000).
Example 4:
Settings:
- Top Count = 5000
- Pagination = On
- Threshold = 15000
Result:
- You will get up to 15000 items returned in batches of 5000.
- If you had a total of 12000 items that would be returned, then this would go back to your SharePoint list 3 times (3 x 5000 = 15000 which is more than 12000). Much quicker than just leaving the Top Count blank.
Note 1: If you're potentially going to receive more than 5000 items, you should set your Top Count to 5000 (max batch size) and turn on Pagination.
Note 2: List rows present in a table (Excel) has a default of 256 items returned. Same conditions as above apply here too, except 256 if Top Count is blank instead of 100.
