How to exclude certain users from column permission in SharePoint | Column/View Permission - BoostSolutions App, Saas & Software for Microsoft 365, Microsoft Teams, SharePoint

How to exclude specific users from column permission in SharePoint?

When using Column/View Permission to set column permission for users, SharePoint groups, or Active Directory groups or users represented by Person or Group fields (such as Created By, Modified By and Assign To) or anonymous users. You may want to exclude specific users from users/groups when configure permission settings.

Column/View Permission provides an easy way to implement it, in this article we will introduce how to achieve this.

WHAT YOU'LL GET

Exclude user Joseph Geisman from column permission settings

The exclude user Joseph Geisman can access the hidden column Monthly Salary in new/edit/view item form while others can not

WHAT YOU'LL NEED

Column/View Permission

The sample data we use for this case

Create a list named as Staff Info from the custom list template with the following columns and staff information on a SharePoint site.

Exclude specific users from column permissions in SharePoint

Download the trial version of Column/View Permission, and install it to your SharePoint server.
Navigate to the Staff List prepared above, click List, then click Column/View Permission in Settings group, and then click Manage Column Permission.
In the Column Permission Settings page, click Add Permission Part to create a new permission part (we call a permission configuration as a permission part), specify a unique name for it.
In Include Users section, select All Users in the Select Users part as following, which means that the new created column permission settings will work for all users in the current site collection.
In Exclude Users section, input user Joseph Geisman in the Select Users/Groups part as following.
In Permission Settings section, click Add Column Permission button.

When Add Column Permission dialog appears, set Monthly Salary as Hidden in the “New Item Form”, “Edit Item Form” and “View Item Form” as following.

The settings we configured above makes users we selected in Include Users section (All users in the current site collection) can’t access the column Monthly Salary whenever they create a new item, or view/edit the existing items in the list. The Monthly Salary column will be hidden from them no matter what. But the column settings will not be applied to users in Exclude Users section (Joseph Geisman).

In the Add Column Permission dialog, click OK to save the column permission settings.
Then, click OK to save all settings for the permission part.
Log in to SharePoint as user Mark Iverson, and navigate to the Staff Info list.

First, Mark Iverson cannot see the Monthly Salary column in the list view for sure as following.

Then, the Monthly Salary column will be hidden when Mark Iverson tries to create a new item in the list either as following.

When Mark Iverson tries to edit any existing item in the list, such as the first item 101, the Monthly Salary column will be hidden from him either as following.
Log in to SharePoint as user Joseph Geisman, and navigate to the Staff Info list.

Because Joseph Geisman is excluded from the column permission settings, the Monthly Salary column will be visible to him when he views/edits/creates an item.

First, Joseph Geisman can see the Monthly Salary column in the list view as following.

When Joseph Geisman tries to create a new item, the Monthly Salary column is visible to him also as following.

When Joseph Geisman tries to edit an existing item in the list, such as the item 101, the Monthly Salary column is also visible to him as following.