Hi,

I have 2 simple lists. First list is “Contact list”, with “First Name”, “Last Name” and a calculated fieds “Full name” which concatenate both.

Second list is “Contact Log”, with a lookup field from the first list “Full Name”.

The issue is that now I have more than 5000 records in the first list. I went through different articles but it is not working. e.g. Index column (you cannot do index on calculated fields), Lookup with filtered view (I neven found the option to select a view).

I can’t believe a huge CMS as Sharepoint cannot manage more than 5000 records in a lookup.

Is there another solution/workaround that I missed?

thanks

​Hi, I have 2 simple lists. First list is “Contact list”, with “First Name”, “Last Name” and a calculated fieds “Full name” which concatenate both.Second list is “Contact Log”, with a lookup field from the first list “Full Name”.The issue is that now I have more than 5000 records in the first list. I went through different articles but it is not working. e.g. Index column (you cannot do index on calculated fields), Lookup with filtered view (I neven found the option to select a view).I can’t believe a huge CMS as Sharepoint cannot manage more than 5000 records in a lookup.Is there another solution/workaround that I missed?thanks  Read More

​