I have a large list, over 5000 items (~6000). I need to enable cascade delete on a lookup column SharePoint errors out and tells me the action exceeds the list view threshold. Note: This feature is working on a list with over 5000 items when I configured the column for cascade delete BEFORE it reached 5000 items. Has anyone encountered this issue and found some kind of work around to get this enabled? Additional Details:

  • I am on Office 365.
  • I don't have tenant admin access.
  • The list that the lookup is connected to has about 2000 items.
  • The lookup column does have an index.

1 Answer 1


I did not find a workaround. I had to use REST to move items out of the list into a new list, make the column index change, then move the items back. We had to also update any lookups to the as the "move" required that items in the original list be deleted.

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.