Answered

Power Apps Send email with attachments being optional

(0) Share

Report

Posted on by MHSPDev

Hi all,

I've developed a Power App for logging issues in a Data Centre, users can submit a picture utilising the Add Picture control.

The issue I'm facing is that if the user does not attach a picture, the email does not trigger.

I've tried to use a condition but I'm still fairly new to Power Apps and cannot figure out how to get it to work without the attachment.

Here is the current formula:

If(
 IsBlank(imgAttachEmail.Image),
 Office365Outlook.SendEmailV2(
 "Test@TestDomain.Com",
 "New Issue logged via app - With Image",
 "<b>Name of Reporter:</b>" & " " & TextInput_Name.Text & "<br>" & "<b>Reporter Email:</b>" & " " & TextInput_Email.Text & "<br>" & "<br>" & "<b>Location of issue:</b>" & " " & TextInput_Location.Text & "<br>" & "<b>Subject of issue:</b>" & " " & TextInput_Subject.Text & "<br>" & "<br>" & "<b><u>Description of issue</u></b>" & " " & RichTextInput_Description.HtmlText,
{
 Attachments: {
 Name: ambFileAttach.FileName,
 ContentBytes: imgAttachEmail.Image,
 '@odata.type': ""
 }
 }
),
Office365Outlook.SendEmailV2(
 "Test@TestDomain.com",
 "New Issue logged via app",
"<b>Name of Reporter:</b>" & " " & TextInput_Name.Text & "<br>" & "<b>Reporter Email:</b>" & " " & TextInput_Email.Text & "<br>" & "<br>" & "<b>Location of issue:</b>" & " " & TextInput_Location.Text & "<br>" & "<b>Subject of issue:</b>" & " " & TextInput_Subject.Text & "<br>" & "<br>" & "<b><u>Description of issue</u></b>" & " " & RichTextInput_Description.HtmlText
);

The issue I get with it set up like this is that it will send the email with no attachment, whether I attach an image or not.

If I switch the attachment part of the formula to the "else" value, it won't work unless there is an attachment.

Any help is greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

rpersad 780 on at

Like (0)

Report
Copy link

Link copied!

Try isEmpty instead of isBlank

Was this reply helpful? Yes No
MHSPDev 65 on at

Like (0)

Report
Copy link

Link copied!

I get "Invalid argument type (Image). Expecting a Table value instead.

Was this reply helpful? Yes No
rpersad 780 on at

Like (0)

Report
Copy link

Link copied!

Just for confirmation what control are you using to store the image?

Was this reply helpful? Yes No
MHSPDev 65 on at

Like (0)

Report
Copy link

Link copied!

I believe it's the Image Control that stores the image.

In the image below I am using the imgAttachEmail (Image Control) to store the image and the ambFileAttach (Add Picture control) for the file name.

Was this reply helpful? Yes No
Verified answer

rpersad 780 on at

Like (0)

Report
Copy link

Link copied!

Use !IsBlank(ambFileAttach) which would return true if there is an image selected and false if no image selected.

Was this reply helpful? Yes No
MHSPDev 65 on at

Like (0)

Report
Copy link

Link copied!
You are a genius, I've got it working now.

Formula looks like this now:

If( IsBlank(ambFileAttach.Media), Office365Outlook.SendEmailV2( "Test@TestDomain.com", "New Issue logged via app", "Name of Reporter:" & " " & TextInput_Name.Text & " " & "Reporter Email:" & " " & TextInput_Email.Text & " " & " " & "Location of issue:" & " " & TextInput_Location.Text & " " & "Subject of issue:" & " " & TextInput_Subject.Text & " " & " " & "Description of issue" & " " & RichTextInput_Description.HtmlText & Navigate(Screen_Confirmation) ), Office365Outlook.SendEmailV2( "Test@TestDomain.com", "New Issue logged via app - With Image", "Name of Reporter:" & " " & TextInput_Name.Text & " " & "Reporter Email:" & " " & TextInput_Email.Text & " " & " " & "Location of issue:" & " " & TextInput_Location.Text & " " & "Subject of issue:" & " " & TextInput_Subject.Text & " " & " " & "Description of issue" & " " & RichTextInput_Description.HtmlText, { Attachments: { Name: ambFileAttach.FileName, ContentBytes: imgAttachEmail.Image, '@odata.type': "" } } );

Thank you so much, spent a few hours trying to get this working and googling all sorts with no luck!

Was this reply helpful? Yes No
MHSPDev 65 on at

Like (0)

Report
Copy link

Link copied!
You are a genius, thank you so much!

I spent hours googling and testing things out before coming here and you've managed to solve it for me.

Updated formula is here:

If( IsBlank(ambFileAttach.Media), Office365Outlook.SendEmailV2( "Test@TestDomain.com", "New Issue logged via app", "Name of Reporter:" & " " & TextInput_Name.Text & " " & "Reporter Email:" & " " & TextInput_Email.Text & " " & " " & "Location of issue:" & " " & TextInput_Location.Text & " " & "Subject of issue:" & " " & TextInput_Subject.Text & " " & " " & "Description of issue" & " " & RichTextInput_Description.HtmlText & Navigate(Screen_Confirmation) ), Office365Outlook.SendEmailV2( "Test@TestDomain.com", "New Issue logged via app", "Name of Reporter:" & " " & TextInput_Name.Text & " " & "Reporter Email:" & " " & TextInput_Email.Text & " " & " " & "Location of issue:" & " " & TextInput_Location.Text & " " & "Subject of issue:" & " " & TextInput_Subject.Text & " " & " " & "Description of issue" & " " & RichTextInput_Description.HtmlText, { Attachments: { Name: ambFileAttach.FileName, ContentBytes: imgAttachEmail.Image, '@odata.type': "" } } );

Was this reply helpful? Yes No
rpersad 780 on at

Like (1)

Report
Copy link

Link copied!

No problem. Weird that you have to add the '.Media' while I got it to work without it. But glad it works.

Was this reply helpful? Yes No