cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IT-white-paper
Regular Visitor

Parse JSON Attachment Flow error

I got an MS message that they turned off my Attachment flow because of below error:
"Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '20001': 'Required property 'content' expects a value but got null. Path ''.'."

 

My flow worked fine until early March when i started to get error messages then they shut down my flow yesterday.
I've already tried setting the upload question in the MS form as 'required' to feedback a yes/no answer.

 

Can anyone help look at below script to see what's wrong? (URGENT help needed as it's a flow of a critical platform). I've looked at other posts on similar subject but since I'm not good at Power Automate so don't quite know how to apply their solutions (and i applied some but didn't solve the problem).

Know it's a lot to ask but grateful if anyone can provide me with a corrected script to below or give me screenshots on step-by-step correction... Thanks a zillionth in advance!

 

{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "name": {
                "type""string"
            },
            "link": {
                "type""string"
            },
            "id": {
                "type""string"
            },
            "type": {},
            "size": {
                "type""integer"
            },
            "referenceId": {
                "type""string"
            },
            "driveId": {
                "type""string"
            },
            "status": {
                "type""integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}
 
IT-white-paper_0-1618636304358.png

 

 
7 REPLIES 7
v-litu-msft
Community Support
Community Support

Hi @IT-white-paper,

 

The error said the input content is null. Could you please share a screenshot of Parse JSON input?

If you input attachment content, maybe it is an error of item attachment content is null, you could confirm it.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lin Tu,

 

Thanks for your help - do you mean below inputs?

 

{"id":"bc72feb7-b03a-4e1a-acb3-e21b-e772ff75","brandColor":"#8C6CFF","connectionReferences":{"shared_onedriveforbusiness":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness/connections/shared-onedriveforbu-43149ebf-0816-494a-841c-5e97-574bcd76"}},"shared_sharepointonline":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/shared-sharepointonl-cd88ff96-4c08-4b21-b76d-034c-54040047"}},"shared_microsoftforms":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_microsoftforms/connections/shared-microsoftform-9e0659da-9d2c-4d54-a3c7-ea7c-6310b919"}}},"connectorDisplayName":"Data Operations","icon":"data:image/svg+xml;base64,PHN2ZyB2ZXJzaW9uPSIxLjEiIHZpZXdCb3g9IjAgMCAzMiAzMiIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4NCiA8cGF0aCBmaWxsPSIjOEM2Q0ZGIiBkPSJtMCAwaDMydjMyaC0zMnoiLz4NCiA8ZyBmaWxsPSIjZmZmIj4NCiAgPHBhdGggdHJhbnNmb3JtPSJtYXRyaXgoLjggMCAwIC44IDMuMTk4IDIuNjczKSIgZD0iTTYgMTYuMDdhMi4yNCAyLjI0IDAgMCAwIC45LS4xOSAyLjM2IDIuMzYgMCAwIDAgMS4yNC0xLjI0IDIuMjIgMi4yMiAwIDAgMCAuMTktLjl2LTEuMjlhOC4yMiA4LjIyIDAgMCAxIDAtMS4yNiA0LjY4IDQuNjggMCAwIDEgLjMtMS4xOSAzLjA5IDMuMDkgMCAwIDEgLjcxLTEgMy40MiAzLjQyIDAgMCAxIDEuMTQtLjc1IDMuNTEgMy41MSAwIDAgMSAxLjM0LS4yNnYxLjExYTIuMjEgMi4yMSAwIDAgMC0uOS4xOSAyLjM2IDIuMzYgMCAwIDAtMS4yNCAxLjI0IDIuMjMgMi4yMyAwIDAgMC0uMTkuOXYyYTcgNyAwIDAgMS0uMDkuOTMgMy43MyAzLjczIDAgMCAxLS4yNS44NiAzLjI3IDMuMjcgMCAwIDEtLjQ3Ljc4IDMuNDQgMy40NCAwIDAgMS0uNzcuNjkgMy40OCAzLjQ4IDAgMCAxIC43Ny42OSAzLjI5IDMuMjkgMCAwIDEgLjQ3Ljc4IDMuNzUgMy43NSAwIDAgMSAuMjUuODYgNyA3IDAgMCAxIC4wOS45M3YyYTIuMjIgMi4yMiAwIDAgMCAuMTkuOSAyLjM3IDIuMzcgMCAwIDAgMS4yMyAxLjE1IDIuMjIgMi4yMiAwIDAgMCAuOS4xOXYxLjE2YTMuNDkgMy40OSAwIDAgMS0xLjM0LS4yNiAzLjQxIDMuNDEgMCAwIDEtMS4xNC0uNzUgMy4wOSAzLjA5IDAgMCAxLS43MS0xLjA2IDQuNjcgNC42NyAwIDAgMS0uMjktMS4xOCA4LjI0IDguMjQgMCAwIDEgMC0xLjI2di0xLjI5YTIuMjMgMi4yMyAwIDAgMC0uMTktLjkgMi4zNSAyLjM1IDAgMCAwLTEuMjQtMS4yMyAyLjIyIDIuMjIgMCAwIDAtLjktLjE4em0xNC4xOS04LjEzYTMuNTEgMy41MSAwIDAgMSAxLjM0LjI2IDMuNDIgMy40MiAwIDAgMSAxLjEzLjggMy4wOSAzLjA5IDAgMCAxIC43MSAxIDQuNjggNC42OCAwIDAgMSAuMjkgMS4xOSA4LjIyIDguMjIgMCAwIDEgMCAxLjI2djEuMjlhMi4yMiAyLjIyIDAgMCAwIC4xOS45IDIuMzcgMi4zNyAwIDAgMCAxLjI0IDEuMjQgMi4yMiAyLjIyIDAgMCAwIC45LjE5djEuMTZhMi4yMSAyLjIxIDAgMCAwLS45LjE5IDIuMzYgMi4zNiAwIDAgMC0xLjI0IDEuMjQgMi4yMyAyLjIzIDAgMCAwLS4xOS45djEuMjlhOC4yNCA4LjI0IDAgMCAxIDAgMS4yNiA0LjY3IDQuNjcgMCAwIDEtLjI5IDEuMTggMy4wOSAzLjA5IDAgMCAxLS43MSAxLjA2IDMuNDEgMy40MSAwIDAgMS0xLjE0Ljc1IDMuNDkgMy40OSAwIDAgMS0xLjM0LjI2di0xLjE1YTIuMjQgMi4yNCAwIDAgMCAuOS0uMTkgMi4zNiAyLjM2IDAgMCAwIDEuMjQtMS4yNCAyLjIyIDIuMjIgMCAwIDAgLjE5LS45di0yYTcgNyAwIDAgMSAuMDctLjg4IDMuNzUgMy43NSAwIDAgMSAuMjUtLjg2IDMuMjkgMy4yOSAwIDAgMSAuNDctLjc4IDMuNDggMy40OCAwIDAgMSAuNzctLjY5IDMuNDQgMy40NCAwIDAgMS0uNzgtLjY3IDMuMjcgMy4yNyAwIDAgMS0uNDctLjc4IDMuNzMgMy43MyAwIDAgMS0uMjUtLjg2IDcgNyAwIDAgMS0uMDktLjkzdi0yYTIuMjMgMi4yMyAwIDAgMC0uMTktLjkgMi4zNSAyLjM1IDAgMCAwLTEuMjQtMS4yNCAyLjIyIDIuMjIgMCAwIDAtLjktLjE5di0xLjE2eiIvPg0KICA8cGF0aCB0cmFuc2Zvcm09Im1hdHJpeCguOCAwIDAgLjggMy4xOTggMi42NzMpIiBkPSJNMjAuMTIgMTRhMS4yOSAxLjI5IDAgMCAxLS4wOS40OCAxLjIxIDEuMjEgMCAwIDEtLjI4LjQybC01IDUtMi4zOS42LjY0LTIuNCA1LTVhMS4yNSAxLjI1IDAgMCAxIC40Mi0uMjggMS4yOSAxLjI5IDAgMCAxIC40OC0uMDkgMS4yMiAxLjIyIDAgMCAxIC40OS4xIDEuMjcgMS4yNyAwIDAgMSAuNjcuNjcgMS4yMiAxLjIyIDAgMCAxIC4wNi41em0tNy4wNyA1LjhsMS4yNC0uMzFhMS4yMiAxLjIyIDAgMCAwLS45My0uOTN6bS41Ny0xLjY4YTEuNzIgMS43MiAwIDAgMSAxLjExIDEuMTFsNC4wOC00LjA4LTEuMTEtMS4xMXptNS41My0zLjMybC4xOC0uMThhMS4zNyAxLjM3IDAgMCAwIC4xNi0uMTguNzguNzggMCAwIDAgLjExLS4yLjcyLjcyIDAgMCAwIDAtLjI1Ljc2Ljc2IDAgMCAwLS4wNi0uMy43OC43OCAwIDAgMC0uMTctLjI1LjgzLjgzIDAgMCAwLS4yNS0uMTcuNzYuNzYgMCAwIDAtLjMtLjA2LjcyLjcyIDAgMCAwLS4yNSAwIC44Mi44MiAwIDAgMC0uMi4xMWwtLjE4LjE2LS4xOS4yNXoiIHN0cm9rZT0iI2ZmZiIgc3Ryb2tlLW1pdGVybGltaXQ9IjEwIiBzdHJva2Utd2lkdGg9Ii4yNSIvPg0KIDwvZz4NCjwvc3ZnPg0K","isTrigger":false,"operationName":"Parse_JSON","operationDefinition":{"type":"ParseJson","inputs":{"content":"@outputs('Get_response_details')?['body/rde62965fb36c47a2898a002592d7403a']","schema":{"type":"array","items":{"type":"object","properties":{"name":{"type":"string"},"link":{"type":"string"},"id":{"type":"string"},"type":{},"size":{"type":"integer"},"referenceId":{"type":"string"},"driveId":{"type":"string"},"status":{"type":"integer"},"uploadSessionUrl":{}},"required":["name","link","id","type","size","referenceId","driveId","status","uploadSessionUrl"]}}},"runAfter":{"Create_item":["Succeeded"]}}}

IT-white-paper_2-1618802311073.png

 

Many thanks.

 

BR/p.

Hi @v-litu-msft ,

 

Is it because if Q26 the answer is 'NO' and there's nothing uploaded in Q27,

the system will still create a link with no attachment therefore the error?
Does it mean I need to add a step 'if yes/If no' before the Parse JSON?

 

IT-white-paper_1-1618803872775.png

 

BR/p.

v-litu-msft
Community Support
Community Support

Hi @IT-white-paper,

 

Yes, as a workaround, you could create a Condition action to check if the Q26 is Yes, if it is yes, go to Parse JSON, or do nothing.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-litu-msft,

 

Do you have any reference how to create that Yes/No condition? As i dunno how.
(best if have screen shots so i can follow step-by-step)

 

Thanks/p.

v-litu-msft
Community Support
Community Support

Hi @IT-white-paper,

 

OK, an example is created as below:

Screenshot 2021-04-19 132416.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-litu-msft,

 

I've successfully avoided the error by adding the extra Yes/No step,

however i now have a new problem of attachment uploaded not able to be found in the link created.

 

Do you know where i could have gone wrong?
As after the Parse JSON i still have a 'Apply to each' step like below:

IT-white-paper_0-1618825624930.png

Please see if you can shed some light on it. Thank you again!

 

BR/p.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,326)