💡Tips: Get "DisplayName" of the Lookup field on Power Automate

#PowerAutomate, #OData, #LookupFiled

Recently, I have leveraged Power Automate to retrieve a list of new deals and then sent this list to the Sales Owner.

In practice, I encountered difficulties when attempting to retrieve the Account name and Primary Contact name, both of which are lookup fields, from the Deals entity.

Deal form: Account & Primary Contact is lookup field

1st attempt - Using Dynamics Content

I used the value in Dynamic content (OOB dynamics field content of Power Automate)

Dynamics content	Result
Account (Value): Get record GUID Account (Type): Get the entity name	Account (Value): fdf6a531-..... Account (Type): account

... first try, I failed to get the display name with the OOB dynamic content field of the Power Automate.

2nd attempt - Using Expression

Then, I used Expression to create the formula and get the Display Name of Account lookup field.

---

Initially, when displaying all attributes of the Deal entity and then applying a filter on the lookup field "Account" (ntd_account_id), I discovered exciting aspects.

All attributes of the field "Account" (ntd_account_id)

I observed the first value is the "Display Name" of the Account field, I promptly accessed Power Automate and employed the mentioned attribute in my expression.

//The expression:
item()?['[e-mail]']

Power Automate used Expression

... And checking now:

The final result - Get the "Display Name" of Account lookup field

Thank you for reading & Hoping well... 🎉 [NTD]yns.asia ...invite me a cup. ☕ Thank you. ❤️