Dynamics Community Forum Thread Details

Dataverse AUTO GUID ID

So hello,

I am pretty new in the Power Platform concepts and I am trying to figure things out.

More precisely, talking about Dataverse. From what I have seen, I get that when we are creating

a new table automatically, in the background system is creating a column, lets suppose it is named ID

and it is GUID data type, but it is not visible for us. This is the primary key for each record.

Also, there is the primary column, in order to achieve a more user-friendly approach. Could we

say that it is a /fake/ primary key.

My question is I do not know how to retrieve this GUID when I want it. Also, I have not understand fully the concept

of alternate keys even if I have read pretty much almost every document, maybe tmi in a few days :). Also,

how I can create a custom GUID field, because autonumber data type has an upper limit.

Thanks

Hi Partner,

Yes.
In Dataverse, the GUID column is created automatically, it is the same as the table name but with an id suffix, for example, the GUID column for the account table is accountid.
We can't add this column directly to the form or view, it's by-design.

1. how to retrieve this GUID when I want it

1)In Power apps, we can add fields with the same name as the table:

2)You can get it form the record url: "id=<guid here>" parameter

3)From a List View, you can export to Excel. The GUID is held in Column A.

4)Web API

https://orgname.crm.dynamics.com/api/data/v9.2/accounts?$select=accountid,name

2.how I can create a custom GUID field, because autonumber data type has an upper limit.

The GUID column's type is 'Unique identifier', we can't create custom column with this type.

But you can create one custom text column, then copy GUID value to this custom column.

https://www.youtube.com/watch?v=8HS5Q5TX6CA

3.Primary column, alternate keys:

https://www.hellosmart.ca/2023/09/understanding-primary-key-alternate.html

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Quick Links

Leaderboard