How to configure lookup fields pointing to large lists with more than 5000 items

Default SharePoint Lookups do not support large lists with more than 5,000 Items, but Plumsail Forms’ Lookups will work with these large Lists.

But choosing correct item among more than 5,000 choices is not an easy task. That’s why, our Lookups also support search and filtering.

Threshold

Index Columns

How to configure Source list, so it can be searched and filtered? It’s very easy. All you have to do is index Source list’s columns that you intend to filter.

Read more about indexing columns in Microsoft's instruction.

You need to index all columns that you intend to use with the Lookup filtering and search.

If you only want to search items by Title, then only the Title needs to be indexed.

Title Indexed

If you follow our instruction for Cascading Dropdowns, then both Category and Product columns need to be indexed in the Source list.

Result

Here I have a large list with over 5,000 Items:

Large List

And here’s a Lookup to that List, which I can search as I see fit after indexing its Title:

Lookup to a Large List