Get text value of LookUp Column

[Revlock97]

I'm having trouble getting the text value of a LookUp column in my Dataverse table. Upon initializing and using the expression below (since it returns the GUID) which I got from here 

https://www.crmug.com/communities/community-home/digestviewer/viewthread?GroupId=1285&MessageKey=069...

...but it returns with nothing/blank. 

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

[grantjenkins]

For testing can you just add the trigger body into the variable then run it and have a look at the output to confirm the field name you are using is correct.

[Expiscornovus · Accepted solution]

Hi @Revlock97,

A lookup is something different than a field of type choice. The details of this lookup will be stored in a different table. Is it a lookup or a choice type of field?

With a lookup you could use a Get row by id and use the related table and the id to lookup related data of that record.