Search SharePoint List - make column searchable

%3CLINGO-SUB%20id%3D%22lingo-sub-1715207%22%20slang%3D%22en-US%22%3ESearch%20SharePoint%20List%20-%20make%20column%20searchable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715207%22%20slang%3D%22en-US%22%3E%3CP%3EType%3A%20GCC%20-%20Communication%20site%3CBR%20%2F%3E%3CBR%20%2F%3EI%20created%20a%20new%20list%20with%202%20columns.%26nbsp%3B%20%26nbsp%3BUsing%20the%20list%20search%20box%2C%20it%20only%20finds%20items%20under%20TITLE%20column%2C%20anytime%20I%20try%20to%20search%20something%20from%20the%20other%20column%2C%20it%20returns%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20make%20any%20columns%20searchable%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-09-25_16-05-56.png%22%20style%3D%22width%3A%20516px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222332i1629134C70D8F916%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-09-25_16-05-56.png%22%20alt%3D%222020-09-25_16-05-56.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1715207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715268%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20SharePoint%20List%20-%20make%20column%20searchable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F297777%22%20target%3D%22_blank%22%3E%40Tamras1972%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20columns%20should%20be%20searchable%20by%20default.%20Please%20check%20the%20list%20settings%20and%20also%20activate%20the%20indexing%20through%20advanced%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20it%20up%20to%2024h%20to%20show%20new%20columns%20in%20the%20search%20bar.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715643%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20SharePoint%20List%20-%20make%20column%20searchable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715643%22%20slang%3D%22en-US%22%3EYeah.%20Give%20it%20some%20time.%20The%20first%20index%20will%20take%20awhile%20to%20index%20and%20pick%20up%20the%20new%20columns.%20Subsequent%20updates%20will%20be%20quicker.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715711%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20SharePoint%20List%20-%20make%20column%20searchable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715711%22%20slang%3D%22en-US%22%3ECorrect%2C%20but%20he%20needs%20to%20create%20also%20managed%20properties%20in%20the%20Search%20Schema%20to%20be%20able%20to%20search%20by%20column%20content%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1716177%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20SharePoint%20List%20-%20make%20column%20searchable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716177%22%20slang%3D%22en-US%22%3EExplicitly%20for%20a%20column%20yes.%20But%20using%20standard%20list%20search%20bar%20should%20return%20results%20based%20on%20other%20columns.%20Like%20if%20you%20had%20a%20single%20line%20of%20text%202nd%20column%20with%20%E2%80%9CJuan%E2%80%9D%20in%20it%20and%20they%20search%20Juan%20on%20the%20bar%20it%E2%80%99ll%20return%20that%20item.%20A%20bit%20different.%3C%2FLINGO-BODY%3E
Occasional Contributor

Type: GCC - Communication site

I created a new list with 2 columns.   Using the list search box, it only finds items under TITLE column, anytime I try to search something from the other column, it returns 0.

 

Is there a way I can make any columns searchable?

2020-09-25_16-05-56.png


7 Replies

@Tamras1972 

 

All columns should be searchable by default. Please check the list settings and also activate the indexing through advanced settings.

 

Give it up to 24h to show new columns in the search bar. 

Yeah. Give it some time. The first index will take awhile to index and pick up the new columns. Subsequent updates will be quicker.
Correct, but he needs to create also managed properties in the Search Schema to be able to search by column content
Explicitly for a column yes. But using standard list search bar should return results based on other columns. Like if you had a single line of text 2nd column with “Juan” in it and they search Juan on the bar it’ll return that item. A bit different.

@ArefHalmstrand @Chris Webb 
Its been few days and still can't find any from other columns. I also indexed both columns before posting my initial question

 

 

@Tamras1972 I am curious to why there is a search bar on your command bar. If you look at the suite bar, you should see the SharePoint modern search bar. The search bar should have predefined text "Search this library". Try searching for your content there.

@ArefHalmstrand 
Its a list and its the only search bar I see.

2020-09-30_09-10-00.png