Forum Discussion
Can SharePoint Search read Office file properties?
The title does not refer to files stored on SharePoint. I would like to know if Office file intrinsic metadata can be included into the SharePoint Search index. Especially when a file was created (not on SharePoint) but in the Office App, see:
Is that possible?
I did a quick test with a docx file with properties like Company, Comments, etc... containing values. After waiting a short while for the docx file to be indexed I searched for the property values without results.
Property promotion (available for office files and tiff files) should in principle allow for office properties to be added as metadata to the SharePoint file if the SharePoint columns names match (e.g. title). I have not seen this working for the "Last Modified" office property though: SharePoint simply creates a file with a new date/time.
One possible approach is to create managed properties in the SharePoint Search schema that are mapped to the crawled properties of the Office files (named ows_Office:xyz). This works for text fields but I could not created a managed property of type date/time.
Another approach is to use Apps (example) that can extract the Office file properties into SharePoint columns. These columns can then be used for sorting, filtering, grouping and of course searching. For example, this approach also allows using the property "Last Modified" date in an Office file in SharePoint as the SharePoint "Modified" date instead of the date/time the file was uploaded. This can be important in organizations where content needs to be kept for a certain period or must be deleted after a fixed period.
No, search for ows_Office:
This will return a list with crawled Office file properties like
After mapping the crawled properties to managed properties you can use full text search because managed properties are automatically included. Creating managed properties for the date/time fields will be next challenge. This link (https://blog.velingeorgiev.com/how-set-datetime-managed-property-sharepoint-online) may offer a solution.
