Answered

Liquid fetchxml get optionset/lookup value from linked entity

(0) Share

Report

Posted on by TheIntern

I am joining two entities with a fetchxml query.

field 2 and field 3 are lookup and optionset respectively. I am trying to access the values using result['entity2.field2.name'] and result['aa.field3.label'], but i get blank for both.

Is there a way to get these values?

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (1)

Sort by

justinburch Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Assuming result is the iterative object from your for loop, try {{ result.aa.field3.label }} - otherwise it's expecting aa.field3.label to be a static string. Also, try filtering your fetch to only those that have data in field3 to ensure you're testing against data that should have a value.

Was this reply helpful? Yes No
Verified answer

Fubar 8,503 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Is there a way to get the value, Yes. I can't remember exactly off the top of my head using the array notation but I think you have too much in the [].
Something more like result['aa.field3'].label

also see
https://powerusers.microsoft.com/t5/Building-Power-Apps/Portal-Liquid-Template-with-FetchXML-OptionSet-Label/m-p/364341

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I would ensure you can retrieve the ID first.
{{ result['aa.field2'].id }}
Once you have got the ID coming back, that proves your permissions are Okay.
Then I suggest trying to get the text value back, but depending on the field type you have setup try the following:
{{ result['aa.field2'] }} {{ result['aa.field2'].value }} {{ result['aa.field2'].label }} {{ result['aa.field2'].text }} {{ result['aa.field2'].name }} {{ result['aa.field3'] }} {{ result['aa.field3'].value }} {{ result['aa.field3'].label }} {{ result['aa.field3'].text }} {{ result['aa.field3'].name }}
Let me know if this helps.

1 people found this reply helpful.

Was this reply helpful? Yes No