Greetings,
I am attempting to surface the formatted value of this field, into an HTML table in Power Automate:
"new_ap_dedicated@OData.Community.Display.V1.FormattedValue": "No", the value I am seeking is "No".
The field is in the Fetch Xml Query:
<entity name="ind_piareports">
<attribute name="ind_name"/>
<attribute name="createdon"/>
<attribute name="ind_dealerpia"/>
<attribute name="new_piacontact"/>
<attribute name="ind_itemsdiscussed"/>
<attribute name="ind_goodcallbadcall"/>
<attribute name="createdby"/>
<attribute name="ind_callnotes"/>
<attribute name="ind_piareportsid"/>
<attribute name="new_healthcare_dedicated"/>
<attribute name="new_educational_dedicated"/>
<attribute name="new_ap_dedicated"/>
<order descending="false" attribute="createdby"/>
<order descending="true" attribute="createdon"/>
<filter type="and">
<condition attribute="statecode" value="0" operator="eq"/>
<condition attribute="createdon" operator="last-seven-days"/>
<condition attribute="createdby" operator="ne-userid"/>
However, I am getting an error in the flow:
The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language expression 'item()['new_ap_dedicated@OData.Community.Display.V1.FormattedValue']' cannot be evaluated because property 'new_ap_dedicated@OData.Community.Display.V1.FormattedValue' doesn't exist.
Your assistance would be greatly appreciated.
