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.

All responses (8)

Answers (2)

PlusCTRL on at

Like (0)

Report

Re: Sending emails with attachments from a form using powerapps and flow

Love Shane Young videos! And I have been reading your blog, lots of helpful information, so thank you!
WarrenBelz 146,635 Most Valuable Professional on at

Like (1)

Report

Re: Sending emails with attachments from a form using powerapps and flow

@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.
WarrenBelz 146,635 Most Valuable Professional on at

Like (1)

Report

Re: Sending emails with attachments from a form using powerapps and flow

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.
Verified answer

PlusCTRL on at

Like (1)

Report
Re: Sending emails with attachments from a form using powerapps and flow

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" }
PlusCTRL on at

Like (0)

Report

Re: Sending emails with attachments from a form using powerapps and flow

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
PlusCTRL on at

Like (0)

Report

Re: Sending emails with attachments from a form using powerapps and flow

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!
PlusCTRL on at

Like (0)

Report

Re: Sending emails with attachments from a form using powerapps and flow

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 🙂
Verified answer

WarrenBelz 146,635 Most Valuable Professional on at

Like (1)

Report

Re: Sending emails with attachments from a form using powerapps and flow

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.