Others

How to Set an Initial Filter Without Restricting Connected SharePoint Lists

WPS Content Manager Oct 9, 2026 869 views

Question details

The user needs to set a default initial filter on a SharePoint connected web part to show specific regional items (like United States holidays) on page load, while still allowing users to dynamically select items from other countries.

How to Set an Initial Filter Without Restricting Connected SharePoint Lists

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Configuring connected web parts on a SharePoint page to display a prioritized set of data initially while retaining access to the entire global dataset for later user selection.
Observed behavior: Currently, applying an out-of-the-box filter restricts the list entirely on page load, preventing users from selecting un-filtered items from the connected list. Alternate methods like showing individual item properties or requiring users to change views manually do not meet the workflow requirements.

Before you start

Note that SharePoint does not currently provide an out-of-the-box setting to apply a temporary initial filter on page load that preserves full connected-list functionality. You will need to rely on custom sorting adjustments or custom scripting.

Solution 1Recommended

Use a Custom Sort Order Field as a Workaround

Pin specific items to the top of the list view using a custom sorting column, ensuring prioritized data is immediately visible on load without restricting the overall dataset.

Since a strict filter permanently removes items from the selectable view, applying a forced sort order ensures your target items (e.g., United States holidays) appear first on the page.

Add a Sort Order Column

Navigate to your SharePoint list, click 'Add column', and choose the 'Number' or 'Choice' type. Name it 'SortOrder'.

Assign Priority Values

Edit your list items and assign the highest priority value (like 1 or 'A') to the items you want to appear first upon page load.

Configure the View Sorting

Click the column header of your new 'SortOrder' field and select 'Sort ascending'. This pins the prioritized items to the top.

Save as Default View

Click the view selector dropdown in the top right, select 'Save view as', and ensure this sorted view is set as the default view for the web part.

Use a Custom Sort Order Field as a Workaround

Ideal for Hidden Command Bars: This method is highly recommended if you have hidden the view command bar to simplify the user interface, as it requires zero manual view-switching from your users.

Solution 2

Implement a Custom Scripting or SPFx Solution

Develop a custom SharePoint Framework (SPFx) web part or script to dynamically filter the list on load and release the filter upon interaction.

Free Microsoft Office alternative

Enhance Your Productivity with WPS Office

While SharePoint connected lists often require complex custom development for dynamic data filtering, WPS Office provides a streamlined, lightweight, and highly capable alternative for managing your everyday datasets, spreadsheets, and document collaborations.

1. Download the Installer: Visit the official WPS Office website to download the free version suited for your operating system.
2. Install WPS Office: Run the setup file and follow the brief on-screen instructions to deploy the software in minutes.
3. Manage Your Data Seamlessly: Open your exported Microsoft Office data and use WPS Spreadsheets' built-in Data Filter tools to effortlessly manage and sort regional items.

Fully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formats.Robust data filtering and sorting tools natively built into WPS Spreadsheets.Free and lightweight suite that bypasses the heavy deployments of traditional Office environments.Familiar, intuitive user interface ensuring a seamless migration with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I set a default filter on a SharePoint list web part?

Yes, you can edit the web part to apply a static default filter. However, this restricts the entire underlying dataset. In a connected web part scenario, this prevents users from selecting and viewing items outside of that strict filtered view.

How do I hide the view command bar in a SharePoint list?

You can hide the command bar by editing the list web part properties and toggling off the command bar visibility, or by using JSON view formatting. This simplifies the page layout but removes the user's ability to easily switch between different views.

Is it possible to dynamically filter connected SharePoint web parts without code?

Out of the box, connected web parts natively filter data based on the active selection from the source web part. Applying conditional logic, such as an initial load filter that automatically clears upon user selection, requires custom SharePoint Framework (SPFx) development.

Office Quick Solutions