Sharepoint 5,000 record view limit and Lookup column

I understand the 5,000 item view limit and what do about it for generally "Viewing" purposes.

How does the 5,000 item limit apply to using a Lookup column to find and store a value from a list that has more than 5,000 items?

My data structure is an "Opportunity" which looks up and stores its  associated Contact from a Contact with more than 5,000 records.

Thanks.

Ken
kflorianAsked:
Who is Participating?
 
Keyboard CowboyCommented:
Two approaches I can think of.  
1) use Spservices cascading dropdowns - the first to filter on some field (like cateogry or office or something) and then the second to look up the real field - Or use 3 cascaded dropdowns.  YOu can do this via Javascript in a web part to control the field. Put in a CEWP and point it to the script in site assets - don't try to put the script directly in a CEWP and in a script editor webpart isn't a good idea since you need it for new/edit forms.

That might work - never tried it with > 5000 items
2) Use spEasyForms - which also allows for cascaded dropdowns - free, easy install, and incredibly powerful for doing OOB but custom new/edit/disp forms.
0
 
Walter CurtisSharePoint AEDCommented:
I lookup column is part of a view and may not show more than the first 5000 items. I honestly imagine a lookup with that many items though. Is there any way to use a people column? Are the contacts all in Active Directory or some other repository that you can filter somewhat?

Good luck...
0
 
kflorianAuthor Commented:
The Contacts are currently in a third-party CRM

But surely my use case is common: the need to create a referential link between two lists and one or both of those lists having >5000 items each.

The user will know the List Item (in this case a "Contact") that they need from the Lookup.....start typing and find it. In no situation will the user be wandering a 10,000 item list uncertain what they are looking for.

 Anybody have custom code to share?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Walter CurtisSharePoint AEDCommented:
What you last comment describes is totally different than the first description, therefore things are different :-)

If you lookup column is coming from a third-party CRM the list view limit does not apply. That limit just limits the query results size of the SharePoint list, which also limits what is displayed (viewed).

As you mention, you will need custom code for the lookup column. You may consider using SharePoint Business Connectivity Service, which may have a different name depending upon your SharePoint version. That service would allow you to use a 3rd party CRM data source.

Good luck...
0
 
kflorianAuthor Commented:
My bad...precision in everything but especially asking questions like this.

The list that will have >5000 records will be exported from a soon-to-be retired CRM and imported into a SP list.

This means I'm going the custom-code route which I suspected might happen.

Thanks for taking the time to respond.
0
 
Walter CurtisSharePoint AEDCommented:
Good luck and if you have questions in the future don't hesitate to ask...

btw.. the list view limit can be increased if necessary.
0
 
kflorianAuthor Commented:
It's an 0365 subscription.
0
 
Walter CurtisSharePoint AEDCommented:
Information provided is accurate and correct.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.