Forum Discussion
Issue with List.Generate
Hi jbrines ,
Thank you for the followup.I would be happy to assist you!
when working with large SharePoint lists, it is best not to use $skip or $skiptoken manually. The recommended way is to use SharePoint.Tables, which automatically manages paging and avoids the 5,000-item threshold issues. You may find this approach in Microsoft’s documentation on SharePoint.Tables, and more about handling large lists here.
Hope this helps.If so,consider accepting it as solution.
Hi jbrines ,
Thank you for the helpful response pankajnamekar25 !
When working with SharePoint lists that exceed 5000 items, list thresholds may introduce complexity—especially when using $skip and $skiptoken.
To better understand the limitations and recommended approaches, here are some helpful Microsoft documentation links:
https://learn.microsoft.com/en-us/power-query/connectors/odata-feed
https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/modern-experience-site-classification#handling-large-lists-and-libraries
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest
Hope this helps.If so,give us kudoa and consider accepting it as solution.
Regards,
Pallavi.
Hi Anonymous so I shouldn't use $skip or $skiptoken?
Any chance you can give me an example of what I should be using?
Hi jbrines ,
Thank you for the followup.I would be happy to assist you!
when working with large SharePoint lists, it is best not to use $skip or $skiptoken manually. The recommended way is to use SharePoint.Tables, which automatically manages paging and avoids the 5,000-item threshold issues. You may find this approach in Microsoft’s documentation on SharePoint.Tables, and more about handling large lists here.
Hope this helps.If so,consider accepting it as solution.