question

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

Can we create a lookup relation between 2 lists even if the 2 lists exceeds the threshold limitation

We have 3 SharePoint online lists A,B & C .. where lists B & C has a lookup field to list A. now all of the 3 lists will contain around 1 million record.. so when we create or edit items from lists B & C will we be able to select the related list A item? or the lookup field inside lists B & C create/edit forms will not show the 1 million options? we will be using the modern ui.

Regards

office-sharepoint-online
· 1
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.

Thank you for your question. We are currently looking into this issue and will give you an update as soon as possible. Thank you for your understanding and support.

0 Votes 0 ·

1 Answer

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

Hi @johnjohn-0472,

Per my research, Lists with a large number of Lookup columns may result in complex and potentially intensive SQL statements. And SharePoint will verify the length of the full SQL statement and will display this error message in case that the maximum allowed length was exceeded: "The list item could not be displayed/added because the length of the fields was too long. Please shorten the new entries or remove some fields from this list."

For Reference:
https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59


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.


· 1
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.

Hi @johnjohn-0472,

I'm checking how the things are going on about this issue. Is there any progress on this issue?

0 Votes 0 ·