How to get multiple files using GetBobContent and add as attachment to Email in Azure Logic app?

Question

Hi I am working in Azure Logic app. I am trying to get multiple files from azure data Lake gen v2 and attach these multiple files in an email. As a first step I have added http request and I am giving required information along with file path. It works fine for one file. but I am trying to input folder path and inside that folder, all the files I want to get and attach in email.

Logic app Flow Diagram

Added sample screenshot for attachment

tried to add attchment

In the above diagram, Get blob content step which works fine for one file but I am finding difficult to attach multiple files in email. Can some one help me to figure out the solution. Any help would be appreciated. Thank you

Does this answer your question? [Azure Logic app : How to Send an Email with one or more attachments after getting the content from Blob storage?](https://stackoverflow.com/questions/51473878/azure-logic-app-how-to-send-an-email-with-one-or-more-attachments-after-gettin) — John OKeeffe, Nov 11 '20 at 14:48
Hi John. No I already went through that question. That will send multiple emails but i want to add multiple files in same email — Niranjan Godbole Hosmar, Nov 11 '20 at 15:28

Frank Borzage · Accepted Answer · 2020-11-12T05:16:31.107

3

You can use List blobs action to list all blobs in the folder you want:

Then you can define a variable to append the attachments array.

Use For Each to loop the blobs from List Blobs action. Within For Each you can use Get blob content to get blob content, and then use Append to array variable to append attachments.

The expressions of Path, DisplayName and File Content are as follows:

Path : items('For_each')?['Path']

DisplayName : items('For_each')?['DisplayName']

File Content : body('Get_blob_content')

Finally, please fill in the attachment in the email:

==========================update===================

If you send an email with 400 response, please use expression in Append to array variable as below:

base64(body('Get_blob_content'))

edited Nov 12 '20 at 05:16

answered Nov 11 '20 at 15:30

Frank Borzage

6,292
1
6
19

Thanks for you Frank gong. When I add expression to path @items('For each')?['Path'] I am getting invalid expression. what would be the issue any thing I am missing? – Niranjan Godbole Hosmar Nov 12 '20 at 04:38
Please try [this way](https://i.stack.imgur.com/i94h1.png). – Frank Borzage Nov 12 '20 at 05:15
Thanks It worked but I was trying to give expression Path : items('For_each')?['Path']. So same thing for displayName and Contentbytes right? – Niranjan Godbole Hosmar Nov 12 '20 at 05:19
Yes, `displayName` and `Contentbytes` also apply. – Frank Borzage Nov 12 '20 at 05:27
I came to last step of sending email. In attachments I do not see {x}attachments. I will upload sample screenshot here – Niranjan Godbole Hosmar Nov 12 '20 at 05:34
Please click [there](https://i.stack.imgur.com/ZMx0P.png) to switch to input entire array. – Frank Borzage Nov 12 '20 at 05:39
I recieved multiple attachments email but I recieved email also twice because I had two attachments. – Niranjan Godbole Hosmar Nov 12 '20 at 05:43
Please make sure that `send email` is outside `for each` – Frank Borzage Nov 12 '20 at 05:45
The workflow is like [this](https://i.stack.imgur.com/SXXgx.png). – Frank Borzage Nov 12 '20 at 05:47

How to get multiple files using GetBobContent and add as attachment to Email in Azure Logic app?

1 Answers1

Linked