Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Common Data Service - List Records - Bad JSON on expand?

Hello Flow Community,


I'm using the Common Data Service List Records step to pull some data out of an entity including some properties from a related entity using the expand box. The problem I seem to be having is that the JSON that is returned seems to be badly formatted for the related properties.


This is end of the first record that is returned:

      "hs_prescriptionmedication": false,
      "hs_MainContact": "{\r\n  \"address1_postalcode\": \"NW10 6BA\",\r\n  \"contactid\": \"07859a78-5d8a-ea11-a811-000d3a654e39\"\r\n}"

 hs_prescriptionmedication is a property of the main entity and hs_MainContact is the related properties. Rather than being returned as more nested JSON items the related properties are being returned as the JSON as a string with the whole item quoted, \r\n printed explicitly and the internal quotes escaped. This means I can't use the Parse JSON step to pull out the related properties because rather than the nicely nested JSON they are this odd string instead. In examples such as this one the related properties come as properly formatted JSON.

Is there something I need to do to get the related properties in properly formatted JSON?

Any help gratefully received!

Helpful resources


August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (4,925)