cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
calvares
Continued Contributor
Continued Contributor

Parse JSON error

I'm following this blog post to create a SharePoint group then assign permissions and users.

My flow fails at step 5 - Parse JSON.

Error message is: Unable to process template language expressions in action 'Parse_JSON_-_Owners' inputs at line '1' and column '16532': 'Required property 'content' expects a value but got null. Path ''.'. Any idea where I could be going wrong with it?

 GroupsFlow.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
calvares
Continued Contributor
Continued Contributor

I worked it out finally. In the HTTP request to create the group, I had to add "RequestToJoinLeaveEmailSetting": "true" in the body. 

View solution in original post

10 REPLIES 10
Hardesh15
Super User II
Super User II

@calvares  when you use sample json which does not handle null value.

Please go through this post

https://www.google.com/amp/s/msolenacrm.blog/2020/07/06/power-automate-parse-json-action-with-value-...

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Pstork1
Dual Super User III
Dual Super User III

Double check that your HTTP request is actually returning data and not a null array.  This error complaining about a null Path usually means there is no data in the Body you are trying to parse.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
calvares
Continued Contributor
Continued Contributor

Thanks @Hardesh15 - that's helpful. I might try option 1 as I don't need to generate dynamic content value.
Could you tell me where I would need to add the null value to this part of the code?:

"Owner": {
"type": "object",
"properties": {
"__deferred": {
"type": "object","null"
"properties": {
"uri": {
"type": "string"
}
}
}
}
},
"Users": {
"type": "object",
"properties": {
"__deferred": {
"type": "object","null"
"properties": {
"uri": {
"type": "string"
}

calvares
Continued Contributor
Continued Contributor

@Pstork1 Thanks, that was my first thought. However there is data in the Body of the HTTP request:Capture.PNG

@calvares  Run your flow and expand https action copy http action output and put this in parse json sample. Try this  and let me know.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

calvares
Continued Contributor
Continued Contributor

Still no luck @Hardesh15 . I identified a property that was coming up as null and tried option 1 and 3 from the post but get the same error. 

"RequestToJoinLeaveEmailSetting": {}
 
"RequestToJoinLeaveEmailSetting": {"type": [
                    "number",
                    "null"
                ]}
 

@calvares As expected. Please use in this way.

"RequestToJoinLeaveEmailSetting":

[

{

"type": "number"

},

{

"type": "null"
}

]

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

 

calvares
Continued Contributor
Continued Contributor

Thanks for the suggestion @Hardesh15 but this didn't work on my flow, nor did any other attempts at getting rid of that null value. 

I do wonder if the issue is with the body of the HTTP request as @Pstork1 suggested, since that is what the error message suggests too. But I can't see how it could be turning up null.

abm
Super User III
Super User III

Hi @calvares 

 

Check the response status code from the HTTP Post. You might be getting 202. The request has been accepted for processing, but the processing has not been completed.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
calvares
Continued Contributor
Continued Contributor

I worked it out finally. In the HTTP request to create the group, I had to add "RequestToJoinLeaveEmailSetting": "true" in the body. 

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (20,487)