Noel Williams

Anita Fritz

The folders that business users like and the metadata that they need

If you’re looking for a way to improve productivity and adoption of your document management solution in Microsoft 365/SharePoint Online or Teams, consider the importance of folders for business users. By allowing users to organise their documents into folders, they are more likely to adopt and efficiently manage their documents. In this post, we’ll explore the benefits of folders for business users and how they can improve overall document management in your organisation.

But as IT specialists know, one of the strengths of SharePoint Online is how it can record metadata for the saved documents. That metadata makes searching and finding documents much more efficient than simply relying on the text content of the documents.

What you need are folders that automatically have metadata – e.g. if a user stores a document in a folder called invoice, a metadata attribute (e.g. called document type) is automatically set to invoice. That way you have the best of both worlds – the folders that business users like and the metadata that they need.

One way to implement – folder level default values

You could make use of a native SharePoint Online feature, which is folder-level default values. BUT this requires additional administrative effort every time you create a folder and can also lead to poor performance. The poor performance stems from the way the default values for every metadata column in your environment are stored in a single XML file, which can grow very large and be slow to load and process every time you save a document.

A better way to implement – MacroView Map Folder Name to Field

A much better alternative is the Map Folder Name To Field feature that is available based on MacroView DMS.

A MacroView DMS user sees a tree-view that contains all the areas for which they have permission in their Microsoft 365 tenant. Those areas include all the folders in their SharePoint Online document libraries and document sets.




A MacroView user can save a document or email by dragging and dropping it onto one of these SharePoint Online folders. If the name of the folder is also a valid value for a nominated metadata column – e.g. document type – that folder name is automatically recorded as the value for that metadata column. So if the user drops a document or email in a folder called invoice, the document type is automatically recorded as invoice.




There is no need to define a default value for each folder – the metadata recording is all based on the name of the folder being a valid value for the metadata column. Typically that metadata column would be of type managed, with its valid values defined in a central term set.

Map Folder Name to Field can record multiple metadata values as part of a save. If you are dragging to a sub-folder whose name is a valid value for a nominated metadata column and the name of the upper-level folder is also a valid value for a different metadata column, then both metadata columns will be recorded automatically.

With MacroView DMS, the recording of document type can be completely silent. Alternatively MacroView DMS can display a dialog that shows the automatic default value, which the user can adjust if desired – e.g. to choose supplier invoice rather than just invoice.

More efficient searching and finding

The automatically recorded metadata enables much more efficient retrieval of relevant documents and emails.

The MacroView DMS user can ‘slice and dice’ a view of a document library based on one or more metadata columns, including metadata columns whose values have been recorded automatically as described above. Clicking on the heading for the metadata column at the top of the view displays a pick list of all the metadata values that are in use within the current folder, or across the current folder and all its sub-folders. When the user chooses a value from the pick list, MacroView DMS filters the view display to show only the documents and emails that have that value.




MacroView DMS also facilitates searching across the Microsoft 365 tenant for documents and emails that have specified values in their metadata columns, including metadata columns that have been recorded automatically as described above. The search criteria can include text content as well as multiple metadata attributes.





MacroView DMS lets users working in Outlook search across all areas of the Microsoft 365 tenant for which they have permission. The search criteria can be a combination of content (contains the word checking) and multiple metadata attributes, including metadata which is recorded automatically, such as to and from attributes of emails.

Behind the scenes the search is performed by the SharePoint Online Search engine, so no new crawls, search indexes or search servers are required. By default the scope of the search is all areas in the Microsoft 365 tenant for which the user has permission. The MacroView user can also right-click on a hub site, site or library to restrict the scope of the search to just that hub site, site or library.

Importantly, MacroView DMS lets users harness the power of the SharePoint Online Search engine while they continue to work in desktop Microsoft Outlook and other familiar business applications – users do NOT have to jump out to the web browser to perform their searches.

More Information

Check this video in the MacroView channel on YouTube: