Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Purpose of AutoNumber field

(0) ShareShare
ReportReport
Posted on by 51

What is the purpose of the  AutoNumber primary name field?  Since is not guaranteed to be unique, why else would you want to use it?

Categories:
  • FerrDiBarnes Profile Picture
    51 on at
    Re: Purpose of AutoNumber field

    I appreciate the workaround, but really my question is why is there a duplicating autonumber feature in the first place.  When would you want that?    I guess that is just a sub question to the main question:    What is the purpose of the primary name field, other than "the field you think is unique but if not no harm since all the joins are on the GUID, except there will be harm because you will end up with duplicate records with different GUIDS when importing records unless you have created alternate keys on the columns you thought were unique".

  • Shawn11 Profile Picture
    152 on at
    Re: Purpose of AutoNumber field

    Hello @FerrDiBarnes 

    Please refer https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Autonumber-isn-t-unique/td-p/1744606 

     

    Hope this was helpful 

  • Verified answer
    a33ik Profile Picture
    3,304 Most Valuable Professional on at
    Re: Purpose of AutoNumber field

    Hello,

    There are a few techniques to guarantee the uniqueness of that field:

    1. You can create an alternate key on top of your autonumber field so if the value is repeated - the record just won't be created and a user will see an error. Maintenance of such schema is complicated if you're dealing with dataimports and the field is pre-set externally that would override the autonumber value or allow the manual editing of that field.
    2. You can add the randomly generated postfix to the autonumber format and it'll with quite high probability gives you the unique value - https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/create-auto-number-attributes?view=op-9-1#autonumberformat-options
  • FerrDiBarnes Profile Picture
    51 on at
    Re: Purpose of AutoNumber field

    How do you make it read only?   The field does not appear on any form.

  • Shawn11 Profile Picture
    152 on at
    Re: Purpose of AutoNumber field

    Hi @FerrDiBarnes  if you make the field read- only then it can be unique right.

     

    Hope this was helpful 

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.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics