Filtering by a field with 1000s of values

%3CLINGO-SUB%20id%3D%22lingo-sub-851513%22%20slang%3D%22en-US%22%3EFiltering%20by%20a%20field%20with%201000s%20of%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851513%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20metadata%20(libraries%20and%20lists)%20i%20have%20project%20number.%20I%20have%20hundreds%20of%20project%20numbers.%20Do%20i%20really%20have%20to%20scroll%20to%20find%20the%20one%20that%20i%20want%20to%20filter%20by%3F%20Is%20there%20really%20no%20way%20of%20typing%20in%20the%20number%20i%20want%20to%20filter%20by%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131459i1036BACFFCFF8777%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-851513%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-851554%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20a%20field%20with%201000s%20of%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851554%22%20slang%3D%22en-US%22%3E%3CP%3EClicking%20filter%20by%20on%20the%20column%20header%20allows%20for%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-852882%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20a%20field%20with%201000s%20of%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-852882%22%20slang%3D%22en-US%22%3ENo.%20Only%20if%20the%20column%20is%20text%20type.%20Choice%20%2F%20lookup%20columns%20have%20no%20ability%20to%20filter%20them%20down.%20Also%20the%20width%20could%20use%20some%20help%20as%20well%20as%20longer%20items%20get%20cut%20off%20at%20a%20low%20character%20count.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAdding%20a%20type%20ahead%20feature%20to%20these%20column%20types%20would%20be%20nice.%20%3CBR%20%2F%3E%3CBR%20%2F%3EOn%20a%20second%20note.%20You%20can%20use%20customize%20form%20with%20powerapps%20and%20easily%20change%20that%20field%20if%20it%20doesn%E2%80%99t%20have%20it.%20To%20be%20searchable.%20Save%20it%20and%20you%20can%20utilize%20search%20in%20a%20customized%20form.%20The%20downside%20is%20you%20can%E2%80%99t%20utilize%20the%20details%20pane%20on%20the%20default%20view%20UI%20with%20the%20custom%20forms.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853881%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20a%20field%20with%201000s%20of%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853881%22%20slang%3D%22en-US%22%3EYou're%20right%2C%20i%20was%20looking%20at%20the%20source%20list%20for%20the%20lookup%2C%20the%20lookup%20fields%20cant%20do%20this.%20Major%20flaw%20for%20document%20libraries%20with%20lookup%20metadata...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853963%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20a%20field%20with%201000s%20of%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853963%22%20slang%3D%22en-US%22%3EOn%20the%20second%20note%3A%20do%20you%20have%20any%20tips%20on%20how%20to%20set%20that%20up%3F%20Not%20very%20familiar%20with%20powerapps%20(yet)%3C%2FLINGO-BODY%3E
Contributor

In my metadata (libraries and lists) i have project number. I have hundreds of project numbers. Do i really have to scroll to find the one that i want to filter by? Is there really no way of typing in the number i want to filter by?

 

clipboard_image_0.png

4 Replies

Clicking filter by on the column header allows for this.

No. Only if the column is text type. Choice / lookup columns have no ability to filter them down. Also the width could use some help as well as longer items get cut off at a low character count.

Adding a type ahead feature to these column types would be nice.

On a second note. You can use customize form with powerapps and easily change that field if it doesn’t have it. To be searchable. Save it and you can utilize search in a customized form. The downside is you can’t utilize the details pane on the default view UI with the custom forms.
You're right, i was looking at the source list for the lookup, the lookup fields cant do this. Major flaw for document libraries with lookup metadata...
On the second note: do you have any tips on how to set that up? Not very familiar with powerapps (yet)