CDS Formatted OptionSets

[Greggomatic]

When performing a select query for fields in CDS (D365), is there a way to return formatted data results?

I.e., instead of the enum 8200000, I want to get back 'Work'

I tried adding to the end of a field in the selectQuery view.

OData.Community.Display.V1.FormattedValue

Thanks 

[PowerBack19 · Accepted solution]

@Greggomatic - Test this out with a Compose step: body/<fieldname>@OData.Community.Display.V1.FormattedValue

Here is an example: body/statuscode@OData.Community.Display.V1.FormattedValue

Refer to the great blog by @LinnZawWin - https://community.dynamics.com/365/b/linn-s-power-platform-notebook/posts/get-the-lookup-display-nam...