Building an automatuon rule that using Rovo to create a page and run a Scenario

[Jamie Scott]

AIM: Create a Confluence page to show my squads Sprint Status Report

Manual process: 

1. Created a Confluence - 

2. Added a SMART BUTTON which when clicked runs a Rovo request to Create a new child page called "My Squads Latest Status Report" and populates it with info about current sprint

3. At the end of each week, I need to manually delete that page in Confluence and rerun the SMART BUTTON

I would like to setup a Confluence Automation Rule that will

- Each week (Friday 9am)

- Create a new Confluence page 

- Select a Rovo Agent

- Run a setup Scenario to populate the crated page <-- Issue

- Send an email notification (able to do)

Is this even possible?

[Bill Sheboy]

Hi @Jamie Scott 

Depending upon what the "status report" contains, this seems possible for things such as work item counts by status, etc. for building the page.  And, a Scheduled trigger rule could do both the create page and delete old ones (...although I am unclear why the prior one would be deleted when new pages are just added weekly).

What have you tried thus far to create the rule? 

If you have a rule that is not working as expected, please post the following to provide context for the community to help:

• an image of the complete rule,
• an image of the audit log details showing the rule execution, and
• explain what is not working as expected, and why you believe that to be the case.

Kind regards,
Bill

[Arkadiusz Wroblewski]

Agree @Bill Sheboy

Learning by doing. Better paste his Automation than ready answer.

I think mission here is not only help people here but to be better at the same time 🤗

[Jamie Scott]

I also tried to setup an automation.

1. Manual Trigger 

2. Find the page 

3. Delete it

4. Create a new page <-- Couldn't get this to work

5. Use Rovo to populate the page <-- Couldn't get this to work, perhaps becuase of step 4

6. Email me 

Any help would be appreciated

[Bill Sheboy]

Hi @Jamie Scott 

Please note in the flow of your rule, started manually from a page, that it:

• deletes the current page
• creates a new one
• and then attempts to use Rovo to update the current page

But, the current page is gone now...and do not believe Confluence rules have a branch to most-recently-created-page.

Have you tried removing the page delete, and changing the prompt to replace the content of the current page?

[Jamie Scott]

Hi Bill 

Thanks for your message.

The Status Report is actually just a standard text-driven report on how the sprint is progressing.

An example 

Create a Confluence page which includes the following report:

Jira Board: URL to the board

Review: Active Sprint

Provide the output as follows

Board Name

Sprint Name

Sprint start and end date

Sprint Goal

WORK RELEASED IN SPRINT:

List all Jira Issues with status 'DEPLOYED TO PRODUCTION'

WORK READY TO RELEASE:

List all Jira Issues with status 'READY TO DEPLOY TO PRODUCTION'

WHAT THE SQUAD ARE WORKING ON:

List all other Jira Issues not included SUBTASKS

ANY ISSUES?

List all Jira Issues with an active Flag

LAST UPDATE:

Date and Time Page Updated

Rovo is great at producing the report and when I run manually, it's consistant each time.

Using Confluence "SMART BUTTONS" I can get it to create a Confluence page with the data required.

I just can't set up an automation to do that.