SOLVED

Filter by option

%3CLINGO-SUB%20id%3D%22lingo-sub-1389661%22%20slang%3D%22en-US%22%3EFilter%20by%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389661%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%20how%20are%20you%3F%3C%2FP%3E%3CP%3EI'm%20new%20here%20and%20I%20don't%20know%20if%20this%20is%20a%20stupid%20question%2C%20but%20I%20really%20want%20to%20understand%20why%20this%20is%20happening.%3C%2FP%3E%3CP%3EI%20created%20a%20document%20library%20and%20I%20would%20like%20to%20filter%20a%20column%20by%20a%20specific%20text%2C%20but%20the%20option%20doesn't%20even%20appear.%20I%20want%20to%20%22filter%20by%22%20in%20the%20name%20column%2C%20it%20appears%20for%20all%20the%20others%20columns%2C%20except%20this%20one.%20Anyone%20knows%20how%20I%20can%20fix%20it%3F%3C%2FP%3E%3CP%3EImage%20below%20to%20explain.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22narrigib_0-1589470051522.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F191672iCA51B6A09D216B0F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22narrigib_0-1589470051522.png%22%20alt%3D%22narrigib_0-1589470051522.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22narrigib_1-1589470103837.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F191673i02E83C671ED72C60%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22narrigib_1-1589470103837.png%22%20alt%3D%22narrigib_1-1589470103837.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1389661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1389739%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20by%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1389739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F668082%22%20target%3D%22_blank%22%3E%40narrigib%3C%2FA%3E%26nbsp%3Byou%20can't%20filter%20on%20the%20Name%20column%20but%20if%20you%20add%20the%20Title%20column%20to%20your%20view%20(from%20Library%20Settings)%20and%20always%20make%20sure%20that%20in%20the%20document%20properties%20you%20add%20the%20name%20(excluding%20the%20extension)%2C%20then%20you%20can%20filter%20on%20the%20Title%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20do%20for%20some%20libraries%20is%20to%20have%20a%20very%20simple%20flow%20in%20Power%20Automate%20that%20adds%20the%20name%20of%20the%20document%20into%20the%20Title%20column%20when%20the%20doc%20is%20uploaded%2C%20so%20the%20user%20doesn't%20need%20to%20remember%20to%20update%20the%20document%20properties%20manually%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22UpdateTitle.png%22%20style%3D%22width%3A%20595px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F191686i3D892CFA04A39C2E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22UpdateTitle.png%22%20alt%3D%22UpdateTitle.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1403430%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20by%20option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403430%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20so%20so%20much!!!%3C%2FP%3E%3CP%3EYou%20were%20really%20helpful!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hey guys, how are you?

I'm new here and I don't know if this is a stupid question, but I really want to understand why this is happening.

I created a document library and I would like to filter a column by a specific text, but the option doesn't even appear. I want to "filter by" in the name column, it appears for all the others columns, except this one. Anyone knows how can I fix it?

Image below to explain. 

narrigib_0-1589470051522.png

narrigib_1-1589470103837.png

 

Thank you all in advance.

2 Replies
Highlighted
Best Response confirmed by narrigib (New Contributor)
Solution

@narrigib you can't filter on the Name column but if you add the Title column to your view (from Library Settings) and always make sure that in the document properties you add the name (excluding the extension), then you can filter on the Title column.

 

What I do for some libraries is to have a very simple flow in Power Automate that adds the name of the document into the Title column when the doc is uploaded, so the user doesn't need to remember to update the document properties manually:

UpdateTitle.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

Thank you so so so much!!!

You were really helpful!