Check for duplicate entries with number value and lookup value

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?

SharePoint Asked by Frank Bertucci on December 13, 2020

1 Answers

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

Email a daily calendar summary to a Outlook Group

0  Asked on August 9, 2020 by david-boddie


SharePoint 2016 user profile service issue

2  Asked on August 6, 2020 by eric-vanroy


How to create a public facing website?

2  Asked on July 31, 2020 by keshav-taurah


Sharepoint designer workflow copy

2  Asked on July 30, 2020 by roxette


Ask a Question

Get help from others!

© 2022 All rights reserved.