CAN'T FIND FILES ATTACHED ON MICROSOFT FORM

Like (0) Share

Report

Posted on 21 Oct 2024 14:47:27 by MB-21101438-0

Help!

We have a flow which connects to an MS Form where people can attach files. On the Power Automate flow we collect all the attachments in an array, and use it to send an automatic email. The flow has been working for months, but since early Oct it gives an error on the get file content step. Below are screenshots of the parts of the flow which are failing, and the content of the Parse JSON.

Thank you.

{
    "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"
        ]
    }
}

Categories:

Business Process Flows

All responses (2)

Answers (0)

MB-21101438-0 2 on 22 Oct 2024 at 11:41:54

Like (0)

Report

CAN'T FIND FILES ATTACHED ON MICROSOFT FORM

Thanks CFernandes. The reason for the two variables is because there are two questions on the MS forms for uploading extra attachments, and due to the form’s branching, only one of them will be used on any given form response. This way we ensure we can catch the attachment, no matter which of the form branches are used. The variables on the Parse JSON are two different form questions, despite having the same name. We use this strategy on different steps throughout the flow and it doesn’t cause any problem. This flow had been working fine for many months, and suddenly it stopped working causing this error. It must be something that has changed either on Power Automate or on OneDrive. The MS forms attachments are automatically saved on a SharePoint folder, maybe OneDrive can’t open SharePoint files anymore?
CFernandes 8,285 Most Valuable Professional on 21 Oct 2024 at 19:58:50

Like (0)

Report

CAN'T FIND FILES ATTACHED ON MICROSOFT FORM

At the first glace I see "Parse JSON" has the variable "Upload Extra attachment twice"

You flow should look like the screenshot below.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Community site session details

CAN'T FIND FILES ATTACHED ON MICROSOFT FORM

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

CAN'T FIND FILES ATTACHED ON MICROSOFT FORM

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates