"Exceeds list view threshold" or "too many items with unique permissions" error when trying to share or break inheritance

Symptoms

When you try to share or break the inheritance of a folder in Microsoft SharePoint Online or Microsoft OneDrive for Business, you receive one of the following error messages:

  • Microsoft.SharePoint.SPQueryThrottledException","message":{"lang":"en-US","value":"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."},"status":500,"

  • OneDrive Sharing Failed: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

  • You cannot break inheritance for this item because there are too many items with unique permissions in this list.

Cause

This issue occurs for one of the following reasons:

  • When a list, library, or folder contains more than 100,000 items, you can neither break permission inheritance nor reinherit permissions on the list, library, or folder. However, you can still break inheritance on the individual items within that list, library, or folder, up to the maximum number of unique permissions.
  • The supported limit of unique permissions for items in a list or library is 50,000. However, the recommended general limit is 5,000. Making changes to more than 5,000 uniquely permitted items at a time takes longer. Therefore, for large lists, design the list to have as few unique permissions as possible.

Resolution

To fix this issue, use the following methods:

  • Reduce the number of uniquely permitted items in a list or library.
  • Follow best practices for lists, such as having a low list item count.

More information

For more information about lists and libraries, see the following articles:

Still need help? Go to SharePoint Community.