Forum Discussion
What SharePoint library columns might be recognized as columns (details/fields) in File Explorer?
Bear in mind, I'm no expert...
What SharePoint library columns might be recognized as columns (details/fields) in File Explorer for Windows 10? I've found that if I set up a Single Line of Text column in Office365 SharePoint Online called "Subject", that content is picked up in the "Subject" column in File Explorer for Windows 10. That is very useful since I can now use my SharePoint metadata for easy filtering and sorting within File Explorer of my synced OneDirve for Business/SharePoint libraries. Do any of you know of other column fields in File Explorer and SharePoint that can be co-opted in this way?
Think of it this way, SharePoint knows a lot about Office document properties (because SP used to be part of the Office product line) and somethings about other vendors documents, if you want SharePoint to know more about those properties, you can created custom content types and/or managed search properties.
Windows File Explorer does not know a lot about properties configured in SharePoint because every company can customize SharePoint as they see fit. Why the Windows team has not integrated with the default SP Properties is a mystery to me.
I have almost the same question, however I did not find the answer here.
My collegues would like to start using metadata but also want to synchronize the document library they work with on a regular basis with their PC (in case Internet does not work when they want to access a document).
Unfortunately, none of the metadata colums we add seem to be available in the explorer, which makes it kind of difficult to find documents in long lists.
What am I missing?
I add a printscreen (example) of what we see in both situations.
There is nothing you are missing.
In short:
- SharePoint additional columns are mapped to document properties for Office files and hence are visible locally in the backstage of the Office application when the synced file is opened.
- SharePoint additional columns are, in general, NOT mapped to document properties for non-Office files (e.g. PDFs). In the article that I referenced in a previous post in this thread are listed the file types for which additional properties could be actually mapped. Again, not PDFs.
- In any case, additional properties are not visible as columns in File Explorer.
Hope it helps...
- Thanks!
That would be amazing if that is possible. Being able to sync and change the meta data directly in file explorer or even filter/search by the meta data in windows would be huge. I am going to have a play with it and see whats possible.
Note: if you right click on the column header Subject is already there, so maybe it just matches it up. Hmmm.
Thanks Stephen. I've explored a little more. It is only Office Documents and not pdfs, so it isn't as useful as I thought. If I change the Subject in Properties in the Office document, it shows up in SharePoint and File Explorer and vice versa but I couldn't get that behavior if I tried the same trick with fields such as Status, Categories, Hyperlink Base, or Company; just Subject.
Hi Don Doering
The behavior you are seeing is related to Document Property Promotion and Demotion.
We have already discussed it in other threads.
For more details, see https://blogs.technet.microsoft.com/wbaer/2014/08/29/document-property-promotion-and-demotion-overview-and-considerations/
- True, I keep that in mind.
Can you please show me how you got this done?Don Doering
I want to show metadata from folders in sharepoint to the windows explorer.
i tried using the Title column but that didn't work.
You used the subject column i can't find a subject column in the explorer.
thanks for helping me out.
