Power Automate Tutorial - Microsoft Forms Multiple Attachments
Vložit
- čas přidán 1. 08. 2024
- Whats up friends!
VIEW THE UPDATED VIDEO: • Power Automate Tutoria...
Join me and MVP Yash Agarwal as he shows us how to attach multiple files to a Microsoft Form in a programmatic fashion with Power Automate!
Yash is here again to show us how to be a pro like him! welcome back Yash!
Watch part 1 of Forms Attachments: • Power Automate Tutoria...
To get started on flow head to flow.microsoft.com
To follow Yash on Twitter head to / yashagarwal1651
To follow his blog head to bythedevs.com
To follow me on Twitter head to / jonjlevesque
to make videos like mine head to my shop www.amazon.com/shop/jonlevesque
as always please LIKE & SUBSCRIBE
Much Love from Me!
-Jon - Zábava
Thanks Jon and Yash....this was much needed. Great stuff !!
A new hit on CZcams!
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!!! :)
loving these tutorials!!!
My Man!!! I've been searching for this for daysssssss!!! This video is a hit! :)
Ahhh so glad to hear it!!
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
this was great, I got it to work super well... LOVE IT. thank you so very much
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
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 :)?
you guys rock!
No you rock!
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!
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
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?
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?
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?
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.
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
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?
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!! :)
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)
Super Duper LIKE 👍🏻
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.
thank you this comment really helped me!
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.
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
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
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?
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.'.'.
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 ...
I tried the flow and it works! But my problem is the word document is distorted, why is that? Thanks
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".
Hi, I cannot add more than one action to the SCOPE. please need an answer?
Thanks....
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?
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'.
@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.
I'm getting the same error, has this been resolved?
@@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.
whenever i add initialize variable it says the operation should be used at top level
My flow fails when I don't have attachments. In my case, attachments is not necessary to upload. How to fix it? Thanks
Is this still internal oir can I use it with external users.
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
how do you embed and image in an email from a form with power automate
anyone think that add get attachment action somewhere in the scope would work to fix?
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....
Did you put the base64 expression in a quote? say "base64Xpression"
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.
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.
Hi Jon, any thoughts on my 'Enter a valid json' error?
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?
I am having the exact same issue as this
Hi, I have the same problem? You resolved this ?
I'm having the same issue
Hi Fabricio, you should remove base64 and use File Content directly, it helps me and the flow works perfectly
@@jakubbanda8585 I tried that and it still isn't working.
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?
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!
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.'.'.
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.
@@yashagarwal116 I'm having the same issue
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?
Right now it only passes to OneDrive.
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.
@@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
I have one question actually is there any connectors that make me update a form automatically when I add or modify a SharePoint list
No, unfortunately there’s no such thing
@@JonJLevesque is there any other way can I achieve it like other than power automate
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.
Me too
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
Hi, you need to remove "base64" and the double quotes, then it will works!
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?
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!
Thanks Andrew!
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?
I get the same error; any help on this?
same!
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
@@ShaneStenhjem I'm getting this same issue. Did you figure it out?
@@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 CZcams video to help me. @cvkealey Chad Kealey "Power Automate and Microsoft Forms: Send uploaded files as email attachments". Good luck
Does this work for outside the org or inside the org.
Right now it works for users within the Organization only..
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!
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.
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)
@@i_am_batman_ph OMG thank you so much for this. it helped me too!!!
@@i_am_batman_ph OMG - thank you sooo very much. I am new to all of this, so I appreciate is greatly.
@@colzo6361 Heey Thanks it worked! Base64 is not required
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?
Hi, you need to remove "base64" and the double quotes, then it will works!
I got attached files to my email but I can not open that files, How to solve this issues?
Did you make sure the content is passing as the right type?
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.
Yeah this is three years old now, it’s likely some things changed at this point.
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.
I faced the same issue. Have you tried using File Content directly without base64 encoding? Worked for me!
Poorna G awesome I will give that a try today and see how I go. Appreciate the response!
@@Jithu1713 It doens't work. When opening PDF documents, Acrobat Reader said the file is damaged and could not be repaired.
Same is happening to me...otherwise it works beautifully for my flow. @Yash any words of wisdom?
Yes unfortunately mine still isn’t working so I can’t help you either sorry. Hopefully we can get some assistance soon!
Combine with image content in word connector please...😁😁😁
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?
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.
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?
@@saramiller9349 use the function “get file content” and pass the ID of the attachment
@@dianajimenez9574 thanks...must have done something wrong because it didn't work...
He goes way too fast. Not great. Please allow us to follow along without having to rewind constantly