Convert Microsoft Form response to Word doc

Like (0) Share

Report

Posted on 26 Jun 2020 12:41:51 by lingo

Hi,

I tried to follow this example to create a Flow that converts each new Microsoft Form response to a Word document. But I keep getting the following error message when I test the Flow. The solution posted here didn't solve my problem. What have I done wrong? Apologies for my limited computing knowledge.

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerBody()' is of type 'Object'. The result must be a valid array.

When asked to "Select an output from previous steps" for the "Apply to each" step, I tried all 4 options:

List of response notifications Response ID
Body
List of response notifications resourceData
List of response notifications Item

None of them work. The error message persisted. Help me please! I tried for three hours already with no luck.

Thanks,

Phoebe

All responses (2)

Answers (0)

lingo 2 on 29 Jun 2020 at 01:07:11

Like (0)

Report

Re: Convert Microsoft Form response to Word doc

@ChristianAbata
Below is the screenshot. Thank you in advance!

This is what I saw when I clicked 'Peek code' for the "Get response details" step:
{
    "inputs": {
        "host": {
            "connection": {
                "name": "@parameters('$connections')['shared_microsoftforms']['connectionId']"
            }
        },
        "method": "get",
        "path": "/formapi/api/forms('@{encodeURIComponent('1-QJ7A89_06cHnuoBgxUF2UhfuL2pB5IonMatC4aneBUREtKVE5EVUdZWVgxMjNGNENKOTNUS1VHWi4u')}')/responses",
        "queries": {
            "response_id": "@triggerBody()?['resourceData']?['responseId']"
        },
        "authentication": "@parameters('$authentication')"
    },
    "metadata": {
        "flowSystemMetadata": {
            "swaggerOperationId": "GetFormResponseById"
        }
    }
}
ChristianAbata 8,947 Most Valuable Professional on 28 Jun 2020 at 20:43:43

Like (0)

Report

Re: Convert Microsoft Form response to Word doc

hi @lingo please could you share an screanshot?