cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Veronica
Resolver I
Resolver I

Problem of dupliation a secuential number

Hi everyone:

 

I've been developing an app that creates a secuential number depending on the region-year-casetype-seqnum for example Car2019Ley121-002.  This sequential number is form in the text property of the label and is store at the Submit buttom.  The problem is that, at testing, I had duplicity of the same number under the same conditions. If two employees under the same conditions (same region, same case type,etc ) consult the next number to be, it could happen that at the time to save the info, they have assign the same number in the sequence.  Can I lock the SQL table before the submition to avoid duplicity?  I need to assign a temporary number before writing at the SQL table?

 

Any help I will appreciate.

 

veronica

7 REPLIES 7
Mr-Dang-MSFT
Power Apps
Power Apps

@Veronica,

Edit:

I'd look into primary keys and composite keys as they are unique.

 

+ SQL experts @KroonOfficeSol , @DavesTechTips @seadude 

I change my primary key but also I think the problem is that the sequential number is built in the text property when I invoke the form.  The user consult the next number but is not until the summit buttom that the number is written in the table.  In that period of time when the user is filling the others fields another user could consult and asign the same sequential number.  Thats why I was asking if I could lock the table or asign a temporary number.

ericonline
Community Champion
Community Champion

Hi @Veronica ,

I think you've found a common problem that most databases have. There are only a few ways of ensuring duplicate values aren't set when two users create records at the same time. This is usually something delegated to the database to handle using:

primaryKeyColumnName INT IDENTITY(1,1) NOT NULL PRIMARY KEY

Here are the docs on `IDENTITY` 

Hope this helps!

And why not as a bonus add this wonderful post on Stack Overflow by @CarlosFigueira and that goofball @seadude 🙂 in case you want to:

  • Take the Primary Key from one table's Patch statement
  • Use it as the Foreign Key of another table's Patch statement

$10k code right there!

Thanks a lot for your help.  I will check the info and I will let you know...

Anonymous
Not applicable

Hi, 

I think if I understood you correctly you want to store in the table the primary key you generate from the app and you don't want it to duplicated. Is that corrected ? 

 

If so, you may possiblely patch the table whenever first user starts to use one number ( may be write the patch in a control select etc) with a status and then delete it if the user is not completing the rest of the fields. 

 

By this any user logs in to use the same number will find it with the status "in progress" and can't use it again. 

 

Hope this helps. 

 

Thanks, 

Deb

I am tring another approch, to recalculate the sequential number just before saving by hiding the save button.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,110)