Send issues in a single email structured in a table
Platform Notice: Cloud - This article 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 logic to 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:
Email content<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: