Email attachments from SharePoint list

[chucksta]

Good afternoon,

I have a flow that when a user adds a SharePoint list item it sends an email and if the list item sends to the another group they see those attached in the email..

Now, when the email is sent, if I have more than 2 attachments it sends two email or an email for each attachment.

Can anyone help with this? I want all  the attachments to be in one email instead of multiple.

My Variable for looking at the attachments is :

@{body('Get_attachment_content_2')?['$content']}

[chsanche]

Hi @chucksta 

Can you please share with me a screenshot from the Send email action? I can see that you are setting up correctly the attachments variable. The Send email action should look something like this:

It also needs to be outside any Apply to each action.

Best Regards,

[chucksta]

@chsanche  Thanks for replying, currently I am using the send an email (V2) with my attachment array  in the attachments as seen in your screen shot, but I do notice you have send an email with multiple attachments which i do not see for Office Outlook 365. 

[chsanche]

Hi @chucksta 

The "Send an email with multiple attachments" its just the action name, sorry for the confusion, it is the same one that you are using. Can you please confirm that the Send email action is outside any apply to each? Here is a tutorial on how to set up this correctly but I think you have your Flow almost the same: https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

Please confirm inside which action the Send email resides.

Best Regards,

[chucksta]

@chsanche Its in a condition at the moment. it seems to have been working p until about a week or two ago. Below is the shots of the layout:

Its in a condition the way I have it setup, if it has attachments, its sends an email with the attachments, but my problem is the yest conditions to send attachments sends one email for each attachment, the no condition, just sends an email to a specific team.

If there is a way to do that piece with the false attachment condition, let me know and I will try that. Again I really appreciate your help with this! 👍

[chsanche]

Hi @chucksta 

From your email, I can see that you have the Send Email action inside an Apply to Each, this is the reason that multiple emails are getting sent

If you check on the No part of the condition, there is no Apply to Each there. You need to move the Send email action outside the Apply to each.

Best Regards,

[chucksta]

@chsanche  Thank you sir that did it but it seems to only work for screenshots and not other types of files, when I ran it again I got the error below. Question though.... Are there limitations to the attachments.?When I add .xls, or .txt. or .sql files they dont work.

.xls attachment:

[chsanche]

Hi @chucksta 

It shouldn't fail for other file formats. Can you please show the action that actually failed? As you can see in your screenshot, the "Get attachment content 2" is not the action that failed, most likely is the one below, the one that creates the variable.

Best Regards,

[chucksta]

@chsanche  Sorry about that. I sent the wrong screenshot at first.

This is the error below:

[chsanche · Accepted solution]

Hi @chucksta 

Where you are appending to the array variable, can you please select the Attachment content that is coming from the Get attachment content 2 action to populate the ContentBytes:

This might be related to the formula that you indicated you are using to get content. Instead of this: @{body('Get_attachment_content_2')?['$content']}, please select the one from the dynamic content window as indicated on the above screenshot.

Best Regards,

[chucksta]

@chsanche  Thanks again. its working now. I was told in the past to use that formula but it could have been just bugs since the attachment content was not working when I selected it from the dynamic content but we are good now and thanks again!