Views in large libraries 5000 item limit

%3CLINGO-SUB%20id%3D%22lingo-sub-149773%22%20slang%3D%22en-US%22%3EViews%20in%20large%20libraries%205000%20item%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149773%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20question%20regarding%20large%20libraries%20in%20Sharepoint%20online.%26nbsp%3B%20I%20have%20a%20library%20with%20more%20the%2060%20thousand%20items.%26nbsp%3B%20After%20experiencing%20and%20searching%20for%20answers%20to%20make%20the%20views%20work%20I%20found%20out%20that%20moving%20some%20of%20the%20documents%20to%20another%20library%20and%20creating%20indexing%20before%20the%20library%20would%20reach%205000%20items%20would%20solve%20the%20problem.%26nbsp%3B%20%26nbsp%3B%20Also%20the%20predictive%20indexing%20should%20be%20working%20when%20documents%20are%20less%20than%2019.999.%26nbsp%3B%20So%20after%20%3CSTRONG%3Ecreating%20indexes%20%3C%2FSTRONG%3Ein%20a%20library%20under%205000%20I%20moved%20more%20documents%20to%20the%20library%20so%20it%20is%20now%20around%2014%2C000.%26nbsp%3B%20However%20after%20that%2C%20none%20of%20the%20views%20are%20working.%26nbsp%3B%20The%205000%20limit%20error%20always%20appears.%26nbsp%3B%20I%20have%20than%20tried%20deleting%20the%20documents%20and%20getting%20back%20to%20around%203000%20and%20%3CSTRONG%3Eallowing%20predictive%20indexing%3C%2FSTRONG%3E%20create%20automatically%20indexes%2C%20that%20are%20showing%20in%20the%20list%20of%20indexes.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20views%20are%20showing%20and%20working%20ok%2C%20but%20as%20soon%20as%20returning%20more%20documents%20up%20to%2014000%20the%20error%20is%20back%20!%26nbsp%3B%20%26nbsp%3BHas%20someone%20found%20a%20solution%20to%20make%20this%20work%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20document%20library%20has%20a%20lot%20of%20folders%20and%20subfolders%20so%20the%20views%20must%20show%20items%20without%20folders.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-149773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185245%22%20slang%3D%22en-US%22%3ERe%3A%20Views%20in%20large%20libraries%205000%20item%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185245%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20what%20was%20the%20problem%20for%20us.%20We%20had%20set%20a%20count%20in%20the%20Totals%20section%20when%20we%20had%20set%20up%20the%20view%20before%20Modern%20UI.%20Simply%20removing%20it%20solved%20the%20problem!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185231%22%20slang%3D%22en-US%22%3ERe%3A%20Views%20in%20large%20libraries%205000%20item%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185231%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%40Deleted.%20Did%20you%20get%20an%20answer%20from%20Microsoft%20on%20this%3F%20Did%20you%20get%20to%20solve%20this%20issue%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149849%22%20slang%3D%22en-US%22%3ERe%3A%20Views%20in%20large%20libraries%205000%20item%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149849%22%20slang%3D%22en-US%22%3E%3CP%3Emm%20that%20is%20strange%20as%20it%20now%20works%20with%20batches.%20Maybe%20you%20need%20to%20create%20a%20support%20call%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149817%22%20slang%3D%22en-US%22%3ERe%3A%20Views%20in%20large%20libraries%205000%20item%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149817%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Modern%20SP%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149807%22%20slang%3D%22en-US%22%3ERe%3A%20Views%20in%20large%20libraries%205000%20item%20limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149807%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20you%20using%20a%20classic%20view%20or%20the%20modern%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have a question regarding large libraries in Sharepoint online.  I have a library with more the 60 thousand items.  After experiencing and searching for answers to make the views work I found out that moving some of the documents to another library and creating indexing before the library would reach 5000 items would solve the problem.    Also the predictive indexing should be working when documents are less than 19.999.  So after creating indexes in a library under 5000 I moved more documents to the library so it is now around 14,000.  However after that, none of the views are working.  The 5000 limit error always appears.  I have than tried deleting the documents and getting back to around 3000 and allowing predictive indexing create automatically indexes, that are showing in the list of indexes.   

The views are showing and working ok, but as soon as returning more documents up to 14000 the error is back !   Has someone found a solution to make this work? 

 

This document library has a lot of folders and subfolders so the views must show items without folders.  

 

5 Replies
Highlighted

Are you using a classic view or the modern?

Highlighted

I am using Modern SP 

Highlighted

mm that is strange as it now works with batches. Maybe you need to create a support call

Highlighted

Hi @Deleted. Did you get an answer from Microsoft on this? Did you get to solve this issue?

Thanks

Highlighted

I found what was the problem for us. We had set a count in the Totals section when we had set up the view before Modern UI. Simply removing it solved the problem! :)