Customize and output sql query results to an email using Azure Logic Apps

Question

Customize and output sql query results to an email using Azure Logic Apps

Vivek Komarla Bhaskar 956

Hi,

Screenshot 2024-01-09 at 12.50.40

I am using Logic apps to email the results of a SQL query. Would it be possible to enhance the visual appearance of the SQL query results outputted as a table in the email? As an example,

Adding all border lines to the table
Make the headers bold and add a background color
Make the Footer/Totals row bold and add a background color.

Is there a way for me to accomplish this? I would want my email to look like below -
Screenshot 2024-01-09 at 13.01.53

Vivek Komarla Bhaskar 956 Reputation points

2024-01-09T13:04:00.35+00:00

Hi @Sonny Gillissen Could you please help

Accepted answer

0 additional answers

Your answer

Vivek Komarla Bhaskar 956 Reputation points

2024-01-09T13:04:00.35+00:00

Hi @Sonny Gillissen Could you please help

Answer 1

Sonny Gillissen 3,751 Volunteer Moderator

Hi Vivek Komarla Bhaskar,

Thank you for reaching out on Microsoft Q&A!

I've tested it in my lab, and this is possible by adding CSS to your email.

It's basically an HTML email, meaning you can style parts using CSS as you would with normal HTML. For this, create a 'Compose' action in your Logic App with the name "CSS" and add in the code below which colors your table (be sure to convert red and blue to the color codes of your liking):

<style>
table {
    border-collapse: collapse;
    border-spacing: 0;
}
tr, td, th {
    border: 1px solid black;
}
th {
    background-color: blue;
    font-weight: bold;
    color: white;
}
tr:last-child {
    background-color: red;
    font-weight: bold;
}
</style>

Now go to your email action and add the 'CSS' action output on top of your mail using the dynamic content:

User's image

When you send the mail it should appear like this:

User's image

Please click “Accept answer” if you find this helpful. Feel free to drop additional queries in the comments below.

Kind regards,

Sonny

Vivek Komarla Bhaskar 956 Reputation points

2024-01-09T17:18:09.9766667+00:00

Hi @Sonny Gillissen It works perfectly. A small issue, the emails internally when sent out include digital signatures, so in this instance, the signature is also being treated as a table, making things look clumsy. Is it possible to limit the table and last line CSS rules to before the digital signature? See below screenshot of the issue -
Sonny Gillissen 3,751 Reputation points Volunteer Moderator

2024-01-09T18:10:24.3466667+00:00
I see! Inline CSS is possible, however, that would mean a lot of replacing and extra complexity. I wouldn't advise you going there. But, there is another way!

What you could do is replace one tag, the top one, being <table>. If you replace it within your email with <table id="myId"> using the code below:

replace(body('Create_HTML_table'),'<table>','<table id="myId">')

You're able to change your CSS accordingly to the one below:

<style> table#myId { border-collapse: collapse; border-spacing: 0; } table#myId thead tr, table#myId thead tr th, table#myId tbody tr, table#myId tbody tr td { border: 1px solid black; } table#myId thead tr th { background-color: blue; font-weight: bold; color: white; } table#myId tbody tr:last-child { background-color: red; font-weight: bold; } </style>

Now the CSS only applies to the table with the same id, being your table, and therefor leave the signature out of play. Your Logic App will then look like this:

Let me know if this helped!
Vivek Komarla Bhaskar 956 Reputation points

2024-01-09T22:47:57.4733333+00:00

Thanks, @Sonny Gillissen Works great.

Share via

Customize and output sql query results to an email using Azure Logic Apps

0 additional answers

Your answer