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

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.

<figure><img src="/files/qeIffp155PstWzpyRiVl" alt=""><figcaption><p>Deal form: Account &#x26; Primary Contact is lookup field</p></figcaption></figure>

## 1st attempt - Using Dynamics Content

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

<table><thead><tr><th width="357">Dynamics content</th><th width="281">Result</th></tr></thead><tbody><tr><td><img src="/files/fYBEgeumi768sg8IXDx4" alt="" data-size="original"></td><td><img src="/files/gC2AtDMZnXsI8BG62VuY" alt="" data-size="original"></td></tr><tr><td><ul><li>Account (Value): Get record GUID</li><li>Account (Type): Get the entity name</li></ul></td><td><ul><li>Account (Value): <em><strong>fdf6a531-.....</strong></em></li><li>Account (Type): <em><strong>account</strong></em></li></ul></td></tr></tbody></table>

... 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.

<figure><img src="/files/BGHnuI7sVLBiaJIISfwp" alt=""><figcaption><p>All attributes of the field "Account" (ntd_account_id)</p></figcaption></figure>

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.

<pre class="language-javascript" data-overflow="wrap"><code class="lang-javascript"><strong>//The expression:
</strong><strong>item()?['_ntd_account_id_value@OData.Community.Display.V1.FormattedValue']
</strong></code></pre>

<figure><img src="/files/deyCRdIjKUe5iW5uh2zd" alt="" width="375"><figcaption><p>Power Automate used Expression</p></figcaption></figure>

... And checking now:

<figure><img src="/files/4j3fWwI2oJEDhmWySAib" alt="" width="375"><figcaption><p>The final result - Get the "Display Name" of Account lookup field</p></figcaption></figure>

Thank you for reading & Hoping well... :tada:\
\&#xNAN;**\[NTD]yns.asia**\
...[invite me a cup.](https://ko-fi.com/ntdyns/?ref=qr\&amp;v=2) :coffee: <mark style="color:blue;">Thank you.</mark> :heart:


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://dyns.ntd.asia/power-dynamics/power-platform/power-automate/tips-get-displayname-of-the-lookup-field-on-power-automate.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.