Hi folks,
I've successfully figured out how to add an attachment from an MS Form into a Sharepoint list. It works like a charm thanks to the good people in this community (thank you!).
My issue now (ironically) is that when my MS Form submission doesn't have an attachment, the flow fails at the Parse JSON step with the following error:
InvalidTemplate. 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 think this means that it's expecting to find content, but there's no attachment. Is this as simple as just adding a condition to check if there is no attachment? Any suggestions?
Here's the Parse JSON code:
{
"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"
]
}
}
