Dynamics 365 Getting the look up value instead of the GUID

(0) Share

Report

Posted on by alexyoy111

Hello,

Trying to perform a simple task of converting a list of records to HTML table and send it to email.

One of the fields is lookup field then from some reason instead of getting the value I'm getting the GUID in this scenario is the owner field:

All responses (13)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report
Re: Dynamics 365 Getting the look up value instead of the GUID

replace(replace(replace(body('Create_HTML_table'), '<', '<'), '>', '>'), '"', '"')

alexyoy111

56 on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @v-bacao-msft

So sorry it's taking so long time to me to understand I don't know why Microsoft did it so difficult

This is how I would like to see the email:

)	LINK
Susanna Stubberod (sample)	LINK
Nancy Anderson (sample)	LINK
Maria Campbell (sample)	LINK
Sidney Higa (sample)	LINK
Scott Konersmann (sample)	LINK
Robert Lyon (sample)	LINK
Paul Cannon (sample)	LINK
Rene Valdes (sample)	LINK
Jim 1	LINK
Patrick Sands (sample)	LINK
Susan Burk (sample)	LINK
Thomas Andersen (sample)	LINK

This is how I am receiving the email:

EMAIL BODET.png

This is my entire flow can you please direct me to what I'm doing wrong and why i'm not receiving a simple link to record

v-bacao-msft on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @alexyoy111 ,

Could you share the email message? If you want to add hyperlink, you need to add <a></a> and check this similar thread to format HTML table:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-format-the-table-as-Rich-text-in-send-an-email-body/m-p/203544#M21369

Best Regards,
alexyoy111 56 on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @v-bacao-msft
Email body
v-bacao-msft on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Email body???
alexyoy111 56 on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

The same

😥
v-bacao-msft on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @alexyoy111 ,

You could remove <a></a> and fill link in Compose directly.

Best Regards,
alexyoy111 56 on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @v-bacao-msft

The good news is that i'm not getting any errors but I'm also didn't get a link as you can see the content of the email contains entire URL and the text “LINK TO RECORD” as link
v-bacao-msft on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @alexyoy111 ,

Because href contains "", so it is a valid JSON.

You could add a compose above Append to array variable action and fill hyperlink in it.

Then fill the output of the Compose in Value.

Hope this helps.

Best Regards,
alexyoy111 56 on at

Like (0)

Report

Re: Dynamics 365 Getting the look up value instead of the GUID

Hi @v-bacao-msft
Unfortunately it's make the same error Enter a valid json
Although i'm not sure I added correctly