Good Morning all!
This is my first post in the community after being referred here by a member of another community. It’ll be a good one…I hope.
We are trying to create a lookup column that uses data from a single column SharePoint list.
The list contains 165,000+ items which is a boat load but it’s based on part numbers in our ERP system.
We really just need to be able to start typing the first few characters of the part number and choose from a selection and select a few.
Is there a best practices way to do this so the lookup column doesn’t bog down the rest of the site?
What’s happening is when we load about 20,000 items (and raise the item limit for list views) the list will work but it is slow. However if we drop all 165,000+ items in the list we start getting errors and the site becomes unusable.
If we load the default 5000 limit the column selection works like a charm. I don’t see it being an option to create 30+ lists and add each of them as a column. I think that’s going to blow up as well.
Thank you Vlad! Since I am a SharePoint baby would I be able to add managed properties from an existing list?
How about you do it with advanced Search, add your part number columns as managed properties. Then maybe you can implement suggestions like this post by bradshannon. http://sharepointcandothat.com/creating-an-auto-complete-sharepoint-list-search-in-sharepoint-2013/
Only ideas, some people may have a lot better ideas 🙂
