Sharepoint teams site Searching list

%3CLINGO-SUB%20id%3D%22lingo-sub-891119%22%20slang%3D%22en-US%22%3ESharepoint%20teams%20site%20Searching%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891119%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20in%20a%20Teams%20site%20that%20I%20opened%20in%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20filter%20the%20default%20'ID'%20column%20in%20a%20searchable%20way%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20pics%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20I%20have%20100%20items%2F%20IDs%20in%20a%20list.%20I%20wanted%20to%20filter%20the%20ID%20by%20say%201%2C%2050%20and%20100.%20Currently%20I%20would%20have%20to%20scroll%20down%20and%20find%20the%20ID%20but%20is%20there%20no%20search%20bar%20functionality%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20751px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135276i9F935D562FFDBC34%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20830px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135277i1BCA8892731A00B7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-891119%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-891788%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20teams%20site%20Searching%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891788%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F252982%22%20target%3D%22_blank%22%3E%40testio2%3C%2FA%3E%26nbsp%3BI%20wish%20we%20had%20that%20function%20but%20we%20don't%20have%20but%20we%20have%20some%20alternatives%20which%20you%20might%20be%20already%20using.%20Applying%20filter%20using%20%3CSTRONG%3EText%20find%20filter%3C%2FSTRONG%3E%20but%20the%20catch%20is%20that%20do%20not%20gets%20applied%20for%20SharePoint%20List%20Item%20ID%20field%20or%20any%20Number%20fields.%20For%20example%20shown%20below%20I%20am%20showing%20three%20different%20types%20of%20fields%20ID(SP-OOB)%2C%20Single%20Line%20of%20Text%20Field(TextItem%23)%20and%20a%20number%20Field(Item%23).%20I%20can%20apply%20the%20Text%20find%20filter%20function%20on%20the%20Single%20Line%20Text%20field(TextItem%23)%20where%20I%20am%20saving%20Number%20in%20form%20of%20a%20Text%20but%20not%20in%20other%20two%20type%20of%20fields.%20%3CSTRONG%3EIf%20you%20can%20copy%20the%20ID%20field%20value%20to%20a%20single%20line%20text%20field(Multiple%20ways%20are%20there)%20then%20you%20can%20get%20your%20desired%20function.%20%3C%2FSTRONG%3EPlease%20find%20the%20below%20screen%20shots%20for%20your%20reference.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20469px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135332i879BB96E91C10757%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-10-03_0953.png%22%20title%3D%222019-10-03_0953.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EJust%20start%20typing%20each%20Filtering%20number(One%20at%20a%20Time)%20and%20it%20will%20Check%20it%20for%20you%20and%20you%20don't%20have%20to%20scroll%20then.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20333px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135333iE93AF2D6B7C82C57%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-10-03_1000.png%22%20title%3D%222019-10-03_1000.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHope%20this%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello,

 

I have a list in a Teams site that I opened in SharePoint.

 

Is there any way to filter the default 'ID' column in a searchable way?

 

Please see pics

 

For example I have 100 items/ IDs in a list. I wanted to filter the ID by say 1, 50 and 100. Currently I would have to scroll down and find the ID but is there no search bar functionality?

 

Thanks!image.pngimage.png

1 Reply

@testio2 I wish we had that function but we don't have but we have some alternatives which you might be already using. Applying filter using Text find filter but the catch is that do not gets applied for SharePoint List Item ID field or any Number fields. For example shown below I am showing three different types of fields ID(SP-OOB), Single Line of Text Field(TextItem#) and a number Field(Item#). I can apply the Text find filter function on the Single Line Text field(TextItem#) where I am saving Number in form of a Text but not in other two type of fields. If you can copy the ID field value to a single line text field(Multiple ways are there) then you can get your desired function. Please find the below screen shots for your reference.

 

2019-10-03_0953.png

Just start typing each Filtering number(One at a Time) and it will Check it for you and you don't have to scroll then.

2019-10-03_1000.png

Hope this helps!