Skip to main content

Notifications

Community site session details

Community site session details

Session Id : TpGQ36d6d1tKhG/Clz0BYo
Power Automate - Building Flows
Unanswered

CAN'T FIND FILES ATTACHED ON MICROSOFT FORM

Like (0) ShareShare
ReportReport
Posted on 21 Oct 2024 14:47:27 by 2
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"
        ]
    }
}
  • MB-21101438-0 Profile Picture
    2 on 22 Oct 2024 at 11:41:54
    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 Profile Picture
    8,295 Most Valuable Professional on 21 Oct 2024 at 19:58:50
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 385 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 328

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 1

Overall leaderboard
Loading started