Add Sprint Reports in scheduled Project Automation email

Question

Hi,

I am using Jira Cloud and would like to schedule reports which includes list and status of all issues in the current sprint.

I want to schedule Sprint Reports through Project Automations and either send the list of issues in the email body or as an attachment.

Can you let me know the steps to do that?

Best,

Pankhuri

John Funk · Answer

Unfortunately, sending a single list of issues is not available for Cloud yet. You can follow along with the feature in this post:

https://community.atlassian.com/t5/Jira-Software-questions/Sending-an-email-with-a-list-of-issues-using-Automation-for-Jira/qaq-p/1192501

pankhuri_u4ed5p · Answer

Hi @John Funk

Thank you for your response!

Well I am not trying to update any field value of an issue.

I want to send an email with all the issues in the current sprint.

I did following:

1. Project Settings > Project Automation

2. Create Rule

3. Select Scheduled, entered 5 days and JQL Query: project = "project name" AND Sprint in openSprints()

4. Add Component -> Send email

5. To: admin, Subject: Weekly Report, Content: {{issue.key}}: {{issue.summary}}

6. Save and Publish the rule

Now, when I run the rule I am getting different emails with different issue name and number. (Number of emails received is the number of issues in that sprint eg. there are 10 issues in the sprint I am getting 10 different emails.)

I need following 2 in my emails:

1. I want 1 email with the list of all issues in that email. (Not multiple emails).

2. I also want to view the status of the issue in that email.

Please help me resolve this issue.

Thank you again!

Best,

Pankhuri

pankhuri_u4ed5p · Answer

Hi John,

Thank you for your response!

I basically don't want to update any field of the issue list. I would like to run a weekly email where I can send the list of issues and their status for the active sprint.

I did the following:

1. Project Settings -> Project Automation

2. Create Rule -> Scheduled

3. Fixed Rate of every 5 days and JQL Query: project = "project name" AND Sprint in openSprints()

4. SAVE

5. Add Component -> Send Email

6. To: admin, Subject: Weekly report, Content: Welcome.

7. Save and Publish the report.

When I run the rule, I am getting emails with the content mentioned "Welcome".

However, I get different emails with same content (the number of emails is same as the number of issues in the current sprint).

There are 2 things I want to do in the email:

1. To see the issue number and the current status of the issue (All issues in current sprint).

2. I want all the issues to be added in same email rather than getting X different emails.

I hope you understand my question and help me resolve this issue.

Thank you again!

Best,

Pankhuri