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.



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
    Jul 23 '21 at 14:04
  • It caused by the list view threshold is 5000. Jul 29 '21 at 10:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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