cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NSimpraga
Helper I
Helper I

Sending an email after Sharepoint list entry is added (email attachment and signature issue)

Hi everyone,

 

I am having a couple of issues with emails sent by Flow. 

I used the template "Send a customized email when a new SharePoint list item is added". 

 

After an entry is added to a SharePoint list, an email should be generated with a few .pdf documents and a .mp4 video.

I've added the files to my Site Contents but I can't figure out how to add them to the email as attachments from there.

I tried using the 'Get file content' action on the documents and adding those to the 'Attachments content' field but it's throwing an error and failing the flow so I guess I am doing something wrong.

Thought I should use 'Get attachments' action but I am not sure on how it's supposed to be used. 

 

Second issue I am facing is about the email formatting, specifically adding a signature to the end of the email.

I understood that if you want to format the email you have to use html tags, which I did for the line breaks. Thing is, this email that is sent is supposed to be sent with an email signature which can't be copy&pasted because it's not plain text but consists of thumbnails, custom fonts and whatnot.

 

Not sure how to handle this part. Am I approaching this wrong? Can I somehow just attach an email that is exported from Outlook as a whole (with formatting and attachments and everything) instead of editing the email myself in the text box that Flow offers me?

 

Any help is really appreciated! Thank you

3 REPLIES 3
NSimpraga
Helper I
Helper I

Update: I managed to attach the pdf files correctly using the Get file content action.

The problem is the video file. I successfully fetched and attached the 3 pdfs but after I fetch and attach the .mp4 file, the sending of the email action fails and throws a 'bad gateway' error. 

 

What could be the issue here?

v-litu-msft
Community Support
Community Support

Hi @NSimpraga,

 

1. You can try this way to send attachments that initialize an Array variable then Append it by using the name and content, then add the variable into the Email attachment field.

Annotation 2019-12-04 112621.png

 2.  If you want to add the signature into your Email, I think you can consider save it as a picture in SharePoint, then add it in the email body.

Annotation 2019-12-04 113205.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

In the end it was the size of the attachment that was the problem. The maximum size is 4MB but my video was 5MB so that's why the error. Ended up just uploading the video to Sharepoint and shared the link instead of attaching it to the mail.

 

Thanks for the info nonetheless!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,269)