Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

surfacing Formatted value of D365 field



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.


Helpful resources

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,571)