Unanswered

Parsing Json to get link to optional file

(0) Share

Report

Posted on by Eske939

Hello all,

may I ask for a quick help? I have a PowerAutomate flow to update MS list when new MS Form is submitted. One of the MS Form´s field is to upload screenshot, but it is optional.

The problem is, Flow fails if file is not uploaded, saying:

**Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.**

Any idea how to make it work even if file is not uploaded?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Eske939
According to your error code "'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null.".
This seems to be due to the fact that the json argument you passed in doesn't match the Type of your parsing. For example, if you set the String type in Parse Json, but you pass in null, an error will be reported.
Here are the steps you can refer to :
"type": ["string","null"]
And for more information, you can also refer to :
Solved: Handling NULL in Parse JSON - Power Platform Community (microsoft.com)

Second, for extracting the values in Json, we can directly use Expression to get them, such as the value of the Vary field here:
outputs('Compose')? ['headers']? ['Vary']

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Chriddle 8,634 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If the field is optional, you should remove it from the required list in the schema 😉

Was this reply helpful? Yes No
Eske939 12 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yueyun-msft
thanks for getting back. My "type" is Parsing Json. How do I know which to modify?

What do you mean by ** Vary ** in second reply?

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Eske939
Thanks for your quick response , in my understand , you can try to modify the schema in Parse Json action:
And you can see the type for each key , you need to find the error key and modify its type as my above reply.

And the second reply "Vary" is just one of the key in my Json String .

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No