How to Filter SharePoint Online Lists by the Current User's Department
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.

- 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.
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.
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.
In SharePoint Online, open the target list and select Integrate > Power Apps > Create an app.
In Power Apps Studio, select the browse gallery, open the Items property, and enter: Filter([YourListName], Department = Office365Users.MyProfile().Department).
Select Save and Publish, then edit a modern SharePoint page and add the Power Apps web part to surface the filtered list.

Use audience targeting for manual department-based filtering
Use this approach when you can assign audience values to list items manually or with Microsoft 365 groups.
Build an advanced SPFx or Power Automate solution for profile-based filtering
Choose this option when you need full control, tenant-wide reuse, or automated permissions based on user profile fields.
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.

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.




