Forum Discussion
Help: Highlighting if incorrect value pair in two columns is entered
Hello, I am very new to power automate, and having some issues to get my head around a problem with conditional formatting or some sort of highlighting a certain condition in my SharePoint list. May...
Hi Ma_Heu, As I understand, you would like to have unique pairs between process ID and product ID. I’m not sure how far you are with the development of the list, but maybe you can create a new list with just the process ID and product ID pairs and enforce unique values on the process ID column. Then, you can use values from the newly created list in your list as a lookup column. This way, you can avoid problems with inconsistencies.
If that solution does not help then i will check the possibilities with Power Automate, but I can do on Sunday.
