Automation - Send email (with sprint scope) after sprint is complete

[Pedro Webster]

Hi, 

I'd like to create a automation to send email (single email) with the sprint scope (issues completed, not completed, etc) to certain users.

I have visited the topic bellow but still coudn't do it.
https://community.atlassian.com/t5/Jira-Software-questions/How-can-I-use-Automation-to-communicate-the-Sprint-scope/qaq-p/1331103

I have two problems:
> I need to send a single email (the automation is sending a email for each issue in the sprint).
> I need to make an email body with the sprint issues.

Help, pleasee!!

[Trudy Claspill · Accepted solution]

Hello @Pedro Webster ,

Welcome to the community.

I found several posts on sending a single email with a list of issues via Automation. Perhaps one of those would help.

The answer from @Bill Sheboy  in this post seems like it might be useful in your situation.

[Bill Sheboy]

Hi @Pedro Webster -- Welcome to the Atlassian Community!

Adding to Trudy's answer, the key helper for your use case is the Lookup Issues action to gather issues for one email: https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues

Kind regards,
Bill

[Pedro Webster]

Hello, @Trudy Claspill and @Bill Sheboy 

Thanks so much for the answers !! 

The challenge now is making a JQL that shows issues of my previous sprint.

The JQL query "project = myproject AND Sprint in openSprints()" doen'st work because my trigger is When: Sprint completed, so it returns blank =(

Any tips? tks again!

[Trudy Claspill]

Use the sprint smart value in your JQL

sprint = {{ sprint }}

That should pull the sprint that triggered the rule.

References:

https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/#Sprint-created--started--or-completed

https://community.atlassian.com/t5/Jira-questions/Jira-automation-can-I-use-smart-values-with-JQL-search/qaq-p/1921932

[Pedro Webster]

The email is blank =(

[Trudy Claspill]

You might need to add quotes around the smart value in the JQL.

sprint = '{{sprint}}'

You can also try using a Log action to confirm that the smart value  {{ sprint }} has the value you would expect from the closed sprint.

https://support.atlassian.com/cloud-automation/docs/debug-an-automation-rule/

[Pedro Webster]

It works!

Tk you so much! <3