web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Dataverse AUTO GUID ID

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Dataverse AUTO GUID ID

(0) Share

Report

Report

Posted on by KC-11031355-0

2

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Dataverse AUTO GUID ID

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

DAnny3211 433

#2

Abhilash Warrier 137 Super User 2025 Season 2

#3

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans