Forum Discussion

testio2's avatar
testio2
Brass Contributor
Oct 03, 2019

Sharepoint teams site Searching list

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!

SharePoint Online
  • Vikram_Samal's avatar
    Vikram_Samal
    Steel Contributor
    Oct 03, 2019

    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.

     

    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.

    Hope this helps!

Resources