Adding top level folder name to metadata

%3CLINGO-SUB%20id%3D%22lingo-sub-1925000%22%20slang%3D%22en-US%22%3EAdding%20top%20level%20folder%20name%20to%20metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1925000%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20group%20of%20users%20with%20a%20large%20library%2C%20comprised%20of%20more%20than%201000%20top-level%20folders%20with%20client%20names.%26nbsp%3B%20(Under%20each%20top%20level%20folder%2C%20there%20may%20or%20may%20not%20be%20subfolders.)%26nbsp%3B%20I've%20been%20working%20with%20them%20to%20add%20metadata%20to%20be%20applied%20to%20a%20subset%20of%20documents%20from%20a%20variety%20of%20folders%2C%20and%20have%20created%20a%20view%20to%20%22show%20all%20items%20without%20folders%22%20to%20display%20documents%20independent%20of%20their%20folders.%26nbsp%3B%20Unfortunately%2C%20this%20view%20%22loses%22%20the%20client%20name%20from%20the%20top-level%20folder%20in%20which%20the%20document%20is%20found.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20add%20a%20metadata%20column%20to%20the%20library%20that%20displays%20the%20name%20of%20the%20top-level%20folder%20in%20which%20the%20document%20is%20stored%20(and%20not%20any%20of%20the%20intermediate%20folders%2C%20if%20there%20are%20any).%26nbsp%3B%20What%20are%20my%20best%20options%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESeth%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1925000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1928329%22%20slang%3D%22de-DE%22%3ESubject%3A%20Adding%20top%20level%20folder%20name%20to%20metadata%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1928329%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266999%22%20target%3D%22_blank%22%3E%40SethHorwitz%3C%2FA%3E%20you%20can%20create%20documents%20sets%2C%20which%20are%20a%20kind%20of%20folder%2C%20but%20with%20metadata%20columns.%20They%20vanished%20from%20SharePoint%20a%20couple%20of%20years%2C%20now%20they%20back%20again%20in%20modern%20SharePoint%20online.%20Here%20is%20an%20article%20about%20doc%20sets%20in%20modern%20SharePoint%20Sites%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.c-sharpcorner.com%2Fblogs%2Fdocument-sets-in-modern-sharepoint-libraries%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EDocument%20Sets%20In%20Modern%20SharePoint%20Libraries%20(c-sharpcorner.com)%3C%2FA%3E%3C%2FP%3E%3CP%3EWith%20doc%20sets%20you%20can%20have%20the%20customers%20on%20the%20top%20and%20for%20each%20doc%20set%20the%20projects%20and%20their%20files%20within.%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%2C%20greets%20from%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a group of users with a large library, comprised of more than 1000 top-level folders with client names.  (Under each top level folder, there may or may not be subfolders.)  I've been working with them to add metadata to be applied to a subset of documents from a variety of folders, and have created a view to "show all items without folders" to display documents independent of their folders.  Unfortunately, this view "loses" the client name from the top-level folder in which the document is found.

 

I would like to add a metadata column to the library that displays the name of the top-level folder in which the document is stored (and not any of the intermediate folders, if there are any).  What are my best options?

 

Thanks,

 

Seth

1 Reply

@SethHorwitz, I made a screenshot for a document set I used once in a site ... you can create documents sets, which are a kind of folder, but with metadata columns. They vanished from SharePoint a couple of years, now they back again in modern SharePoint online. Here is an article about doc sets in modern SharePoint Sites: Document Sets In Modern SharePoint Libraries (c-sharpcorner.com)

With doc sets you can have the customers on the top and for each doc set the projects and their files within. 

Hope this helps, greets from Eva.