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.– Ganesh Sanap - Microsoft MVPFeb 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 ?– Jean-Pierre MullerFeb 25, 2019 at 9:55
Add a comment
|
3 Answers
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
-
-
@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.
