web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Force Data Integrity o...
Power Apps
Unanswered

Force Data Integrity on Submit of a New Record to a SharePoint List

(0) ShareShare
ReportReport
Posted on by 311

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!

Categories:
I have the same question (0)
  • Verified answer
    C-Papa Profile Picture
    1,836 on at

    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()

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard