How to Create a SharePoint View for Specific Metadata Across Subfolders
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.

- 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.
Ensure you have 'Edit', 'Design', or 'Full Control' permissions for the SharePoint document library to create public views or modify site pages.
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.
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'.
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.
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').
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'.
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.

Use Document Library Web Parts on a Site Page
If you must maintain visual separation between folders but still want to surface specific files, add separate Document Library web parts to a custom page.
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. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button for your operating system.
- 2. Install WPS Office: Run the downloaded installer file and follow the simple on-screen instructions to complete the setup process.
- 3. Edit Your Documents: Download your files from SharePoint and open them directly in WPS Office to begin editing with full format compatibility.

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.




