Merge 2 SharePoint List into a third List SharePoint Online

%3CLINGO-SUB%20id%3D%22lingo-sub-1127016%22%20slang%3D%22en-US%22%3EMerge%202%20SharePoint%20List%20into%20a%20third%20List%20SharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1127016%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20using%20share%20point%20online%20and%26nbsp%3B%20have%20a%20share%20point%20online%20list%20which%20contains%20more%20than%205000k%20elements%20.%20i%20am%20able%20to%20overcome%20this%20threshold%26nbsp%3Busing%20indexing%20but%20if%20i%20use%20index%20column%20i%20should%20switch%20to%20classic%20experience%20view%20for%20the%20list%20but%20i%26nbsp%3Bdo%20not%20want%20to%20use%20classic%20experience%20view%20i%20want%20to%20overcome%20this%20threshold%20with%20modern%20experience%26nbsp%3Bview%20since%26nbsp%3B%20i%20am%20using%20power%20apps%20to%20customize%20my%20create%20and%20edit%20form%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20you%20please%20help%20me%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%2C%3C%2FP%3E%3CP%3ESyed%20Shadab%20Mohammed%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1127016%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPIs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExtensibility%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPnP%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1127180%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%202%20SharePoint%20List%20into%20a%20third%20List%20SharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1127180%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F520511%22%20target%3D%22_blank%22%3E%40syed_shadab_mohammed%3C%2FA%3E%2C%3C%2FP%3E%3CP%3Efor%20what%20i%20know%2C%20in%20the%20modern%20view%20sharepoint%20has%20a%20predictive%20indexing%20for%20large%20lists%20and%20libraries.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIndex%20are%20created%20based%20on%20how%20the%20end-user%20is%20sorting%2Ffiltering%20the%20library.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%20Also%2C%20partial%20results%20are%20returned%20as%20the%20end-user%20scrolls%20down%20the%20list%20of%20items%20rather%20than%20returning%20all%20results%20at%20once.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1127201%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%202%20SharePoint%20List%20into%20a%20third%20List%20SharePoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1127201%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130893%22%20target%3D%22_blank%22%3E%40Valter%20Lima%3C%2FA%3E%26nbsp%3B%20i%20will%20try%20it%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hi,

 

i am using share point online and  have a share point online list which contains more than 5000k elements . i am able to overcome this threshold using indexing but if i use index column i should switch to classic experience view for the list but i do not want to use classic experience view i want to overcome this threshold with modern experience view since  i am using power apps to customize my create and edit form .

 

can you please help me ?

 

thank you,

Syed Shadab Mohammed

2 Replies

Hi @syed_shadab_mohammed,

for what i know, in the modern view sharepoint has a predictive indexing for large lists and libraries. 

Index are created based on how the end-user is sorting/filtering the library.  Also, partial results are returned as the end-user scrolls down the list of items rather than returning all results at once.

 

 

thank you @Valter Lima  i will try it .