How to get lookup name instead of id in send an email action in Ms Flow

(0) Share

Report

Posted on by Himanshu Kamboj

440

Hi,

I have a custom entity Lease. This lease entity contains the many lookups like user's and account.

I have created Ms flow in which I am sending an email and I want to get the all lookup's name in the email body but as flow is triggered I am just getting the lookup's Id's.

I am using this expression in which I got the Id:- triggerOutputs()?['body/_cyno_primaryclientcontact_value']

and If I use:- triggerOutputs()?['body/_cyno_primaryclientcontact_value@OData.Community.Display.V1.FormattedValue'] then got nothing.

I have the same question (2)

All responses (2)

Answers (1)

Sort by

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Himanshu,

Maybe you can add one action ‘Get a row by ID’ action before get lookup field name.

For example, I test I contact entity, which have one lookup field named ‘Account name’ related to account entity.

1.Firstly, I tested it as your example, then I got the same results with you.

triggerOutputs()?['body/_parentcustomerid_value'] can get id.

triggerOutputs()?['body/_parentcustomerid_value_parentcustomerid_value@OData.Community.Display.V1.FormattedValue'] get nothing

2.Then i add one action ‘Get a row by ID’ with guid from the trigger, and use

outputs('Get_a_row_by_ID')?['body/_parentcustomerid_value@OData.Community.Display.V1.FormattedValue']

Test Result:

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Himanshu Kamboj 440 on at

Like (0)

Report
Copy link

Link copied!

Thanks Leah!!

Was this reply helpful? Yes No