question

johnjohn-0472 avatar image
0 Votes"
johnjohn-0472 asked CaseyYangMSFT-4714 commented

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

Inside SharePoint online we have 2 lists Parent & Child lists>> the child list has a lookup field to the parent list.

Now the parent list has 8000++ items, as follow:-

118805-2-lisys.png


so when we try to create a new child record >> i will get this error on the lookup field:-

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

as follow:-

118844-parent.png


any advice how we can eliminate/fix this error?


office-sharepoint-online
2-lisys.png (4.6 KiB)
parent.png (18.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CaseyYangMSFT-4714 avatar image
0 Votes"
CaseyYangMSFT-4714 answered CaseyYangMSFT-4714 commented

Hi @johnjohn-0472,

Per my researsh, this issue is by default. In SharePoint Online there is no solution other than trying to remove records from your parent list. And I found this Remove the list view threshold (5000 by default) in SharePoint UserVoice. From this vote "Being able to index/sort/filter by lookup column types (like person, lookup or managed metadata columns) without being throttled" is in backlog.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@CaseyYangMSFT-4714 so if i got your point correctly we can not have a lookup field on a list which exceeds the 5000 threshold.. is this correct?

second point as a workaround , is it fine/recommended/supported if i only store the parent ID inside the child records .. i mean to store the parent ID inside a numeric field or a text field instead of using lookup fields?

0 Votes 0 ·

Hi @johnjohn-0472,

Sorry for replying late. I found this articel about Overcoming the 5000-item list view threshold in SharePoint online. Index can be a workaround to this issue.
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.



0 Votes 0 ·