Hi all

I'm more an admin person rather than IT, but have been asked to find a solution for one of our directors who prefers to open his documents using File Explorer over Sharepoint online. And before you ask, no he won't change his ways! 

I need to be able to set up File Explorer to filter/display/order (however you want to name it) project folders synced with Sharepoint according to whether they are:

1/ Active or Complete (status)

2/ under his name as project manager.

I thought I had found the answer by adding columns to Sharepoint (see attached a screen shot below), but I have since discovered that those columns do not feed across to File Explorer.  

The only other solution I have is adding multiple layers of folders to Sharepoint. This will only complicate the library for other users so I am averse to implementing this.

Is there a way of tagging or adding some form of metadata to folders that will pass between Sharepoint and File Explorer that we can use to then filter the view on his device? 

Any suggestions please and thank you.

Hi all

I'm more an admin person rather than IT, but have been asked to find a solution for one of our directors who prefers to open his documents using File Explorer over Sharepoint online. And before you ask, no he won't change his ways! 

I need to be able to set up File Explorer to filter/display/order (however you want to name it) project folders synced with Sharepoint according to whether they are:

1/ Active or Complete (status)

2/ under his name as project manager.

I thought I had found the answer by adding columns to Sharepoint (see attached a screen shot below), but I have since discovered that those columns do not feed across to File Explorer.  

The only other solution I have is adding multiple layers of folders to Sharepoint. This will only complicate the library for other users so I am averse to implementing this.

Is there a way of tagging or adding some form of metadata to folders that will pass between Sharepoint and File Explorer that we can use to then filter the view on his device? 

Any suggestions please and thank you.

I know its late, but you can use Power Automate to append the 'Project Manager' and 'Status' properties to the file name, such as '[COMPLETED-DANIEL] ABC Project.ppt'. This way, all necessary properties will \"sync\" to File Explorer, allowing you to sort your directories by the file's name.

Johan Stenberg 

Cant open zip files in sharepoint, or many other filetypes that are not natively in the microsoft ecosystem. 

If it's not .xlsx, .docx, .pptx, .pdf etc, file explorer is your only hope (other than downloading from sharepoint then opening, but again you'd just be in the downloads folder of your file explorer). Also the .pdfs wont launch in your native pdf program, it just uses the browser.

So that's why explorer.

Johan Stenberg  Thank you Johan and others.  Found it. WHY use File Explorer?  Not sure what trouble I'd see by using it, but here are a few reasons:

 - I am not always online to attach to my sharepoint files.  The \"synching\" does not always work - synching has synched the wrong file and set me back.

 - Sharepoint works well on an intranet - but most of the people I work with are not in our organization, some of them are not \"Microsoft shops\" and sharepoint access is intermittent; we are left with having to email a document back and forth.  

 - I work on documents with others, and as I'm writing, editing, changing, I don't always want my work public.  Some initial work and much wordsmithing is not necessary to track.

 - Though Sharepoint has \"revert\" to earlier versions, I  like to keep some of the drafts ver 1.0,1.5, 2.0 etc. intact as complete documents for future reference. 

- Yes we can give the complete docs different filenames with versions - and we do, but the final doc and maybe a last draft can sit in Sharepoint, not all 10 or 20 or however many draft versions. 

 - Working with multiple authors, a document can become unreadable with all changes tracked.

 - Sometimes it's helpful, even necessary, to compare an earlier draft or two side by side with a recent draft.  Especially when working with multiple authors.

  - Especially true for budget worksheets, or datasets. 

  - Provenance can have legal ramifications. 

 - Getting close to a final version, the Sharepoint versions of files changes or DESTROYs formatting. Sharepoint files don't have the same format options that the applications have... especially for book length documents or excel workbooks with complex features.  This is one of the biggest detriments. 

Further some of us use other productivity apps besides MS apps- It's a couple extra steps to convert from/to sharepoint.  

This is all the crap I'm not willing to scrap!

My guess is that Microsoft programmers/developers are just that - and not writers or project managers or people who need both privacy for some documents and complex document formatting.

Last note - the MS world is way overbuilt.  Too many different visions.  What the heck is the difference between and the need for Sharepoint, AND OneDrive, AND MS Teams desktop app files areas, AND MS Teams online web version?  Not all of them work all of the time.  Sometimes files just don't display. Why are attachments saved in some system generated folder that I do not want to keep?  Is it necessary to Manage Teams, and Outlook Groups & Contact Lists separately? I so miss the simplicity of google workspace, (drive & meeting). 

solson550  I agree on all accounts. File Explorer is a must even with the cloud because it gives more flexibility for manipulating files. I am joining this thread in hopes there is a solution. Best! Michelle

Ethan_Cordner Right. I need this option that is available in File Explorer, to be in Sharepoint and in the MS Teams/Files app.  Simple right click on the fields bar to bring up the metadata to display.

Is there any update on this one? We have just created a content repository on sharepoint with a series of metadata columns. Since some of my colleagues live in areas were connection is very unstable, it would be so useful to them to access the repository through file explorer and still be able to filter out the document they are looking for thanks to the metadata information.

CamillaTorresan 

Not really.
Use OneDrive for business client that does not support metadata.
Use browser-based apps that mimic Explorer and support custom metadata (e.g. project) (example)

Using client-side tools that use WebDAV to communicate with SharePoint are afaik also not an option.

Carmen3008 

This functionality is not on the OneDrive roadmap (link). This will also not be supported when using File Explorer in Edge (link).

This leaves the following scenario's:
1. Accept the lack of functionality in Windows Explorer
2. Use third party tools that mimic Windows Explorer and support metadata (example)
3. Convert the manager to use the web interface.

Carmen3008 I totally agree this is a massive need. As Microsoft do more and more to enable both column management in modern SharePoint but also onedrive sync across the ecosystem this is sorely needed. I am merely putting myself into this conversation so that if Microsoft come with a solution, I am tagged 🙂 

Carmen3008  - I know it's been a bit but did you ever get an answer?  I have the same need.