I'm getting desperate.
The form has one text field "DepartmentName". In the edit form settings I have selected the table "TheUploads" and for Attachments I have selected "Enable attachments, attachment is required, allow multiple files" Submitting the form saves the "DepartmentName" to the "TheUploads" table and puts the attachments as a Note in a Note table which has a column called "File Name" for the file name, "Note" as the unique identifier of the note, and "Document" as then contents of the note's attachment.
My PowerAutomate uses trigger "When a row is added, modified, or deleted" and I've tried various things but essential using Outlook's "Send an email (V2)" action the outlook preview reports "We couldn't open the image file." and downloading it to open it reports "It looks like we don't support this file format." I get similar messages with a word document. If I try moving the attachment into a Sharepoint document library instead of using email I get the same result.
I made a quick and dirty PowerApp to retrieve the data from notes and the file downloads fine and is readable. This means the attachment is saved in the database correctly.
So how do I use a PowerAutomate to read the file out of the DV Notes table and send it as an attachment in Outlook?
Thanks. I'm going mad on this one.
