Set Default Metadata by Folder in a Library: Practical Checklist for SharePoint Owners

SharePoint library owners often need different metadata values applied automatically depending on which folder a file is saved into. For example, a Contracts folder should tag documents with the department name Finance, while a Marketing folder tags them with Marketing. Without this behavior, users must manually fill in the same values repeatedly, leading to data entry errors and inconsistent records. This article explains how to configure default metadata at the folder level using SharePoint column default values. You will learn the exact steps to set up folder-specific metadata, what prerequisites are required, and common pitfalls that can break the feature.

How Folder-Level Default Metadata Works

Folder-level default metadata is a SharePoint feature that lets you assign specific column values to all new files uploaded into a particular folder. When a user drags or uploads a file into that folder, SharePoint automatically applies the configured default values. This works for text, choice, date, number, currency, person or group, and managed metadata columns. The feature does not retroactively update existing files; it applies only to new files added after the default is set.

The feature relies on column default value settings found in the library settings page. SharePoint stores these defaults per folder path. If a file is uploaded to a subfolder, the subfolder’s defaults override any defaults set on the parent folder. If no defaults exist for a folder, SharePoint falls back to the library-level defaults, if any. You can set defaults for multiple columns on the same folder, and each column can have a different value per folder.

Prerequisites

Before you start, confirm the following:

• You have at least Edit permissions on the library or are a site owner.
• The library is not set to use content types that enforce required columns at the content type level; folder defaults work with site columns added directly to the library.
• The columns you want to use are already added to the library. If they are not, add them first through Library Settings > Add a column.
• Managed metadata columns must be single-value only. Multi-value term sets do not support folder-level defaults.

Steps to Set Default Metadata by Folder

Follow these steps to configure folder-specific default metadata in a SharePoint document library.

1. Navigate to the library
   Open the SharePoint site and go to the document library where you want to set folder defaults. Make sure you are viewing the library in the browser, not in a synced folder or the OneDrive sync client.
2. Open Library Settings
   Click the gear icon in the top-right corner of the page, then select Library settings. If you are on a modern team site, you may need to click Library on the command bar, then Library settings.
3. Locate Column default value settings
   In the Settings page, scroll down to the Columns section. Look for the link labeled Column default value settings. Click it. If you do not see this link, the library might be using a classic experience or content types that block this feature. Switch to modern experience if needed.
4. Choose a folder
   A dialog opens showing a folder tree. Browse to the folder for which you want to set default metadata. Click the folder name to select it. You can only set defaults for one folder at a time. Repeat the process for each additional folder.
5. Set the default column values
   After selecting a folder, the dialog displays a list of all columns in the library. For each column, you can type or pick a default value. For example, for a choice column named Department, select Finance. For a person or group column, type a user’s name or email. Leave a column blank if you do not want a default for it.
6. Save the settings
   Click OK at the bottom of the dialog. SharePoint applies the defaults immediately. To verify, upload a test file into that folder and check the metadata columns. The values you set should appear automatically.

Setting Defaults for Multiple Folders

You must repeat steps 4 through 6 for each folder that needs its own defaults. There is no bulk-import option. If you have many folders, consider using PowerShell with the PnP PowerShell module to set defaults programmatically. The cmdlet is Set-PnPDefaultColumnValues. Example: Set-PnPDefaultColumnValues -List "Documents" -Folder "Contracts" -Field "Department" -Value "Finance". This method is faster for large libraries but requires SharePoint admin permissions or site collection admin rights.

Common Mistakes and Limitations When Setting Folder Defaults

Default Values Not Applying to Uploaded Files

The most frequent issue is that defaults do not appear after upload. This happens when users upload files through the OneDrive sync client or the mobile app. Folder-level defaults only apply to files uploaded through the browser interface. Files synced from a local computer bypass SharePoint’s upload pipeline and do not trigger default value assignment. To enforce defaults, instruct users to upload through the browser or use a Power Automate flow that sets metadata for synced files.

Content Types Break Folder Defaults

If the library uses content types, column default value settings may be hidden or disabled. Content types enforce their own required columns and default values, and those take precedence over folder defaults. To use folder defaults, either remove content types from the library or ensure the columns you want to set defaults on are not managed by a content type. Go to Library Settings > Advanced settings and set Allow management of content types to No if you do not need content types.

Multi-Value Managed Metadata Columns Not Supported

The dialog for column default value settings does not allow selecting multiple values for a managed metadata column. If you need a folder to default to multiple terms, consider using a single-value column with a parent term that implies the multiple tags, or create separate columns for each tag. This is a known limitation of SharePoint’s folder-level default feature.

Defaults Overwritten by User Edits

Folder defaults are applied only at the moment of upload. If a user edits the metadata after upload, the default value is replaced. SharePoint does not reapply defaults on subsequent saves. If you need to enforce a value permanently, set a column validation or use a retention label with a default value, but those methods do not vary by folder.

Library Defaults vs Folder Defaults vs Content Type Defaults

Item	Library Defaults	Folder Defaults	Content Type Defaults
Scope	Entire library	Specific folder path	Content type across site
Override behavior	Overridden by folder defaults	Overridden by subfolder defaults	Overrides library and folder defaults
User interface	Library Settings > Column default value settings (no folder selected)	Library Settings > Column default value settings (folder selected)	Content type settings in Site Settings or Library Settings
Supports managed metadata	Yes, single-value only	Yes, single-value only	Yes, multi-value supported
Retroactive	No	No	No

You can now configure folder-specific default metadata in your SharePoint library using the column default value settings. Start with a single folder to test the behavior, then expand to other folders. If you manage many folders, consider using the PnP PowerShell cmdlet Set-PnPDefaultColumnValues to automate the setup. Remember that browser uploads apply the defaults, but synced files do not. For synced files, add a Power Automate flow triggered by file creation to set the metadata based on the folder path.