How to send email attachment using ADF

amikm 11 Reputation points
2022-12-06T09:01:01.677+00:00

Hi, I have an ADF pipeline, I want to send the output of my activity as an email attachment in the logic app.

I have a lookup activity followed by a For each activity and an Inside For each activity I have a web activity to call the logic app.

I want to send the output of the lookup activity as an email attachment to the logic app. I am not able to think about this integration part.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,647 Reputation points Microsoft Employee Moderator
    2022-12-07T02:39:21.33+00:00

    Hello @amikm ,

    Thanks for the question and using MS Q&A platform.

    There is no direct or easy way to achieve your requirement using ADF.

    But as a workaround first you will have to save the output of your lookup activity to a file and then follow the approach described in this video by a community volunteer where logic apps come into play to send the lookup activity output data file as an attachment. How To Send File as Attachment From Azure Data Factory - Azure Data Factory Tutorial 2021

    In order to save the lookup output data to a file you can follow this approach: Get Output of lookup activity in a file

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.