The Ultimate Power Automate Flow to work with Microsoft Forms Attachments and File Uploads
Vložit
- čas přidán 14. 12. 2023
- In this video, we revisit the topic of handling attachments in Microsoft Forms, presenting an advanced and more efficient solution using Power Automate. The video addresses a specific challenge posed by a viewer dealing with a form containing 27 file upload fields.
The solution showcased bypasses the complexities of managing numerous attachments by dynamically selecting and processing all attachments into a single array. This approach simplifies the handling of stringified JSON data and is adaptable regardless of the number of upload fields in the form.
The video walks through each stage of the process, including preparing the JSON output, converting it to XML, and then using XPath queries to identify and extract only the attachment data. It then demonstrates how to compile all attachment data into a single JSON array, which can be easily used for various purposes like uploading to a SharePoint list or document library, attaching to emails, and more.
If you feel like this process should be easier - I agree! Check out Power Tools for Power Automate which can extract Microsoft Forms attachments in a single action:
tachytelic.net/power-automate...
If you found this video useful please consider buying me a coffee:
www.buymeacoffee.com/paulie - Jak na to + styl
Check out Power Tools for Power Automate which can extract all of the for attachments in a single action!
tachytelic.net/power-automate-power-tools/
Next level stuff!! And I love that your videos are ‘warts and all’ You don’t try to make yourself look perfect, you miss a comma, flow fails and you fix it, and we all learn something!!!
Yep! I could have edited the mistakes out but they didn’t take up too much time so thought best to leave them in! Glad you liked the video, it’s a neat solution in my opinion!
Thanks for sharing this tutorial. I had previously solved this problem by using an array to store all of the file upload questions, and then iterating through each question in the array to get file contents. I really like your approach as it dynamically selects the file upload fields directly from the forms response. Like you, I haven't quite warmed up to the new editor yet. Here's a handy tip: You can use negative numbers in the slice function to trim the string at both ends: slice('0123456789', 1, -1) should return 12345678 .
That is a tasty tip! Thank you!
For anyone that follows the video, the simplified expression you would use in the select action would be: *slice(item(), 1, -1)*
Thank you very much for another great video 🥰
You are so welcome!
Great content and excellent video!
Glad it was helpful to you.
This is perfect. The one thing I need to do is use a Team SP Library instead of my personal business one drive. How would we do that?
I have the same challenge. Let me know if you find out anything
I am a complete novice when it comes to Power Automate but I have followed your guide and it has helped me enormously. I have the flow working but when I try to send an email it is failing because of the types of attachments I am trying to add.
In addition to following your steps I have also converted the Microsoft form into HTML and then PDF so when it comes to the email attachments I am trying to add your instructions (as an array) and then the PDF details not as an array and it doesn't like it. I have screen shots if that would be helpful.
You could combine the PDF into your first array using the “Append to array” action.
Is it possible to apply this method when submitting files to planner?
Awesome, thanks for sharing!
One question though:
- what alternative can be used to upload attachments? I want to share the Form with external partners hence not possible for them to upload attachments ?
Check out this video..
czcams.com/video/c4aLEJaORYo/video.htmlsi=woqKX0Ei1oJdK12y
Hey Paul! This video helped me push past a barrier I was having with PowerAutomate for a similar flow case as presented here.
I’m having an issue with sending the attachments to a Jira ticket. I’m able to upload the attachments with this (as long as I use a covertBase64toBinary for “content” field), but when I try to open the attachment on Jira it is corrupted. Would you be able to help me with this?
I would have thought you should send the attachments to Jira in Base64 format. Are they part of a JSON payload?
@@PaulieM yes they are part of the JSON payload for an HTTP POST request. When I tried using the Base64 content, the HTTP response would be that it didn’t add any attachments.
@PaulieM sorry for the confusion, it worked when I switched back to Base64!