How to Show Different SharePoint List Views to Different Audiences
Question details
The user wants to display specific SharePoint list columns or views based on the audience or user group accessing the list.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Customizing data visibility for different teams or groups within a single SharePoint list.
- Observed behavior
- SharePoint audience targeting works for pages and web parts but does not natively hide specific columns in a single list view based on the audience.
Understand that audience targeting is a presentation feature, not a security feature. If your list columns contain highly sensitive data, you must use item-level permissions or separate lists instead of relying solely on targeting.
Use Web Part Audience Targeting with Filtered Views
Create tailored views for each group and display them on different pages or sections using web part audience targeting.
Since SharePoint does not allow column-level audience targeting within a single default list view, the best workaround is to create customized list views and use the List Web Part's audience targeting feature on modern SharePoint pages.
Go to your Microsoft 365 Admin Center or Entra ID and create distinct security groups for your different audiences (e.g., 'HR Team', 'Sales Team').
Navigate to your SharePoint list. Click the 'All Items' dropdown in the top right, select 'Save view as', and create a new view (e.g., 'Sales View'). Hide or show the specific columns you want this group to see.
Go to the SharePoint site page where you want to display the list. Click 'Edit', add a new 'List' web part, and select your list. In the web part properties, change the view to the specific view you just created (e.g., 'Sales View').
In the List web part properties pane, toggle 'Enable audience targeting' to On. Enter the specific Microsoft 365 or security group (e.g., 'Sales Team') in the audiences box. Publish the page.
Separate Sensitive Data into Different Lists
If strict security is required for certain columns, separate the data into multiple lists and use lookup columns or Power Automate to sync non-sensitive data.
Simplify Data Management and Collaboration with WPS Office
While configuring SharePoint list views and permissions can be complex and time-consuming, WPS Office offers a free, lightweight, and easy-to-use alternative for managing spreadsheet data and sharing documents. Enjoy a familiar interface and seamless migration without the hassle of complex enterprise setups.
- 1. Download and Install: Get WPS Office for free from the official website and easily install it on Windows, Mac, or Linux.
- 2. Manage Spreadsheet Data: Open WPS Spreadsheet to organize your list data with powerful filtering, sorting, and data validation tools.
- 3. Share Securely: Use built-in link sharing with customized permission settings to control exactly who can view or edit your data.
Frequently Asked Questions
Can I hide a specific column from certain users within a single SharePoint list view?
Not natively using default SharePoint permissions. SharePoint permissions operate at the list, folder, or item level, not the column level. To achieve strict column-level security, you typically need to use Power Apps to customize the form or separate the data into different lists.
Is SharePoint audience targeting a security feature?
No. Audience targeting is strictly a navigation and presentation feature designed to show relevant content to users and reduce clutter. Users who are not in the targeted audience can still access the data if they have the direct link or navigate to the backend list.
How do I turn on audience targeting for a SharePoint list?
Navigate to the list, click the gear icon to access 'List settings', click on 'Audience targeting settings', check the box for 'Enable audience targeting', and click OK. This adds an 'Audience' column to your list where you can specify groups for individual items.
What types of groups can be used for SharePoint audience targeting?
You can use Microsoft 365 groups, Entra ID (formerly Azure AD) security groups, and Microsoft Entra dynamic groups. SharePoint groups cannot be directly used for modern audience targeting.
