So I know there are unique entry options for individual columns but I wanted to know if there is a way to enforce Unique items? Looking below at the photo I provided. If rather enforcing say the multiples of a single column like column one's RX01121 I wanted to enforce the uniqueness of the first row as a whole. So The row with that contains

RX01121 | 6192 | 0010 | AR205610

Doesn't appear multiple times. For example is we have:

RX01121 | 6192 | 0010 | AR205610

This would fail to be added to this list because a copy of it already exists on the list. However if you replaced 6192 with 6191 that would be added to the list and would be counted as its own unique row.

enter image description here

1 Answer 1


I think that here you have the two only solutions for having several columns as unique in a SharePoint list,

  • client-side scripting or
  • event receiver when adding and modifying.

Apart from that, there is no out-of-the-box solution to reach that functionality.

Here you have the article with the specifications for it. Anyway, I also found another similar or exact question as to the one you have with the correct answer, link.

  • So in the first column mark Unique values as true?
    – Rob
    Commented Jun 18, 2019 at 18:54
  • Yes, that's the point. Try it and let me know.
    – jaloplo
    Commented Jun 18, 2019 at 18:57
  • "This field contains duplicate values. Remove all duplicate values and try the operation again." Is what I get without removing any entries.
    – Rob
    Commented Jun 18, 2019 at 19:00
  • So you have to change the values for those rows in order to have unique values on each row. Then, try to set the property to true again.
    – jaloplo
    Commented Jun 18, 2019 at 19:02
  • Alright I did that but now I can't upload anything that would share the same 1st column which many items of the data all share
    – Rob
    Commented Jun 18, 2019 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.