I am new to SP online.

This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit?

Any easy solution as I dont have much programming experience.

  • What exactly the problem you are facing? please add some more details to your question. Feb 25, 2019 at 9:48
  • We have a subscriber database of 5697 .When a subscriber calls in , I need the operator to select the relevant subscriber sand log an issue against that subscriber . This is done via an an issue list ,with a lookup to the subscriber database ? Feb 25, 2019 at 9:55
  • Try to index the columns or columns in the parent list. Surprisingly, this is working for us now, and I heard from Microsoft that they do not support it.
    – Harris
    Nov 27, 2023 at 5:15

3 Answers 3


This will never work, you are pretty much out of luck.

I have been down this road and still travelling along it. Once SharePoint hits 5k anything, it falls over in almost every sense of the word.

SharePoint Online is not meant for enterprise use, period.


You can add an index manually from List Settings in the settings menu > Indexed Columns.

More information, you can refer to: Manage large lists and libraries in SharePoint

  • I have added an index .. .but still there is an issue ? Feb 25, 2019 at 10:07
  • @kally_MSFT how would adding an index help with a lookup field threshold? Oct 2, 2020 at 21:00

You can't make a lookup column over a list that exceds the treshold limit. On SharePoint Online you can't modify it, and this threshold is setted to 5000 elements.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.