Extract string values from JSON Parse

[Anonymous]

I cannot for the life of me get flow to extract each value from my JSON array

Need it to pull string values from each part of the array and then be able to pull that info into an email in later steps.

My current set up is like this - but im hitting a wall here.. JSON does tend to pull Null values if the field is blank in PowerApps

How do i reference each object in the email below? 

[Anonymous]

Tried also to use Compose

[Pstork1]

You should use value not body in the Parse JSON.  Body is an object that contains an array.  value is the array itself.  If you use value in the array you should be able to reference each property using the name.  

outputs('Parse_JSON')?['B211IN']

You can wrap that in a Coalesce to substitute a different value for Null properties.

[Anonymous]

So using your suggestion i think this is where i had problem before - does not seem to be pulling the value through?

[Pstork1]

Based on the schema you posted B211IN is a null object., not string.  Double check your schema.  It should look something like this

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "B211IN": {
                "type": "string"
            },
            "B211OUT": {
                "type": "string"
            }
....

[Anonymous]

Hi @Pstork1 

Right now it is like this - because not all values are filled - sometimes they return null as pulling this data from PowerApps- if i try to change to string value as above i get an error because null is not a string value i believe was the issue i had with this

{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "B211IN": {},
      "B211OUT": {},
      "B2171IN": {},
      "B2171OUT": {},
      "B2172IN": {},
      "B2172OUT": {}
    }
  }
}

OUTPUT 

[
  {
    "B211IN": "TESTCAR"
  },
  {
    "B211OUT": null
  },
  {
    "B2171IN": null
  },
  {
    "B2171OUT": null
  },
  {
    "B2172IN": null
  },
  {
    "B2172OUT": null
  }
]

[Anonymous]

Basically i just want to reference each field value taken from PowerApps JSON and then add their value to an email below. If i directly reference the Parse value it will Apply for Each and send 6 different emails 

[Pstork1]

To handle properties in the array that can be string or null use a schema like this, not one without a type.

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "B211IN": {
                "type": ["string", "null"]
            },
            "B211OUT": {
                "type": ["string", "null"]
            }
....

[Pstork1 · Accepted solution]

To avoid the apply to each loop you will need to manually input the JSON for each value using an Index.  Something like this

body('Parse_JSON')[0]?['B211IN']

where [0] is the first row, [1] is the second, etc.

[Anonymous]

@Pstork1 Thank you so much for your help so far -

still does not appear to pull the string value through am i doing something wrong?