Announcements
I created a dataverse table and my primary key column is WSrvrTaskID. It is a Autonumber column and i loaded some data initially in this table. However you can see the second screenshot when user added a new record to this table it duplicated the primary key value and started with 1000 which and there was already a record i loaded whose primary key value is 1000. What do i do to make sure it assigns the next number in the column and is unique.
Hi,
I can think of two possibilities to have duplicate number:
1. This field is editable and someone entered this value manually.
2. Someone updated the seed value
You can make this field read only to avoid data entry to this field and in the second case make sure limited user have permission to do the customization, you can export these records and correct them manually and reimport to fix this issue.
Hello, @rohitsbots, you have to make sure that the Column that holds the Primary Key value is set as Alternate Key.
Let me know is you need further instructions on how to set it up.
If my reply helped you, please give a 👍, And if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.
Visit my Blog: www.powerplatformplace.com
You should change the seed value to Max of existing ID + 1. The seed value of an autonumber column is the starting number.
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.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
