Retrieving formatted values from D365/CDS with Microsoft Flow

The Dynamics 365 and Common Data Service connectors in Microsoft Flow and Logic Apps do not return formatted values when using the Get Record and List Records actions. This is a real pain if you need to use formatted values.

It seems that the Dynamics 365 and Common Data Service actions do not implement a Prefer header that contains the odata.include-annotations="OData.Community.Display.V1.FormattedValue" value required by the Web API to return formatted values.

There is a work around, however.

UPDATE: This work around is now redundant. Formatted values are available when using the CDS (Current Environment) connector by means of the new_myfield@OData.Community.Display.V1.FormattedValue property. Thanks to Linz Zaw Win for pointing this out. See his blog for more details:

HTTP with Azure AD

Fortunately, we can use the Invoke an HTTP request action that is part of the HTTP with Azure AD connector. This connector and action are awesome because it allows us to send HTTP requests to Dynamics 365 or Common Data Service without having to worry about the authentication. No Azure App registrations! No bearer tokens!

Add a new action to your Flow or Logic App. Search for HTTP with Azure AD and select the Invoke an HTTP request action.

Screenshot of choose action dialog

Enter the base URL of your Dynamics 365 or Common Data Service instance into the Base Resource URL and Azure AD Resource URI (Application ID URI) fields. For example: Next, click Sign in.

Screenshot of HTTP with Azure AD connection creation

Set the Method to GET and enter the Url of the request field, enter rest of the request URL along with the OData query parameters you would have used in the traditional Dynamics 365 and Common Data Service actions.

Now the important part! Add a new header with a key of Prefer and a value of odata.include-annotations="OData.Community.Display.V1.FormattedValue". This will tell the web API to include formatted values in the response.

Screenshot of Invoke an HTTP request action

Save your Flow or Logic App and then trigger it. If you inspect the Invoke an HTTP request action of a successful run, you will notice that the formatted values are now included in the response body JSON.

Screenshot of successful Invoke an HTTP request action

Bonus tips

If you need to iterate through the response values you can use body('Invoke_an_HTTP_request')?['value'] on an Apply to each action.

Invoke_an_HTTP_request is the default name of the action we created. If you changed it’s name then you will need you will need to change it in the expression too.

Screenshot of expression to get response results to iterate over

To get the formatted value from one of the values you are iterating over you can use items('Apply_to_each')?['fieldname@OData.Community.Display.V1.FormattedValue'].

Screenshot of expression to get formatted value from response results

Vote for OData annotations to be added to Flow

If you’d like to see OData annotations added to Flow and Logic Apps please consider voting for it on the Flow Ideas section of the Microsoft Flow Community site.

I'm doing my part!

All views expressed in my blog are my own and do not represent the opinions of any entity whatsover with which i have been, am now, or will be affiliated.