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
a
(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,505 Super User 2026 Season 1 on at

Like
a
(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
a
(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