Microsoft Dynamics 365 | Integration, Dataverse...

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

(0) Share

Report

Posted on by tattmardiff

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?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nya 29,060 on at

Like (0)

Report

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.

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.

Was this reply helpful? Yes No
tattmardiff 25 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No