Skip to main content
added 199 characters in body
Source Link
Matiur Rahman
  • 3.1k
  • 2
  • 8
  • 8

Sample input to [Parse JSON]

{
  "d": {
    "results": [
      {        
        "Title": "Hello Lastisa",
        "Email": "[email protected]"
      }
    ]
  }
}

Schema used for [Parse JSON]

Schema used for [Parse JSON]

Sample input to [Parse JSON]

{
  "d": {
    "results": [
      {        
        "Title": "Hello Lastisa",
        "Email": "[email protected]"
      }
    ]
  }
}

Schema used for [Parse JSON]

Source Link
Matiur Rahman
  • 3.1k
  • 2
  • 8
  • 8

You've not provided your JSON input and output values for [Parse JSON] action in Power Automate, so not sure about the JSON structure.

Usually, a collection fed into [Parse JSON] will have an array called [results], which is the top level array. It may contain other nested arrays.

See an example of getting users from a SharePoint Group and processing the user collection using [Parse JSON] and [Apply to each] actions.

enter image description here

Schema used for [Parse JSON]

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "results": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "Title": {
                                "type": "string"
                            },
                            "Email": {
                                "type": "string"
                            }
                        },
                        "required": [
                            "Title",
                            "Email"
                        ]
                    }
                }
            }
        }
    }
}

Use [Apply to each] for processing [results] array

enter image description here