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:

  1. You can choose a trigger that fits your needs.
  2. Then, using the lookup Issues, you can use a JQL to retrieve the issues you want.
  3. 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:



Last modified on Sep 17, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.