Thanks Jon and Yash....this was much needed. Great stuff !!
@spencerkok13003 жыл бұрын
This video helped me greatly, not sure if anyone of you experienced this.. everything was running fine and suddenly the PDF file was corrupted. I resolved this by removing the "base64()" expression and remove the double quotes (this -> " ). In the array i just use dynamic content and select the file content. It worked properly and well after that. No file corruptions.
@user-rr5bl6hp9l Жыл бұрын
thank you this comment really helped me!
@AMERICACOLCHOES4 жыл бұрын
A new hit on KZbin!
@joeydbandiola3 жыл бұрын
THANKSSSSSS JON!!! I;ve been looking for this solution and watched your first one but it only has one attachment. So started to look for other videos here in youtube but now... I'm all good!!! Thanks!!! U D MAN!!! :)
@fabriciofernandes8914 жыл бұрын
Great Tutorial guys! But, I'm having an issue with the attachments sent. It all runs perfectly fine with the flow, but when I try to open the attachments it says that the files (PDF, Excel ...) are corrupted. Can someone help me?
@priestgiggs3 жыл бұрын
I am having the exact same issue as this
@djmrox22983 жыл бұрын
Hi, I have the same problem? You resolved this ?
@trevorway62813 жыл бұрын
I'm having the same issue
@jakubbanda85853 жыл бұрын
Hi Fabricio, you should remove base64 and use File Content directly, it helps me and the flow works perfectly
@saramiller93493 жыл бұрын
@@jakubbanda8585 I tried that and it still isn't working.
@Marcusbrooks85 Жыл бұрын
My Man!!! I've been searching for this for daysssssss!!! This video is a hit! :)
@JonJLevesque Жыл бұрын
Ahhh so glad to hear it!!
@Marcusbrooks859 ай бұрын
So I switched the form to a group and killed my flow. I got it back working and sending the attachments but they won't actually open from the email (file not support error). Any suggestions?@@JonJLevesque
@jaipalrana.4 жыл бұрын
Thanks Jon :) just followed Yash on Twitter... Thanks Yash for the value adds in Forms for the file uploads by good usage of jason coding
@rajeshmeruguU364 жыл бұрын
@Jon @Yash please can you Answer this - The issue I am having is the attachments are coming through with the email though I get the message to say that it cannot open as it is either an unsupported file type or the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded). Any assistance would be appreciated as I do not know where to start with resolving this issue.
@trevorway62813 жыл бұрын
I'm getting the same error, has this been resolved?
@yashagarwal1163 жыл бұрын
@@trevorway6281 , @rajesh Please try passing the file content directly to the "ContentBytes" or the "content" keys. Based on the action from where file content is coming from, the schema may change.
@ben41sbr23 жыл бұрын
When I input the base64 expression it gets saved successfully but when I check and edit the flow again it automatically change to file content only, not sure why this is happening. I can receive multiple emails but when I open them they are corrupted for some reason. I hope you can help me....
@capacitynigeria90463 жыл бұрын
Did you put the base64 expression in a quote? say "base64Xpression"
@jeannettebradley36844 жыл бұрын
This worked like a treat until I tried to pull the files variable into an approval. Do I need to change the expression associated with the variable? When I followed the tutorial part 1, I could attach the file all the way through the approval cycle. Thanks!! :)
@evob204 жыл бұрын
loving these tutorials!!!
@AYJNChanel05084 ай бұрын
help in error : he 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/ContentBytes'.
@mauriciorenderos3302 Жыл бұрын
Really wonderful video!!!! Really appreciate your job!! I just have a question if I need to attach a word populate document, is there any way to attach it in the same email?
@santhiyav134411 ай бұрын
Hi sir, I have tried this flow and my flow was success but when I try to open the file attachment (excel sheet) in mail it gives the error message file format may not be matching with the file extension. Please help me to solve this ...
@wesleylewellen3296 Жыл бұрын
Thank you for the walk thru, I'm getting the emails but not my attachments, and im not seeing any breaks and having successful runs thru power automate any suggestions?
@catherinefreeman97063 жыл бұрын
Anyone else getting an error on the get file content stage? Mine is saying the File ID is not valid and I am not sure what or where it is wrong.
@sandarudewpriya29553 жыл бұрын
Me too
@ExcelExciting4 жыл бұрын
Super Duper LIKE 👍🏻
@sanjjoyrio3745 Жыл бұрын
I have one question actually is there any connectors that make me update a form automatically when I add or modify a SharePoint list
@JonJLevesque Жыл бұрын
No, unfortunately there’s no such thing
@sanjjoyrio3745 Жыл бұрын
@@JonJLevesque is there any other way can I achieve it like other than power automate
@christianzinck60233 жыл бұрын
this was great, I got it to work super well... LOVE IT. thank you so very much
@sanjjoyrio3745 Жыл бұрын
I have a ms forms in which people upload the files. I need to fetch the content of this file which has been uploaded. And move it the content to another Excel spreadsheet or SharePoint list please help me to achieve this
@mohamedhossam27653 жыл бұрын
Really great job, thanks Yash and Jon. Is there an idea to colleact all attachments in multi forms filed that includes multi attachments per each filed :)?
@MrNaquevedo3 жыл бұрын
My file are soming through as multiple attachments, but when I click to open them I get this error: "Cannot open file: "c:\Users\Joe\AppData..........pdf" Any help on this?
@MrNaquevedo3 жыл бұрын
I get the same error; any help on this?
@ericrojas57923 жыл бұрын
same!
@ShaneStenhjem Жыл бұрын
Same. Everything works great, except the file. I am thinking it is sending everything but the content. We did add Name and ContentBytes but still sending unreadable file. Help
@iwanttolearn496 Жыл бұрын
@@ShaneStenhjem I'm getting this same issue. Did you figure it out?
@ShaneStenhjem Жыл бұрын
@@iwanttolearn496 Oh man. Where do I start. I tried everything. Eventually I did fix it. Within the Apply to each I used Get file Metadata > Get File Content > Append to array variable. So I am not sure exactly what fixed it but I am thinking a combination of File Metadata and also verify in your flow you have set the attachment size limit to 1GB. I used an KZbin video to help me. @cvkealey Chad Kealey "Power Automate and Microsoft Forms: Send uploaded files as email attachments". Good luck
@theresaa.efiokwu98633 жыл бұрын
Thank you Jon and Yash. I found this very helpful. However, I have a concern - at the last step, I tried creating an approval and added the 'files' but my flow failed. I also noticed that when you use the send email V3 it only adds one attachment NOT multiple. Also, when you use send email with options, the email gotten doesn't come with the attachments. Can we have a video where multiple attachments from Microsoft Forms can be attached to an Approval on Microsoft Flow? If you have one already, please reply this comment with the link
@janessabirch Жыл бұрын
Hello, I followed your previous videos on forms attachments. I have a flow built to create a list item in SharePoint and send an email with attachment and it works with 1 attachment only. I tried to follow this video to adjust my current flow but when I try to open the attachment in the email it says "It appears we don't support this file format" can you please help me with this? Also could you advise what needs to be changed in the "create item" and "Add attachment" parts of the flow for the multiple attachments?
@andriany.rahayu13362 жыл бұрын
you guys rock!
@JonJLevesque2 жыл бұрын
No you rock!
@spicyavenue92253 жыл бұрын
Hi, I cannot add more than one action to the SCOPE. please need an answer? Thanks....
@viniciisramossilva3 жыл бұрын
HELLO....WHAT IF I WANT TO SAVE THE ATTACHMENT ARRAY INTO A SHAREPOINT ITEM? IF I USE THE "ADD ATACHMENT" IT SEENS IT ONLY ALLOW STRING AND NOT ARRAYS...i need to save multiple attachment from my MS Forms response in my shrepoint list, not only send an email
@dnasol53702 жыл бұрын
I tried the flow and it works! But my problem is the word document is distorted, why is that? Thanks
@ashvinsaini012 жыл бұрын
Hello Yash! Hello Jon! I have attached pictures in attachments which is not opening and showing " It appear that we don't support this file format".
@saramiller93493 жыл бұрын
I have this working for one form; and it is great! I created another form and copied the flow but wanted to add conditions based on answers in the form. There are three separate conditions. The email sends properly. But the attachments are not...would I add the scope to each condition?
@ebenjamin243 жыл бұрын
Everything flows just fine but the emailed attachments are broken and I can't figure it out. "We couldn't open the image file." The thumbnails are there but I can't open. Could this be because of my Onedrive? Thanks
@crispo1982Ай бұрын
Hi, you need to remove "base64" and the double quotes, then it will works!
@poojanair043 жыл бұрын
Hi, can u assist on saving mutiple files on sharepoint..unable to save multiple files on sharepoint (tried for 1 file which worked well). Thank you
@lka553643 жыл бұрын
Can you also show the way to upload multiple files using Power Automator(Flow) input and attached those as an email attachment? (or list all of the files in the body as a list in a case of attachment or sharable links for the body text of the email)
@louisegarrettc.58743 жыл бұрын
I am pretty sure I followed the video step by step and I am having an issue where the attachments are not coming on the email. Any idea why that might happen?
@louisegarrettc.58743 жыл бұрын
Figured it out, had to remove some quote marks and add a comma in the "Append to array variable". Thank you for the Video it helped a lot!
@pandapoo50023 жыл бұрын
This is great, I was able to replicate but cannot make it work to attach in a "Start and wait for an approval". Any thoughts? This was the error details: The request failed. Error code: 'InvalidRequestContent'. Error Message: 'The request content was invalid and could not be deserialized: 'Could not find member 'ContentBytes' on object of type 'ApprovalsConnectorAttachment'. Path 'attachments[0].ContentBytes', line 1, position 1213.'.'.
@tcreson Жыл бұрын
Didn't work...Yes, it attached the file (JPG), but computer couldn't open it as it was not recognized. I can even download the file (correct name, extension, etc.), but it does the same thing.
@JonJLevesque Жыл бұрын
Yeah this is three years old now, it’s likely some things changed at this point.
@ckimlen3 жыл бұрын
I got attached files to my email but I can not open that files, How to solve this issues?
@JonJLevesque3 жыл бұрын
Did you make sure the content is passing as the right type?
@saramiller93493 жыл бұрын
I followed the video and I have it working..only problem is that I can't get the attachments to open from the email in outlook. I can click on the link from gmail and view the file but can't download it. I can click on the link from my iphone but I can't download it. I cant do anything from outlook in o365. any ideas?
@andrewjameson59184 жыл бұрын
Is this still internal oir can I use it with external users.
@cjsilvestre4 жыл бұрын
Seems to be only internal. Forms do not allows external/anonymous users to upload files. Just sent a note on microsofts user voice page about it. There is a pool asking for votes there. Here is the link microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/39933964-external-users-be-able-to-upload-files
@edwardhodson64933 жыл бұрын
Thanks Jon and Yash. Super helpful but I'm trying to do a slight variation of what you've done and I'm struggling. Instead of attaching the multiple files, I want to output a clickable hyperlink to each file (which is stored in OneDrive). I want the hyperlink to consist of the filename and the URL of the file. I can do the above for single files, but can't work out how to do it for multiple. Any advice would be appreciated!
@MonsieurCee3 жыл бұрын
I followed this only using sharepoint get file content instead of one drive, however when I get to the email section I can't add the variable to the attachments... Send email V3, great video though!
@JonJLevesque3 жыл бұрын
Thanks Andrew!
@stephongadson14112 жыл бұрын
how do you embed and image in an email from a form with power automate
@i_am_batman_ph3 жыл бұрын
Thanks Jon! However, just like the rest. The attachments are sent via email but its no longer viewable. The expressions base64() doesn't work. It always revert back to outputs('Get_file_content_using_path')?['body'] Hope you can answer this, otherwise we could not use this tutorial at all.
@i_am_batman_ph3 жыл бұрын
SOLVED: I was able to resolve it by removing the base64() expression and the double quotes. In the array just use the dynamic content = File content (color blue text)
@spencerkok13003 жыл бұрын
@@i_am_batman_ph OMG thank you so much for this. it helped me too!!!
@colzo63613 жыл бұрын
@@i_am_batman_ph OMG - thank you sooo very much. I am new to all of this, so I appreciate is greatly.
@babufootball99912 жыл бұрын
@@colzo6361 Heey Thanks it worked! Base64 is not required
@MMcGinn103 жыл бұрын
Thanks for the tutorial. It was super helpful! I have an issue though. In my form, I have multiple fields for attachments. All of them show up in the sharepoint documents folder except for one. Why would only one not be showing up? I can't map the flow if I can't find the attachment. Thanks for your help.
@NeshaStanic3 жыл бұрын
Ah, I lost connection between one of my Forms to my OneDrive. One question in a Form that has option for users to upload files is not working, users can't upload. How to restore this connection? Anybody?
@evertonmedeiros72233 жыл бұрын
My flow fails when I don't have attachments. In my case, attachments is not necessary to upload. How to fix it? Thanks
@colzo63613 жыл бұрын
Great info! I wanted to know how I would adjust this flow to send an approval request instead of just an email - with all the attachments. I keep getting an error "There's an error in your flow preventing the creation of Approvals. Use the link below to learn more about the errors with your flow and/or environment configuration" after adding the approval and using "files" in the attachments.
@yvonnekoh52354 жыл бұрын
Thanks for this video. It is really useful. I would like to know if I would like to pass the attachment to a SharePoint List, can you show us how to do that?
@JonJLevesque4 жыл бұрын
Right now it only passes to OneDrive.
@peterder713 жыл бұрын
If you create a SharePoint item immediately after getting MS Form response details and then "Add Attachment" immediately after "Append to array variable" within that "Apply to each" loop, it will work.
@poojanair043 жыл бұрын
@@peterder71 giving me error for multiple file (add attachment) Item does not exist. It may have been deleted by another user. clientRequestId: 9bb2ca21-dd80-41b5-970d-dbe1aac772fd serviceRequestId: 15f5949f-b06c-0000-5545-a18d7c082291
@johnkniphfer44283 жыл бұрын
I solved the issue of the documents not opening by removing the base64 in the array. I read through the post and don't see anyone else mentioning this - When it sends the email - I get the same number of emails as the number of attachments - each email has a varying number of pictures. The final email has all the pictures though. Anyone else have this issue and solve it?
@lucavorraro442610 ай бұрын
Hi, but why do all the replies come to me with the same email address? How can I view the email address of someone who responds?
@pedropadilha024 жыл бұрын
Hello, fist of all, awesome video, very very nice, simple and usefull solution, but i've tried to use on a approval with multiple attachments, but its dosent work, send an email action works clean and nice with all attchments, the approval give me the error below: The request failed. Error code: 'InvalidRequestContent'. Error Message: 'The request content was invalid and could not be deserialized: 'Could not find member 'ContentBytes' on object of type 'ApprovalsConnectorAttachment'. Path 'attachments[0].ContentBytes', line 1, position 972.'.'. do you think actualy that method dosent work on Start and wait for an approval´s action?? Thanks a lot once again, great video, great explanation.
@hannahliteral33424 жыл бұрын
whenever i add initialize variable it says the operation should be used at top level
@johngorringe76194 жыл бұрын
I'm having a few issues getting this to work. When the flow runs I get the following error message. Any ideas on how to fix. The request failed. Error code: 'InvalidRequestContent'. Error Message: 'The request content was invalid and could not be deserialized: 'Unexpected character encountered while parsing value: {. Path 'attachments[0].Content', line 1, position 1202.'.'.
@yashagarwal1164 жыл бұрын
I believe that there must be some error while creating the array of attachments. I would highly recommend you drop a post here (powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity ) so we can better identify the issue and help with this.
@MrNaquevedo3 жыл бұрын
@@yashagarwal116 I'm having the same issue
@saramiller93493 жыл бұрын
anyone think that add get attachment action somewhere in the scope would work to fix?
@davidadams4213 жыл бұрын
This to me seems like a bit of a hack. As file attachments are now a standard feature of Forms, the Get Responses action should surface the attachments if present like any other dynamic content. This Parse JSON then store the attachments as base64 data in an array variable is unnecessarily complicated, imho. Great video, though, definitely solves the problem. Yash> you are a demon on that keyboard, sir!
@k_zildjian44603 жыл бұрын
Thanks guys! My workflow runs without error and the email appears with the attachment. But the attached file is always corrupt and will not open. Suggestions?
@crispo1982Ай бұрын
Hi, you need to remove "base64" and the double quotes, then it will works!
@CaptCJ19694 жыл бұрын
Hi Jon, in the video (Append to array variable), the example for the base64 code is base64(body("Get... when I follow it I get base64(outputs("Get... I'm then getting a 'Enter a valid json.
@CaptCJ19694 жыл бұрын
Hi Jon, any thoughts on my 'Enter a valid json' error?
@therealn4cer4 жыл бұрын
This is excellent, thank you. The issue I am having is the attachments are coming through with the email though I get the message to say that it cannot open as it is either an unsupported file type or the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded). Any assistance would be appreciated as I do not know where to start with resolving this issue.
@Jithu17134 жыл бұрын
I faced the same issue. Have you tried using File Content directly without base64 encoding? Worked for me!
@therealn4cer4 жыл бұрын
Poorna G awesome I will give that a try today and see how I go. Appreciate the response!
@vajocofa4 жыл бұрын
@@Jithu1713 It doens't work. When opening PDF documents, Acrobat Reader said the file is damaged and could not be repaired.
@shellyatkinson25174 жыл бұрын
Same is happening to me...otherwise it works beautifully for my flow. @Yash any words of wisdom?
@therealn4cer4 жыл бұрын
Yes unfortunately mine still isn’t working so I can’t help you either sorry. Hopefully we can get some assistance soon!
@errole4 жыл бұрын
Does this work for outside the org or inside the org.
@yashagarwal1164 жыл бұрын
Right now it works for users within the Organization only..
@yogananda12963 жыл бұрын
Combine with image content in word connector please...😁😁😁
@dianajimenez95743 жыл бұрын
Another solution: instead of using get file content using path, try get file content and simply pass the id. I could not get my flow to work for the life of me using the method outlined in this video.
@saramiller93493 жыл бұрын
what does that look like? is the file path still the same ending in name? what does the append array variable look like? does it change?
@dianajimenez95743 жыл бұрын
@@saramiller9349 use the function “get file content” and pass the ID of the attachment
@saramiller93493 жыл бұрын
@@dianajimenez9574 thanks...must have done something wrong because it didn't work...
@unfeomateo2 жыл бұрын
He goes way too fast. Not great. Please allow us to follow along without having to rewind constantly