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
14 дек 2023
