Microsoft Form --> Email w/ attachment

[Anonymous]

Hey all,

I am recently learning about Forms / Flows / etc. as apart of a work function. I am currently on a project and I've hit a brick wall.

What I'm trying to do - 

1. Microsoft Form is available to be filled out with questions. Users can upload documentation (pictures or such) through it.

2. Once form is filled out, it then sends out those results (with attachments) to specified users. 

3. Done.

Where I'm at - I have step one figured out, and half of two step. I have figured out how to email users automatically the results, and that's great. But I cannot figure out how to get attachments to show in the email. I've played with it, and these are the results I've got. I've tried tweaking things, with different results.

1. Sometimes no email shows at all. 

2. Sometimes the email shows, but only with one attachment, even if there were mulitple

3. One time when I was playing with it, it gave me the correct number of attachments with the correct attachment names, but they were all the same file. So if I had a file called FLOWERS, and it was a picture of flowers, another file may be titled CARS, but still have a picture of the same flowers.

What I need - I really just need a breakdown, in layman terms, of what I need to do. I thought this was going to be pretty simple, but ended up being way more complicated than I imagine. I want for the automated email that includes results and attachments to *actually* include the attachments, even if there are multiples. My form has one question for attachments, allowing a max of 10 attachments which I'm OK with.

https://imgur.com/a/JsJ94Kx 

[Anonymous]

Forgot to mention--

I've been looking at a lot of different resources. Youtube walkthroughs. BytheDevs. So linking an outside resource is something I may have already looked at. I am looking for someone to look at my specific picture, walk me where I went wrong, and how to fix. Thank you again, microsoft forms wizards!

[Mira_Ghaly]

@Anonymous 

Please check below video if it is not working for you , Please share screens of how your flow is structured.

https://www.youtube.com/watch?v=-rwC0k8DG3o

[Mira_Ghaly]

@Anonymous 

Also here is a detailed steps as  havIe replicated the same at my side and it worked 

1. Get the Attachments field and Parse JSON on it so that we can get file contents of each

UploadFiles Below here is to be replaced by your attachments question

Shema for the Parse JSON Step:

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

2. Initialize and Construct the Attachments Array

3. Outside the Apply to each , Send the email

[Pstork1]

Take a look at this Blog walkthrough I wrote.  It will walk you through how to attach files uploaded via MS forms to an email.

Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic? (dontpapanic.com)

[Mia_]

Thank you that is great, except if there is no attachments it errors and stops my flow from then on.

Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic? (dontpapanic.com)

[Pstork1]

You need to add a condition to check the length() of the array where the attachments are stored. If its 0 there are no attachments and you should send the email without the attachments array.  Otherwise send it with the attachments.

[Mia_]

Thanks that worked