Forum Discussion
Parsing Microsoft Forms Likert questions using Flow
Sorry for not clarifying in my original post. The Parse_Breakfast is the JSON output for the Breakfast value using the following schema:
{
"type": "object",
"properties": {
"id": {
"type": "number"
},
"order": {
"type": "number"
},
"answerOrder": {
"type": "number"
},
"displayText": {
"type": "string"
},
"invalid": {
"type": "boolean"
},
"url": {},
"description": {},
"symbol": {},
"symbolColor": {},
"isCustomChoice": {
"type": "boolean"
},
"customProperties": {
"type": "string"
},
"key": {},
"image": {
"type": "object",
"properties": {
"altText": {},
"contentType": {},
"fileIdentifier": {},
"originalFileName": {},
"resourceId": {},
"customProperties": {},
"resourceUrl": {}
}
}
}
}
Here's what the Flow looks like
Great blog, how would you do something similar with a multi answer question in forms? Right now it comes in as one string (csv) that contains all the answers that were checked. I need to split those out and treat them as separate objects.
I figured it out. The multi selection question returns a json string array. If you parse the json (action/data operations/parse JSON) and then apply to each.
Hi Gregory,
Would you be able to share the JSON array you used to extract the individual multiple choice response options? I have a similar problem where there are certain responses from a multiple choice question I want to display but some I do not so being able to omit them via JSON seems ideal.
Thanks in advance.
