Parse Jason null value

(0) Share

Report

Posted on by dominique2001

I am building a data request flow, this involves creating and MS form and ambeding it in sharepoint list for team members to fill, then a sharepoint list is created. One the questions on the MS form ask requester to either upload a document is neccessary but can also be left blank without uploading. I realize whenever the requester uploads a document on the MS forms when submitting , the flow runs succesfully , but if no document is not uploaded, the flow fails with the below error message. how can I make sure that the flow runs even without document upload? Thank you all

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Add a condition to your flow to check if there are attachments added to the question:

You can use the length expression to get the number of attachments added to the question and check if it is greater than 0:

The expression used:

length(outputs('Get_response_details')?['body/yourquestionwithattachments'])

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hey Mate, How does you JSON look like, you handle null values in ParseJSON schema as well. For example -

"FileContent":

{
"type": [
"string",
"null"
]
}

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
dominique2001 11 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes . Thank you so much, I believe yours will work. Can you tell me how I can go about this? below is my Parsed Jason

{

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

]

}

}

Below is what I tried after your answer. still did not work

{
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": ["string", "null"]
},
"link": {
"type": ["string", "null"]
},
"id": {
"type": ["string", "null"]
},
"type": {
"type": ["string", "null"]
},
"size": {
"type": ["integer", "null"]
},
"referenceId": {
"type": ["string", "null"]
},
"driveId": {
"type": ["string", "null"]
},
"status": {
"type": ["integer", "null"]
},
"uploadSessionUrl": {
"type": ["string", "null"]
}
},
"required": [
"name",
"link",
"id",
"type",
"size",
"referenceId",
"driveId",
"status",
"uploadSessionUrl"
]
}
}

Was this reply helpful? Yes No