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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Export a table to excel with the related records GUID

(0) ShareShare
ReportReport
Posted on by 110

Hi Guys,

We are trying to export a table (lets say for now the Account table), but some of the related records' display names are not unique and do not have a unique ID. 

Anybody know how we can extract these records into excel with the related records GUID? Maybe through power automate.

Many thanks,

J

I have the same question (0)
  • James Padkin Profile Picture
    5 on at

    When you export to excel an Account Table "view" to there are 3 columns A,B,C, that are hidden, these will hold the GUID for the CRM record - Account. Just unhide these to view the GUID in the column headed "Row Checksum".

  • BernardV Profile Picture
    2 on at

    Did you find an answer to this in the end?

  • BernardV Profile Picture
    2 on at

    That's the GUID of the Account. Madders is asking whether it is possible to included the GUIDs of lookup values.

  • empath-e CRM Profile Picture
    1,136 on at

    Hi,

    Within PowerApps select the entity you want to export and then click Edit in Excel - Within Excel this should show your related record ID rather than the lookup value

    pastedimage1664265728170v1.png

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans