Cascading Lookup and Threshold error



Cascading Lookup and Threshold error

 

Summary

The following message is displayed on your Cascading lookup field type column:

“This is a lookup column that display data from another list or view that currently exceeds the List View Threshold defined by the administrator. For a possible workaround please visit this KB article”

Ex:

Cause

The lookup query used by cascading lookup field type has exceeded the list threshold in SharePoint.  By default the threshold is 5000.

Solution

KWizCom recommends you first review SharePoint’s list threshold feature to understand the error and how to manage lists with a lot of items.

https://support.office.com/en-sg/article/Manage-lists-and-libraries-with-many-items-11ecc804-2284-4978-8273-4842471fafb7

https://nickhobbs.wordpress.com/2013/06/13/sharepoint-2010-list-view-threshold-explained/

Only after you understand the benefits and risks to your SharePoint environment of managing the threshold limit, KWizCom recommends that you:

1.       Increase the threshold limit to allow the Cascading lookup to perform the lookup operation

2.       Index the column which Cascading field type is looking up to help improve the performance of a large list or library