I'm trying to print the id of a lookup table with fetchXML on my power pages, like:
<fetch version="1.0" mapping="logical" no-lock="false">
<entity name="contact">
<attribute name="fullname" />
<attribute name="cccc_lookupcolumn" />
</entity>
</fetch>
{% endfetchxml %}
{% for contact in yyyy.results.entities %}
<p>
Nome: {{ contact.fullname }} <br/>
my lookup column: {{ contact.cccc_lookupcolumn}}
</p>
{% endfor %}
Result:
in the XrmToolBox it works fine, as you can see below:
I'm able to list in the power pages the lookup table it self with this fetchXML below normally
<fetch version="1.0" mapping="logical" no-lock="false">
<entity name="cccc_myforeigntable">
<attribute name="cccc_anycolumn" />
</entity>
</fetch>
I've tried to link-entity, to try get the lookup table id as well, but without success
I've tried to add a child permission for contact table in Table Permissions without success
any ideas?
