Power Apps - Microsoft Dataverse

Unanswered

Using autonumbers as a primary key

Like (0) Share

Report

Posted on 19 Oct 2021 14:55:49 by julijazas

820

I am designing a database in dataverse

is it recomended to use unique ID of each record in each table as autonumber?

Simple example:

Customers table has these culums

Customer name

Customer code

Country

City

Adress line 1

Adress line 2

etc...

Shal i use in these type of tables additional column ID and set it as primary and autonumber?

Or i shall use columns ID as autonumber when i can not guarantee if at least one of the columns will always have unique value? entered by the user?

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (4)

Answers (0)

julijazas 820 on 20 Oct 2021 at 08:32:27

Like (0)

Report

Re: Using autonumbers as a primary key

Hi @rampprakash but if a user will lookup according this primary key(i understand i can add some more fields in Quick find view) final result when user click will return anything what is defined in primary name key.
I can not return the field that i want from lookup table - it only returns to lookup field primary name key

Was this reply helpful? Yes No
Ram Prakash 5,450 Super User 2025 Season 2 on 20 Oct 2021 at 06:50:41

Like (0)

Report

Re: Using autonumbers as a primary key

Hello @jja,

Consider a scinario, you have Account Table available for this Account Table ACCOUNTID is a PrimarKey(GUID) and it will be Unique, but if we provide GUID field to user its hard to remember.

As per your Query try Creating One Autonumber field and make the Field Searchable, that will work.

For Field Searchable --> Go to Settings --> Customization --> Customize the system --> Entites --> Expand Entities --> Expand the Entity where you want to make the changes --> Click Views --> Click Quick Find View --> Click FIND Columns --> Add the Field

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
julijazas 820 on 20 Oct 2021 at 05:37:23

Like (0)

Report

Re: Using autonumbers as a primary key

Thakns but it makes me confused then what is prinamy name key in dataverse table? Lets say i have table component name and project reference which is a lookup tonorher table and i need to haveprimary name column. In my scenario component name will not be unique as different projects can have same component names. If i set component name as a primary name key i understand it will be unique and will not allow to enter same component name? If yes then what is the primary name key in this table?

Was this reply helpful? Yes No
Fubar 8,186 Super User 2025 Season 2 on 19 Oct 2021 at 22:08:41

Like (0)

Report

Re: Using autonumbers as a primary key

By default your DataVerse table has a Primary Key - the internal GUID that is created when each new record is created (this field is generally not visible in the user interface but is the the table name with a suffix of "id" - this internal GUID is what links tables via Lookup fields (one-to-many) and many-to-many relationships. If you want another field to act like a Primary field you would need to setup an Alternate Key (but the GUID will still be used for the relationships)

Was this reply helpful? Yes No

Community site session details

Using autonumbers as a primary key

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Tom Macfarlan – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

Community site session details

Using autonumbers as a primary key

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Tom Macfarlan – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Apps

Featured topics

Product updates