Answered

Sending emails with attachments from a form using powerapps and flow

(0) Share

Report

Posted on by PlusCTRL

Hi all,

I have an app which consists of a Form connected to a SharePoint list. On Submit I would like to generate an email out and attach the files uploaded as an attachment.

I'm using Office365 SendEmailV2 to send email, no problem, that works ok, however struggling to attach the files on the email. For what I could read so far I need to create an array and add the files (multiple files) from the sharepoint list but would appreciate if someone come help me with clear instructions on how to proceed.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

WarrenBelz 155,962 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @PlusCTRL ,

This blog of mine should be what you need.

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.

Was this reply helpful? Yes No
PlusCTRL on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz!

That actually works, I've integrated the formula on my submit button, added the gallery, the labels and the choice box, all works a treat! However, would you be able to assist me in setting up in a way that ALL attachments are sent without having to select anything? Would it be a case of setting up the check box control invisible and maybe setting up to ON all the time?
many thanks for your help so far 🙂

Was this reply helpful? Yes No
PlusCTRL on at

Like
a
(0)

Report
Copy link

Link copied!

Just did a test and that works! I've just changed the Visible option to false and selected Default to On on the check box. Do you think there would be a less convoluted way of doing this?

Many thanks!

Was this reply helpful? Yes No
PlusCTRL on at

Like
a
(0)

Report
Copy link

Link copied!

If anyone is interested, I found a great article that breaks down how attachment works with the Office 365 connector:
http://powerappsguide.com/blog/post/sending-email-attachments-with-office-365-outllok

Was this reply helpful? Yes No
Verified answer

PlusCTRL on at

Like
a
(1)

Report
Copy link

Link copied!
I've just tested and found a clearer way to add ALL the attachments to the email without adding extra controls. Adding the code in here for others to use, my attachments control is names attControl
{ Attachments: RenameColumns( attControl.Attachments, "Value", "ContentBytes" ), Importance: "Normal" }

Was this reply helpful? Yes No
WarrenBelz 155,962 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @PlusCTRL ,

Even easier - just remove the gallery and send the attachment control content or hide the gallery and do not filter it.

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.

Was this reply helpful? Yes No
WarrenBelz 155,962 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@PlusCTRL ,

That is actually where I started the basis of my blog code and Shane Young did a video on this a couple of years back.

Was this reply helpful? Yes No
PlusCTRL on at

Like
a
(0)

Report
Copy link

Link copied!

Love Shane Young videos! And I have been reading your blog, lots of helpful information, so thank you!

Was this reply helpful? Yes No