You’re offline. This is a read only version of the page.
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
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
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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (