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?

Community site session details

Convert Microsoft Form response to Word doc

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Convert Microsoft Form response to Word doc

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates