Power Automate Tutorial - Microsoft Forms Attachments (2021)

[@angelineh.3049]

I never leave comments. I spent hours trying to figure this out, watched other videos, and had power automation specialists try to help. YOU ARE THE ONLY ONE WHO ENABLED ME TO GET IT TO WORK!!! 🎉 Thank you so much!

[@JonJLevesque]

So happy to hear that !!! 😍

[@Georzsk]

I have been working on this for 2 weeks.... I havent been able to achieve this until I found your video! THANK YOU SO MUCH!

[@solitairel]

This was very helpful - thank you both. Just a pointer - I did everything Yash said with no success. Watched again and again. Finally, I noticed at 11:18 that he modifies the punctuation on the "empty" strand but doesn't explain it. It could save people lots of time to spell that out a little better. Thanks again!

[@kathrynhall2019]

Thanks Solitairel, a huge help, I actually found your comment before watching the video so I was on the lookout for it. For new people coming here with the same sort of issue, instead of doing the copy & paste at this step, you can type empty() and in between the brackets, switch back to dynamic content and select the option in your form that relates to the attachments and it will fill correctly without any additional editing.

[@dprydan2k]

This worked beautifully! Only complaint is that I had to slow it down and repeat certain parts a couple of times, but it was worth the time! Thank you!

[@ebenjamin24]

This is "Chuuurch" my brotha! Preach!

[@janvanhaver6970]

It's those little tricks like that extra compose action that make me not want to miss any of these videos 😎 And glad to see you're making also Power Automate videos again - not that I would have anything against DocuSign of course (but that is part of the job of a colleague of mine, not on my plate).

[@JonJLevesque]

Haha. No problem! Trying to mix it up regularly :)

[@karlazevallos5115]

Thank YOU so much!!! It took me several hours to get it right but I was able to create the correct flow!! I'm so happy now. Thank you both for your help!

[@JonJLevesque]

Yay!! So stoked for you too!!

[@vikalpakulwar1567]

Thanks Yash !! It worked perfectly for me. Keep up the good work !!

[@jaspergapasin]

Great Video with thanks. Finally watched exactly what I'm looking for my project 😁😁😁👍🏼 God Bless and more power to your YT Channel Sir 🎉🎉

[@freddykramer6356]

thank you so much, both of you, it works like a charm, im trying to automate it ticket creation in our organisation, and users needed to be able to add screenprints as attachments, i tried following an online guide but the screenprints wouldn't come through, this worked immediately.

[@JonJLevesque]

You’re so welcome! So glad it worked!

[@kaspsanduiabdulkarim6669]

Guys, thanks for sharing. This has been very helpful.

[@JonJLevesque]

You’re super welcome!

[@NastySmash]

I had to create two different arrays for Teams and Outlook. One with "content" property for Teams, one with "ContentBytes" property for Outlook.

[@mattk9786]

Great video, really helped out. Thanks!

[@HumanBeingYoga]

Fantastic - thank you so much for posting this! This was incredibly helpful.

[@naziaakhtar8575]

Thank you so much. This video was very very helpful!!!

[@JonJLevesque]

So glad to hear!

[@Campacci2k]

Great! How to add attachments from 2 or more fields of MS Forms?

[@JonJLevesque]

Look for my multiple attachments video!

[@nikhilkethu5202]

Thank You So much Its really helpful

[@jillianwilms]

You are a saint!!!!!

[@JonJLevesque]

Okay! I’ll take it :)

[@SapnaPatel-he6yg]

Followed the steps and my attachment is blank. Anyone have troubleshooting ideas?

[@gogogolem]

Hi! @11:00 I don't get any string copied out of ctrl a - ctrl c. Any alternative?

[@gogogolem]

Solved by inspecting element and copying the "title" field.

[@MatthewLCarter]

Thank you for this, do you know how to get it to go into a Document Library as an attachment instead of via email? I'd like to pull in the metadata as well. So if they have an attachment with say "department" then it pulls in department metadata into a Document Library and the attachment shows up as a file in the Document Library.

[@raycalhoon9543]

Great video! I've followed this to the letter, everything works except I get no attachments in the email. Deleted and started over a few times with the same result. How can I correct this?

[@erwinrsli]

great tutorial! How about form with multiple fields to add attachment? I have 2 different fields for responder to upload their attachment and the path are divided by Question and Question 1, having problem to get it work.

[@JonJLevesque]

I do have a multiple attachments video in my collection! We have solved it :)

[@francesfemille]

Is it the same steps if I want to render the forms answers and attachments to a Teams Channel?

[@mahmutolcaycelik1909]

Hi, what about multiple questions with upload? one quesiton one file or multiple file work fine. However I have not been able to run flow with more than one questions with upload. It is getting the file path correctly but not able to add the file to the share point list. Any idea about the solution? thanks

[@JonJLevesque]

Sorry? Multiple questions should have no effect

[@kmbesspiata]

@@JonJLevesque I have this same issue. I have 4 separate questions in my form requesting an upload. How do I represent this in the flow?

[@Dedictation]

Hi, Thank you for the tutorial, everything works perfectly for me. But I have a quick question, the file uploaded to Forms contains the user's first and last name when sending it by email, is it possible to remove it?

[@elgnzalo]

I have the same problem :(

[@azuruwhitney8082]

@@elgnzalo use the action get user profile and select given name

[@dianakeith5067]

If I have two questions that could have attachments, do I have to repeat this process for each question or can you do both in one step?

[@abitaisyummy]

Great tutorial! I've chosen to get file using SharePoint. Everything works perfectly EXCEPT, Power Automate will not attach MS Office files to the email. I've tested png, pdf, gif, etc and those work perfectly. Also, I can see the MS Office files in the SharePoint library where they land (along with the files that aren't MS Office). Any idea what the reason could be? I've googled until I have googly eyes and can't seem to find a solution. Thanks!

[@dianakeith5067]

I have used your video for two of the three forms I created. I have been successful on the first two but keep getting an error message when running the final test on the third. The first issue I run into is when completing the step for Getting file content using the path. I follow the path to my form and select a question but I get a "No items". The attachment isn't there. To find the attachment I need to select Question 1 instead. When I fun the flow at the end I get a error message that says "The resource cannot be found".

[@andrewjameson5918]

I assume that this only meant for internal use only, so I still cannot use it with those that are external to my organisation. Would be great to have some clarification.

[@JonJLevesque]

That is correct. Internal only. It’s a limitation of forms

[@andrewjameson5918]

Thanks Jon.

[@JonJLevesque]

No problem pal! :)

[@elijahkwezi4870]

@@JonJLevesque I struggle to get the array to on the attachment part of the email, doesn’t appear in dynamic content, what could be the problem, I followed Yash steps

[@marekmierzynski5834]

I have a survey with more than 30 multi-file, not mandatory upload questions. I want to use power automate to build Excel with links to these attachments (using friendly name). I would love to call a child flow (that would do the parsing, and retrieving a link) in place where I assign response to Excel column. However that is not possible. Is there better way to handle that case ? All internet solutions says about one or two upload questions. But what if I have so Many?

[@longb1913]

if im doing an approval flow with multiple approvals, do i need to do a condition action after each approval which checks whether the submission has an attachment?

[@draushaus912]

You make this look easy. When I try, however, to add an attachment field to a form, the "upload file" option is greyed. Why?? The rest of the video doesn't help unless I can resolve that!

[@canemreadiguzel9960]

I have had an error like : "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'." , I just not used IF condition , attachment status yes or no , I'm using one controlling as sending e-mail, would be it related to this?

[@annaweitnauer]

I have the Flow to move into an Approvals flow and I"m not able to open the Attachments from the Approval email -- any ideas on how this could be done? Even when I choose the Email action it does not allow me to open the attachments.

[@chasecasey5218]

Hello, great video and very informative, however I keep receiving the following notification when I attempt to open the attached files. "Adobe Acrobat could not open “file name here” because it is either not a supported file type, or because the file has been damaged (for example, it was sent as an email attachment and wasn’t correctly decoded).". This is the final piece that I need solved, and any help would be much appreciated!

[@Diego_Padilla_Teran]

hi !!! same error cannot read files attachetd perfect .. can you solve it ??

[@Familyman-2891]

Stuck at 10:24 building the json. Keep getting "Enter a valid json".

[@zyrarodriguez8307]

Hi, Thanks for this. This is very helpful However, How do I change the Sender (Email From)? I tried to test the forms to other person but the email address doesn't change its still from my me.

[@JonJLevesque]

If you choose the mail connector instead of outlook you can have it come from a generic box. You could also add a mail sender account for just that step. Otherwise you need “send as” permissions for everyone

[@isaavilesvidal]

were you able to solve the problem?

[@andresfelipehurtadomejia6681]

Hi how i can get attachamment, for group forms. Ty

[@coconut762]

Did you ever get a solution to this? Also trying to figure it out.

[@RejektedRecords]

@Jon - how do you attach the same form responses as an attachment (pdf) to the form response via Power Automate ? Any response/s would be appreciated

[@adiariyanto6313]

I follow with carefully step by step the flow run without error but file that attach in email when it opened just a blank page, did I missed something ?

[@nawal7721]

can you do this but instead of email, send the attachment in a message to teams?

[@JonJLevesque]

yes - absolutely you could. the steps would be nearly identical, you just choose that action instead.

[@nawal7721]

@@JonJLevesque I tried to do that but unfortunately posting a message to a channel connector doesn't allow attachments. It only send text

[@francesfemille]

Have you ever found a fix on this issue? I just encountered the same and been looking for solutions.

[@lukestork6293]

Hi - Really useful video I have now implemented this but have fallen foul of what to do if there are zero attachments - the condition statment just hangs (i'm sure this is pilot error but any hep would be appreciated)

[@fayratta5062]

Hi guys...This video got me through my first Power Automate. Well, almost. I keep getting an error 404: File not found when running my flow with an attachment. And yet, the output shows the path to the file. And the file is there in my OneDrive. What could be going on? Thanks!

[@dellboysnr]

How do you add attachments for external users to your organisation

[@JonJLevesque]

Unfortunately as a limit of forms - this isn’t possible

[@mlmiles1]

Is it still true that attachments can only be uploaded by people inside the organization?

[@JonJLevesque]

Yeah still true

[@mlmiles1]

@@JonJLevesque Thanks!!! Very helpful!

[@revolweu]

Cool and stuff, you make two emails. one for attached, one for no attachment. I have to do 150 separate emails that has the attachment and then another 150 with no attachment? that is not automation

[@JonJLevesque]

No worries! You should totally make a video and show me how’s it’s done. I’ll come watch it.

[@revolweu]

@@JonJLevesque you the pro from YT not me

[@patsygrooff3830]

Followed the directions and it works great, except that when i upload attachments, no attachments are added to the email. "ActionBranchingConditionNotSatisfied". Where did I go wrong?

[@KarthikChivakula]

ActionBranchingConditionNotSatisfied. The execution of template action 'Parse_JSON' skipped: the branching condition for this action is not satisfied. Kindly help debug this error. I followed all your steps but encountering this

[@findthetruth3021]

How to put restriction on date field for restricting past dates? When creating a form to request something on a selected date, it would be useful if the date could be restricted so that only a present and future date can be selected. Thanks in advance. Please help me on that.

[@jyotsna_vats]

Hi yash, I am doing a project for a company and I need your help in Power BI. I was stuck somewhere. It would be really appreciate if you could help me pls.

[@marievepetit8136]

Hello! I get: The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)_3' of type 'OpenApiConnection' is not valid. Error details: The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/Name'. Anyone else?

[@sdpattern8449]

I am getting path error even if correct path as per your video mentioned

[@UtsavSharma1]

insert sample json box has no input active for me ..iam stuck at this step

[@sdpattern8449]

'Get_file_content_using_path' failed

[@PrzemysawCioch]

Good video. A bit too fast and no explanation what each function does, but helped me.

[@ITPMSupportdesk]

Followed this to the letter and it does not work. Attachments do not show in the email. This entire video is a waste to time if the end result doesn't work.

[@michaelhull7523]

I was optimistic, but he was moving WAY too fast for me. Guess I'll keep looking