SharePoint 2016 column validation

amon 45 Reputation points
2024-11-18T05:53:34.1366667+00:00

I have a list in SharePoint server 2016 and there are several person and group columns. I want to make sure there are no duplicate users in these columns.

Any advice is appreciated.

Thanks.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,396 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ki-lianK-7341 585 Reputation points
    2024-11-18T08:26:01.9566667+00:00
    1. Go to List Settings:
      • Navigate to your SharePoint list.
      • Click on Settings (gear icon) > List Settings.
    2. Modify Column Settings:
      • Under the Columns section, click on the person or group column you want to enforce uniqueness on.
      • Scroll down to the Column Settings section.
    3. Enable Enforce Unique Values:
      • Check the box for Enforce unique values.
      • Click OK to save the changes.
    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.