Automation problem: When sprint is completed → create retro notes in Confluence

[Tiago Massochin]

Hello Atlassian community!

I'm trying to use automation that creates a new Confluence page every time my team finishes a Sprint.

I thought this automation would create a page in Confluence with our retrospective Sprint information log with the charts we can find in Jira.

But at the moment it's just creating a blank page. I tried to set the template as JIRA Report in automation, but it says "No Template Found" (Actually, I can't set any template no matter what I type).

Can anyone help me to solve this problem?

[Andrea Ho]

Hi @Tiago Massochin ,

Jira cloud has released a new feature for Team Managed Projects where at the end of a sprint, it will automatically create a Confluence retro page using a Confluence template https://support.atlassian.com/jira-software-cloud/docs/enable-sprints/#Complete-a-sprint so you don't need to set up an automation for this anymore! We are currently limited to one specific template in Confluence, but we're keen for feedback on this feature.

Thanks,

Andrea

[Julia Ysabel Yuzon]

do we have any updates if we could now have our template for this automation or are we still limited to a specific template in Confluence?

[Trudy Claspill]

Hello @Tiago Massochin 

Using Automation to create a Confluence page when a sprint ends does not include copying any of the sprint reports from Jira to Confluence, even if you are using a template. 

[Kathy Hart]

Have you already created the Parent Page "Sprint Retro Notes"? Does it exist? If not, this could be an issue. 

When you click in the Template box, does it offer you a list of templates? If not, then access to the templates is probably the issue. 

Make sure the template you want is available for the Space you want to use it in? 

I was able to create and run a manual rule to create a Confluence page from an existing Template. 

It allowed me to select the template from the drop down. 

But when I clicked on the dropdown, it was prepopulated with a list of Templates from the space I selected, and from the global template list. 

Also are you in Cloud, Data Center, or Enterprise? 

[Tiago Massochin]

• Have you already created the Parent Page "Sprint Retro Notes"?

Yes, I have.

• When you click in the Template box, does it offer you a list of templates?

Nope, just say "No Template Found"

• Make sure the template you want is available for the Space you want to use it in? 

I can use the JIRA Report template in Confluence. 

Could you tell me if I have to change any settings or permissions for my templates to appear in Jira?

• Also are you in Cloud, Data Center, or Enterprise? 

I'm using the Cloud free version

[Tiago Massochin]

The problem was that apparently the "Create page in Confluence" action can only identify templates that are not inside blueprints.

I created a template without being inside any blueprint, and it now appears in the list of templates in the Jira action.

---

But, my problem now is that the macros on this JIRA Report template will always push only the search parameters that I set on the template. And I will like to change those parameters dynamically on each sprint report page created. 

Of course, it is possible to edit this manually, but i would like this to be done automatically.

What I was thinking is to generate the page in Confluence with just the Sprint name on the Jira automation, leaving just {{sprint.name}} on the page title to be created.

And configure the macros in the confluence template to generate information based on the name of each page. Something like:

project = MYPROJECT AND Sprint = "Current Confluence Page Name" ORDER BY created DESC

But I don't know how (or if it's possible) to collect the name of the current page from Confluence and send it back to Jira using JQL.

Is there any way to do this?