Lookup text value from Dataverse not displaying

(0) Share

Report

Posted on by ehaynes

Hi folks,

Hoping someone can help because this has been driving me mad. I've used pretty much the same syntax on other builds and it has worked fine so I'm not sure what I'm doing wrong.

Flow is being triggered by a 'When a row is added, modified or deleted' in Dataverse.

I'm attempting to get the text value of a lookup column in the flow. Here is the value:

Therefore, in my FX im using:

triggerBody()?['_tur_fundingstream_value@OData.Community.Display.V1.FormattedValue']

Yet the value returned is just blank. Can confirm there is a value present in the record and that the ID is returned if I just use:

triggerBody()?['_tur_fundingstream_value']

Any value I get using Dynamic content from the trigger record works absolutely fine, although I am having the same issue with displaying OptionSet labels.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ehaynes ,

The lookup column does not return the column name you described.

If you want to get the data in the related table, please extract the id from the lookup and use 'get a row by id ' action.

//TestLookup is the lookup column name.

Besides, if you want to get option set label (single option set), please try this

triggerOutputs()?['body/_cr6d7_testchoice_label']

Best Regards,

Wearsky

Was this reply helpful? Yes No