Hi All,
I'm having a slight issue in trying to incorporate a file attachment into the email notification that's sent when a form is submitted within my Power App.
The app itself is pretty basic -
- Edit Form named formReq ; data source is a SharePoint list named "Requests".
- Default Mode: New
- Form includes a description field and an attachment control named attchItem. The Data Card containing the attachment control is linked to the "Attachments" field on the SharePoint list.
- Icon in the upper-right corner of the screen contains SubmitForm(formReq) in the OnSelect behavior.
- OnSuccess behavior of the form incorporates the Office365Outlook.SendEmailV2 functionality.
Upon submitting the form, I can see (and view/download) the attached file on the SharePoint item that's created - represented by the paperclip icon underneath the "Attachments" column. Thus, it's submitting properly, but for some reason, the attachment is not included in the e-mail notification that's sent out when the form is submitted; everything else (i.e.: subject line, body, cc) works as expected. Below is the code I'm currently using within the OnSuccess behavior of formReq:
Notify("Success", NotificationType.Success);
Office365Outlook.SendEmailV2
(
"myemailaddress@mydomain.com",
"New Request Submitted!",
"<p style='font-size:20px'>
<b>Request # " & formReq.LastSubmit.ID & "</a> has been submitted!</b></p>
<ul><li><p style='font-size:16px'><b>Description:</b> " &
formReq.LastSubmit.Description &
"</p></li><li><p style='font-size:16px'><b>Submitted By:</b>" &
formReq.LastSubmit.Submitted_x0020_By & "</li></ul>",
{
Cc:"teamdistro@mydomain.com",
Attachments: AddColumns(RenameColumns(attchItem.Attachments, "Value", "ContentBytes"), "@odata.type", "")
}
);
Navigate(screenReqListing);
Any thoughts as to why the attachment is missing from the email notification? 😕
