This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 76%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Hello,
I have to prevent duplicate values based on two columns. I've tried the code referenced here: https://www.codeproject.com/Tips/1205585/Unique-Entries-Based-on-Multiple-Columns-in-Sharep. However, it is not working. I'm using SharePoint Server 2016 on premise.
I'm aware there's a built in function (enforce unique values). However, this does not work with multiple columns.
Is there a way to prevent duplicate entries in SharePoint?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 5%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Hi @Michele DuBose ,
You can refer to following code to prevent duplicate entries in a SharePoint list
168859-test.txt
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @RaytheonXie_MSFT ,
I'd marked this answer as accepted but after running my code again, it does not work consistently. Please refer to my code: 187609-testcode.txt
In the console.log, I can see the records returned from my list. However, it also displays, 153 undefined undefined. I assume all records are not returning and therefore showing as undefined. As a result, if I enter data in my list, the record will still save even though it already exists. What's missing?
Hi @RaytheonXie_MSFT ,
I've used the example in this article: https://social.msdn.microsoft.com/Forums/office/en-US/bfd98455-0ece-4e53-838c-6558b825fddb/enforce-unique-values-for-3-columns-in-a-list-on-sharepoint-online?forum=sharepointdevelopment
It's working now.
Thanks.
Hi @Michele DuBose ,
Glad that you found the solution to this problem. Thanks for your sharing.
You could accept your answer via the "Accept Answer" button, it would be helpful to others who have similar issue in the future.
Hi @RaytheonXie_MSFT ,
I do not see the "Accept Answer" button under my comment.
Hi @Michele DuBose ,
Thanks for your time inadvance.
It seems there is some error in "Accept Answer". Since my answer also refer to the article you shared. The code is similar to the article. You can also accept my answer too.