The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed:

[tsparkman]

I'm hoping someone can help me. I have a flow that is triggered by my PowerApp to export data to Excel. 

I have generated the sample JSON from the App...here is what that looks like. This is what I'm entering in the "Generate from Sample" dialog in Power Automate.

[
    {
        "DescItem": "description of service",
        "ExpAmount": 0,
        "OriginalRequestor": "Doe, John",
        "RequestID": 144,
        "Supplier": "ABC Supplier",
        "Title": "ABC Supplier - Test Request from Live Site"
    },
    {
        "DescItem": "Test Description",
        "ExpAmount": 100,
        "OriginalRequestor": "Doe, Jane",
        "RequestID": 146,
        "Supplier": "Acme Supply",
        "Title": "Subscription Service Renewal"
    },
    {
        "DescItem": "Circuit renewal",
        "ExpAmount": 6110,
        "OriginalRequestor": "Doe, John",
        "RequestID": 147,
        "Supplier": "Circuits R Us",
        "Title": "Renewal of streaming circuit"
    }
]

Power Automate seems to be happy with that and returns this as the schema which seems right to me.

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "ExpAmount": {
                "type": "integer"
            },
            "Title": {
                "type": "string"
            },
            "OriginalRequestor": {
                "type": "string"
            },
            "RequestID": {
                "type": "integer"
            },
            "Supplier": {
                "type": "string"
            },
            "DescItem": {
                "type": "string"
            }
        },
        "required": [
            "DescItem",
            "ExpAmount",
            "OriginalRequestor",
            "RequestID",
            "Supplier",
            "Title"
        ]
    }
}

However, when I try to run the flow, passing just the three sample records exactly they way they were in the sample data from which the schema was generated, it throws an error that says:

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

I have been struggling with this all afternoon and can't figure out what's wrong. Any help or insight would be greatly appreciated!

[poweractivate]

@tsparkman

When testing with Compose on my side I cannot reproduce this problem.

[
    {
        "DescItem": "description of service",
        "ExpAmount": 0,
        "OriginalRequestor": "Doe, John",
        "RequestID": 144,
        "Supplier": "ABC Supplier",
        "Title": "ABC Supplier - Test Request from Live Site"
    },
    {
        "DescItem": "Test Description",
        "ExpAmount": 100,
        "OriginalRequestor": "Doe, Jane",
        "RequestID": 146,
        "Supplier": "Acme Supply",
        "Title": "Subscription Service Renewal"
    },
    {
        "DescItem": "Circuit renewal",
        "ExpAmount": 6110,
        "OriginalRequestor": "Doe, John",
        "RequestID": 147,
        "Supplier": "Circuits R Us",
        "Title": "Renewal of streaming circuit"
    }
]

Schema:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "DescItem": {
                "type": "string"
            },
            "ExpAmount": {
                "type": "integer"
            },
            "OriginalRequestor": {
                "type": "string"
            },
            "RequestID": {
                "type": "integer"
            },
            "Supplier": {
                "type": "string"
            },
            "Title": {
                "type": "string"
            }
        },
        "required": [
            "DescItem",
            "ExpAmount",
            "OriginalRequestor",
            "RequestID",
            "Supplier",
            "Title"
        ]
    }
}

And then when test running it I get no error:

What exactly is the input you are passing in Parse JSON and where is it coming from in the Flow? 

If needed, put a dummy Compose action in-between the Parse JSON and the other input and populate this Compose with the exact contents of where the input is coming from. Then take a look at it by running the Flow, looking at the Flow run, seeing what text is shown there, and paste it here - or, take a look at it carefully and see if there might actually be a difference causing the issue you encounter.  It is likely that the input actually being given to Parse JSON is somehow not the same as if you had put it in a dummy Compose action. Where exactly is the JSON input coming from? Also check in the Flow Run under "INPUTS" -> "Content" if the actual Content there is matching. If it is not matching, check carefully in Flow definition for the value of "Content" if it is really correct - if not, put the correct one there and retry.

[prameelaj]

I too face the same issue...  

the input to Parse JSON is the html content given below:

<table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0" style="border:solid black 1.0pt"><thead><tr><td width="96" valign="top" style="width:1.0in; border:none; border-right:solid black 1.0pt; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Name</span></p></td><td width="96" valign="top" style="width:1.0in; border:none; border-right:solid black 1.0pt; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Employee ID</span></p></td><td valign="top" style="border:none; border-right:solid black 1.0pt; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Job Profile</span></p></td><td valign="top" style="border:none; border-right:solid black 1.0pt; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Cost Center</span></p></td><td valign="top" style="border:none; border-right:solid black 1.0pt; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Department</span></p></td><td width="96" valign="top" style="width:1.0in; border:none; border-right:solid black 1.0pt; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Manager</span></p></td><td width="192" valign="top" style="width:2.0in; border:none; background:navy; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:white">Email - Work</span></p></td></tr></thead><tbody><tr><td width="96" valign="top" style="width:1.0in; border-top:solid black 1.0pt; border-left:none; border-bottom:none; border-right:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">xyz, abc</span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td><td width="96" valign="top" style="width:1.0in; border-top:solid black 1.0pt; border-left:none; border-bottom:none; border-right:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">1234567</span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td><td valign="top" style="border-top:solid black 1.0pt; border-left:none; border-bottom:none; border-right:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">Associate Program Manager</span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td><td valign="top" style="border-top:solid black 1.0pt; border-left:none; border-bottom:none; border-right:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">12345</span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td><td valign="top" style="border-top:solid black 1.0pt; border-left:none; border-bottom:none; border-right:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">XYZ</span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td><td width="96" valign="top" style="width:1.0in; border-top:solid black 1.0pt; border-left:none; border-bottom:none; border-right:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">ABC DEF</span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td><td width="192" valign="top" style="width:2.0in; border:none; border-top:solid black 1.0pt; background:white; padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black"><a href="mailto:Alexis.Purtell@highmarkhealth.org">ABC.XYZ@SAMPLE.COM</a></span><span style="font-size:8.0pt; font-family:&quot;Arial&quot;,sans-serif"></span></p></td></tr></tbody>

the JSON converter provided me the below JSON equivalent

when i ran the flow with the schema generated out of this, it is failing with the same issue.

Can someone help?