When we have more than 5000 items in a SharePoint Online list which we need to display in a custom form, we can only display 5000 items def
When we have more than 5000 items in a SharePoint Online list which we need to display in a custom form, we can only display 5000 items in the form, and to display more than 5000 items we need to write a recursive ajax function using REST API.
So that it will concatenate the items in each recursion and then can be able to display more than 5000+ items, but each iteration/recursion pulls only 99 items out of 5000+ items at a time.
I have to recursively/iterate the piece of code 50 times to pull 5000 [i.e. 5000/99] items to display it in a custom form, and if the number of items is more than 5000 for e.g.: 100000 then the iteration of code would be 1010.10 times and so on i.e. Number of items/99
Consider a scenario where we have more than 1 lakh items out of which item in between 60,000 to 70,000 have inactive records which are not in use, which need to pull out, so you can imagine the pain in recursively pulling out 99 items in each iteration of code to reach to items between 60,000 to 70,000 or 100000+ items the scenario will be worst if we don’t know where is the inactive items resided in more than 100000+ records.
In a Scenario where there are complex transaction of more than a 100000+ of records to update and display then again it is a nightmare.
As per Microsoft the limitation is to improve the performance of the database and SharePoint