Add attachments from Forms to Microsoft Lists using Power Automate (UPDATED)

Note: The “Get file content using path” and “Apply to each – Add attachment” actions have updated from my original post to correct an issue where the content from multiple attachments was being duplicated.

I added a check “Condition” on the length of the Associated files from MS Forms to ensure that attempts to add attachments to the list item only occur when the responses included uploaded files.

In my previous blog post I outlined how Power Automate can be used to get responses from Microsoft Forms into Microsoft Lists. As a follow up to that post, I will show how to add attachments from Forms to Lists using Power Automate. See my previous blog post for the form, list and Flow build.

From Power Automate, click “New step”, search for “Control” and select the “Condition” action. The Condition action will check for the existence of attachments in the Forms response.

  • Set the left “Choose a value” to the following expression: length(Associated files). Where “Associated files” is Dynamic content from “Get response details”.
  • Set the condition to “is greater than”
  • Set the right “Choose a value” to “0”.

In the “If yes” branch, click “New step”, search for “Data Operation” and select the “Compose” action. This action will generate the required JSON schema needed to parse the attachment JSON.

  • Set “Inputs” to “Associated files” from the Forms “Get response details” action.

Test the Flow and when complete expand the “Compose” step and copy the Outputs.

Compose action output

In the “If yes” branch, click “New step”, search for “Data Operation” and select the “Parse JSON” action. This action will extract the attachment metadata.

  • Set “Content” to “Associated files” from the Forms “Get response details” action.
  • Click “Generate from sample” and paste the “Compose” outputs into “Schema”.
Parse JSON

In the “If yes” branch, click “New step”, search for “Data Operation” and select the “Compose” action. Power Automate will automatically add a “Apply to each” loop.

  • Set “Inputs” to “name” from the “Parse JSON” action.

In the “If yes” branch, click “New step”, search for “Control” and select the “Apply to each” action. This action will allow us to loop through all of the form response attachments and attach them to our list item.

  • Set “Inputs” to “Body” from the “Parse JSON” action.

In the “If yes” branch, click “New step”, search for “OneDrive for Business” and select the “Get file content using path” action. This action will extract the attachment content.

  • Set “File Path” to your Forms attachment location, i.e. “/Apps/Microsoft Forms/Issue tracker/Question/” and add “name” from the “Parse JSON” action.
OneDrive for Business - Get file content using path action

Note: Forms stores attachments in your OneDrive under “/Apps/Microsoft Forms/form name i.e. “Issue tracker”/Question/”.

In the “If yes” branch, click “New step”, search for “SharePoint” and select the “Add attachment” action.  

  • Set the “Site Address” and “List Name” to you target site and list.
  • Set “Id” to “ID” from the previous “Create item” action.
  • Set “File Name” to “name” from the “Parse JSON” action.
  • Set “File Content” to “File content” from “Get file content using path” action.
SharePoint Add attachment action.  

My completed Flow looks like the image below.

Save your Flow and test by submitting a new item from the “Issue tracker” form. If all goes well your Forms submission will be stored in Microsoft Lists and the attachments will be added to the List entry.

List entry with attachments.

Forms is another excellent tool for citizen developers in the Microsoft 365 toolbox. Getting Forms response data and attachments into Microsoft Lists provides so many opportunities for business process automation using Power Automate without relying on “traditional” IT.

Thanks for reading.

NY

59 thoughts on “Add attachments from Forms to Microsoft Lists using Power Automate (UPDATED)”

  2. Pingback: Get responses from Forms to Microsoft Lists using Power Automate – Norm Young

  3. Hi Norm, thanks for the walkthrough but just have one issue. It seems to work with all file types except for PDFs. The flow completes successfully and i see the attachment uploaded but when i try to look at the attachment, it says ‘Failed to load PDF document.’

    Like

    Reply

    1. Hi Isac,

      This is not what I would have expected. Is the attachment a standard PDF or one with special bookmarks that require the Adobe PDF client to open? Does the attachment open with the OneDrive/SharePoint file viewer?

      Thanks for reading!

      NY

      Like

      Reply

      1. Hi Norm,

        I figured why this is happening. I’ve set my MS Forms to allow the user to upload multiple attachments. It seems like the PARSE JSON and compose action are able to recognise and output the two attachments but i believe the formula inputted in the action ‘get file content using path’ (e.g. /Apps/Microsoft Forms/Issue tracker/Question/first(body(‘Parse_JSON’))?[‘name’]) only extracts the first attachment.

        Please correct me if i am wrong but if not, would you be able to suggest how to accommodate for multiple attachments?

        Thanks!
        Isac

        Like

  4. Hi Isac,

    Let me dig into this further. Adding multiple attachments should be possible.

    I’ll be in touch.

    NY

    Like

    Reply

  5. Hi,
    I’m using the same logic to add attachment but I’m facing an issue with multiple attachment.
    In fact, the list displays multiple documents but the “get file content using path” step is reading the first name (first(body(‘Parse_JSON’))?[‘name’])
    That’s why it doesn’t worj for me.
    Any suggestion would be veray appreciated 😉

    Thanks

    Like

    Reply

  6. Hello,
    very interesting post
    i’m using this logic in & current flow but I’m facing issues to have it working with several attachments

    in fact, I can see both attachments in my sharepoint item but the “Get file content using path” is not working.
    I guess it’s normal because we use the expression first(body(‘Parse_JSON’))?[‘name’]
    So it’s loading only the first name of the body

    I didn’t find a way to loop correctly.

    Any suggestion would be highly appreciated 🙂

    thxs

    Like

    Reply

    1. Hi Thomas,

      The Flow does work with multiple attachments. WordPress will sometimes convert single quotes ‘ to ’. Update: first(body(‘Parse_JSON’))?[‘name’] to first(body(‘Parse_JSON’))?[‘’name’].

      Thanks for reading!

      NY

      Like

      Reply

  7. Thanks for your reply. It doesn’t work for me. And I can’t apply your recommendation because it tells me the expression is invalid.

    Here is the step above where I Parse the JSON .
    The issue is that the file path use twice the same name :\Apps\Microsoft Forms\Demande d’analyse – Saint Fons (Copie)\Données Sécurité Veuillez déposer la FDS du produ\FDS_Thomas LORGE 2.pdf

    instead of \Apps\Microsoft Forms\Demande d’analyse – Saint Fons (Copie)\Données Sécurité Veuillez déposer la FDS du produ\receipt train to airport_Thomas LORGE.pdf

    [
    {
    “name”: “FDS_Thomas LORGE 2.pdf”,
    “link”: “https://elkem-my.sharepoint.com/personal/thomas_lorge_elkem_com/Documents/Apps/Microsoft%20Forms/Demande%20d%27analyse%20-%20Saint%20Fons%20(Copie)/Donn%C3%A9es%20S%C3%A9curit%C3%A9%20%20Veuillez%20d%C3%A9poser%20la%20FDS%20du%20produ/FDS_Thomas%20LORGE%202.pdf”,
    “id”: “01NVQRYGWYS2JFMTOAPRA3X7NOKBZLKYAF”,
    “type”: null,
    “size”: 1818360,
    “referenceId”: “01NVQRYGSWLO2ZLARLYBBYFTTKOGLGMC2N”,
    “driveId”: “b!da_GQCGNTU-TpCq0a75y0fKw_skVS0xBqz7NHiYKvrzmRuCsFE47Q7RDO2bruoQi”,
    “status”: 1,
    “uploadSessionUrl”: null
    },
    {
    “name”: “receipt train to airport_Thomas LORGE.pdf”,
    “link”: “https://elkem-my.sharepoint.com/personal/thomas_lorge_elkem_com/Documents/Apps/Microsoft%20Forms/Demande%20d%27analyse%20-%20Saint%20Fons%20(Copie)/Donn%C3%A9es%20S%C3%A9curit%C3%A9%20%20Veuillez%20d%C3%A9poser%20la%20FDS%20du%20produ/receipt%20train%20to%20airport_Thomas%20LORGE.pdf”,
    “id”: “01NVQRYGSMMLU2M2PW6ZCZFZJW2QQGJMEJ”,
    “type”: null,
    “size”: 47156,
    “referenceId”: “01NVQRYGSWLO2ZLARLYBBYFTTKOGLGMC2N”,
    “driveId”: “b!da_GQCGNTU-TpCq0a75y0fKw_skVS0xBqz7NHiYKvrzmRuCsFE47Q7RDO2bruoQi”,
    “status”: 1,
    “uploadSessionUrl”: null
    }
    ]

    Like

    Reply

    1. Hi Thomas,

      I’ll happy to help but need more info. Expression code, error message and screen prints of each.

      NY

      Like

      Reply

      1. Hi,
        I’m sorry I’m a bit new on this blog, but i can’t paste screen copies, or attach files.
        do you want me to send you details by email or is there a way to proceed via the blog ?
        thxs

        Like

  9. Hello Norm, I want add an attachment from “for a selected item” user input as an attachment to a list item in sharepoint. I suspect the concept is close to what you have demonstrated above but I am a bit stuck. Do you an example?

    Like

    Reply
  10. Pingback: Copying Microsoft Forms Attachments to a SharePoint List Item using Power Automate | Platte Canyon/Jeff Rhodes Blog

  11. Hi, tried your steps here, it works for me, the only thing im concern is just can multiple attachments compile in 1 row? Because on my end, when there is multiple attachments it creates multiple lines on the share point list.

    Like

    Reply

    1. Hi Chona,

      I would review your steps and compare them with mine. My testing shows that attachments are added to a single list item.

      Let me know how you make out and thanks for reading!

      NY

      Like

      Reply

  12. I have an MS form that is part of a team and my list is also part of the same team. Is there a way to just get the file path for each attachment and insert those into the List as hyperlinks instead of copying the document itself?

    Like

    Reply

  13. I have an MS form that is part of a team. My list is also part of the same team. Is there a way to parse the file path of each of the uploaded documents and put the path into the list as a hyperlink instead of duplicating each of the documents?

    Like

    Reply

    1. Hi docwisdom,

      It seems possible. You could use an expression to parse out the path and store the link. The Parse JSON action will have a “link” output that you can use to store the URL to the files. I would probably try a mix of the FIRST, LAST and SPLIT functions to achieve this.

      Let me know if you need help.

      Thanks for reading!

      NY

      Like

      Reply

  14. Norm, I am grateful for this walkthrough. I have a question on this though. Is there an option to have the Compose/Parse JSON be conditional? The flow I have set up works perfectly when there are attachments in the MS form. The MS form I have set up allows attachments to be optional and this flow errors out when there are no attachments available.

    The error message in the Parse JSON is “Unable to process template language expressions in action ‘Parse_JSON’ inputs at line ‘0’ and column ‘0’: ‘Required property ‘content’ expects a value but got null. Path ”.’.”.

    Thank you for any feedback provided.

    Like

    Reply

    1. Hi Soon,

      You can edit the JSON to allow NULL values. For example:

      “name”: {
      “type”: “string”
      },

      Can be updated to:

      “name”: {
      “type”: [“string”, “null”]
      },

      Thanks for reading!

      NY

      Like

      Reply

      1. HI… i have the same issue and wish to make attachment optional. I tried your suggestion but am still getting the same error message.

        {
        “type”: “array”,
        “items”: {
        “type”: “object”,
        “properties”: {
        “name”: {
        “type”: [“string”,”null”]
        },
        “link”: {
        “type”: [“string”,”null”]
        },
        “id”: {
        “type”: [“string”,”null”]
        },
        “type”: {},
        “size”: {
        “type”: [“integer”,”null”]
        },
        “referenceId”: {
        “type”: [“string”,”null”]
        },
        “driveId”: {
        “type”: [“string”,”null”]
        },
        “status”: {
        “type”: [“integer”,”null”]
        },
        “uploadSessionUrl”: {}
        },
        “required”: [
        “name”,
        “link”,
        “id”,
        “type”,
        “size”,
        “referenceId”,
        “driveId”,
        “status”,
        “uploadSessionUrl”
        ]
        }
        }

        anything i did wrong

        Like

      3. It was the same error posted on Soon’s post. I managed to get round the problem with a conditional branch before the checking the attachment. If attachment is there, do the json if the attachment field is blank, do nothing.

        Like

      5. Hello MIndy,

        Try adding a Condition action that checks for length of the Get User ID action. If 0 then the ID does not exist.

        Hope that helps and thanks for reading!

        NY

        Like

      6. Norm, thank you for the response. I edited the JSON to allow for NULL values but am still receiving the following error: Unable to process template language expressions in action ‘Parse_JSON’ inputs at line ‘0’ and column ‘0’: ‘Required property ‘content’ expects a value but got null. Path ”.’.

        I have also edited the JSON to match what Mindy is doing below and am still receiving the same error message.

        Like

      7. Hi Soon,

        You may want to consider Mindy’s approach and add a Condition action that checks for a NULL attachments.

        Let me know how you make out.

        NY

        Like

    1. Hi Josh,

      It is complicated and I hope that you were able to implement the Flow for this use case. You are not the only one to voice your concerns on this point and I believe that Microsoft is listening. Hope this will be simplified in the future.

      Thanks for reading!

      NY

      Like

      Reply

  16. Hi Norm,
    I basically followed the logic and steps, and it works. The only problem I have is that when I run the automation, there are 2 files created in my SP list – one with no attachment, another with an attachment. I wonder what should I do for it? Any recommendations will be appreciated!

    Look forward to your reply

    Like

    Reply

    1. Hi Jessica,

      “there are 2 files created in my SP list – one with no attachment, another with an attachment”

      Are you saying that 2 list entries are created? If so is the Create item in a Apply to each loop?

      Thanks for reading!

      NY

      Like

      Reply

  17. Hi Norm, this has been very useful but I have a small problem. For the last step I can’t seem to add the onedrive file content – it’s not even an option for me. Do you have any suggestions for troubleshooting?

    Like

    Reply

    1. Hi Jamie,

      Sorry the late response. Hopefully you got past this issue. If not, make sure that you are getting output from the “Get file content using path” action. If it is null, then check if the path exists.

      Thanks for reading!

      NY

      Like

      Reply

  18. Hi Norm,

    I’, trying to do something similar but less complicated. i want to attach files in my sharepoint library to the correct row in my client list. for example: a file from a client which was uploaded through onedrive and moved sharepoijt folder is to be added to the client’s row in my sharepoint list by referencing if the file name contains “first name”. “first name” is a column in my sharepoint list, containing the first names of my clients. so far i use the get items action with filter expression: contains(body(‘Get_items’)?[‘value’], ‘First Name’). but i get an error Flow save failed with code ‘InvalidTemplate’ and message ‘The template validation failed: ‘The ‘inputs’ property of template action ‘Get_items’ at line ‘1’ and column ‘2221’ is not valid. The action cannot reference itself.’.’.
    was wondering if you can help me out.

    Like

    Reply

    1. Hi Rustie,

      Sounds like something is wrong with the Get items action. I’m not certain “contains” is supported with an OData filter query and would need to test to know for sure. I’m happy to help but need a few days to find some time.

      Thanks for reading!

      NY

      Like

      Reply

  19. I have this working perfectly, having an MS Group form, where the submitter uploads a document and then submits the form. PowerAutomate then creates the SharePoint list item and attaches the Form’s attachment to the list item. My list has permissions for restricted contribute, so I do not want folks to navigate to the SharePoint site’s Documents>Apps>Microsoft Forms>etc., to be able to see the attachment that may have been uploaded by someone else. Is there a way in the PowerAutomate to delete the attachments from Documents>Apps>Microsoft Forms>… once they have been attached to the SharePoint list?

    Like

    Reply

    1. Hi Annette,

      Interesting question. You should be able to use the SharePoint delete a file action.

      Thanks for reading!
      NY

      Like

      Reply

  20. This works great for getting form responses with file attachments, but it fails every time someone submits a form without an attachment. How do I get both into my list?

    Like

    Reply

    1. Hi Kat,

      Thanks for flagging this issue. Adding a check condition against Associated files – i.e. length greater than 0 – and then moving the add attachments to the “If yes” branch will fix this issue.

      I’ll update the blog shortly.

      Thanks for reading!

      NY

      Like

      Reply

  21. Hi,

    Thx for this flow. But doens’t work with 2 pdf’s.
    Only 1 is uploaded, 2nd only name is coorect but file behind is same as the first. How can I solve this?

    Like

    Reply

    1. Hi Caroline,

      Are you using the Body from the Compose Associated files output in your Apply to each that adds the attachments?

      I recently updated this blog post. Please review and confirm outputs in any loops.

      Thanks for reading!

      NY

      Like

      Reply

  22. Hi Norm,

    I’m quite new to json. I’m having difficulty understanding the specifics of the expressions listed above. This is a possible solution that I can adapt to suit my requirements, just need a bit of help in understanding the JSON expressions so that I can substitute my particular information where applicable; thank you for all of these documented solutions – it’s truly appreciated.

    Like

    Reply

    1. Hi Matt,

      I find JSON is hard to read and don’t do much with the actual JSON itself. The Parse JSON action is a means to an end where you turn output data into referenceable data within your Flow. You shouldn’t have to write any JSON. The Compose action output should be enough to generate the JSON schema from example. On occasion I will add “allow null” entries into the JSON schema to help with error prevention but that is it.

      To answer your question, you can generate JSON from the Compose action output. Let’s say for example you have a HTTP request. Compose the output from HTTP request. Run the Flow and copy the body from the Compose output. Add a Parse JSON action and generate the schema from the Compose output that you just copied and bam your have JSON data and attributes for use in your Flow.

      Hope this helps and thanks for reading!

      NY

      Like

      Reply

  23. Norm,
    Thanks for all your help, Is there a way to attach a document to a list item that already exists? In my flow, since i’m not creating the list item I cant use the “ID” from dynamic content menu.

    Like

    Reply

    1. Hi Michael,

      You can attached a file to the list item but you will need to know the ID for the item. You will need to run a Get items action with enough filtering to narrow down the target item.

      Thanks,
      NY

      Like

      Reply

  24. Hi Norm,

    Thanks for the great post. I’ve followed the instructions and noticed I’m having the following problem:
    The attached file is pointing to the storage location.

    I can confirm the file is uploaded to onedrive, but the path showing up in the list references the team location of the list file. For example:
    File is at : OneDrive/temp.pdf
    The link in the list is pointing to: TeamsName/temp.pdf

    Is there a way to correct this in the flow, or do I need to recreate the form in teams? Currently, the form and flow exist outside of teams in my 365 for business account.

    Thanks for any insight

    Like

    Reply

    1. Hi Martin,

      Check that the “Get file content using path” action is pointing to the correct Forms location. Is this a Group Form?

      Thanks for reading!

      NY

      Like

      Reply

      1. Hi Norm,

        It’s pointing to the forms location. I think the issue is I made the form in my personal one drive space, and not in the teams group. I’m going to try and see if I can move the form into teams and see if that resolves things.

        Like

      2. Hi Martin,

        That makes sense to me and you will need to point to your OneDrive or recreate the Form in the teams group.

        Hope it works out and thanks for reading!

        NY

        Like

  25. Hello Norm,

    thank you for the Instructions it was really helpful, but i had to change one part since the Forms is located on a SharePoint so i use the “Get file Content”

    /Shared Documents/Apps/Microsoft Forms/Internal/Attach/@{items(‘Apply_to_each_2’)[‘name’]}

    So i just added the path in front of the “name” variable.

    My Problem is know that the Flows fails….

    The Flow fails and the Shown Error Details arrent really helpful:
    Route did not match
    clientRequestId: 52e878cc-4e49-420c-9ee7-def941f9882c
    serviceRequestId: 52e878cc-4e49-420c-9ee7-def941f9882c

    Do you have an idea what i could do to solf the Problem?

    Like

    Reply

    1. Hi Nikolaus,

      Confirm that the data in items(‘Apply_to_each_2’) is also coming from SPO. Also, with these types of errors always perform a new test!

      Let me know how it goes and thanks for reading!

      NY

      Like

      Reply

  26. Hi Norm! I used to have an MS Flow that fetches MS Forms reply and reflects responses to a SharePoint list using “List of response notifications” as dynamic value on “Apply to each” action. Now “List of response notifications” is missing when I draft a new flow or use this template: https://make.powerautomate.com/environments/Default-d966cb11-b024-463b-8c9d-face5df64110/galleries/public/templates/2be590104bdd11e78896d10a96d3fac3/record-form-responses-in-sharepoint

    Would you be able to guide how to solve this or any workaround? Thank you!

    Like

    Reply

Leave a comment