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?

[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