Power Automate Tutorial - Microsoft Forms Attachments

[@nicolekoval1879]

Thank you! I was working on this ALL day. The other previous video I watched on this subject did not work. But this tutorial did. Success!!

[@JonJLevesque]

Woohoo Nicole! Glad to know i could help! :)

[@JustinShaedo]

******* Get submitted Form******* -:-- create list 2:50 - Form creation 3:48 - file attachment in Form 5:34 - Flow creation -> new -> blank -> When a new response submitted 6:05 - Flow: Get response details (*always use after 'when a new response...' ******* Extract file information from submitted form ******* 7:10 - Flow: Compose (Data operations) - used temporarily to make JSON schema Inputs: dynamic ref to file from form 7:43 - 'Test' in Flow -> 'Preview' in Forms ****9:28** ** copy the string from above to format to JSON below to set schema 9:30 - Flow: Parse JSON - Content: dynamic file reference - Schema: Generate from sample - paste string from 9:28 10:15 - Flow: Delete Compose Data (now JSON schema is made) ***** Manipulate file to save and send in email ****** 10:21 - Flow: Get file content using path (One drive for business) 11:06 - click on folder icon -> Apps -> Microsoft Forms -> [Form name] -> [Question Name] -> [File Name] 14:01 create Expression to reference file name *first(body('Parse_JSON'))?['name']* 'first' - returns first element in string or array 'body' - == actions('actionName').outputs.body /Apps/Microsoft Forms/[Form name]/[Question Name]/first(body('Parse_JSON'))?['name'] ?Can this be replaced with first(body('Parse_JSON'))?['link'] 14:39 Create Item (SharePoint) 15:51 Add Attachment (SharePoint) 16:35 Send an email (V2) (Office 365 Outlook) 18:08 testing the finished Flow 21:05 Further parse JSON explanation Above are my notes on this great video so I can efficiently refer back to it. Much respect to Jon the incredible creator and Yash the Super Super User.

[@DuncanCunningham]

didn't he type in first(body('Parse_JSON')?['name']) Does it matter? EDIT: Never mind, He fixed it to the one you documented which indeed is first(body('Parse_JSON'))?['name']

[@lewisrae7810]

Thank you so much - hours and hours of failed attempts and rabbit holes until I came across this video.

[@liladaoudi]

Amazing..i ve been struggling to do that for ages!!!

[@JonJLevesque]

So glad this helped!!

[@JonDoesFlow]

Thanks a lot Yash, really not as simple as I thought. Nice one for sharing Jon

[@JonJLevesque]

Yeah im glad he showed this. It is not easy...

[@hammaadchoudharyltd5850]

Been looking for something like this for ages! Life saver!

[@marienaalvarez8235]

Great video, thanks. Do you now if there is any workaround to get attachments from external users.

[@karos6744]

This was so so helpful!!! I couldn't figure it out on my own. Thank you :D

[@alihusain.k]

Thanks a lot for this help! It was an amazing video. Thank you Yash!

[@ishaniur]

Superb and this was truly helpful .. ❤️❤️❤️❤️

[@knollsontv]

This helped me out a lot! Thanks for your in-depth explanation :)

[@JonJLevesque]

You are very welcome!

[@euclidesdejes]

Hi "@Jon Levesque" , can not do the same using a Get File Content from Sharepoint, help please. I am using a Ms Form located on a O365 Group.

[@jurgenguns1925]

Thank you! This really good work and clear instructions through the process. Apreciate it!

[@mauricioflorencio5475]

Hello, very good, the tips were excellent. I have a question, maybe you can help me: When an item is inserted with an attachment it works perfectly, but when the item has no attachment it gives an error because it has no content. I thought of creating a condition for the flow to check when a form was filled out without an attachment and go to a simpler path and use this path for when the item has an attachment. How can I make the flow understand if the form has an attachment or not? Thank you very much

[@chasecasey5218]

Following for an answer.

[@ukaszdutowski6110]

@@chasecasey5218 You can create a condition and check whether lenght of attachments is not 0

[@erikmoore5896]

Awesome Video! Thank you so much, it worked great!

[@dannyhometown]

Love this one, what I am looking for.

[@JonJLevesque]

Excellent!!

[@JeffreyBox]

Oooof, that's a convoluted process, but this works! Thanks

[@JonJLevesque]

yeah - sometimes we do terrible things to make it work haha

[@JeffreyBox]

@@JonJLevesque Hey whatever. It gets the job done, and life is easier.

[@ronaangeles5377]

This is super helpful!! Thank you so much!

[@JonJLevesque]

You’re very welcome!

[@GreyDob]

Great tip !!! bringing Forms and Power Automate to the next step. When the user is not adding a picture it hangs, what is the easiest way to avoid this ?

[@VipinNair]

Thanks a lot for this. Very helpful! :)

[@madeux324]

Excellent video. Thank you very much!

[@crystalmarini5208]

This has drastically changed since this video was created, yet it is still the best video available. Would it be possible to revisit this and redo using the updated PowerAutomate? It's tough to follow along when things have changed so much.

[@JonJLevesque]

I’ll talk to Yash and see what he thinks!

[@Tamilan6382]

@@JonJLevesque hi Jon I have one request actually can you please do a video on how to use Excel as input and fill a web form where we have date feilds and drop-down radio button etc...

[@jasatan]

Oh gosh! THANK YOU FOR THIS wonderful, instructional clip. IT HELPS A LOT.

[@Wazzanx]

Great stuff. But in my case I have three questions, and for each the user has to upload a file. how can I take all of those?

[@MSH3423]

Microsoft Form.... Is it always top to bottom linear format? Can I design it like DMV Form? Like traditional forms?

[@JonJLevesque]

It’s always top to bottom. You can create branching but not multiple columns

[@cvkealey]

Any chance there could be an updated version of this that covers file attachments on Group/Team Forms? The files themselves are stored in the Documents library for the Group/Team SharePoint site, but if you want to work with them, you can't use the SharePoint actions directly. You need to use the OneDrive actions. I use a "Get file metadata" action and pass in the . from the parse json action. Yes, this runs in an "apply to each" loop, but that means it'll work with one attachment or 10.

[@andresfelipehurtadomejia6681]

I need that solution, but i cant get id attachamment for group forms

[@cvkealey]

@@andresfelipehurtadomejia6681 see this video: kzbin.info/www/bejne/l6uVZKN-i7GXidE

[@andresfelipehurtadomejia6681]

@@cvkealey ty so much

[@resrudeboy]

Did you ever find a video on doing this? Thanks

[@cvkealey]

@@resrudeboy there are a few of them around, including these: kzbin.info/aero/PLMVyjgrWIGnwQowO2RsvHg0pZ8EozvAG-

[@mamirnazmibromli6260]

Hi.. this is a great video.. just a question, how to use multiple attachment in approval? Using same append array..

[@JonJLevesque]

Did you check the description?

[@mamirnazmibromli6260]

Yes.. just realized for multiple attachment.. thanks Jon 😅

[@raymin9241]

Thanks, Jon and Yash! This is a great tutorial, and I made it. A question: what the expression would be if I need to upload multiple attachments?

[@yashagarwal116]

Hi Ray! I was able to look into the multiple attachments part and posted this blog and you can check it out here: www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate

[@cyberiho]

@@yashagarwal116 It would be great for us novices with json to add a section in this blog on the scenario of mulitple attachments but one per question. Most probably is just adding many times the original set of steps (one for every attachment) but it would be nice to include this too.)

[@j3jenkins]

@@yashagarwal116 Hey Yash! I can't seem to grab the array input after the apply to each loop to place into the attachments field. It acts like it's not even there. Thoughts?

[@chandrashekhar5634]

This is working great Thank You. Want to know if we can embed the uploaded MS Forms picture in mail body instead of attachment?

[@tarahammond6627]

LOVE this! Our problem is that someone other than me created the form, but I'm trying to help with the Flow. I have access to her OneDrive, but it's not recognizing her drive when I'm looking for the file. Is it possible to connect to her OneDrive and not mine to get the file?

[@JonJLevesque]

If you share it as a team flow, change the one drive step to her connection and fetch the file from there - it should work.

[@brianodhiambo4079]

How can I achieve this when the files go to sharepoint. I am using a group form that saves attachments to the shared documents folder. Your assitance will be highly appreciated.

[@SenergyPetroleum]

How do you connect multiple attachments? I tried to repeat the pattern that did not work.

[@miguelsalazar7053]

Jon, definitelly a must...honestly so useful! the flow works great with uploaded attachments.....but (in my case) if I do not upload an attachment, the flow does not work because it is expecting a document but it gets a null instead - (not all the forms require to upload a file) would you please advise on this? greetings from Mexico!!

[@FlameHidden]

Our current sollution is to mandate whatever it is that we are requesting to be a file, however simpel it may be.

[@miss_mann2402]

Great video, thank you. This worked for me, but I can't figure out how to get the flow to work when some submissions will have an attachment, and some will not. Is there also a video that can help with that scenario? I work at FedEx, and have been struggling with this for many days. Please and thank you. Monique

[@boronderi1746]

Thank you for this video. Does this support NULL entries in the 'upload attachment' question?

[@tru12]

i guess not, but you can mark the questin as beeing essential in Forms to avoid "NULL" answers

[@sundarun]

Whoa! Can we have multiple such upload file fields which may contain 1 to 10 files each? If possible how can we handle that? Essentially I am looking for uploading attachment field under each question. Any assistance is greatly appreciated

[@tru12]

same requirement here

[@sukanv4271]

@@tru12 Also need help here please!

[@resrussia]

I attempted the procedure outlined in the video> However, on the step where Get Response Details is added, I don't have a List of Responses as option. How does one add Get Response Details with a List of Responses as something to add to it?

[@Snacka]

Yash, this is good stuff :)

[@Naklina]

Hi, this video is great! Just one issue I have on the step onedrive business "get file content using path" in the list I can't find "Apps" could you help please?

[@axelgonzalez3318]

im looking for the same answer , please let me know if you solve this problem

[@astonish1109]

I've got this to work on a shared ms forms. Which resides in SP and not OneDrive using your tutorial here. One question though, I get an error if the user doesn't need to upload a file. This happens as well if I choose to not use parse Json. Any ideas on how to allow forms through even if the upload is equal to null? Below error returns in power automate when a user doesn't upload file in MS Forms if I use your parse method. "Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '23675': 'Required property 'content' expects a value but got null. Path ''.'. And the following error occurs in power Automate if I don't use parse Json. Parameter 'Attachment Content' cannot be null or empty. clientRequestId: 8e76ad04-9617-48a3-bcd8-7ea287d81f41 I believe that the issue lies in the MS Forms when a file isn't uploaded by the responders. Please help

[@yogithas2864]

How we can get multiple attachment links. To add it in create a team meeting in power automate?

[@glenngallemit5470]

I tried this procedure and it worked but there is 1 problem though, it only transferred 1 attachment to sharepoint. What is the process if i need to transfer more than 1 attachment to sharepoint?

[@ABriefHistoryOfhistory]

This would be an awesome video to have as I have the same problem

[@Fernando-ry4gt]

/watch?v=UKuzX8zlnuE

[@ChrisCollao]

@@Fernando-ry4gt Pretty impressive. But if you want to also email the several attachments?

[@Fernando-ry4gt]

@@ChrisCollao that's one thing I am looking for too, maybe adding the content of the file as attachment to email? Idk, would have to test...

[@Fernando-ry4gt]

@@ChrisCollao www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate

[@nicu9028]

Hi Jon, Is it possible to upload the files to sharepoint instead of One drive?

[@1911mall]

Great content, thank you so much. Just one issue i'm having, if the user submits multiple attachments only one seems to be coming through on the email.

[@vipulbhuwania7883]

Thanks Jon and Yash. I m new to using flow for my small business. Can you help me with following 1. Create a flow to send email attachment based on choice submitted in form. ( Real life scenario - i have a form where client chooses from product list options to receive single or multiple product catalog as attachment in email.) Thanking in advance.

[@kanchankhadka235]

What if you are sending the form to external users - out of organization?

[@ashthomas024]

Can you delete from the OneDrive directly after the flow has completed?

[@dijonhelmey3742]

Hi Jon, what happens if we need to cater for forms where attachments aren't mandatory? My parse json fails when i receive a form that wasn't submitted with a attachment.

[@jdisaster13]

Hi, is there a way to delete the attachments uploaded in forms 365 via flow? because it is not not always practical to manually delete the attachments uploaded in forms and it will accumulate many files. Thanks

[@BullsBadri]

Hi, Is there a way to store the URL variables or the URL itself using Flow/Power Automate in Excel ?

[@karandhanak6015]

Is it possible to attach a form itself on an email ? Some form fields being read only for context of mail recipient and others editable fields for mail recipient to respond to. Once he submits response, we store it in an excel or share point list.

[@angrybatvoice]

This works well for grabbing a single file attached via a Forms form question. What if multiple files are attached through a single question?

[@angrybatvoice]

Of course Yash already has that answered on his blog: www.bythedevs.com/post/working-with-files-on-ms-forms-group-form-in-ms-power-automate Thanks so much!

[@JonJLevesque]

Thanks so much for posting the answer you found!

[@nghanzo405]

@@JonJLevesque Is there a way to get multiple images from a Group forms to one single SP list item?

[@vickys2555]

@@angrybatvoice how to do with or without attachments? attachments are not mandatory but an option

[@angrybatvoice]

@@vickys2555 To handle optional attachments, in your flow, you have to create a condition that checks if the response that would contain the attachment is empty. If yes, do nothing and move on to the next step. If no, collect the attachments in whatever manner you're needing to (in my case, I put the attachments in Sharepoint and append the link to the created items into an array variable so I can email out links to the files later on in the flow.). Hope that helps!

[@jdisaster13]

Sir, is there a way to pass the attachment name and attachment contents into a variable? Been struggling on how to do it. Thanks

[@marcnzapasnik6455]

Thank you it is very helpful. I have one problem - when i dont attached file there is an error - someone knows how to fix it? Thank you!

[@glenngallemit5470]

I have another question, is there any flow that deletes the content of onedrive after transferring the attachment to sharepoint?

[@pitecusco2]

Thank you so much!!!

[@lornabrooke9848]

This is working great thank you, however on my form you dont always have to upload the file, it is a risk assessment therefore if the risk assessment is not required you can carry on to the next section however it falls over and fails if it cant find an upload does anyone know a fix for this?

[@carolisabel6710]

did you find a form to work when a file is not uploaded?

[@DanOverlander]

@@carolisabel6710 I'm rather new to Power Automate but it looks like you'll need a Compose with the input of the file-upload field, and then a condition with the input of length(outputs('Compose')). Check if the length is not equal to 0, and do your conditional processing. See powerusers.microsoft.com/t5/Building-Flows/How-to-attach-files-from-Microsoft-Forms-into-a-Planner-Task/td-p/564949

[@jhonatanorabadillo]

Good morning, Con. An inquiry, please. Could you tell us how all the files could be attached in a single email for approval submission that are sent through Forms. Currently, the flow that I have generated, sends an email for each file uploaded and that is an error for now, since a single email should be sent for each Forms record (Sometimes they could load a single file or more). Thank you very much in advance. Regards,

[@yujaliria8486]

Hi Jon, by any chance you can guide me insert image into PDF from upload file, tried to follow similarly as in this video but still have no luck, Cheers

[@patriciadaibes]

Hey guys! Is it possible to attach a file on a public form? I want any external person with the URL's form to be able to send files. 🤔

[@marshallsmith8794]

The instructions given in this video do not work. I have followed your direction exactly. However there is not a "List of Response Notifications" under the "Get Response Details" only "Response Id". the flow runs successfully but there is no array created in the compose field.

[@JonJLevesque]

Hey there. We made a new video about this cause they changed things. Power Automate Tutorial - Microsoft Forms Attachments (2021) kzbin.info/www/bejne/nITIeHh4ethgoaM

[@JonJLevesque]

I had that same video linked at the top of the description as well. Sorry you didn’t see it before jumping into this older version

[@SenergyPetroleum]

what do you do if you have 2 upload questions?

[@rixd]

I'm new to this, but I've seen that the "Apply to each" would take care of that for you.

[@dhuston521]

This worked perfectly for a single attachment. However, not working for multiple attachments. Can someone help?

[@kaushikmistry4358]

Hi Yash,I get the following error Can you help to resolve Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '2851': 'Required property 'content' expects a value but got null. Path ''.'.

[@gabrielkpaes]

Jon, I was trying to working on this 1/2 of my day. For some reason I got stuck on the GET FILE CONTENT USING PATH. I'm using Sharepoint instead of using OneDrive to store the attachment. Any idea on how could I replace what you guys have done with the Sharepoint?

[@seth_sesu]

Having the same problem here. Using '(Sharepoint) Get File Content Using Path' but when I run the flow, it fails.

[@seanmcevoy5076]

Could you move the file or copy the file from OneDrive to SharePoint that has worked for me in the past?

[@lochveasna]

when i use upload file option, why at outside organization close, not allow to click on it ?

[@fpereda]

Hi!, I've been looking all over the internet for an easy way to send emails with customised attachments - no luck. I need to send a certificate of participation as an attachment to 100 students (a certificate per student). How can I add a specific attachment to each email? I have the pdf files in a library in share point + the mailing list in an excel sheet.

[@angelacremonini1763]

That was create...but can someone tell me if is possible to have the date in the format day/month/year?

[@zoricalatinovic2305]

Hi! I tried this and it did not work. The report states 404 Error - You cannot get content for a folder. Can you help me, please?

[@djmrox2298]

Hi, i have to send 5 files on email. How can i do this?

[@ashleesalu]

Hi All, I am still having trouble with my file path?! Can someone please help?

[@ketakidahale5949]

for me the file upload option is not available , what do i do

[@JonJLevesque]

Make the form not public

[@ketakidahale5949]

How to do that

[@hannahliteral3342]

worked with 1 attachment but failed with 2 attachments - how to fix it

[@rosavalentinroman9904]

Me gustaría saber como crear una tarea a partir de un formulario

[@xuqingxiong7274]

I am getting an error message saying "it looks like we don't support the file format" when I tried to open the photos (png format) attached to the email. Has anyone come across the same issue?

[@brettgoldberger9576]

Can someone completing the form upload a file if they are not "within the organization?"

[@swankyshivy]

hi did this ever work?

[@ABriefHistoryOfhistory]

Can someone put up the first expression

[@GreyDob]

this one ? first(body('Parse_JSon'))?['name']

[@norwildulay8359]

Get file content using path is not working when Form is shared to a Group.

[@Путинхуйло-х1ы]

i think that when Form is shared in a Group , files are stored in Sharepoint and not in Onedrive . Therefore you should use the connector SHAREPOINT- get file content using path instead of ONEDRIVE-get file content using path ......

[@norwildulay8359]

Federico Giuliani, Thanks!

[@rajg1231]

@@norwildulay8359 did you get this to work? I keep getting 404 errors file not found but my inputs and outputs look right.

[@resrudeboy]

@@rajg1231 im getting the same, did you ever solve this?

[@kelseydott7936]

Instead of OneDrive, how could I make this flow go into my Teams?

[@neilp6208]

You may know the answer by now, but Microsoft Forms allows forms to be "moved" to a group. Move the form to group associated with your Teams and the files will be saved to that Teams' SharePoint site, in the Shared Documents library, instead of your OneDrive for Business.

[@randomwonders6320]

13:30

[@kensleylewis7916]

waisted 30 minutes of my time as "Array elements can only be selected using an integer index". A big part of the problem is that guest developer created a demo that ONLY works for uploading 1 and only 1 attachment. Anything beyond that, than his system breaks.

[@JonJLevesque]

You need this video for multiple attachments! kzbin.info/www/bejne/oX-maaRsg991e8U

[@irailtonferreira1536]

Thank you! Great

[@JonJLevesque]

You’re welcome!