LA: Sending email containing one or multiple attachments from a SPO listitem: issues with the array

Question

Hi Guys

We have a SPO list that can hold 1 or more attachments. At some point the information in the listitem and all attachments of that listitem needs to be sent via email.

I could not get the more than one attachment sent and found this article how-to-send-listitem-attachments-as-email-attachment-from-flow

I followed his steps but in testing the email does not get sent. Could you guys check if this is still the way to do it in 2021 in LA. the article is a bit older and for Flows, not LA

the error I get states I did not specify a to: and subject, but both are specified. When I remove the attachments the email gets through. So I assume I am doing something wrong with the attachments array

{  
  "status": 400,  
  "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.\r\nclientRequestId: ece54e11-b0cf-47e5-b449-b3b2b1bbe9a9",  
  "error": {  
    "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'."  
  },  
  "source": "office365-ne.azconn-ne-01.p.azurewebsites.net"  
}  

Not in the screenshot as it has to be in the top and not in a condition, there is an inittialize Array called Attachments Array step.
In the Append to array step, the first variable Contentbytes is the Body:(Get_Attachment_Content) from the step above it
the Name variable comes from the for each step Items(for each)?[displayname]

Answer 1

Hi Allen,

It seems to be a known issue!

In march Prakash Maitani posted a video explaining the steps and the error: watch

You need to alter the "Append to array Variable" action to find the content pointing it to the variable $Content as in the screenshot below. Then it does send one email containing all attachments of the listitem.

Thanks!

Answer 2

Hi @Jurgen Verhelst ,

I could reproduce your issue in my end. We can use dynamic content 'attachment content' instead of using the array variable.

Please refer to my flow:

Details:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi Allen,

I tried that but it sends 2 emails. I need it to be 1 email with all attachments

any idea how?

Answer 4

@Jurgen Verhelst

Thanks for your response :-)

I followed the steps in this article: Advanced | Flow of the Week: Send multiple attachments on a single email, it works in my environment without any error, multiple attachments can also be included in an email.

Comparing my flow with yours, the only difference I found is the order of "Name" and "ContentBytes". Mine is as below:

If I change the order of them, my flow will fail and get error:

So, try to change the order the them in your flow. If the error still persists, recreate a new flow under the instruction of the above article.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.