Remove SP list columns from search results

Copper Contributor

I have created an employee directory in a SharePoint list.  Currently, when I search the list using my name all records are returned since I created the records.  I would like to remove the "Created by" and "Modified by" columns from the search results so that when someone searches for me all records are not returned.  I'm looking for a solution that can be applied at the site level as I do not want to change the default behavior for other sites in the tenant.

6 Replies
By default, the “Created by” and “Modified by” columns are mapped to crawled properties named ows_Created_0x0020_By and ows_Modified_0x0020_By.
You can remove this mapping to prevent these columns from appearing in search results.
Go to the SharePoint Administration Center.
Navigate to “Manage search scheme” and then “Managed properties.”
Find the managed properties corresponding to “Created by” and “Modified by.”
Ensure that the “Allow search” option is unchecked for these properties1.
Uncheck “Include in Full-Text Index”:
Another approach is to open the ows_Created_x0020_By and ows_Modified_0x0020_By crawled properties.
Uncheck the box labeled “Include in full-text index” for both properties.
This action will prevent these properties from being included in the search index, effectively excluding them from search results

Hello @Ken Gano

 

there is no setting to hide columns from search index in the SharePoint GUI.

 

You can customize the query in a PnP Modern Search to search only exact match from your search query: https://www.mehr365.com/volltreffer-exakte-uebereinstimmung-in-der-suche/

 

Best, Dave 

@David Mehr, I want users to be able to use the search bar at the top of the page in SharePoint Online.  It is my understanding (from reading this page) that while you can use a custom search results page for site search, you cannot customize the search results page when you are searching within a list.  

@Josh_Wickes, I did not want to impact search results for other sites I just wanted to make the changes for the site with the staff directory.  So, at this point I'm reluctant to make any changes at the tenant level.  I've removed the mappings for ows_Created_x0020_By and ows_Modified_x0020_By at the site level, but so far it hasn't made a difference.  All of the settings for the managed properties are grayed out so I'm unable to make any changes to the settings.  According to this MS page, the only settings that you can change for built-in managed properties are their mappings to crawled properties and the alias.

 

I'm unsure of how long it takes for a site or list to be recrawled.  My understanding is that if you request that a site be reindexed that that just adds it to the que.  I'll take a look after the weekend and see if the search results have changed.

Did the above work?

@Josh_Wickes No, removing the mappings at the site level did not work.  Search still returns results based on the Created by and Modified by fields.

 

Instead of removing the columns from the search we have decided to take a different approach.  Most additions and updates to this list will be done by a flow.  The flows connection to SharePoint will use a service account with a name that is not likely to be searched and thus won't show up in search results.

 

For additions or edits that are made to the list directly from SharePoint.  We are considering a flow that will change the modified by and created by fields to the service account.  Here are two different posts explaining how to create such a flow:  

 

How to Easily Change the Creator or Editor of a SharePoint File or List Item Using Power Automate – ...  

 

#FlowNinja hack 78 - modifying Modified By and Modified time with Microsoft Flow — John Liu .NET