web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to find the Guid c...
Power Apps
Unanswered

How to find the Guid column in Dataverse

(3) ShareShare
ReportReport
Posted on by 894

After an update of Power Platform I am unable to find the the GUID under the DATA tab. I can't add the column in Views either... so how to find this? The guid is synonymous with Row ID.

 

This is the only thing I can access. What am I missing?

Screenshot 2022-06-06 at 12.06.51.png

Screenshot 2022-06-06 at 12.04.36.png

 

 

I have the same question (0)
  • MaxDoglia Profile Picture
    39 on at

    Same here, the column can be viewed when exported to csv, but not in then new view. 

  • Gyllentid Profile Picture
    894 on at

    @MaxDoglia does the csv file work for you? I don't know how to get it to be readable so I gave it up.

  • MaxDoglia Profile Picture
    39 on at

    HI @shavora , yes it does work for me. Its not the best, but... as temporary workaround it works. I'll put a ticket with Microsoft, as this looks like its happening for everybody. I'll let you know if they provide any solutions. 

  • nataliareal1 Profile Picture
    5 on at

    Same here.

  • Fubar Profile Picture
    17 Super User 2026 Season 1 on at

    First, the field/column is generally not exposed in the user interface - this is by design so logging it as a bug will probably not result in any change, if anything log it as an Enhancement.

     

    In DataVerse the GUID is held in a field that is the same name as the table but with an id suffix eg. the Contact table it is in contactid, for a custom Table myCustom would be in something like new_mycustomid  where the prefix will depend on what publisher is being used)

     

    Second, some ways you can get it

    • Power Query / Power BI - use an oData data source or the DataVerse connector see: https://docs.microsoft.com/en-us/power-query/connectors/dataverse
    • Model Driven App
      • From a List View or by doing an Advanced Find you can Export to Excel.  The GUID is held in Column A.  The first 3 column in the exported Excel file are hidden  so to see Col A you need to unhide (highlight Column D, then drag to the left, then right click and choose 'unhide'
      • For an individual record in your browser bar with the record open it is the value of the the "id=<guid here>" parameter.
      • For an individual record you may have an Email Link button in the Command bar, if so clicking it will give you a URL and again it is the "id=" parameter
    • XrmToolBox 
      • you can run FetchXML from either the FetchXML Builder or FetchXML Tester to retrieve fields
    • Also you can query it via oData in your browser or by creating a Flow
  • Gyllentid Profile Picture
    894 on at

    I am sure many of us working in Power Platform and using Dataverse/CDS has looked for the guid for error handling and long work arounds won't be useful. If you are using Power Automate and you look at a record with lookups, there is only the guid referenced so you will have to double check somewhere that THAT record is indeed the right related record. Or looking in Power Automate for createdby will give a guid, not a name. Burying those guids makes the system non transparent which is an important quality in terms of interactive design, especially for this kind of functionality.

    My workaround has been to use List rows in power automate and find the guids that way, but it's still longer than having the Data tab.

  • MaxDoglia Profile Picture
    39 on at

    I agree @shavora  I was using it the same way. I have a ticket open with MS and one of the Customizations Engineers is taking a look... hopefully, I'll back here with some solution/news

  • Gyllentid Profile Picture
    894 on at

    @MaxDoglia eager to hear, thanks so much 🙏

  • MaxDoglia Profile Picture
    39 on at

    HI @shavora looks like they fixed yesterday. Its working now 🙂 

  • Gyllentid Profile Picture
    894 on at

    @MaxDoglia wonderful thanks 😀

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 401 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard