Answered

Get text value of LookUp Column

(0) Share

Report

Posted on by Revlock97

187

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=069373ac-23ec-47db-b58a-78aaf6b89a71&CommunityKey=dc83c23b-ede0-4070-ae7a-dd90859148a6&tab=digestviewer

...but it returns with nothing/blank.

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (2)

Report

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.

Was this reply helpful? Yes No