Parsing Microsoft Forms Likert questions using Flow

Earlier this year, Microsoft announced the Likert survey question type in Microsoft Forms. A Likert captures multiple choice question on a scale. When the survey responses are loaded ...

office 365

Haniel Croitoru

Learn Expert

Aug 19, 2018

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

Gregory Sharrow

Copper Contributor

Aug 20, 2018

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.

Forum Discussion

Parsing Microsoft Forms Likert questions using Flow

Resources