Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to include Contact...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to include Contact GUID as related field in Cases Advanced Find

(0) ShareShare
ReportReport
Posted on by tattmardiff 25

Is it possible to include the Contact GUID (primary key) in a related entity view in Advanced Find? For example, if I am pulling a list in Advanced Find for Cases, and want to include the Contact GUID primary key for the related Contact. I am able to see the Contact name as a related column in Advanced Find, but not the actual GUID.

Is this possible to accomplish without creating a free text field, mapping/importing the Contact GUID to that free text field, and including that free text field in the Case Advanced Find view?

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,959 Super User 2024 Season 1 on at
    RE: How to include Contact GUID as related field in Cases Advanced Find

    Hi,

    With advanced find export to excel you will only get related lookup field name only.

    I have since learnt of a very easy technique using Power Apps - https://make.powerapps.com/ there you can choose an Entity such as Phone Calls, click 'Edit data in Excel' - this produces a spreadsheet full of data for each field of each record including the GUIDs of the associated regarding records which is exactly what is was after.

  • tattmardiff Profile Picture
    tattmardiff 25 on at
    RE: How to include Contact GUID as related field in Cases Advanced Find

    Nya - I am looking to have the Contact ID GUID as a column in the view, not as a filter as I see it in your XML example. Is that possible?

  • Suggested answer
    Nya Profile Picture
    Nya 29,058 on at
    RE: How to include Contact GUID as related field in Cases Advanced Find

    Hi,

    The GUID cannot be input directly into the Advanced Find.

    But you can achieve it by downloading fetchXML from the Advanced Find and then inputting the GUID into it.

    Here is an example.

    pastedimage1654245279951v2.png

    pastedimage1654245294418v3.jpeg

    Then you can use the fetchXML to query data.

    Use FetchXML to query data (Microsoft Dataverse) - Power Apps | Microsoft Docs

    There is a tool in XMLToolBox called FexchXML Builder which helps a lot on it.

    FetchXML Builder for XrmToolBox - empower yourself to achieve more.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans