A column such as Account Name on the contact record is actually a lookup value.
When you use the Company Name in Power Automate there are two options, either the type, or the value
The type is the table i.e. contact or account (account in this example).
If you want to get the name of the account, without doing a separate Get Row by Id request, then you need to append
@OData.Community.Display.V1.FormattedValue
As in example 3 below.
- Gets us the name of the table
- Gets us the Id of the record
- Gets us the display name of the lookup
