Apologies for the Newbie post. I've searched the forum extensively and still drawing a blank having tried several different solutions.
We have a MS Form (associated with a Group) that collects reports of quality incidents. The form allows up to 10 files to be attached (normally photos). Once the form is submitted we want to email key details to a number of people for immediate action - and need to include the attachments to the email.
I've followed the instructions in this blog post https://www.bythedevs.com/post/working-with-files-on-ms-forms-group-form-in-ms-power-automate
In order to try out the different email options I've created three arrays:
- Uploaded_Files (which has the "names" and the "file content"
- File_Names (which just has the filenames)
- File_Content (which should just have the file content)
There are two issues that I need help with:
1. I'd like to use the "Send an email notification (V3)" but cannot work out how to a add multiple attachments
2. If I used the "Send an email notification (V2)" I get an attachment to the email but when I try to open it (a simple jpg) the computer complains that the file format is not recognised
Here's my flow:
where the Value field is
{
"Name": "@{items('Apply_to_each')['name']}",
"ContentBytes": @{body('Get_file_content_using_path')['$content']}
}
where Attachments is Fx variables('Uploaded_Files')
where Attachment is Fx variables('File_Content')
and AttachmentFileName is Fx variables('File_Names')
Thanks for your help.
I'm also using the same flow to save the results from the form in a Sharepoint List, so once I've got the email sorted my next challenge will be getting the files attached to the list too...
