Answered

Updated auto number field on existing records, however new records ignore the auto number cadence

(0) Share

Report

Posted on by Juhoon_P

I have a custom ID field on Contact table as the attached screenshot.

I used Power Automate to set ID to some of the existing contacts (circled in blue). As a test, I created a new contact in the red circle. The issue is that the new contact(s) do not respect the existing auto number values and cadence. Because I have manually set the IDs in blue through Power Automate in the same format, I expected the one in red to be "C00016" instead of "C00001." The ID is an auto number type field with the expression to set it such as "Cxxxxx" with the number increment by 1.

Anyone has ideas why the new contact does not follow the auto number format based on the existing records?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

@Juhoon_P, Make sure you create an Alternate Key and assign it to your ID Column. Before you do that, remove any duplicates data from the column.

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com

Was this reply helpful? Yes No
Juhoon_P 11 on at

Like (0)

Report

Thanks @AhmedSalih Unfortunately, then the system prevents entry of a record entirely with an alternate key now.
It is strange to me that the insert action does not respect the existing autonumber values.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@Juhoon_P, are you entering the data manually to the ID column? Also, what is the seed value for your autonumber format?

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,678 Moderator on at

Like (1)

Report

@Juhoon_P, also remember that autonumber columns do not reset when records are deleted. So for example if you have autonumber values from 1 to 10, and you deleted all the records, when you start inserting values again, it will start from 11.

Was this reply helpful? Yes No
Juhoon_P 11 on at

Like (0)

Report

@AhmedSalih Yes I have set the values on existing records using Power Automate, but I guess it makes no difference between setting it manually. The seed value is C00001.

The issue is that the system ignores the current autonumbering sequence that was set through Power Automate as seen in the attachment, and a new contact is appended with one of the existing auto number values.

If the number started from 11 in your example, this issue won't be an issue because that is the behaviour I expected.

Perhaps, Microsoft stores those values somewhere in the backend and setting autonumber manually/workflow/flow does not get to set that value into the server side?

Was this reply helpful? Yes No
Juhoon_P 11 on at

Like (1)

Report

@AhmedSalih Nevermind. Autonumber isn't that "smart." I had thought that the autonumber field would look at the existing table and insert the next number. What you said make sense about it only looks at seed value.

I am going to set the autonumber manually on all existing records, and set the seed value of autonumber ID field to be greater than the last manual ID number.

Thanks for your help!

Was this reply helpful? Yes No