Forum Discussion
SharePoint Online List - Row Limit for Lookup
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 wh...
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
- I'd like to understand on how these indexes will help. Will it help if I set up the field "Email" as the index?
