Answered

Add serial autonumber even after existing record is deleted

(0) Share

Report

Posted on by Community Power Pla...

I have an entity "Questions" in which there is an S.no Column. I used the auto number attribute to assign a value to the S.no column in this format: "QNo" + number with seed value 1000. I have 14 questions in the table(the 14th column has a value QNo1013). After creating a question in the form and deleting it, when I'm trying to create a new question I am getting a value of QNo1015 instead of QNo1014. Is there any way to retain the order of the column values in the auto number variable?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Autonumber its following a cardinal rule that a primary key is not reused once it is deleted. It makes sense when the key is used to connect to another table to establish a relationship. That being said, there are ways to fill in missing numbers using Sequence() or First(Sort(datasource, number, Descending)).number+1

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks a lot @Drrickryp !!

Was this reply helpful? Yes No