SharePoint Online Search API does not return custom choice and text column values

%3CLINGO-SUB%20id%3D%22lingo-sub-1300885%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20Search%20API%20does%20not%20return%20custom%20choice%20and%20text%20column%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EDetails%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3EFacing%20elementary%20issue%20i.e.%20%26nbsp%3BCreated%20custom%20site%20column%20and%20mapped%20i.e.%20crawl%20property%20with%20managed%20property%20but%20managed%20property%20does%20not%20return%20result%20and%20it%20always%20shows%20blank%20values%20but%20title%20column%20shows%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESite%20Template%3C%2FSTRONG%3E%3A%20-%20Modern%20Team%20Site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSTRONG%3ESteps%20Followed%3C%2FSTRONG%3E%3A-%3C%2FP%3E%3COL%3E%3CLI%3ECreated%20Team%20Site%20in%20SharePoint%20Online%3C%2FLI%3E%3CLI%3ECreated%20one%20site%20column.%3C%2FLI%3E%3CLI%3ECreated%20custom%20list%20and%20added%20custom%20site%20column.%3C%2FLI%3E%3CLI%3EAdded%20100%2B%20records%20to%20list%3C%2FLI%3E%3CLI%3EActivated%20all%20search%20related%20feature%20at%20Site%20%26amp%3B%20Web%20Level.%3C%2FLI%3E%3CLI%3EApplied%20Re-Index%20entire%20site%20as%20well%20as%20custom%20list%20and%20wait%20for%20couple%20of%20hours.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3BAs%20I%20navigate%20to%20Search%20Schema%20-%26gt%3B%20Search%20for%20custom%20site%20column%20under%20Managed%20%26amp%3B%20Crawled%20Property.%26nbsp%3B%20I%20did%20mapping%20i.e.%20crawled%20property%20with%20managed%20property%20i.e.%20prefix%20ows_.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EList%20Level%20Details%3A-%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3BList%20have%20searchable%20property%20is%20on.%3C%2FP%3E%3CP%3E%3CSTRONG%3ECrawl%20Property%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ECrawl%20property%20has%20%E2%80%9CInclude%20in%20full%20%E2%80%93%20text%20index%E2%80%9D%20property%20as%20true.%3C%2FP%3E%3CP%3E%3CSTRONG%3EType%20of%20Site%20Column%3A-%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3ECreated%20few%20text%20and%20choice%20column%20as%20a%20site%20column%20and%20mapped%20into%20list%20to%20add%20content.%3C%2FLI%3E%3CLI%3ECreated%20a%20Managed%20Property%20against%20the%20site%20column%20and%20mapped%20with%20crawled%20property.%3C%2FLI%3E%3C%2FOL%3E%3CP%3ENote%3A-%20I%20tried%20PnP%20PowerShell%20to%20find%20out%20crawl%20log%20error%20at%20site%20as%20well%20as%20list%20level.%20It%20did%20not%20through%20any%20error%3C%2FP%3E%3CP%3EReference%3A-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-pnp%2Fget-pnpsearchcrawllog%3Fview%3Dsharepoint-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-pnp%2Fget-pnpsearchcrawllog%3Fview%3Dsharepoint-ps%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESearch%20API%3A-%20%3CA%20href%3D%22https%3A%2F%2Fsantjust1.sharepoint.com%2Fsites%2Fdevinmobot%2F_api%2Fsearch%2Fquery%3Fquerytext%3D%2527GOLD0005*%2527%26amp%3Browlimit%3D100%26amp%3Bselectproperties%3D%2527Title%2Cinmoproductnamemp%2527%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmittal1201.sharepoint.com%2Fsites%2Fdevinmobot%2F_api%2Fsearch%2Fquery%3Fquerytext%3D%2527GOLD0005*%2527%26amp%3Browlimit%3D100%26amp%3Bselectproperties%3D%2527Title%2Cinmoproductnamemp%2527%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScreen%20Shot%20for%20Ref%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SearchAPIIssue.png%22%20style%3D%22width%3A%20618px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183781i8F1F9C3887EFE675%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22SearchAPIIssue.png%22%20alt%3D%22Custom%20Managed%20Property%20return%20null%20.%20even%20its%20mapped%20properly%20with%20crawl%20property%20and%20having%20values%20also%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ECustom%20Managed%20Property%20return%20null%20.%20even%20its%20mapped%20properly%20with%20crawl%20property%20and%20having%20values%20also%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESharePoint%20Online%20List%20Data%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SearchSharePointListData.png%22%20style%3D%22width%3A%20623px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183783iD41ED8153A6C415B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22SearchSharePointListData.png%22%20alt%3D%22List%20Data%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EList%20Data%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1300885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESearch%20API%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Details:

Facing elementary issue i.e.  Created custom site column and mapped i.e. crawl property with managed property but managed property does not return result and it always shows blank values but title column shows values.

 

Site Template: - Modern Team Site.

 Steps Followed:-

  1. Created Team Site in SharePoint Online
  2. Created one site column.
  3. Created custom list and added custom site column.
  4. Added 100+ records to list
  5. Activated all search related feature at Site & Web Level.
  6. Applied Re-Index entire site as well as custom list and wait for couple of hours.

 As I navigate to Search Schema -> Search for custom site column under Managed & Crawled Property.  I did mapping i.e. crawled property with managed property i.e. prefix ows_.

 

List Level Details:-

 List have searchable property is on.

Crawl Property

Crawl property has “Include in full – text index” property as true.

Type of Site Column:-

  1. Created few text and choice column as a site column and mapped into list to add content.
  2. Created a Managed Property against the site column and mapped with crawled property.

Note:- I tried PnP PowerShell to find out crawl log error at site as well as list level. It did not through any error

Reference:- https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/get-pnpsearchcrawllog?view=sharepo...

 

Search API:- https://mittal1201.sharepoint.com/sites/devinmobot/_api/search/query?querytext=%27GOLD0005*%27&rowli...

 

Screen Shot for Ref:-

Custom Managed Property return null . even its mapped properly with crawl property and having values alsoCustom Managed Property return null . even its mapped properly with crawl property and having values also

 

SharePoint Online List Data:-

List DataList Data

0 Replies