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?
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
2 Asked on January 6, 2022
1 Asked on January 6, 2022
1 Asked on January 6, 2022 by jes516
1 Asked on January 6, 2022 by ah-jamali
1 Asked on January 4, 2022
3 Asked on January 4, 2022 by default_noob_network
1 Asked on January 4, 2022 by j-choe
2 Asked on January 2, 2022 by rothrock
1 Asked on January 2, 2022 by drvr
1 Asked on January 2, 2022 by scott-davis
3 Asked on January 2, 2022 by lieptas
column formatting date time json formatting modern experience sharepoint online
1 Asked on December 31, 2021
development office 365 sandbox solution sharepoint online site logo
1 Asked on December 31, 2021 by okmqaz135
2 Asked on December 31, 2021 by kandace
2 Asked on December 31, 2021 by namwar-rizvi
microsoft teams modern team site pnp powershell rest sharepoint online
3 Asked on December 31, 2021
1 Asked on December 31, 2021 by ahmed-alsharkawy
1 Asked on December 31, 2021 by zombeezsp
calculated column calculated column formula date time modern experience sharepoint online
Get help from others!
Recent Answers
© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP