Prevent repeat entries in SharePoint list
In a column on my SharePoint list, the entries must either be equal to a specific value, or unique from every item in the list. For example, when a user adds a value in this column, it must either be "****" or a four digit number that is unique from all other numbers in that column. A valid list would be: 0001 0002 **** 0004 **** 0005 I want to make sure that any values in this column are either exactly "****" or unique from any other number value, but I can not do this with the existing enforce unique values option as this would not allow for any repeats of "****". Is there a way to do this with Power Automate and have it present an error message for any number repeats?