Unanswered

Attachment is not included while sending mail

(0) Share

Report

Posted on by Pavithran

Hi PowerApps team,

I am facing an issue, I created a form and I set that when the user submits the form. That time it wants to save that form into my SharePoint and also wants to send a mail with an attachment to admin.

For this scenario, I used the code in my app. I am getting mail when the user submits the form. But in that mail attachment is not included.

Please review this code and If is there any mistakes or errors. Please reply to this post.

SubmitForm('Employee Form_1');
ClearCollect(
RecipientList,
MyPeople.Mail
);
Set(
_emailRecipientString,
Concat(
RecipientList,
Mail,
";"
)
);

Office365Outlook.SendEmail(
"abcd@gmail.com",
"New Referral Submitted for " & JobDataCardValue1_1.Text & " Position",
Concatenate(
"Hi HR Team,",
Char(10),
Char(10),
"I hope this email finds you well. I wanted to inform you that a new referral has been submitted via our referral form.",
Char(10),
Char(10),
"The referral details are as follows:",
Char(10),
Char(10),
"- Name: ",
NameDataCardValue5_1.Text,
Char(10),
"- Position: ",
JobDataCardValue1_1.Text,
Char(10),
"- Referred by: ",
User().FullName,
Char(10),
Char(10),
"Please take the necessary actions to verify the profile and follow up with the candidate accordingly.",
Char(10),
Char(10),
"You can view the referral form in PowerApps here: ",
"https://web.powerapps.com/apps/<AppID>/edit/ReferralForm",
Char(10),
Char(10),
"Thank you for your attention to this matter."
),
{
Importance: "Normal",
Attachments: AddColumns(
 RenameColumns(
 txtemailattach_1.Attachments,
 "Value",
 "ContentBytes"
 ),
 "@odata.type",
 "")
}
);
ClearCollect(
MyPeople,
{Mail: ""}
);

I hope you can help me with this. @vikas1606 @WarrenBelz @iAm_ManCat and others

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Pavithran ,

Assuming txEmailAttach_1 is an Attachment control (unusual name for it), try with V2 of the send email - a couple of other suggestions also below

With( {wList: MyPeople.Mail}, With( { wTo: Concat( wList, Mail, ";" ) }, Office365Outlook.SendEmailV2( wTo, "New Referral Submitted for " & JobDataCardValue1_1.Text & " Position", "Hi HR Team, I hope this email finds you well. I wanted to inform you that a new referral has been submitted via our referral form. The referral details are as follows: - Name: " & NameDataCardValue5_1.Text & " - Position: " & JobDataCardValue1_1.Text & " - Referred by: " & User().FullName & " Please take the necessary actions to verify the profile and follow up with the candidate accordingly. You can view <a href='https://web.powerapps.com/apps/<AppID>/edit/ReferralForm'>the referral form in PowerApps here</a> Thank you for your attention to this matter." { Attachments: AddColumns( RenameColumns( txtemailattach_1.Attachments, "Value", "ContentBytes" ), "@odata.type", "" ) } ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Pavithran ,

Assuming txEmailAttach_1 is an Attachment control (unusual name for it), try with V2 of the send email - a couple of other suggestions also below

With( {wList: MyPeople.Mail}, With( { wTo: Concat( wList, Mail, ";" ) }, Office365Outlook.SendEmailV2( wTo, "New Referral Submitted for " & JobDataCardValue1_1.Text & " Position", "Hi HR Team, I hope this email finds you well. I wanted to inform you that a new referral has been submitted via our referral form. The referral details are as follows: - Name: " & NameDataCardValue5_1.Text & " - Position: " & JobDataCardValue1_1.Text & " - Referred by: " & User().FullName & " Please take the necessary actions to verify the profile and follow up with the candidate accordingly. You can view <a href='https://web.powerapps.com/apps/<AppID>/edit/ReferralForm'>the referral form in PowerApps here</a> Thank you for your attention to this matter." { Attachments: AddColumns( RenameColumns( txtemailattach_1.Attachments, "Value", "ContentBytes" ), "@odata.type", "" ) } ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Pavithran on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying @WarrenBelz. It is very useful to solve the issue. I found another solution for that. Actually In my code, First I submitted the form and then only I try to send mail. Instead of that, I changed my code to First send mail and then submit. This way gives me a simple solution. Anyway, I got another solution from you @WarrenBelz.

Once again, Thanks for replying🙌