Logic Apps: Run query and visualize results Html Table displayed in Email

Question

I would like to display the results of my query in a html table via email.

My attempt:

The above is attaching the .html to the email but i would like to display it in the email.

Answer 1

Here's a solution that does not require you to attach the .html file to the email.

Instead i've used run query and list results + create html table. Then wrapped the table in html to then be used inside an email.