How to resolve the SharePoint 5000 item limit threshold?
We all know that SharePoint is such a great platform to save and manage data according to various organizational needs. We make use of SharePoint lists to store the data as list items and fetch those items as per the requirement. We can fetch up to 5000 items from the SharePoint list which is its threshold limit.
But what if the threshold limit exceeds and we need to fetch the items beyond the limit? Let me share a steady solution for this common issue we usually encounter while fetching data from a SharePoint list, using JavaScript.
How to fix this threshold issue?
First, we will try to fetch the data from the required list and save the data in a globally declared array variable as shown below.
We can now write a set code that will fetch the next 5000 items from the list, once the threshold limit is reached.
The result of the populateWFItems() function will include the items beyond the threshold limit.
Hope this will save some time for you while trying to resolve the hurdles during development. Happy coding!!