SharePoint Online Limitation

Number of Site Collections:

The number of site collections you can create depends on your subscription. Generally, you can have a large number of site collections, but there may be practical considerations for managing them.

Subsites:

2,000 per site (site collection). We recommend creating sites and organizing them into hubs instead of creating subsites. If you do use subsites, we recommend limiting their number (especially on heavily trafficked sites). In addition, all navigation types (site, hub, global, and footer) are limited to 500 child links at each level.

Site Collection Storage:

SharePoint Online site collections have storage limits that depend on your subscription plan. For example, most business plans offer 1 TB of storage for the organization.

List and Library Limits:

List view threshold: Default limit is 5,000 items. Beyond this limit, performance issues might occur.

List size: The maximum number of items in a list or library can be tens of millions, but managing such large lists can be challenging.

Document set size: A document set can contain thousands of documents, but it's advisable not to exceed the threshold.

File size and file path length:

250 GB - File upload limit. Applies to each individual file uploaded to Microsoft Teams Files tab, SharePoint document libraries, OneDrive folders, and Viva Engage conversations.

250 MB - File attached to a list item. Applies to Microsoft Lists and SharePoint lists - both based on same lists platform.

Unique Permissions:

While SharePoint supports a substantial number of unique permissions, the recommended practice is to avoid excessive unique permissions, with a maximum of 50,000 per list or library.

SharePoint groups:

A user can belong to 5,000 groups per site (site collection), and each group can have up to 5,000 users. You can have up to 10,000 groups per site (site collection).

Versions:

50,000 major versions and 511 minor versions.