SharePoint Document Issues

How to Create a SharePoint View for Specific Metadata Across Subfolders

Adam DavisAdam Davis Nov 2, 2026 869 views

Question details

The user wants to aggregate and display files containing a specific metadata value (e.g., 'Pending') across an entire SharePoint document library, including files nested within multiple subfolders, using a single view or page.

How to Create a SharePoint View for Specific Metadata Across Subfolders
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Tracking file statuses and organizing documents via custom metadata in a library with a deep folder hierarchy.
Observed behavior
Standard SharePoint folder views isolate files, preventing users from seeing all files matching a specific metadata status simultaneously unless they click through every individual folder.
Before you start

Ensure you have 'Edit', 'Design', or 'Full Control' permissions for the SharePoint document library to create public views or modify site pages.

Solution 1Recommended

Create a Flat View to Show Items Without Folders

Modify your document library view settings to ignore the folder structure, allowing you to filter and display all files in a single, flat list.

While standard default views keep files hidden inside their respective folders, SharePoint includes a 'Show all items without folders' feature. By combining this setting with a metadata filter, you can successfully aggregate all matching files across the entire library.

1
Access Library Settings

Navigate to your SharePoint document library, click the gear icon (Settings) in the top right corner, and select 'Library settings'. Then click on 'More library settings'.

2
Create or Modify a View

Scroll to the bottom of the settings page to the 'Views' section. Click 'Create view' to start fresh, or click an existing view name to edit it.

3
Apply the Metadata Filter

Scroll down to the 'Filter' section. Select 'Show items only when the following is true'. Set the column to your specific metadata field (e.g., 'Status'), choose 'is equal to', and type your value (e.g., 'Pending').

4
Disable Folder Navigation

Scroll down further to the 'Folders' section. Click the plus icon to expand it, and select the radio button for 'Show all items without folders'.

5
Save the View

Click 'OK' at the top or bottom of the page to save. Your view will now display all files marked as 'Pending', ignoring where they are stored in the folder hierarchy.

Create a Flat View to Show Items Without Folders
View Visibility: If you created this as a 'Public View', anyone with access to the library can select it from the views dropdown menu.
Free Microsoft Office alternative

Boost Document Productivity with WPS Office

While SharePoint handles your team's file storage and metadata, you need a reliable suite to create and edit the documents themselves. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, ensuring your Word, Excel, and PowerPoint files open flawlessly on any platform.

  1. 1. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer file and follow the simple on-screen instructions to complete the setup process.
  3. 3. Edit Your Documents: Download your files from SharePoint and open them directly in WPS Office to begin editing with full format compatibility.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) stored in SharePoint.Lightweight application that runs smoothly on Windows, Mac, and Linux systems.Seamlessly open, edit, and save documents downloaded from your SharePoint libraries.Free to use with a familiar, easy-to-navigate tabbed interface, requiring zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my standard SharePoint view only show files in the root folder?

By default, SharePoint views are configured to display items within their folder hierarchy. To see items nested inside subfolders on the main view, you must modify the view settings under the 'Folders' section and select 'Show all items without folders'.

Can I filter a SharePoint view by multiple metadata values at once?

Yes. In the view settings under the 'Filter' section, you can add multiple conditions using 'And' / 'Or' operators. For example, you can filter for files where 'Status' is equal to 'Pending' AND 'Department' is equal to 'HR'.

Do I need special permissions to create a flat view in SharePoint?

Yes, you typically need 'Edit', 'Design', or 'Full Control' permission levels to create or modify public views in a SharePoint document library. Users with only 'Read' access are restricted to creating personal views that only they can see.

Will editing files offline in desktop software erase SharePoint metadata?

No, editing the document contents using desktop software like WPS Office and uploading the files back to SharePoint will not erase your custom metadata, provided the library columns are configured to retain existing values upon file updates.