List/Library 5000 item No Folder View

%3CLINGO-SUB%20id%3D%22lingo-sub-1746537%22%20slang%3D%22en-US%22%3EList%2FLibrary%205000%20item%20No%20Folder%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746537%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20company%20regularly%20uses%20no%20folder%20views%20when%20adding%20documents%20to%20a%20document%20library%20or%20list%20items%20to%20a%20list.%26nbsp%3B%20For%20example%2C%20a%20library%20might%20have%20100%20folders%20with%20subfolders%2C%20but%20we%20like%20to%20look%20at%20all%20of%20the%20documents%20at%20once%20as%20a%20%22master%20library%22%20so%20we%20can%20filter%20down%20to%20the%20files%20or%20items%20we%20want%20to%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERecently%20we%20have%20started%20passing%20the%205000%20threshold%20and%20I%20would%20like%20to%20know%20if%20there%20is%20a%20way%20that%20we%20can%20still%20use%20the%20%22no%20folder%22%20view%20that%20we%20have%20been%20accustomed%20to%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1746537%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E5000%20items%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eview%20threshold%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1746997%22%20slang%3D%22en-US%22%3ERe%3A%20List%2FLibrary%205000%20item%20No%20Folder%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746997%22%20slang%3D%22en-US%22%3EFWIW%20I%20noticed%20today%20in%20User%20Voice%20a%20request%20to%20remove%20that%205000%20item%20limit%20and%20Microsoft%20has%20it%20marked%20as%20%22Working%20on%20it%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1748441%22%20slang%3D%22en-US%22%3ERe%3A%20List%2FLibrary%205000%20item%20No%20Folder%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1748441%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F708272%22%20target%3D%22_blank%22%3E%40jkiblerfbibuildings%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EDon't%20hold%20your%20breath.%20The%205000%20limit%20originates%20from%20the%20underlying%20database%20system.%20It%20might%20be%20useful%20to%20start%20looking%20into%20adding%20indexes%20or%20making%20optimal%20use%20of%20search%20in%20the%20interim%20period.%3CBR%20%2F%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello all.

 

My company regularly uses no folder views when adding documents to a document library or list items to a list.  For example, a library might have 100 folders with subfolders, but we like to look at all of the documents at once as a "master library" so we can filter down to the files or items we want to see.

 

Recently we have started passing the 5000 threshold and I would like to know if there is a way that we can still use the "no folder" view that we have been accustomed to?  

 

Please help.  Thank you!

3 Replies
Highlighted
FWIW I noticed today in User Voice a request to remove that 5000 item limit and Microsoft has it marked as "Working on it"
Highlighted

@jkiblerfbibuildings 
Don't hold your breath. The 5000 limit originates from the underlying database system. It might be useful to start looking into adding indexes or making optimal use of search in the interim period.
Paul

Highlighted

@Paul de Jong & All,

If there is an indexed column within a list of 5000+ records, can it be used to filter when attaching list metadata to a document in a document library?  

Example, my list is 6000+ records of deal names, they are divided into 6 markets.  The 'Markets' column is indexed. 

2020-10-13 11_08_47-Window.jpg

I'm attaching the deal names from this list to documents in the library.  Can I configure 'Market' as a filter that will then allow me to view the less than 5000 building names in the list?