Answered

Pass null image value in JSON

(0) Share

Report

Posted on by zaidkhan20

Hi,

I have created a flow connecting MS Forms to MS excel. There is an option to upload a picture, however I want to make it optional. If form is submitted without a picture I get an error as

"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 ''.'."

I tried finding solution for this exact question, but unfortunately couldn't.

PARSE JSON:

{

"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"

]

}

Help will be appreciated.

Thanks

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (0)

Report

Re: Pass null image value in JSON

Hi @zaidkhan20 ,
Do you want:
1. The user submits the Form and uses excel to collect user information?

Here is a test for your reference:
Here is form
Here is excel
Here is flow:
(Because there will be cases where the user does not submit a picture, [Condition] needs to be set)
Because I don't know how you collect the pictures into excel, I put the pictures into excel in the form of Uri

Test 1 (user submitted image)

Test 2 (User has not submitted an image):

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards
Cheng Feng
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Re: Pass null image value in JSON

Hi @zaidkhan20,
Please Confirm the Name of Property Where You Are Receive Picture Content. and try to remove from Required section of that property where you generate Json template.

Please Send me output of Get response details Action If I misunderstood the requirement.