SharePoint Online List - Row Limit for Lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-1121878%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20List%20-%20Row%20Limit%20for%20Lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121878%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20row%20limit%20for%20a%20lookup%20column%20to%20lookup%20to%3F%20If%20yes%2C%20what%20is%20the%20threshold%20number%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%26nbsp%3B%3CEM%3EList%20A%3C%2FEM%3E%20wants%20to%20lookup%20field%20%3CEM%3Efoo%3C%2FEM%3E%20from%20%3CEM%3EList%20B%3C%2FEM%3E%20where%20%3CEM%3Eid%3C%2FEM%3E%20from%20%3CEM%3EList%20A%3C%2FEM%3E%20%3D%20%3CEM%3Eid%3C%2FEM%3E%20from%20%3CEM%3EList%20B%3C%2FEM%3E.%26nbsp%3B%3CEM%3EList%20B%3C%2FEM%3E%20has%2010k%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20the%20error%20message%20receive%20in%20%3CEM%3EList%20A%3C%2FEM%3E.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166484i4A9CD6086E36ADCF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1121878%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1122281%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20List%20-%20Row%20Limit%20for%20Lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1122281%22%20slang%3D%22en-US%22%3EIt's%20just%20what%20Magnus%20said...to%20mitigate%20the%20problem%2C%20try%20to%20create%20indexes%20in%20the%20lists%20you%20are%20linking%20with%20the%20lookup%20column%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1122079%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Online%20List%20-%20Row%20Limit%20for%20Lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1122079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F528130%22%20target%3D%22_blank%22%3E%40izzatdarani%3C%2FA%3E%26nbsp%3BHistorically%20(using%20Classic%20experience)%20the%26nbsp%3B%3CSPAN%3Ethreshold%20for%20lookup%20of%20elements%20in%20a%20list%20has%20been%205.000%20and%20as%20far%20as%20i%20know%20this%20has%20not%20changed.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAre%20both%20of%20your%20lists%20%22Modern%22%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBest%20regards%2C%20Magnus%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Is there any row limit for a lookup column to lookup to? If yes, what is the threshold number?

 

For example, List A wants to set its field Country Lookup by looking up field Country from List B where Email from List A = Email from List BList B has 10k rows.

 

Below is the error message receive in List A.

clipboard_image_0.png

 

Appreciate your help. Thanks

4 Replies

@izzatdarani Historically (using Classic experience) the threshold for lookup of elements in a list has been 5.000 and as far as i know this has not changed.

Are both of your lists "Modern"?

 

Best regards, Magnus 

It's just what Magnus said...to mitigate the problem, try to create indexes in the lists you are linking with the lookup column

@Magnus Goksøyr yes I'm using modern experience

I'd like to understand on how these indexes will help. Will it help if I set up the field "Email" as the index?