
Announcements
I have a New Record Screen associated with a SharePoint List, which is in use by many different users. There is an issue where 2 or more users may submit a new record in a similar timeframe - and associated ID's are becoming duplicated. How can I apply a data integrity rule, to ensure that no 2 records contain the same unique ID, when users Commit / Submit a New Record?
At the moment, I have a variable which is invoked directly prior to submission, which gets a MAX + 1 of the current unique ID - but still I am seeing duplicates in the process and it's exceptionally frustrating!
Thanks!
Hi, click the SharePoint list settings, click on the column that you would like unique values for, then select Enforce unique values => yes.
If an ID already exists the user will get an error, then you can handle the error using IfError()