One of our users requires a column in their Document Library to enforce unique values, however the library contains more documents than the 5000 item threshold limit.

Whenever you try to switch on the setting you are met with an error:

"Sorry, something went wrong The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator"

Are there any other ways to change this setting?

1 Answer 1


It is not suggested to have more than 5000 item in a library.

Manage large lists and libraries in SharePoint for your reference:


You can try to use PowerShell to Make a column unique in SharePoint Online.

SharePoint Online: change list field settings using PowerShell for your reference:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.