Send Weekly Email using Jira Automation

[qais_alkhateeb]

Hello folks,

I made the setup correctly to send a weekly email for the issues in the active sprints only, but the strange thing if we have 100 issues in an active sprint, jira send 100 emails, why is not send a single email and list the issues in the email body, even i used the smart values in the email body but it seems jira is treating every issue as separate rule. please advise what i am missing here. thank you

[Bill Sheboy]

Hi @qais_alkhateeb 

You were expecting 1 email with 100 issues, and instead got 100 emails.  Correct?

This can happen if you are using the branch to iterate over the issues rather than the lookup action.  Here is an example rule which would do what you ask.

• Trigger: probably scheduled once per week, based upon your description
• Action: lookup using JQL for the issues in the active sprint.  Note that lookup can only return a maximum of 100 issues.  For example:

project = myproject AND sprint IN openSprints() ORDER BY Key

• Action: send an email to the interested people, listing all the issues.  For example:

Here are the issues in our sprint:
<ul>
{{#lookupIssues}}
<li><a href="{{url}}">{{key}} - {{summary}}</a></li>
{{/}}
</ul>

Best regards,

Bill