I am facing an issue with lookup column in the list forms due to list view threshold limit (5000 items).

The parent list is having more than 5000 items. Hence the lookup field is not getting displayed in the forms and showing a message like below.

"This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000)."

I have tried indexing this lookup column and some of the columns in the Parent list but the issue still persists.

Is there any workaround for this issue so that lookup column gets displayed?

Thanks in advance.

  • Did you find a solution? – Frank Fajardo Jul 12 '17 at 4:04
  • From the error, it appears your issue is that the LOOKUP list has more than 5000 items. Not your PARENT list. The purpose of a lookup list is to give the user options, such as "Category", or "State". Lookup lists should NOT have thousands of options. They would be of no use to your user. I don't know the specifics of your use case, but I think you should rethink how your data is arranged. – CigarDoug May 17 '18 at 9:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.