Set Default Metadata by Folder in a Library: Mistakes to Avoid

When you set default metadata by folder in a SharePoint document library, you can automatically fill column values for new files uploaded to that folder. This feature saves time and ensures consistent data entry. However, many administrators and site owners make configuration errors that break the feature or cause confusion. This article explains how default metadata works, the exact steps to set it correctly, and the most common mistakes to avoid.

How Default Metadata by Folder Works in SharePoint

Default metadata by folder is a feature in SharePoint document libraries that lets you assign default values to columns for all new files uploaded to a specific folder. When a user uploads a document to that folder, the system pre-fills the defined column values. The user can still change those values before saving.

This feature is available in SharePoint Online and SharePoint Server 2016 and later. It works only on site columns and library columns that are set to accept default values. Not all column types support defaults. Supported types include single line of text, choice, number, currency, date and time, person or group, and yes/no. Lookup columns and managed metadata columns do not support folder-level defaults.

The default value applies only to files uploaded directly to that folder. Files moved or copied from another location do not trigger the default. The feature also does not apply to files created via a workflow or API call unless the upload explicitly targets the folder.

Prerequisites for Using Folder Defaults

Before you configure defaults, ensure your library meets these conditions:

• The library uses the New Document or Upload button. Default metadata does not work with drag-and-drop uploads from File Explorer in classic mode.
• The column you want to default must be added to the library content type. Hidden columns cannot receive defaults.
• You must have Edit or Full Control permissions on the library.

Steps to Set Default Metadata for a Folder

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

1. Open the library and navigate to the folder
   Go to the document library that contains the target folder. Click the folder name to open it.
2. Access library settings
   Click the gear icon in the upper right corner and select Library settings. If you are inside the folder, the settings still apply to the library.
3. Open column default value settings
   Under the Permissions and Management section, click Column default value settings. This link appears only if the library has at least one column that supports default values.
4. Select the folder
   On the Column Default Value Settings page, choose the folder from the list. The page lists all subfolders in the library. If you do not see your folder, confirm you created it under the library root.
5. Choose the column and set the default value
   After selecting the folder, a list of eligible columns appears. Click the column you want to configure. Enter the default value. For choice columns, type the exact option text. For person or group columns, type the user display name or email. Click OK.
6. Repeat for additional columns
   Return to the folder selection page and repeat step 5 for each column you want to default. Each column must be configured separately.
7. Test the configuration
   Upload a new document to the folder using the New button or Upload button. The metadata pane should show the default values. Save the document and verify the column values appear in the library view.

Common Mistakes to Avoid When Setting Default Metadata by Folder

Applying Defaults to the Wrong Folder

The Column Default Value Settings page lists all folders in the library. It is easy to select the wrong folder, especially when folders have similar names. After selecting a folder, the page shows the folder path at the top. Verify the path before setting values. If you apply defaults to the root folder instead of a subfolder, all new files in the library receive those values.

Assuming Subfolders Inherit Defaults

SharePoint does not propagate default metadata from a parent folder to its subfolders. If you set a default on Folder A, any subfolders inside Folder A do not automatically get the same default. You must manually configure defaults for each subfolder. This is the most frequent mistake. Users upload a file to a subfolder and expect the default from the parent folder, but the value is blank.

Using Unsupported Column Types

Lookup columns, managed metadata columns, and calculated columns cannot have folder-level defaults. If you try to set a default for these columns, the option is grayed out or missing from the list. Use a choice column or single line of text column instead. If you need a managed metadata default, consider using a content type default at the library level.

Conflicting Defaults Between Content Type and Folder

A library content type can have default values for its columns. When you also set a folder-level default for the same column, the folder default takes precedence for files uploaded to that folder. For files uploaded outside the folder, the content type default applies. This can cause inconsistent values if users upload files to different locations. Decide which default method to use and avoid mixing them for the same column.

Not Testing After Configuration

After setting defaults, upload a test file to the folder. Check that the metadata pane shows the correct values. Also upload a file to a different folder to confirm the defaults do not leak. If the default does not appear, verify the column is not hidden and that the folder path is correct. Restart the browser if the metadata pane does not refresh.

Overwriting Existing Metadata on Upload

Default metadata only pre-fills values for new files. If a user uploads a file that already has metadata (for example, from a synced folder with file properties), the existing values remain. The folder default does not overwrite them. Train users to clear existing metadata before upload if they want the folder default to apply.

Folder Defaults vs Content Type Defaults: Key Differences

Item	Folder Defaults	Content Type Defaults
Scope	Single folder in a library	Entire library or content type across multiple libraries
Column support	Limited to simple column types	Supports all column types including managed metadata
Inheritance	Does not apply to subfolders	Applies to all files of that content type everywhere in the library
Override behavior	Overrides content type default for that folder only	Overridden by folder defaults when both are set
Configuration location	Library settings > Column default value settings	Library settings > Content type > Column default values

Use folder defaults when you need different metadata for different projects or departments inside one library. Use content type defaults when you want consistent metadata across all files of a specific type, such as invoices or contracts. Avoid using both for the same column unless you fully understand the precedence rules.

Now you can set default metadata by folder in a SharePoint library without the common errors. Start by mapping which columns need defaults per folder. Configure each folder individually and test with a sample upload. For advanced scenarios, consider using Power Automate to set metadata based on folder path, which gives you more control over inheritance and conditional logic.