KWizCom Support Center

Cascading Lookup and Threshold error

Cascading Lookup Plus field type

Cascading Lookup and Threshold error



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”



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


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

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


On a scale of 1-5, please rate the helpfulness of this article

Not Helpful
Very Helpful
Optionally provide private feedback to help us improve this article...

Thank you for your feedback!

Last Modified: 6 Years Ago
Last Modified By: anthony.pham
Rated 2 stars based on 1 vote
Article has been viewed 2.9K times.
Also In This Category