Confluence automation

[Rajan Dangol]

Hi,

How can I set up an automation to send out a reminder email for pages that need reviewing and haven't been updated in the last two months?

I have created the following automation, but I am encountering an issue:

• When the email action is placed within the branch, an email is sent for each individual page.
• When the email action is moved outside the branch to generate a single email with a list of pages needing updates, the resulting list appears empty.

Could you please assist with resolving this issue?

[Tomislav Tobijas _Koios_ · Accepted solution]

Hi @Rajan Dangol ,

Instead of using branch, you can try going with Lookup pages action.

Although Lookup action in Confluence automation is a bit more limited than the one in Jira, you can still use "Last updated" criteria for this particular case.

And then, in the Send email action, you can make a list of all pages that have been found within search. Something like this may work:

{{#lookupPages}}
* Article: <a href="{{url}}">{{title}}</a>
* Page author: {{author.fullName}}
* Date last updated: {{dateLastUpdated}}
{{/}}

Cheers,
Tobi

[Rajan Dangol]

Hi Tobi,

Thank you so much for your support. Its working as expected.

Kind Regards,

Rajan

[Rajan Dangol]

Hi Tobi,

Is there a way to format the date last updated to "DD/MM/YYYY"?

[Tomislav Tobijas _Koios_]

@Rajan Dangol sure. You can use the following smart value:

{{dateLastUpdated.format("dd/MM/yyyy")}}

For more info, I would suggest taking a look at the following documentation: Automation smart values - date and time 

[Rajan Dangol]

Thanks Tobi, appreciate your support :)

Kind Regards,

Rajan

[Justin Schlueter]

This has been helpful, but I'm seeking a more advanced solution. I'd like to automate a process that identifies Knowledge Base (KB) pages, using lookuppages, that haven't been updated in 12 months. This automation would then send an email to each KB article owner, listing only the articles they own that require review. If an owner has multiple outdated articles, all of them should be included in the email. Do you have any suggestions on how to implement this? Thanks