Check for duplicate entries with number value and lookup value

SharePoint Asked by Frank Bertucci on December 13, 2020

I have a sharepoint list that requires a user to input a part number (text field) and a vendor (lookup field) along with some other fields. I want to allow the user to enter duplicates of either the part number or vendor (so enforce unique values will not work), but not allow duplicates of the combination of the part number and vendor. In other words, I want to allow only one part number entry per vendor and alert the user if the part number has already been entered for that vendor. Is there a way to accomplish this with a validation rule or basic functionality?

One Answer

There is no OOB solution for this requirement, since you will need to compare the input twice in order and with an unknown collection from the column values. But there are several workarounds based on which version of SharePoint you are using.

For example, you can create Event Receiver (custom solution) if you are on SharePoint on-premises, or use InfoPath to build validation on field controls.

Here is a post for your reference: Validating between two columns to be unique.

If you are using SharePoint Online, you can use PowerApps to do the validation.

References: How to check duplicate item in list using powerapps. / Identifying Duplicate Entries.

Answered by Chelsea_MSFT on December 13, 2020

Add your own answers!

Related Questions

Can I change favicon without modifying the master page?

3  Asked on January 4, 2022 by default_noob_network


Add link to button in infopath

1  Asked on January 4, 2022 by j-choe


Get Page Field Values with javascript

2  Asked on January 2, 2022 by rothrock


I’ve sharepoint 2013 farm last updated June 2014

1  Asked on December 31, 2021 by ahmed-alsharkawy


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP