SharePoint Online (2013) Unique List Items Limit

I found conflicting information on the number of items within a list that can contain unique item permissions, a number of resources said 5000, and some mentioned 50000 – however these limits were for SharePoint 2010/2013 on-prem and no information around SharePoint Online.

After a quick test, I can confirm there is a hard limit at 50000 items that can contain unique permissions.

Running a PowerShell CSOM script to create 55000 items, the script failed at 50001 items with the error:

Exception calling “ExecuteQuery” with “0” argument(s): “You cannot break inheritance for this item because there are too many items with unique permissions

Script snippet:

$list = $web.Lists.GetByTitle('limit')
$ctx.Load($list)
$ctx.ExecuteQuery()

$count = 0
$push = 0

for($count -eq 0; $count -lt 55000; $count++)
{ 
Write-Host "adding $count"
$ListItemInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation
$Item = $list.AddItem($ListItemInfo)
$Item["Title"] = $count
$ctx.Load($list)
$item.BreakRoleInheritance($True, $true);
$Item.Update() 
$push++

if($push -eq 50)
{
$ctx.ExecuteQuery()
$push = 0
Write-Host "pushed"
}
}


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s