I am facing an issue with the Get List Items activity while retrieving items from SharePoint. The list contains around 2,000 items, but I am unable to retrieve the details. However, when I try the same activity with another list that has around 10 items, it works correctly and fetches the data.
My question is: Is there any limitation in the Get List Items activity based on the number of list items? When I try to retrieve the list with approximately 2,000 items, the output is coming as null.
Yeah, I think this is actually expected with large lists. From what I’ve seen, the Get List Items activity can struggle when the list gets big. Around 2,000 items shouldn’t sound huge, but in Microsoft SharePoint queries can fail if there’s no filtering, indexing, or pagination sometimes it just returns null instead of throwing a clear error.
I think you should try:
Adding a small Filter Query (even something simple like a date or ID range)
Retrieving items in batches instead of all at once
Maybe start with a filter that returns like 100–200 items and see if it works. if it does, then it’s definitely a volume/query issue.
When I use the classic Get List Items SharePoint activity, I face an issue while applying an ODataFilter to retrieve the top 50 items. My list contains more than 22,000 items. However, if I do not use any filter, the activity retrieves zero items.
This is likely due to the SharePoint list view threshold (5,000 items). Since your list has ~22k items, SharePoint won’t return results unless you use a filter on an indexed column.
Also, ?$top=10 is not a valid OData filter for the Filter field in the Classic activity. $top is a query option, not a filter condition.
Try:
Use a valid OData filter on an indexed column (e.g., ID gt 0)
Enable Pagination in the activity
Or switch to Modern SharePoint activities (recommended for large lists)
Without an indexed filter, large lists may return 0 items.
SharePoint list view threshold limit (5000 items) as you mentioned there was 22,000 items. it is greater than 5000 right. so as it is greater than threshold due to it giving the 0 count.
Based on requirement you may get by using Odata filter on index column.
No Actually, i started using Microsoft Graph API, i have tested it in Graph Explorer, where i can get the data but when i use the Http Request (Legacy) it is still giving me null value as “value: ” is there any additional permission required to fetch the details from share point, but when i tried with other lists which are having less than 100 i can able to get the details.
