The Ultimate Power Automate Flow to work with Microsoft Forms Attachments and File Uploads
HTML-код
- Опубликовано: 14 дек 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 found this video useful please consider buying me a coffee:
www.buymeacoffee.com/paulie 
Хобби
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
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..
ruclips.net/video/c4aLEJaORYo/видео.htmlsi=woqKX0Ei1oJdK12y
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.