Add Sprint Reports in scheduled Project Automation email

[pankhuri]

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]

Hi @pankhuri  - Welcome to the Atlassian Community!

I would encourage you to first try to create a rule and then ask here for assistance if you run into problems.

1. Go to Project Settings > Project Automation (on left-hand menu)
2. Press Create Rule in top-right corner
3. Select the Trigger "Issue Created" and press Save
4. Next Select to add an Action, and choose "Edit Issue"
5. Select the field Label
6. Select the options icon (3-dots) - and choose "Add/remove values"
7. Enter the value you want as a default and press Save
8. Name your Automation and turn it on

Now when each issue is created, it will add the desired default label as long as the issue is created in that project. You might need to refresh the page after each issue creation to see it.

You can do this via global rules to apply to all projects also. You'll need to be a Jira Admin/Site Admin, then instead of going to Project Settings, go to Jira Settings (cog icon on left-hand navigation bar) > System > Automation Rules (left-hand menu).

For more on using Automation For Jira see these help pages.

[pankhuri]

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

[pankhuri]

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

[John Funk]

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]

Oh Okay! Thank you for your reply!