Answered

Passing attachments on to an email

(0) Share

Report

Posted on by Tetris

Attachments are being collected from an attachment control by setting the OnSelect property of a button to

ClearCollect(AttachCollect,ForAll(DataCardValue12.Attachments As Document,{contentBytes: Document.Value,name: Document.Name}))

Things seem to be working fine up to this point; Gallery_Attachments displays the content of the collection correctly (both Name and ContentBytes):

Now I am trying to pass the same information from the AttachCollect collection on to an email; I've set the OnSelect property of the Send Email button to Office365Outlook.SendEmail(_varToField, TextEmailSubject2.Text, TextEmailMessage2.Text,{Attachments:Table(AttachCollect)}), but I am getting this error:

What am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Tetris 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Forgot to add that _varToField in the Send Email button code is a variable that collects email addresses from another table and that the error is given by the {Attachments:Table(AttachCollect)} of the code. Thanks!

Was this reply helpful? Yes No
WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Salv ,

This blog of mine sets out sending attachments by email.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Tetris 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! Will check it out

Was this reply helpful? Yes No
Tetris 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Clever! Great blog,

However, I'm kinda looking for the inverse process: select all my files from a library > get them into a gallery (which I did successfully) > transfer them to an attachment control.

I'm not even sure whether that is possible at all... but it'd work perfectly for my solution...

Was this reply helpful? Yes No
Tetris 72 on at

Like
a
(0)

Report
Copy link

Link copied!

... and, of course... get everything into an email...

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Salv ,

Firstly, if you do this - assuming all the attachments are unsaved

ClearCollect( AttachCollect, AddColumns( RenameColumns( DataCardValue12.Attachments, "Value", "ContentBytes" ), "@odata.type", "" ) )

You should be able to send this

Office365Outlook.SendEmailV2( _varToField, TextEmailSubject2.Text, TextEmailMessage2.Text, {Attachments: AttachCollect} )

With regard to your second question - collecting a Library does not retrieve the actual file content (you get the file name and URL and some Thumbnail information which can be resolved in an Image control).

It could be done with Power Automate with a fair bit of complexity getting all the item content in a filter you send then parsing all of that into an array, but it is not something I have needed to attempt (a single attachment however is quite easy).

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Tetris 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz. Works like a dream!

Was this reply helpful? Yes No