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