Assistance with Confluence Automation - Smart Value for Page Table Row

[Birthe Schmidt]

Hi all,

I am trying to create a Smart Value to use in Confluence Automation, that retrieves the email addresses from a table on the Confluence page:

I was thinking of something like:

{{#join(page.table.rows, ", ")}}

{{this.cells[0]}}

{{/join}}

Can anyone help me with how the Smart Value for "To" in Confluence Automation should look like?

[Birthe Schmidt]

Hi Toby,

unfortunately this is not a good solution for me, as the emails I want to retrieve are not all Confluence Users.

So now I am trying to create a variable based on another task called "Business Owner" that holds the email address:

Variable:
{{task.body.substringAfter("Business Owner: ").substringBefore(" ")}}

However, this is not working... I guess it's because I am using two different TaskBody's in the automation!?

1. one in the trigger - "equals Initial value..."

2. one in the variable - "business owner"

[Tomislav Tobijas]

Hi @Birthe Schmidt ,

That's a tricky one, as you'll need to parse content from the page body.

I'd suggest trying something like this: https://community.atlassian.com/forums/Confluence-questions/Email-recipients-based-on-Page-properties-smart-values/qaq-p/2902922

Definitelly not the prettiest solution, but it should work :/

On the other hand, once Rovo is rolled out to your instance, you could create an agent that would extract all email addresses from the page. 
I've quickly tried this and it does extract email(s), but also adds some extra text as well. However, maybe you can prompt it to extract the exact email OR, you could use smart value functions to extract the email from the agent response.

This would need some playing around, but this could maybe be 'cleaner' solution than the one using body parsing.

Cheers,
Tobi

[Birthe Schmidt]

Hi Toby,

unfortunately this is not a good solution for me, as the emails I want to retrieve are not all Confluence Users.

So now I am trying to create a variable using based on another task called "Business Owner" that holds the email address:

Variable:
{{task.body.substringAfter("Business Owner: ").substringBefore(" ")}}

However, this is not working... I guess it's because I am using two different TaskBody's in the automation!?

1. one in the trigger - "equals Initial value..."

2. one in the variable - "business owner"

[Tomislav Tobijas]

@Birthe Schmidt apologies! I've just managed to catch up with these emails.

Can you maybe share what this task on the page looks like? Generally, this should work, but it depends on how you've formatted the content there.

[Birthe Schmidt]

Hi, 

I found a work around as I didn't manage to create a variable the includes a number of e-mail addresses displayed on my page (table format)  

So, I went with "human in the loop" and created a variable with the user email instead...that then can forward to relevant stakeholders.

I know this is not optimal, but it works.