Search a certain column in a list

%3CLINGO-SUB%20id%3D%22lingo-sub-1084114%22%20slang%3D%22en-US%22%3ESearch%20a%20certain%20column%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084114%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20in%20a%20List%20called%20WorksheetID.%26nbsp%3B%20it's%20a%20text%20column.%3C%2FP%3E%3CP%3EWhen%20I%20use%20the%20search%20box%2C%20when%20viewing%20the%20list%2C%20and%20enter%20a%20valid%20WorksheetID%2C%20I%20don't%20get%20any%20search%20results.%3C%2FP%3E%3CP%3EThere%20must%20be%20a%20way%20to%20make%20something%20happen...can%20someone%20point%20me%20in%20the%20right%20direction%3F%3C%2FP%3E%3CP%3EThanks%20ahead%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1084114%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-1084199%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20a%20certain%20column%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084199%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F502609%22%20target%3D%22_blank%22%3E%40AdminEckler%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EThe%20column%26nbsp%3B%3CSPAN%3EWorksheetID%20is%20probably%20not%20%22Searchable%22.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20this%20scenarios%20you%20should%20search%20something%20like%20this%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EWorksheetID%3A%20%3CVALUE%20to%3D%22%22%20search%3D%22%22%3E%3C%2FVALUE%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20you%20don't%20want%20to%20put%20the%26nbsp%3BWorksheetID%20property%20in%20the%20search%20box%2C%20you%20should%20go%20to%20the%20search%20shema%2C%20and%20set%20the%26nbsp%3BWorksheetID%26nbsp%3B%20Managed%20Property%26nbsp%3B%20has%20searchable%3C%2FSPAN%3E%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%20678px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163423iFE07B70AE3C1E8CB%2Fimage-dimensions%2F678x141%3Fv%3D1.0%22%20width%3D%22678%22%20height%3D%22141%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-SUB%20id%3D%22lingo-sub-1084388%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20a%20certain%20column%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084388%22%20slang%3D%22en-US%22%3EIf%20you%20want%20to%20directly%20search%20by%20the%20column%20value%2C%20you%20need%20to%20create%20a%20manged%20property%20for%20that%20column.%20See%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fjoannecklein.com%2F2019%2F02%2F08%2Fcrawled-managed-properties-and-modern-team-sites%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjoannecklein.com%2F2019%2F02%2F08%2Fcrawled-managed-properties-and-modern-team-sites%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Visitor

I have a column in a List called WorksheetID.  it's a text column.

When I use the search box, when viewing the list, and enter a valid WorksheetID, I don't get any search results.

There must be a way to make something happen...can someone point me in the right direction?

Thanks ahead of time.

 

 

2 Replies

Hi @AdminEckler,

The column WorksheetID is probably not "Searchable".

In this scenarios you should search something like this:

WorksheetID: <value to search>

If you don't want to put the WorksheetID property in the search box, you should go to the search shema, and set the WorksheetID  Managed Property  has searchable

 

clipboard_image_0.png

If you want to directly search by the column value, you need to create a manged property for that column. See this: https://joannecklein.com/2019/02/08/crawled-managed-properties-and-modern-team-sites/