Send email with attachments from Sharepoint Library

(0) Share

Report

Posted on by Schu94

Hi all

I'm creating an app where I would like to attach multiple documents from a Sharepoint document library to an email.

I have a gallery with all files from the library where the user can choose which documents that should be attached. When choosing a document a collection is created and a flow is running to get the filecontent.

But the filecontent is not accepted in the email.

Can somebody help?

Thanks

Mikkel

Skærmbillede 2022-10-05 kl. 08.19.32.png

Skærmbillede 2022-10-05 kl. 08.18.24.png

Skærmbillede 2022-10-05 kl. 08.18.54.png

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Collect(col_Attachment;{File:{Name:...., ContentBytes:....,'Odata':""}})
Try implementing it this way
Schu94 17 on at

Like
a
(0)

Report
Copy link

Link copied!

It gives me an error which says "A column ContentBytes is missing with the type Blob"
Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried sending mail directly throught the flow?
Schu94 17 on at

Like
a
(0)

Report
Copy link

Link copied!

When I send directly through a flow it works just fine. But I don't know how to loop through all chosen gallery items to add multiple attachments to the email
Manan-Malhotra 621 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
in the highlighted area
{Attachments:First(Col_attachments.file)}
could you try this once, it should attach the first attachment
If this work will work in figuring out attaching multiple at once
Schu94 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately same error 😞
LeandroTF 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I am trying to do something similar, I have the files saved in the SP library and I am showing them in a power apps gallery, the plan is to send the selected items (full patch or identifier, not sure yet) to a flow, attaching them to the email, and send them to my printer to print them out.

Would you mind sharing with me how you built your flow on power automate to send the files by email?
Schu94 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi LeandroTF

I just did it for one attachment when selecting in gallery to check if it would work.
I'm not sure how to loop through the gallery.
Maybe you can just use a collection as input to the flow and then for each loop?
LeandroTF 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Schu94 ,

I just implemented your flow on my end,
Saved the ThisItem.'File path', in another variable to use in the flow trigger, and it works perfectly, thanks.

Once again, thanks for sharing!