List View Threshold Error for Lookup Field

Hi Community,

I have a two Lookup fields and I want to make one of the lookup fields dependent on the other. Unfortunately, I have come across this error which I have never encountered before:

The number of rows in the source list that the lookup is looking up is 15,000.

Here is the error message in the console:

How do I get rid of this?

Many thanks!

Dear @DryChips,
The issue is that a filter is applied on the source list when you make it dependent on another lookup. Filters only work with large list with over 5000 items, when they are applied on an indexed column.

Try to apply an index to the column that the lookup is filtered by, and see if it works.

1 Like

Oh, this is awesome!

Thank you again Nikita! Your the best! :sunglasses: