Forum Discussion
Solved
Sincerely requesting advice! How many rows can a list in SharePoint hold?
How many lists can be stored in SharePoint and how many rows of data can be stored in each list? I've found some information about this in the documentation, but I'm not quite sure if it's correc...
- 5000 items is the view limit, any more and you start getting issues with filtering(filter doesn't show all items), slow down, problems with querying. Reason for this is that it becomes to much for the back-end to manage in the view.
The more item you have the larger the issue becomes, at 100K you lose the ability to have custom permissions etc.
If you don't care about any of these issues you can have 30 million items...
Also having that much item won't be managable...
That is correct but It's not recommended to have over 5000 items. You start having some weird behaviour in filtering and sorting and just managing the list.
- Thanks for your reply.
I got your point, but 5,000 items and 100,000 items are way too much of a difference, isn't it? Why is that?- That was true back in the days (5,000 items) but that's not the case anymore. Personally, I'm working with lists of 500,000 items without any problems. If everything ( Site setting, list setting, search settings, etc.) is set up correctly, no problems. Myths die hard.....
GillesSylvestreHow you can do that , I have 300K items need to upload for first time at crested, and every day, ihave a new item need to insert to the list by Power Apps, then , on going it have update som value from user. Colud you please in advance.
- 5000 items is the view limit, any more and you start getting issues with filtering(filter doesn't show all items), slow down, problems with querying. Reason for this is that it becomes to much for the back-end to manage in the view.
The more item you have the larger the issue becomes, at 100K you lose the ability to have custom permissions etc.
If you don't care about any of these issues you can have 30 million items...
Also having that much item won't be managable...
