Send email with attachment from SharePoint list when condition is met

[Anonymous]

Hi, 

Previously had help setting up the below flow so it didn't send multiple emails and it's working perfectly now, but I would like to be able to send attachments from the SharePoint list in the email too (there may be multiple attachments and I'm using powerapps to input the attachment and other columns on the SharePoint list) I don't want it to end up sending multiple emails again

[Pstork1]

The key to doing this is to build an array of attachments in a variable using a Loop before you send the email.  Then you can click the icon to the right to the Attachment name and switch the input over to accept an array of attachments.  See the icon highlighted in the screenshot.

Here's an article that explains how to create the array of attachments in a variable.

https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

[Anonymous]

Hi, 

I tried this and it would only let me create the array at top level, and just couldn't get it to work

[Pstork1]

YOu initialize the array variable at the top level with a null value, but then you can 'Append to the Array' inside the loop.  Read the article I posted.  There a full step by step explanation with screenshots.

[Anonymous]

I have followed this exactly from what I can see but it fails at the condition part

[Pstork1]

Your problem is something in the Send Email Action.  Can you send a screenshot of that and the loop where you are building the attachments array.

[Anonymous]

Thanks for your patience with me, see below my full flow

[Pstork1]

That all looks correct.  In the failed run you posted earlier, what is the error in the Send Email Step?

[Anonymous · Accepted solution]

I have managed to get it working, the solution seemed to be the below, this code after contentbytes 🙂 

[Cjohnson20]

I am trying to do the same thing with the item ID coming from powerapps, but keep getting an error message stating to enter valid JSON.  Any idea what could be causing this?

[Pstork1]

Please Post this as a new question.  You'll get more answers that way and others will be able to find the answer later.

[adr55555]

I realize this thread is old, but @Pstork1's response saved me from completely losing my sanity. As soon as I read it, insert Picard face-palm image.

[Anonymous]

It is possible you may be missing quotation marks?

I posted an example of what I mean below although I'm not sure if this will answer your question.

{
"Name": "Dynamic Content",
"ContentBytes": "Dynamic Content"
}

[7799]

Hello,

First of all thank you for the this flow.
I tried and it works, but I'm unable to open the attachments

As you see I did receive an email with the attachments, but then in the 2nd screenshot you'll see I'm unable to open it. 

Kindly assist

[Anonymous]

Make sure you using the correct syntax and have no extra spaces. You can copy what the JSON part from my previous message into the array when you append the "content" to the array. It should look something like this:

[7799]

Hello 
I tried doing that, but still the same issue.

Below is the Code Snapshot (Append to Array Variable)

and this is what I see

[Anonymous]

I think you're missing a step in your flow?

Please refer to below, hopefully this helps!

[7799]

Below is my code, can you please help me identify the disconnect?

Kindly assist

[Anonymous]

Move your Append to array Variable 2 into your Apply to each 3

Remove your Apply to each 4.

When you have the apply each 3 getting the information it has no where to store it.

Its a loop. When you get information inside a loop but your don't store it anywhere where does it go? It's lost.

So you apply to each 3 gets the information and then chucks it because it has no where to put it. Then when apply to each 4 its taking in information it can't process

[Anonymous]

What moving that step into the same "Apply to each" does a two step process. You get the desired data with the "Get Attachment Contents" step and the it take that information and adds it to the array!