Answered

Autonumber column for existing records

(0) Share

Report

Posted on by rrslaven

I have created an autonumber column through Power Apps for a table (Leads) that has existing records. How can I update a set of existing records (either all or created on or after X date) with an autonumber?

If it is not possible to automate this and I did an update with an export/import from excel, does it matter if the numbers are within the range of the seed value (500000)? I would like them to be unique.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/autonumber-fields

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @rrslaven,

Auto-Number Column will set the value when a new record is created. You can Delete existing records and reload them and that will create the Auto-Number values starting from your Seed value.

Auto-Number Columns will never allow duplicates.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (3)

Report

Hi @rrslaven ,

I would export the records to Excel and set the values of the existing records and set the seed value to 1 higher than these values otherwise you will get duplicates because the process just increases the value, it will not check if that number is already in use.

Was this reply helpful? Yes No
DE-23081130-0 105 on at

Like (0)

Report

Hi @rrslaven maybe you can try with a Power Automate flow that takes the rows with null autonumber column and update this row with the same autonumber schema but out of the actual rows range. Does it make sense for you?
Cheers!
Diego.

1 people found this reply helpful.

Was this reply helpful? Yes No
Gowri Halan 262 on at

Like (0)

Report

@rrslaven Try below approach.
1. Just export all the leads where auto number column is null.
2. after you export delete all these records from Dataverse
3. Now import these back again. I think automatically auto number would be applied to these records from 1 incremented from already existing record(for example if you already have a record with number 5000020) then for these imported record it will start from 5000021).

I haven't tried it but it should work since auto number will be automatically created whenever record is created in Dataverse.

Was this reply helpful? Yes No
candide on at

Like (0)

Report

@AhmedSalih wrote:
Hello, @rrslaven,

Auto-Number Columns will never allow duplicates.
as written by dpoggemann in the post above that's wrong as I run into this issue with my dataverse table.
I got same ID which is Autonumber when entering via canvas form.
So be aware as in Dataverse an Autonumber column does not behave like all the long-year existing RDBMS out there.😀

Was this reply helpful? Yes No