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

Question

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?

Julia Ysabel Yuzon · Answer

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?

Andrea Ho_anennp · Answer

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

Tiago Massochin_629l4u · Answer

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?