Announcements
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
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
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.
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.
@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.
@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.😀
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 493 Most Valuable Professional
11manish 479
Haque 328
