Jira Automation to append content to Confluence

[Jose Quispe]

I am trying to make use of the Jira Automation feature to append comments made on Epics to a Confluence page that my team wants to use as overview of the relevant notes made by other colleagues on this work items, so far I have made the automation work and every time a new comment is logged on an Epic the automation appends successfully the URL, Key, CommentTimestamp, CommentAuthorName and CommentBody.  The problem is that the values returned in CommentTimestamp, CommentAuthorName and CommentBody contain ALL comments logged in the Epic not just the LAST ONE which is what I am after, in other tools I could imagine something like parsing the response (because I see is comma separated) and only write the last value of that list, BUT have no idea how to achieve that in the Jira Automation tool, anyone has experienced anything similar OR knows how to go about this.  Thank you!

[Bill Sheboy]

Hi @Jose Quispe -- Welcome to the Atlassian Community!

For a question like this, context is important for the community to help.  Please post the following:

• an image of your complete automation rule in a single image for continuity
• images of any relevant actions / conditions / branches
• an image of the audit log details showing the rule execution

Until we see those...

If the trigger for your rule is the adding of comments to the work item, you could reference the last comment only from the list of comments to add it:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#list.last

Kind regards,
Bill

[Jose Quispe]

@Bill Sheboy thank you that documentation helped a lot! are you aware of any kind of "trigger" that would take the system date and based on a day of the week allow to perform an action?

[Bill Sheboy]

If I understand your question, the Scheduled Trigger would work:

https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/#Scheduled

When using a different trigger and you want to compare the current date to a specific day of week, the date / time functions will help:

• The current date time is {{now}} -- https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Current-date-and-time---now--
• And with date formatting, that could be used to extract the day of week for testing in a condition: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-format---