Email issues structured in a table
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
How to send a structured table by email containing issues' fields using automation.
Solution
You can combine HTML tables +lists smart values and conditional logicto achieve the goal. Example:
You can choose a trigger that fits your needs.
Then, using the lookup Issues, you can use a JQL to retrieve the issues you want.
On the send email action, you can use a structure like below to have a table:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18<html> <body> <table border="1" cellpadding="5"> <tr> <th>Issues</th> <th>Assignee</th> <th>Created</th> </tr> {{#lookupIssues}} <tr> <td>{{key}}</td> <td>{{reporter.displayName}}</td> <td>{{created.shortDateTime}}</td> </tr> {{/}} </table> </body </html>
To insert new columns to the table, add them using the syntax <th>Title</th> between the first <tr></tr> tags.
Then, add the corresponding smart value using the syntax <td>{{smartvalue}}</td> between the second <tr></tr>.
Make sure to keep the format as HTML and the option "Convert line breaks to HTML line breaks" unchecked to avoid breaking the table:
Was this helpful?