The following are three key SharePoint Online points regarding large data in lists and libraries:
- List and Library Size:
- SharePoint can hold up to 30 million items in a single list or library.
- While the default threshold for displaying items in a view is by default 5000, it’s possible to work with larger lists by planning ahead and applying filtering and sorting techniques.
- Using the modern experience, improves the functionality and time aspects compared to the classic experience.
- Myths Debunked:
- Treating a list as a database is fine for power users, and lists with more than 5000 items can indeed work.
- As a site owner, one can be proactive in managing lists and libraries to avoid hitting the threshold.
- Cautionary Tale:
- Plan carefully, so that end-users and power-users do not encounter issues when the threshold is exceeded.
- The threshold affects the view presentation, not the actual data stored in the list or library.
