Save MS Form Attachment to SharePoint List using Power Automate 

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

Hi! Thank you so much for this fantastic guide. I've tried multiple tutorials for this flow, and yours is the only one that worked for me the first time! I was a little worried that after 4 years, some functionality would have changed, but this is still accurate!

Awesome work, short concise and to the point. One of the best power automate tutorials I have seen. The only add I would do is to delete the file from one drive once its on SharePoint. As if your getting thousands of submissions it will nuke your OneDrive. Thank you again.

This was really helpful as everywhere the fetching of schema details was getting inaccurate details...thanks for the tutorial..!!

Thank you! Tried a lot of other methods before finding this video but this is the first one that worked and it's explained very clearly 👍

Hi My Friend, I've just used your JSON schema, works properly, many thanks & good luck!

Thank you sir. Several other postings had outdated info. Saved me a huge headache.

Dude you are king! Straightforward and clean instructions!

Very nice, thanks for help. As usual, indian guy teaches the world :)

Thank you so so much for this video! I've been searching for a straightforward guide for doing this and gone down a lot of dead ends, this one is absolutely perfect.

I have been working on this for days. Thank you so much. I am giddy with laughter!

First of all, I would like to thank you for your time. Also, just FYI, it is possible to generate a schema file content from a sample. I've just tried and it works

Very nice video. this one has worked well in my case. thank you for sharing this wonderful tip of attaching ms form to sharepoint.

Give this guy a medal!!

Awesome!!! Not sure why anyone would give this a thumbs down!!

Lernen Tech i have used your Json It works great thank you. how what needs adding to the Json to stop error if there was no attachment in the form.

Thank you so much...... it was very useful..... Thank you once again....

Hi ... Thanks for the explanation. How can you make the attachment upload as optional... if there is no attachment then form content should be saved without attachement

Hey man, you are the best. Great work!

This was fantastic, saved me pulling a lot more of my hair out! Thank you!!

Thank you! Very detailed and helpful! Fixed my issue easily.

Great thanks. Short & simple using your script. Works a treat

Thank you so much, I was looking foard to do this. Just a little request. Could you make an other video sending all the attachment and forms answers to e-mail? to complement this video. thank you

Thank you so much for this! I love Power Automate, but it isn't always easy to figure out. This video really help me achieve my goal :-)

Amazing tutorial. Thank you so much!

Thank you. You are the best.

Wonderful tutorial Sir..and thanks a lot for your time and effort,👌🙏

Great Tutorial. Easy to understand and to the point!

Thank you so much!!!! I tried several solutions today, and this was the only one that worked.

Worked like a charm! Thank you so much

Brilliant!!! This help me so much! Do you have any other forms ->emails workflow related videos that require to provide an approval before the sharepoint list item is actually going to be started?

Fantastic! Quick and easy to follow. Great steps!

Thank you!

This worked great. Thanks so much!

Thank you! i was looking many videos... please continue with examples and cases

Awesome tutorial. Worked like a charm. Thank you very much for your effort here. Much appreciated.

Great video, answers exactly my needs

wow, many thanks man. very helpful

Great video!! Help me a lot. And about many question type with attachments in forms? and saved in list? How i can do this? Tks

Hi! I want to thank you very very much for this great and useful step-by-step. It really helped a lot! THANK YOU!

Thanks you!! You are amazing and a life saver!!

This worked! One question. Can you use SharePoint/Teams instead of OneDrive to store the attachments?

Thank you very much for this guide. Big help in a new request process.

This is just what I was looking for, Thank you so much for sharing!

Thanks you so much for the tutorial. You're a life saver !

So thankful for this video as I've been struggling with pulling links into SP list from MS Forms. Appears the solution expects an attachment or it fails. Where would I add a condition to move records to list if attachment field is null?

Thanks for your effort! Very appreciated I got one question here. If I want to rename the file as I dont want the responser name after the attached file name in the SharePoint list. How can I change or remove it?

Fantastic. Thank you so much!

Thank you so much!! Your contents are SO helpful.

Hi what happens if you have form submissions with and without attachments. Will the flow fail if there are no attachments?

Awesome!!! Thank you for solution. I just wonder is there any way to make the attached pdf "prettier"?

hello there. i used this w/ an MS Form created from a Sharepoint site (e.g. Add New Form from a SharePoint list), then i created the MSFlow but i had to use the Get Content using Path (for SharePoint, not OneDrive as shown from your video, coz the MS Form Uploaded File is in the same Sharepoint site where the MS Form was created). My Problem is that the ParseJson link return if the file types are not png or jpg or pdf (e.g. file types xlsx and docx) the ParseJson returns a link with this added to the end of the path "&action=default&mobileredirect=true" , which when used with the Get File Content Using Path (for SharePoint) returns an ERROR of 404. There's no error for file types png,jpg,pdf as the ParseJson returns a link that ends with the filename only. What should i do here ?

I get an error on this flow if no file is uploaded to the form. Is it possible for the flow to complete even if there is no content to upload. I would like to use this jsond in my flows; but in my forms the request to upload a file is optional. It works when I get an file uploaded but fails when there is no file. Thanks.

Thank you very much, i love your video. Plase if i want to use power automate to move/copy the file from OneDrive to Sharepoint and then just generate the file link and put it in the file column, how can we go about doing that?

Excellent! Thank you so much.

March 2023 Comment. This worked very well for me. I was seeing an error with the file URL field being to long, but I only had to update the field type on the target list.

This is absolutely brilliant! Thank you so much for sharing:-)

Thank you so much!

Great Tutorial.Thank you.

Excellent video that is super helpful! One Question, How can we remove the "Username" text that automatically is appended in the filename? For instance "Filename_Username.xlsx"

Hi! What will be the modification if the uploading of file is not mandatory? Thanks! Great work btw!

Big help, thank you

Brilliant tutorial, thank you!

thank you. This has helped me.

Awesome thanks!

SO helpful! thank you SOO much!! One quick question.. could I set up another action to remove the "_username" part of the attachment filename? Seems it is adding the name of the person that submitted the form response

Thanks very much. It was very useful

Thank you very much! This is helpful for me May I ask you a question. I created a form in my group form and I cannot fill Fill Path in Get file content using path. how to fix that? Thank you in advance.

This works great! The only problem I have if the form does not have an attachment the form works and the power automate works, but it states it has failed. It has not failed. How to handle non-attachments?

Obrigada por compartilhar! Excelente vídeo, me ajudou muito!!!

Hi, thank you so much for the tutorial. Its very easy to understand. But I do have a questions tho, when it comes to choosing the path of one drive, for my form it has multiple folders and in each folder has its own files (i guess this happen because i create sections in my forms) and my flow will fail here. Do you able to assist on this?

Great training video

Nice clean demo!

Great video ! This works perfectly when all your forms contains attachments. But what about if attachments are optional? Thanks in advance for your help.

Thank you so much for this, I have finally managed to get files to attach in SP!! However, for some reason if the attachment is anything other than a word document it will not open in sharepoint or even in the original app. For example, I have used an excel spreadsheet as an attachment. It won't open from SP in Excel online, if I try to open in Excel it tells me that the file format is not valid (filename = TEST EXCEL_username.xlsx) If I navigate to OneDrive I can open the same document just fine. Word docs open OK, but PPT also fails. What am I doing wrong?

Thank you so much, This was REALLY helpfull!

Thanks for share this knowledge, it helped me! :)

I am trying to save attachment in title but it is showing error for number of characters could you please tell how do i fix that? Which type of column should it be , thanks for your help and excellent video i am just one step away to solve it

Great video! I was able to duplicate this for my project with no problem. One question: If I move the Form out of my OneDirve into a Group Form on a SharePoint Site and change the file path (and modify everything "up stream"), I get an error in the Flow that says File path not found. I've checked it several times (appears correct) and changed the Get File Path step from OneDrive to SharePoint. Any thoughts?

Hello, thank you for your video, it helped a lot , and it works, however when there is no attachment submitted in forms, the flow doesn't work which is very problematic for me now. Can you please help on this point ? Thank you so much

Hi thanks this is great - Can I ask though if the use of the OneDrive folder structure can be improved so that everything doesnt just end up in the /Question folder? Eg it would be great if we could specify (in my example I am using a change request form) /Apps/Microsoft Forms/Change Requests/[Variable based on Change ID] So that each time I receive a new change request, a new folder is created using a new name based on a column in my sharepoint list? This would be great for the housekeeping of my Onedrive

I was wondering if you could assist me to create a power automate flow that would create some folders and move some files into this folder every time a new folder is created. I want to create the folder based on the windows dialog box from a html5 form, and I do have some checks list that I want to select to control how many files will be moving into the new folders. Do you think you could help me?

Thanks for your guidance. I need your help please, I have same flow but I have to add the uploaded file as attachment in email and send this to approve specific user to approve it.

Hi thank you for that :) i can't find in your videos the condition when there is not attachments. can you tell us where is it or to write that here please ? have a good day

Very helpful video. Thank you. ​ @Lernen Tech Do you have a video that shows condition to move the data to the list if the attachment field is null? Thank you

Thank you so much, this was really helpful

Can I use something like this, from forms create calendar event in Outlook and upload an attached file in the form, to same calendar event

Hello. On the flow Records responses in sharepoint list is possible to save the attachments as well? I have tried and no luck. Thanks

Hi. This is really helpful thank you. I'd like to ask if I delete the file from my OneDrive will the attachment also be deleted from the Sharepoint item?

Searching for the solution for a group form in sharepoint site already. There is not find file by path and I don't see how to separate out just the files desired for that item.

Hello there, I just wanted to know whether the flow will work if I add other users file path in ‘get file content using path’? If no, what is the way to do that?

Ta muchly. For me I'll just present a List view webpart in a SharePoint Page for submission. With a view for only their ( [Me] ) files. The text above will say drag an drop your files here, or they can use the Toolbar, Upload etc. Automatically picks up the Filename an Attachment. If I really wanted to, I could use a Flow to populate the Title, but no need. And It'll get users used to using actual SharePoint.

Hi, I tried this method, all steps worked EXCEPT Get file content using Path. When I put the path, I get error message "Item not found", I'm sure I put the right path, but apparently it's not taking it since i'm putting it manually.

Very good, thanks for sharing. I have a similar need to take an Office group's Forms file to a SharePoint list. When I send a reply the attachment goes to the sharepoint list's decrees. How do I send the attachment to the list?

Thank you so much, this helps me alot!

Excellent buddy- i just subscribed to your channel. Are you also on Power Automate community by any chance?

This was great, thank you.

Great tutorial! How do we handle the JSON is there is no Attachment?

Hi It's helpful, Thanks!! If there is no attachment in the FORM, Flow fails. How to handle it?

hello. the error i'm getting is at the point where it's trying to obtain the content using the path. Can anyone help shed some light on how i can figure out why it's not finding the content?