Home

"IF AND" Metadata Filter Logic

%3CLINGO-SUB%20id%3D%22lingo-sub-1398255%22%20slang%3D%22en-US%22%3E%22IF%20AND%22%20Metadata%20Filter%20Logic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1398255%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EWe%20are%20looking%20at%20moving%20our%20document%20storage%20to%20Sharepoint%20from%20Dropbox%2C%20we%20dislike%20the%20folder%20structure%20in%20Dropbox%20as%20it%20makes%20it%20very%20hard%20to%20find%20documents%20which%20don't%20clearly%20fit%20into%20one%20sub%20folder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20what%20I've%20seen%20on%20Sharepoint%20with%20it's%20metadata%20system%2C%20I've%20so%20far%20been%20able%20to%20add%20files%2Ffolders%20and%20implement%20a%20Metadata%20filter.%20My%20question%20now%20is%20can%20I%20make%20it%20so%20the%20Metadata%20filter%20only%20displays%20files%20with%20all%20the%20selected%20tags%3F%20Sort%20of%20like%20an%20IF%20AND%20logic%20setup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20an%20example%20imagine%20I%20have%20two%20tags%2C%20one%20called%20%22Microsoft%22%20which%20belongs%20to%20the%20%22brand%22%20terms%20and%20another%20called%20%22Repair%20Information%22.%26nbsp%3B%22Microsoft%22%20could%20be%20used%20on%20files%20that%20aren't%20repair%20guides%20and%20the%20%22Repair%20Information%22%20tag%20is%20used%20for%20multiple%20brands.%20I%20don't%20want%20to%20see%20files%20that%20met%20either%20criteria%20I%20only%20want%20to%20see%20files%20that%20meet%20both%20(Repair%20information%20for%20Microsoft)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Adam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1398255%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%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-1400280%22%20slang%3D%22en-US%22%3ERe%3A%20%22IF%20AND%22%20Metadata%20Filter%20Logic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1400280%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F670850%22%20target%3D%22_blank%22%3E%40acrcmb%3C%2FA%3E%26nbsp%3B%20You%20would%20filter%20first%20by%20one%20field%2C%20which%20would%20narrow%20down%20your%20choices%2C%20and%20then%20by%20the%20other.%26nbsp%3B%20If%20you%20find%20yourselves%20doing%20the%20same%20filter%20over%20and%20over%20again%2C%20you%20could%20create%20a%20unique%20view.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi there,

We are looking at moving our document storage to Sharepoint from Dropbox, we dislike the folder structure in Dropbox as it makes it very hard to find documents which don't clearly fit into one sub folder.

 

I like what I've seen on Sharepoint with it's metadata system, I've so far been able to add files/folders and implement a Metadata filter. My question now is can I make it so the Metadata filter only displays files with all the selected tags? Sort of like an IF AND logic setup.

 

As an example imagine I have two tags, one called "Microsoft" which belongs to the "brand" terms and another called "Repair Information". "Microsoft" could be used on files that aren't repair guides and the "Repair Information" tag is used for multiple brands. I don't want to see files that met either criteria I only want to see files that meet both (Repair information for Microsoft)

 

Any suggestions?

 

Thanks Adam

1 Reply
Highlighted

@acrcmb  You would filter first by one field, which would narrow down your choices, and then by the other.  If you find yourselves doing the same filter over and over again, you could create a unique view.