I have an issue where my SharePoint document folder has an issue with the list view threshold. It has 193757 items (list view threshold is 5000). However, what I do not understand is that these documents are all stored within folders and the actual list should never list more than maybe 100 items at a time. Is there a setting I am missing? I'm using SharePoint online.

  • Folders are a metadata property of the list item. They’re not constructs of the list that store list items. This was the reason SP2016 changes the default list view to not sort folders first before items.
    – Greg W
    Dec 2, 2019 at 1:54

1 Answer 1


The List View Threshold states that you cannot have more than 5,000 items (by default) returned in your list view. So it really does not matter if you have stored them in a folder or not.

Each List view should not return more than 5000 items as this limitation comes from SQL server where SharePoint stores it's data in a table. So it'd better to re-plan structure such that each list view should not have more than 5000 items.

You can have a look on the below link to have a better understanding on List view threshold.


I hope this helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.