SharePoint Document Issues

How to Filter SharePoint Online Lists by the Current User's Department

John WilsonJohn Wilson Nov 13, 2026 869 views

Question details

The user needs to filter SharePoint Online list items by the current user's profile department on a modern SharePoint site because the classic Current User Filter web part is unavailable.

How to Filter SharePoint Online Lists by the Current User's Department
Product
Microsoft SharePoint Online
Device & OS
not provided
Scenario
A SharePoint site owner or list manager wants the list to display only items that match the signed-in user's department or location.
Observed behavior
The classic Current User Filter web part is not available in the modern SharePoint web part gallery, so no standard web part can dynamically filter list items by user profile fields.
Before you start

Confirm whether the site is a modern SharePoint site and identify the user profile field to filter by, such as Department or Location. Verify that users have values populated for that field in Microsoft 365 profile settings.

Solution 1Recommended

Filter list items by the current user's department with Power Apps

Use this no-code Power Apps method when you need the list to dynamically evaluate the signed-in user's Microsoft 365 profile.

Power Apps can read the current user's profile with Office365Users and apply the filter directly to a SharePoint list gallery, which replaces the classic Current User Filter behavior without switching to classic mode.

1
Open Power Apps from the SharePoint list

In SharePoint Online, open the target list and select Integrate > Power Apps > Create an app.

2
Set the gallery filter formula

In Power Apps Studio, select the browse gallery, open the Items property, and enter: Filter([YourListName], Department = Office365Users.MyProfile().Department).

3
Publish the app and add it to a page

Select Save and Publish, then edit a modern SharePoint page and add the Power Apps web part to surface the filtered list.

Filter list items by the current user's department with Power Apps
Dynamic filter restored: The list will now filter by the signed-in user's department after the app loads, without requiring the classic Current User Filter web part.
Free Microsoft Office alternative

Use WPS Office as a Free Microsoft Office Alternative

When SharePoint Online list filtering is handled by Microsoft 365 configuration, WPS Office provides a free, lightweight Office suite with strong Microsoft Office format compatibility, a familiar ribbon interface, and seamless document migration.

Works with Word, Excel, and PowerPoint files without changing Microsoft Office formats.Free and lightweight Office suite for everyday document editing.Familiar ribbon UI reduces the learning curve when moving from Microsoft Office.Lets you continue editing documents even while SharePoint list filtering remains in Microsoft 365.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the Current User Filter web part missing on my modern SharePoint site?

Modern SharePoint sites do not include the classic Current User Filter web part. Use audience targeting, Power Apps, Power Automate, or a custom SPFx solution instead.

Can I switch a Teams-created SharePoint site to classic view to get the Current User Filter web part?

No. Sites created from a Microsoft Teams channel stay in the modern experience. You need an alternative such as a Power Apps form or SPFx web part.

How do I filter a SharePoint list by the signed-in user's department without code?

Use Power Apps. Open the list, select Integrate > Power Apps > Create an app, and set the Items formula to Filter([YourListName], Department = Office365Users.MyProfile().Department).

What is the difference between audience targeting and the Current User Filter web part?

Audience targeting shows or hides items based on Microsoft 365 groups or manually selected audience values. The classic Current User Filter web part reads profile properties like Department automatically.

Does WPS Office include a SharePoint Current User Filter web part?

No, WPS Office is an Office suite for documents and does not provide SharePoint web parts. Use Microsoft 365 configuration for SharePoint list filtering.