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.