Filter Entire Document Library

%3CLINGO-SUB%20id%3D%22lingo-sub-2065145%22%20slang%3D%22en-US%22%3EFilter%20Entire%20Document%20Library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065145%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Document%20Library%20with%20multiple%20folders%20and%20sub-folders%20that%20I%20would%20like%20to%20filter%20on.%26nbsp%3B%20I%20created%20a%20%22CHOICE%22%20column%20which%20can%20be%20assigned%20different%20categories%20(e.g.%20Category%20A%2C%20Category%20B%2C%20Category%20C....)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20apply%20a%20filter%20to%20the%20Root%20folder%20and%20see%20only%20those%20folders%20(or%20items%20in%20the%20Root%20folder)%20which%20contain%20items%20assigned%20with%2C%20say%2C%20Category%20A.%26nbsp%3B%20The%20issue%20I%20have%20is%20that%20if%20the%20Root%20folder%20itself%20doesn't%20have%20any%20items%20assigned%20as%20Category%20A%2C%20then%20the%20resulting%20file%20list%20is%20blank%20EVEN%20THOUGH%20there%20are%20item%20in%20sub-folders%20of%20the%20Root%20folder%20that%20DO%20have%20items%20assigned%20with%20Category%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20fix%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2065145%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2069795%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Entire%20Document%20Library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2069795%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F172123%22%20target%3D%22_blank%22%3E%40Daniel%20Bonner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20where%20you%20are%20trying%20to%20use%20the%20filter%20option%3F%20is%20it%20in%20SPFx%20or%20Power%20Automate%3F%20Are%20you%20using%20CAML%20query%2C%20if%20then%20try%20to%20use%20the%20recursive%20scope%20inside%20the%20query%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a Document Library with multiple folders and sub-folders that I would like to filter on.  I created a "CHOICE" column which can be assigned different categories (e.g. Category A, Category B, Category C....)

 

I would like to apply a filter to the Root folder and see only those folders (or items in the Root folder) which contain items assigned with, say, Category A.  The issue I have is that if the Root folder itself doesn't have any items assigned as Category A, then the resulting file list is blank EVEN THOUGH there are item in sub-folders of the Root folder that DO have items assigned with Category A.

 

Is there a fix for this?

2 Replies

@Daniel Bonner 

From where you are trying to use the filter option? is it in SPFx or Power Automate? Are you using CAML query, if then try to use the recursive scope inside the query?

 

@Sudharsan K  this is within my SharePoint Site.  I open up a document library - click open the filter pane on the right hand side - then select the category I want to filter on.