Solved: 'Unexpected character encountered while parsing value: P. Path '', line 0, position 0.'.

'Unexpected character encountered while parsing value: P. Path '', line 0, position 0.'.

Hi Everyone,

I am having an error in my Parse JSON step. I have read all the replies in the forum as well as the external website discussions, but could not come up with a solution/explanation.

I have a JSON file that I use for customer details. For simplicity, I reduced it to two customers, with customer name name and the people to put in to and cc in the email communication:

{
  "customers": [
    {
      "name": "Customer 1",
      "to": [
        "contactA@customer1.com",
        "contactB@customer1.com"
      ],
      "cc": [
        "contactC@customer1.com",
        "contactD@customer1.com"
      ]
    },
    {
      "name": "Customer 2",
      "to": [
        "contactE@customer2.com",
        "contactF@customer2.com"
      ],
      "cc": [
        "contactG@customer2.com",
        "contactH@customer2.com"
      ]
    }
  ]
}

I checked the JSON, and successfully deserializes.

I create a Parse JSON step in Power Automate, click on the "Generate from sample", paste the above JSON and Power Automate successfully generates the schema:

{
    "type": "object",
    "properties": {
        "customers": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "name": {
                        "type": "string"
                    },
                    "to": {
                        "type": "array",
                        "items": {
                            "type": "string"
                        }
                    },
                    "cc": {
                        "type": "array",
                        "items": {
                            "type": "string"
                        }
                    }
                },
                "required": [
                    "name",
                    "to",
                    "cc"
                ]
            }
        }
    }
}

Up to this point, everything goes successful, and I can save the flow. But when I it, the flow errors out:

The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: P. Path '', line 0, position 0.'.

Any ideas?

Thank you!

Tolga

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate - Building Flows