Table columns are getting squeezed while sending a table data to email using outlook connector (in logic apps)

Question

question

Issueinoutlookconnector-6340 asked Apr 20, '22 AndrewBlumhardt-1137 answered Apr 20, '22

Table columns are getting squeezed while sending a table data to email using outlook connector (in logic apps)

I am fetching the kusto query results using log analytics workspace connector , the results are in the form of a HTML table.
The results looks good . But when i am using the outlook connector to send the table data to an email ,then the table columns are getting squeezed .PFA scrrenshot.

office-outlook-itpro azure-logic-apps

image.png (12.7 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-20T14:09:32.923Z

AlistairRoss-msft answered Apr 20, '22 AlistairRoss-msft commented Apr 20, '22

What are you using to create the HTML table? The built in data connector for HTML tables does not allow for HTML formatting. I am no HTML expert, but I have been using this playbook as my starter for building formatted tables and www.w3schools.com for setting the relevant attributes

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Issueinoutlookconnector-6340 · Apr 20 at 02:49 PM

I am using the "Run query and visualize results" action from "log analytics workspace" connector in logic app to create a HTML table.

0 ·

AlistairRoss-msft Issueinoutlookconnector-6340 · Apr 20 at 03:10 PM

Same applies to this connector, you have no control over the output, though in this case the HTML is in a file. Use the "Run query and list results" and compose the HTML table using the example playbook I provided. One of the benefits of doing this, it that you can add colour and emphasis to data that may need to "pop out", such as alert severity, or in your case, Status.

Hope this helps

0 ·

Answer 2 · 2022-04-20T15:45:47.54Z

AndrewBlumhardt-1137 answered Apr 20, '22

I wonder if there isn't something in your output that is being misinterpreted; maybe needing an escape character. You might try alternatives like a CSV table, Exchange Online, or PowerBI.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question