Hi,
I am trying to run a flow to pick up form responses and also add the embedded attachment within the form into a SharePoint List.
I have added the PARSE JSON etc. and this works really well - apart from that the attachment isn't present on all branches of the form. So the responses that do not contain an attachment are creating an error at the PARSE stage of the flow.
The error in this instance is:
Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '32007': 'Required property 'content' expects a value but got null. Path ''.'.
The flow is attached, and the schema within the PARSE action is:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": [
"string",
"null"
]
},
"link": {
"type": [
"string",
"null"
]
},
"id": {
"type": [
"string",
"null"
]
},
"type": {},
"size": {
"type": [
"integer",
"null"
]
},
"referenceId": {
"type": [
"string",
"null"
]
},
"driveId": {
"type": [
"string",
"null"
]
},
"status": {
"type": [
"integer",
"null"
]
},
"uploadSessionUrl": {}
},
"required": [
"name",
"link",
"id",
"type",
"size",
"referenceId",
"driveId",
"status",
"uploadSessionUrl"
]
}
}
The only way around it I can think of is to build in a condition at the beginning of the flow to make the different branches of the form follow different paths in the flow but this seems complicated.
Please advise!
D
