You’re offline. This is a read only version of the page.
3
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
@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.😀
@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.
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.
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.
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
|
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
