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.


1 Answer 1


Per my knowledge, creating a lookup column to list A which has over 5000 items is not available.

Similar question:

New item with lookup on list with more than 5k items

  • that looks weird ...
    – John John
    Commented Jul 23, 2021 at 14:04
  • It caused by the list view threshold is 5000. Commented Jul 29, 2021 at 10:44

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.