2

I need to send an email with attachment according to a condition from table. For e.g I have a table XYZ which has column "Flag" and if the column flag value is "N" then it has to pick the values with value as "N from the table and write into a file. This file has to be sent as attachment in an email in Azure data factory. f you can help with the process for this in Azure data factory it should be great.

Arun S
  • 1,363
  • 3
  • 13
  • 17
  • 1
    You should do this using Azure Logic Apps wherein you can define a SQL Trigger or a SQL action basis your requirement and then chain this with an email activity to send emails along with an attachment – Raunak Jhawar Sep 11 '19 at 10:59
  • Can Azure logic apps able to send emails with attachment..if you can also share any useful links it would be great.. – Arun S Sep 11 '19 at 12:00
  • 1
    You should go through the official MSFT Azure docs - https://learn.microsoft.com/en-us/azure/logic-apps/tutorial-process-email-attachments-workflow – Raunak Jhawar Sep 11 '19 at 12:20

1 Answers1

0

Per my researching, there is no such activity could send email with attachment,you could vote up this feedback to improve this feature.

As workaround, you could adopt @Raunak Jhawar's suggestion that using SQL Connector Trigger.

enter image description here

Then you could get the value you want into Azure File Storage or Azure Blob Storage.

After that,send email with attachments following this tutorial. Here is s similar case for your reference:Azure Logic app : How to Send an Email with one or more attachments after getting the content from Blob storage?

Jay Gong
  • 23,163
  • 2
  • 27
  • 32