Create a Compliance Review View in SharePoint: Practical Checklist for SharePoint Owners

SharePoint site owners often need a quick way to review all documents for compliance without scrolling through every folder. A compliance review view filters content by metadata like approval status, expiration date, or sensitive content type. This article explains how to build a custom view in SharePoint that shows only items requiring review. You will learn the exact steps to create, configure, and share this view with your compliance team.

What a Compliance Review View Does and What You Need Before Creating It

A compliance review view is a filtered view of a SharePoint document library or list. It shows only items that meet specific criteria related to compliance, such as documents that are pending approval, have an upcoming expiration date, or are tagged with a specific retention label. This view helps site owners and compliance officers quickly identify content that needs review without manually browsing every folder.

Before you create the view, you need the following:

• Site owner or member permissions: You must have at least Contribute permissions to create views in a library.
• Compliance metadata columns: The library must contain columns that store compliance information. Common columns include Approval Status, Expiration Date, Compliance Tag, or Reviewer. If these columns do not exist, add them before creating the view.
• Content already tagged or filled in: The view filters rely on data in those columns. If no items have values, the view will appear empty. Populate the metadata first or plan to train users to fill in the fields.

Steps to Create a Compliance Review View in SharePoint

1. Open the document library
   Navigate to the SharePoint site and open the document library or list where you want the compliance review view. Click the library name in the quick launch or go to Site contents and select the library.
2. Access the view creation menu
   Click the drop-down arrow next to the current view name at the top right of the library. The view name is usually “All Documents” or “All Items.” Select Create new view from the menu.
3. Choose a view type
   In the Create View page, select Standard view as the view type. Standard views are the most flexible for filtering and sorting. Give the view a name such as “Compliance Review” or “Pending Approval.”
4. Set the view audience
   Under Audience, select Create a personal view if only you need it, or Create a public view if the compliance team should see it. Public views are visible to all users with access to the library.
5. Add filter criteria
   Scroll to the Filter section. Select Show items only when the following is true. Click Add a filter. Choose a compliance column from the first drop-down, such as “Approval Status.” In the next drop-down, select the condition like “is equal to.” In the value box, type or select “Pending.” Click Add a filter again to add another condition, such as “Expiration Date” “is less than” “[Today]+30” to show items expiring within 30 days.
6. Configure columns to display
   In the Columns section, select the checkboxes for columns you want to show in the view. Include at least the compliance columns you filtered on, plus Title, Modified By, and Modified Date. Uncheck columns that are not relevant to the review.
7. Set sort order
   Under Sort, choose a primary sort column such as “Approval Status” or “Expiration Date.” Select ascending or descending order. This makes the most urgent items appear at the top.
8. Save and test the view
   Click OK at the bottom of the page. The library reloads with the new view applied. Check that only the expected items appear. If the view shows too many or too few items, edit the view and adjust the filters.

Common Mistakes and Limitations When Creating a Compliance Review View

Filters return no items or too many items

The most common mistake is using the wrong condition. For example, using “contains” instead of “equals” may return items with partial matches. Also, if no items have the metadata value you filtered on, the view will be empty. Verify that at least a few documents have the required column values before creating the view. To fix this, edit the view and change the filter condition or value.

Public view does not appear for other users

If you created a public view but other users cannot see it, check that you saved the view as public. Also, users need at least Read permissions to see public views. If the view still does not appear, instruct users to refresh the page or clear their browser cache. In rare cases, SharePoint may take a few minutes to propagate a new public view.

Cannot filter on a metadata column that is missing

The view filter drop-down only shows columns that exist in the library. If you need a compliance column like “Retention Label” or “Review Date,” add it to the library first. Go to Library settings > Add a column, choose the column type, and name it. After adding the column, populate existing items with values before creating the view.

View does not update when new items are added

The view filters dynamically. When a new item is added that meets the filter criteria, it appears automatically. If it does not, the item likely lacks the correct metadata. Train users to fill in compliance columns when uploading documents. Alternatively, use Power Automate to set default metadata values based on conditions.

Standard View vs Compliance Review View: Key Differences

Item	Standard View (All Documents)	Compliance Review View
Purpose	Show all items in the library	Show only items needing compliance review
Filters	None or basic	Multiple conditions on compliance columns
Columns displayed	Default columns (Title, Name, Modified)	Custom columns including Approval Status, Expiration Date, Reviewer
Sort order	By name or date modified	By priority: expiration date or approval status
Audience	All users	Compliance team or specific reviewers
Default visibility	Usually the default view	Set as default for compliance team or used as a secondary view

You can now create a compliance review view in SharePoint that filters documents by approval status, expiration date, or other metadata. Test the view with a small set of documents first, then share it with your compliance team by setting it as the default view for their group. For advanced compliance workflows, consider using Microsoft Purview retention labels and Power Automate to automatically flag documents for review.