How to send a SQL query output as a mail using PowerAutomate and ADF

Question

I have a task in which i want to send a SQL QUERY OUTPUT as mail body using Power Automate and ADF. i am creating a Lookup activity in ADF where i am passing my query as: select * from adventure table where Animals = 'Lion' and Jungle = 'Amazon'. this table is available in the SQL Database.

the output of the above query i want to send in mail body not as csv attachment but as mail body only in form of table so third party can directly view the data in mail only using Power Automate Flow. this flow should run in every 1 hour daily.

 mail SUbject should look like:
    FROM: [email protected]
    TO : [email protected]
    Subject: Animals Details
    Hi XXXXX,
    these are the animal details :

output of SQL query: 
in table format

Thanks Retailer

i am using lookup activity where i am running my Query, just want to clarify is this good way to start the Process or some other activity we should use. — BigData Lover, Commented May 17, 2023 at 18:01
Just want to add one more point we don't want to share the QUERY output as csv file and send as attachment in mail. — BigData Lover, Commented May 17, 2023 at 18:02
I think you are right in using Lookup activty in ADF . Since ADF does not have its own email feature . have you explored Logic app . The below thread should give you some idea . learn.microsoft.com/en-us/answers/questions/152528/… — Himanshu Kumar Sinha, Commented May 17, 2023 at 20:40
Hi @HimanshuSinha as i am new to power automate, can you please help me with the end to end explanation. The link you have shared is totally different from my query — BigData Lover, Commented May 17, 2023 at 20:54

SwethaKandikonda · Accepted Answer · 2023-05-18 07:43:43Z

2

Below is something you can try to achieve your requirement. After the lookup activity, I used Web Activity and did a post call on power automate as below.

enter image description here

Body - @activity('Lookup1').output.value

Flow in power automate can be structured as below.

enter image description here

Here is the schema generated for the sample data

{
    "items": {
        "properties": {
            "animal": {
                "type": "string"
            },
            "id": {
                "type": "integer"
            }
        },
        "required": [
            "id",
            "animal"
        ],
        "type": "object"
    },
    "type": "array"
}

sample data

[
  {
    "id": 1,
    "animal": "Dog"
  },
  {
    "id": 2,
    "animal": "Cat"
  },
  {
    "id": 3,
    "animal": "Raccoon"
  }
]

Results:

edited May 18, 2023 at 7:43

answered May 18, 2023 at 6:49

SwethaKandikonda

8,2822 gold badges7 silver badges21 bronze badges

@BigDataLover, do check the updated answer
– SwethaKandikonda
Commented May 18, 2023 at 7:44
@BigDataLover, Im afraid thats not possible. Can you update the question on whats blocking you with images, so that I can have a look at it.
– SwethaKandikonda
Commented May 18, 2023 at 7:57
@BigDataLover, sure, here is the room chat.stackoverflow.com/rooms/253712/76274977
– SwethaKandikonda
Commented May 18, 2023 at 8:05
@BigDataLover, No we aren't passing any schema. rather it is generated
– SwethaKandikonda
Commented May 18, 2023 at 9:38

Add a comment |

Collectives™ on Stack Overflow

How to send a SQL query output as a mail using PowerAutomate and ADF

1 Answer 1

Results:

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Results:

Related