Lookup column which reference a list that have 2 million records is not working, the lookup keeps lo

%3CLINGO-SUB%20id%3D%22lingo-sub-2885445%22%20slang%3D%22en-US%22%3ELookup%20column%20which%20reference%20a%20list%20that%20have%202%20million%20records%20is%20not%20working%2C%20the%20lookup%20keeps%20lo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2885445%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3EI%20have%20a%20Parent%20list%20which%20contain%20over%202%20million%20records%3A-%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319984i4348D70530F852F0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.png%22%20alt%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20inside%20another%20list%20(Child%20list)%20i%20have%20a%20lookup%20field%20which%20reference%20the%20above%20parent%20list%2C%20as%20follow%3A-%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319987iB4A8FEB4071C25FE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222.png%22%20alt%3D%222.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20inside%20the%20Parent%20list%20i%20added%20the%20Title%20as%20an%20index%20column%2C%20as%20follow%3A-%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%223.png%22%20style%3D%22width%3A%20943px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319988i9A4B2963AB1F7645%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223.png%22%20alt%3D%223.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Enow%20when%20i%20access%20the%20Child%20list's%20create%2Fedit%20modern%20list%20forms%2C%20i%20will%20get%20this%20warning%20on%20the%20lookup%20field%20(which%20is%20understandable)%20%3A-%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%224.png%22%20style%3D%22width%3A%20947px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319989i9ACFC5893C604842%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%224.png%22%20alt%3D%224.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20when%20i%20start%20typing%20in%20the%20Parent%20Title%20inside%20the%20lookup%20field%2C%20the%20field%20will%20keep%20loading%20as%20if%20it%20is%20retrieving%20data%2C%20but%20for%20more%20than%202%20hours%20now%20i%20am%20still%20getting%20the%20loading%20image%20and%20never%20get%20the%20Parent%20record..%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%225.png%22%20style%3D%22width%3A%20980px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319991i6127B7EDAB6486F4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%225.png%22%20alt%3D%225.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20%3F%20per%20my%20knowledge%20that%20defining%20the%20correct%20Index%20on%20the%20Parent%20list%20should%20allow%20us%20to%20reference%20the%20list%20using%20Lookup%20field%2C%20even%20if%20the%20list%20has%20more%20than%205%2C000%20records...%20but%20seems%20this%20is%20not%20working%20in%20my%20case%3F%20am%20i%20missing%20something%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2885445%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Valued Contributor

I have a Parent list which contain over 2 million records:-

 
 
 

1.png

 

and inside another list (Child list) i have a lookup field which reference the above parent list, as follow:-

 

2.png

 

and inside the Parent list i added the Title as an index column, as follow:-

 

3.png

 

now when i access the Child list's create/edit modern list forms, i will get this warning on the lookup field (which is understandable) :-

 

4.png

 

but when i start typing in the Parent Title inside the lookup field, the field will keep loading as if it is retrieving data, but for more than 2 hours now i am still getting the loading image and never get the Parent record..

 

5.png

 

Any advice ? per my knowledge that defining the correct Index on the Parent list should allow us to reference the list using Lookup field, even if the list has more than 5,000 records... but seems this is not working in my case? am i missing something?

Thanks

0 Replies