Forum Discussion
colonel_claypoo
May 01, 2024Iron Contributor
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 (no...
colonel_claypoo
May 02, 2024Iron Contributor
Paul de Jong
May 02, 2024Iron Contributor
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.
- colonel_claypooMay 02, 2024Iron Contributor
Thanks. But that's strange. My SPO tenant doesn't seem to have ows_Office crawled properties. Aren't ows_ properties only those for which columns in document libaries were created?
Here's where I was looking: https://[]-admin.sharepoint.com/_layouts/15/searchadmin/ta_listcrawledproperties.aspx?level=tenant
And in the mapping popup for the managed property itself:
Any idea?
- Paul de JongMay 02, 2024Iron ContributorI am also confused. In one of my tenants (has been around for many years) I see the list with ows_Office:Application.
In one of my other tenants (more recent) I get the same results as you get.
I did notice that the category "Document Parser" contains several crawled properties that look similar the properties in Office files. Not sure if there is documentation out there. Otherwise it is like reverse engineering the schema.