Forum Discussion
Multi line text column with append changes managed property
Please consider below steps:
-
Ensure Correct Field Type: Make sure the multi-line text field is set to plain text rather than rich text. Rich text fields can sometimes cause issues with search indexing and retrieval.
-
Use Crawled Properties: Verify that the multi-line text field is being crawled correctly. You can check this in the SharePoint Search Schema under Crawled Properties. Look for a property that corresponds to your multi-line text field.
-
Map to Managed Properties: Once you have identified the correct crawled property, map it to a managed property. Use a RefinableString managed property if possible, as these are often more flexible.
-
Reindex the List: After making changes to the search schema, reindex the list or library. This can be done from the list settings under “Advanced settings.”
-
Check Search Schema Settings: Ensure that the managed property is set to be searchable, queryable, and retrievable. Sometimes, it helps to create a new managed property specifically for this field.
-
Use REST API for Debugging: If the above steps don’t work, use the SharePoint REST API to query the list and check if the field values are being returned correctly. This can help identify if the issue is with the search indexing or the field configuration.
-
PnP Search Web Parts Configuration: Make sure that the PnP Search web parts are configured to use the correct managed property. Sometimes, the issue might be with the web part configuration rather than the search schema.
Kidd_Ip Thanks for the reply - comments below
Ensure Correct Field Type: I need this to be rich text because we are using this field to store replies from emails that come to a list.
Use Crawled Properties: Verified the crawled property exists.
Map to Managed Properties: Mapped to three different managed properties, including refinablestring.
Reindex the List: Done multiple times as well as used a PowerShell script to edit the list items to ensure lots of data exists in the field.
Check Search Schema Settings: Done.
Use REST API for Debugging: Done, this is what is making me suspect I can't get the values in search because they are part of an item's versioning and it was difficult to retrieve with REST.
PnP Search Web Parts Configuration: Done, I've tested using independent tools like the SP Insider plug in for Chrome and all the managed properties for that specific field are null. Other MLOT fields in that list without Append Changes return data.