Power Automate Tutorial - Microsoft Forms Multiple Attachments

แชร์
ฝัง
  • เผยแพร่เมื่อ 16 ธ.ค. 2024

ความคิดเห็น • 135

  • @kingdomarrows7508
    @kingdomarrows7508 4 ปีที่แล้ว +5

    Thanks Jon and Yash....this was much needed. Great stuff !!

  • @AMERICACOLCHOES
    @AMERICACOLCHOES 4 ปีที่แล้ว +2

    A new hit on TH-cam!

  • @Marcusbrooks85
    @Marcusbrooks85 ปีที่แล้ว +1

    My Man!!! I've been searching for this for daysssssss!!! This video is a hit! :)

    • @JonJLevesque
      @JonJLevesque  ปีที่แล้ว

      Ahhh so glad to hear it!!

    • @Marcusbrooks85
      @Marcusbrooks85 ปีที่แล้ว

      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

  • @joeydbandiola
    @joeydbandiola 3 ปีที่แล้ว +1

    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!!! :)

  • @mauriciorenderos3302
    @mauriciorenderos3302 ปีที่แล้ว +1

    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?

  • @mohamedhossam2765
    @mohamedhossam2765 4 ปีที่แล้ว +2

    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 :)?

  • @jaipalrana.
    @jaipalrana. 4 ปีที่แล้ว +3

    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

  • @rajeshmeruguU36
    @rajeshmeruguU36 4 ปีที่แล้ว +3

    @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.

    • @trevorway6281
      @trevorway6281 4 ปีที่แล้ว

      I'm getting the same error, has this been resolved?

    • @yashagarwal116
      @yashagarwal116 4 ปีที่แล้ว

      ​@@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.

  • @evob20
    @evob20 4 ปีที่แล้ว +2

    loving these tutorials!!!

  • @fabriciofernandes891
    @fabriciofernandes891 4 ปีที่แล้ว +11

    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?

    • @priestgiggs
      @priestgiggs 4 ปีที่แล้ว +2

      I am having the exact same issue as this

    • @djmrox2298
      @djmrox2298 4 ปีที่แล้ว +1

      Hi, I have the same problem? You resolved this ?

    • @trevorway6281
      @trevorway6281 4 ปีที่แล้ว +1

      I'm having the same issue

    • @jakubbanda8585
      @jakubbanda8585 4 ปีที่แล้ว +5

      Hi Fabricio, you should remove base64 and use File Content directly, it helps me and the flow works perfectly

    • @saramiller9349
      @saramiller9349 3 ปีที่แล้ว +1

      @@jakubbanda8585 I tried that and it still isn't working.

  • @wesleylewellen3296
    @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?

  • @spencerkok1300
    @spencerkok1300 3 ปีที่แล้ว +2

    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.

    • @marjhkl
      @marjhkl ปีที่แล้ว

      thank you this comment really helped me!

  • @theresaa.efiokwu9863
    @theresaa.efiokwu9863 3 ปีที่แล้ว +1

    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

  • @jeannettebradley3684
    @jeannettebradley3684 4 ปีที่แล้ว +3

    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!! :)

  • @lka55364
    @lka55364 4 ปีที่แล้ว +1

    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)

  • @Tamilan6382
    @Tamilan6382 ปีที่แล้ว +2

    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
      @JonJLevesque  ปีที่แล้ว

      No, unfortunately there’s no such thing

    • @Tamilan6382
      @Tamilan6382 ปีที่แล้ว

      @@JonJLevesque is there any other way can I achieve it like other than power automate

  • @janessabirch
    @janessabirch 2 ปีที่แล้ว

    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?

  • @AYJNChanel0508
    @AYJNChanel0508 7 หลายเดือนก่อน

    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'.

  • @saramiller9349
    @saramiller9349 3 ปีที่แล้ว

    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?

  • @edwardhodson6493
    @edwardhodson6493 4 ปีที่แล้ว

    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!

  • @ben41sbr2
    @ben41sbr2 4 ปีที่แล้ว +3

    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....

    • @capacitynigeria9046
      @capacitynigeria9046 4 ปีที่แล้ว

      Did you put the base64 expression in a quote? say "base64Xpression"

  • @Tamilan6382
    @Tamilan6382 ปีที่แล้ว

    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

  • @christianzinck6023
    @christianzinck6023 4 ปีที่แล้ว

    this was great, I got it to work super well... LOVE IT. thank you so very much

  • @yvonnekoh5235
    @yvonnekoh5235 4 ปีที่แล้ว +2

    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?

    • @JonJLevesque
      @JonJLevesque  4 ปีที่แล้ว +2

      Right now it only passes to OneDrive.

    • @peterder71
      @peterder71 4 ปีที่แล้ว

      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.

    • @poojanair04
      @poojanair04 4 ปีที่แล้ว

      @@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

  • @santhiyav1344
    @santhiyav1344 ปีที่แล้ว

    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 ...

  • @MrNaquevedo
    @MrNaquevedo 4 ปีที่แล้ว +2

    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?

    • @MrNaquevedo
      @MrNaquevedo 3 ปีที่แล้ว

      I get the same error; any help on this?

    • @ericrojas5792
      @ericrojas5792 3 ปีที่แล้ว

      same!

    • @ShaneStenhjem
      @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
      @iwanttolearn496 ปีที่แล้ว

      @@ShaneStenhjem I'm getting this same issue. Did you figure it out?

    • @ShaneStenhjem
      @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 TH-cam video to help me. @cvkealey Chad Kealey "Power Automate and Microsoft Forms: Send uploaded files as email attachments". Good luck

  • @MMcGinn10
    @MMcGinn10 3 ปีที่แล้ว

    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.

  • @spicyavenue9225
    @spicyavenue9225 3 ปีที่แล้ว

    Hi, I cannot add more than one action to the SCOPE. please need an answer?
    Thanks....

  • @colzo6361
    @colzo6361 3 ปีที่แล้ว

    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.

  • @therealn4cer
    @therealn4cer 4 ปีที่แล้ว +1

    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.

    • @Jithu1713
      @Jithu1713 4 ปีที่แล้ว

      I faced the same issue. Have you tried using File Content directly without base64 encoding? Worked for me!

    • @therealn4cer
      @therealn4cer 4 ปีที่แล้ว

      Poorna G awesome I will give that a try today and see how I go. Appreciate the response!

    • @vajocofa
      @vajocofa 4 ปีที่แล้ว

      @@Jithu1713 It doens't work. When opening PDF documents, Acrobat Reader said the file is damaged and could not be repaired.

    • @shellyatkinson2517
      @shellyatkinson2517 4 ปีที่แล้ว

      Same is happening to me...otherwise it works beautifully for my flow. @Yash any words of wisdom?

    • @therealn4cer
      @therealn4cer 4 ปีที่แล้ว

      Yes unfortunately mine still isn’t working so I can’t help you either sorry. Hopefully we can get some assistance soon!

  • @viniciisramossilva
    @viniciisramossilva 3 ปีที่แล้ว

    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

  • @andrewjameson5918
    @andrewjameson5918 4 ปีที่แล้ว +2

    Is this still internal oir can I use it with external users.

    • @cjsilvestre
      @cjsilvestre 4 ปีที่แล้ว +3

      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

  • @ebenjamin24
    @ebenjamin24 3 ปีที่แล้ว

    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
      @crispo1982 4 หลายเดือนก่อน

      Hi, you need to remove "base64" and the double quotes, then it will works!

  • @poojanair04
    @poojanair04 4 ปีที่แล้ว

    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

  • @ExcelExciting
    @ExcelExciting 4 ปีที่แล้ว +3

    Super Duper LIKE 👍🏻

  • @CaptCJ1969
    @CaptCJ1969 4 ปีที่แล้ว

    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.

    • @CaptCJ1969
      @CaptCJ1969 4 ปีที่แล้ว +1

      Hi Jon, any thoughts on my 'Enter a valid json' error?

  • @stephongadson1411
    @stephongadson1411 2 ปีที่แล้ว

    how do you embed and image in an email from a form with power automate

  • @catherinefreeman9706
    @catherinefreeman9706 3 ปีที่แล้ว +1

    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.

  • @ashvinsaini01
    @ashvinsaini01 2 ปีที่แล้ว

    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".

  • @dnasol5370
    @dnasol5370 2 ปีที่แล้ว

    I tried the flow and it works! But my problem is the word document is distorted, why is that? Thanks

  • @i_am_batman_ph
    @i_am_batman_ph 3 ปีที่แล้ว +1

    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_ph
      @i_am_batman_ph 3 ปีที่แล้ว +3

      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)

    • @spencerkok1300
      @spencerkok1300 3 ปีที่แล้ว +1

      @@i_am_batman_ph OMG thank you so much for this. it helped me too!!!

    • @colzo6361
      @colzo6361 3 ปีที่แล้ว +1

      @@i_am_batman_ph OMG - thank you sooo very much. I am new to all of this, so I appreciate is greatly.

    • @babufootball9991
      @babufootball9991 2 ปีที่แล้ว

      @@colzo6361 Heey Thanks it worked! Base64 is not required

  • @andriany.rahayu1336
    @andriany.rahayu1336 2 ปีที่แล้ว +1

    you guys rock!

  • @yogithas2864
    @yogithas2864 15 วันที่ผ่านมา

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

  • @louisegarrettc.5874
    @louisegarrettc.5874 3 ปีที่แล้ว +1

    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.5874
      @louisegarrettc.5874 3 ปีที่แล้ว +1

      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!

  • @saramiller9349
    @saramiller9349 3 ปีที่แล้ว

    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?

  • @MonsieurCee
    @MonsieurCee 3 ปีที่แล้ว +1

    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!

  • @ckimlen
    @ckimlen 3 ปีที่แล้ว +1

    I got attached files to my email but I can not open that files, How to solve this issues?

    • @JonJLevesque
      @JonJLevesque  3 ปีที่แล้ว

      Did you make sure the content is passing as the right type?

  • @pandapoo5002
    @pandapoo5002 3 ปีที่แล้ว

    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.'.'.

  • @saramiller9349
    @saramiller9349 3 ปีที่แล้ว

    anyone think that add get attachment action somewhere in the scope would work to fix?

  • @pedropadilha02
    @pedropadilha02 4 ปีที่แล้ว

    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.

  • @johngorringe7619
    @johngorringe7619 4 ปีที่แล้ว

    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.'.'.

    • @yashagarwal116
      @yashagarwal116 4 ปีที่แล้ว

      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.

    • @MrNaquevedo
      @MrNaquevedo 4 ปีที่แล้ว

      @@yashagarwal116 I'm having the same issue

  • @evertonmedeiros7223
    @evertonmedeiros7223 3 ปีที่แล้ว

    My flow fails when I don't have attachments. In my case, attachments is not necessary to upload. How to fix it? Thanks

  • @NeshaStanic
    @NeshaStanic 3 ปีที่แล้ว

    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?

  • @johnkniphfer4428
    @johnkniphfer4428 3 ปีที่แล้ว

    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?

  • @tcreson
    @tcreson ปีที่แล้ว +1

    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
      @JonJLevesque  ปีที่แล้ว

      Yeah this is three years old now, it’s likely some things changed at this point.

  • @hannahliteral3342
    @hannahliteral3342 4 ปีที่แล้ว

    whenever i add initialize variable it says the operation should be used at top level

  • @k_zildjian4460
    @k_zildjian4460 3 ปีที่แล้ว

    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
      @crispo1982 4 หลายเดือนก่อน

      Hi, you need to remove "base64" and the double quotes, then it will works!

  • @errole
    @errole 4 ปีที่แล้ว

    Does this work for outside the org or inside the org.

    • @yashagarwal116
      @yashagarwal116 4 ปีที่แล้ว

      Right now it works for users within the Organization only..

  • @lucavorraro4426
    @lucavorraro4426 ปีที่แล้ว

    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?

  • @davidadams421
    @davidadams421 4 ปีที่แล้ว

    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!

  • @yogananda1296
    @yogananda1296 4 ปีที่แล้ว

    Combine with image content in word connector please...😁😁😁

  • @dianajimenez9574
    @dianajimenez9574 3 ปีที่แล้ว

    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.

    • @saramiller9349
      @saramiller9349 3 ปีที่แล้ว

      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?

    • @dianajimenez9574
      @dianajimenez9574 3 ปีที่แล้ว

      @@saramiller9349 use the function “get file content” and pass the ID of the attachment

    • @saramiller9349
      @saramiller9349 3 ปีที่แล้ว

      @@dianajimenez9574 thanks...must have done something wrong because it didn't work...

  • @unfeomateo
    @unfeomateo 3 ปีที่แล้ว

    He goes way too fast. Not great. Please allow us to follow along without having to rewind constantly

  • @yogithas2864
    @yogithas2864 15 วันที่ผ่านมา

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