Menu

Search

KWizCom Support Center


Cascading Lookup and Threshold error


Igor
Cascading Lookup Plus field type

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

 


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!


Comments require login or registration.

Details
Last Modified: 4 Years Ago
Last Modified By: anthony.pham
Type: HOWTO
Rated 2 stars based on 1 vote
Article has been viewed 2.3K times.
Options
Also In This Category