Unanswered

Get SQL rows and send email

(0) Share

Report

Posted on by PJ-10092242-0 Microsoft Employee

I am trying to get the list of the emloyees from my database and wanted to send them as HTML table in email but i do not see any options iof sending the result set as email

All responses (3)

Answers (0)

funzel 2 on at

Like (0)

Report

Re: Get SQL rows and send email

Hi,

html output works for me (wihth log analytics query for example)
How do the same and send the output as csv file ?
v-micsh-msft on at

Like (2)

Report

Re: Get SQL rows and send email

Hi @Phani,

I came out an idea which might be a workaround here.

Please follow the Action steps showing in the screenshot below:

1. After add the Get Rows of SQL server, add a Compose Action, under the Dynamic content, search for Value;

2. Choose the SQL "Value" as the Compose Inputs;

3. Add the Send Email action after the Compose action, specify the Compose outputs as the Email Body, then click Advanced options in Send Email action, choose the IS HTML with Yes;

4. Save this Flow.

The testing result is the following:

Regards
v-micsh-msft on at

Like (0)

Report

Re: Get SQL rows and send email

Hi @Phani,

Currently I don't think it is available to have the emloyees queried from SQL database be sent directly in HTML email format through Microsoft Flow.

If we are using the SQL server Get rows, and add another action of Send an email, based on the outputs, it may automatically add an apply to each to the Send an email action, which means the email would send one employee name each time, and in total of the SQL table RowCount.

Sorry to say that currently I have no workaround available to offer.

Please consider to submit this as an idea in the Flow idea forum.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards