Answered

Send email with attachment from SharePoint list when condition is met

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Flow 1.PNG

Flow 2.PNG

Categories:

General topics

I have the same question (0)

All responses (23)

Answers (1)

Pstork1 69,129 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

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

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Cjohnson20 31 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No