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

(0) Share

Report

Posted on by Himanshu Kamboj

393

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.

All responses (2)

Answers (1)

Himanshu Kamboj 393 on at

Like (0)

Report

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

Thanks Leah!!
Verified answer

Community Member on at

Like (0)

Report

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

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.