nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Email recipients based on Page properties - smart values

Ashok Rao_8ngpt2

Hi,

I am new and not very fluent in smart values, so would appreciate some help:

I have created a confluence template with a page properties macro. In that macro is the project team (i.e. sales, technical lead, project manager, etc). These are often different for each project.

I would now like to use the @username mentions in that page properties macro to send a standard email only to those users.

I have looked on the confluence documentation for smart values, but I cannot find the answer to the problem. I know I am making an error in the syntax, as every time I run the automation rule, i get the following error:

"Unable to send the email as the recipient's email address wasn't provided".

Thanks,

Accepted answers

Tomislav Tobijas

Hi @Ashok Rao ,

On top of what Valerie sad, you can try following the steps described by Manon on this question: Confluence automation - Send email with title based on input of page properties macro

While it's not the prettiest solution, until CONFCLOUD-78944 is released, this could be a way to go.

Cheers,
Tobi

All comments

Valerie Knapp_dpp5c6

Hi @Ashok Rao , thanks for your question

Please can you share some screens of the automation rule so we can see how far you have got and how you want the rule to work? For example, what is the trigger? Are there any conditions? I appreciate you're asking for help with the actions but for us it's helpful to see the whole picture.

Thanks

Ashok Rao_8ngpt2

Hi @Valerie Knapp

Yeah, sure:

So, in the template, I have the page properties macro below:

Schermafbeelding 2024-12-26 141308.png

I want to send a mail to the users that are filled in.

Schermafbeelding 2024-12-26 141717.png

Not sure where I'm going wrong here. As I said, I'm not really very experienced in the syntax of smart values.

Thanks,

Valerie Knapp_dpp5c6

Hi @Ashok Rao , sorry, after checking the smart values documentation for Confluence, it seems you can't access the Page Properties Macro values yet.

There is a suggestion for this open with Atlassian, which you can vote on https://jira.atlassian.com/browse/CONFCLOUD-78944

For now, these are the smart values that are supported https://support.atlassian.com/cloud-automation/docs/smart-values-in-confluence-automation/

Sorry to disappoint.

Cheers

Ashok Rao_8ngpt2

Hi @Valerie Knapp ,

Thanks for confirming this. At least I know now to stop trying and wondering why it won't work...

Tomislav Tobijas

Hi @Ashok Rao ,

On top of what Valerie sad, you can try following the steps described by Manon on this question: Confluence automation - Send email with title based on input of page properties macro

While it's not the prettiest solution, until CONFCLOUD-78944 is released, this could be a way to go.

Cheers,
Tobi

Ashok Rao_8ngpt2

Hi @Tomislav Tobijas ,

Thanks for the response.

That was also my question, from a few weeks ago.

It's what made me think that a solution was possible, But even with that, I cannot find the exact syntax to make it work. Every try I've done results in the same error message in the log: "Unable to send the email as the recipient's email address wasn't provided"

Tomislav Tobijas

My apologies m8! Didn't even consider checking who's the author of the question 🤦‍♂️

I think I'll have some extra time in the next couple of days so I might test it out and try to find the 'workaround'. If I manage to get it to work, I'll share it here.

Tomislav Tobijas

@Ashok Rao I've managed to get it to work. Although, a slight notice is that this solution is based when only one user is mentioned in Page Properties table row. In order to get it to work for any number of mentioned users, you would need to adjust parsing content from the page (in this example variable part) and then probably use branch based on string of account IDs which would be stored inside mentioned variable.

Anyway, all of this is based on answer Manon provided with additional part of getting account email from account ID which is visible in the page body part.

Here's a page example:

2024-12-28 10-20-04.png

Firstly you can create variable and use the following:

{{page.body.storage.substringBetween("Client names</strong></p></th><td><p><ac:link><ri:user ri:account-id=\"","\"")}}

This would get you ID of the account that was mentioned.
*👆 change string Client names if necessary; this is just a name I've used in my page properties table (see first screenshot)

2024-12-28 10-09-37.png

Next, you would need to send a web request to the Atlassian site to get user details. For this, use account ID which is stored in previously created variable. Web request URL would look something like:

https://sitename.atlassian.net/rest/api/3/user?accountId={{accountId}}

For authorization part, take a look at the following article: Automation for Jira - Send web request using Jira REST API

2024-12-28 10-09-57.png

And lastly, you can then use

{{webResponse.body.emailAddress}}

smart value and add it to "To" part of the Send email action in automation.

2024-12-28 10-10-02.png

Hope this helps.

Cheers,
Tobi

Jad Saliba

Hi @Ashok Rao @Tetiana T_ @Tomislav Tobijas @Valerie Knapp

We have been thinking about the problem you have described and eventually also solved. We feel that this problem is a common one and that Confluence deserves a better, more user-friendly solution. As an app vendor we were thinking about whether it is worth to implement a streamlined solution. It would look something like this:

There is a new Automation action which extracts content from the Confluence page and associates it with Smart Values. These data can come from:
- Content Properties (formerly Page Properties)
- @-mentions on the page
The new Smart Values can then be used in subsequent actions, for example, email notifications

Do you think this would have helped you solving the problem? Do you think it generates value for Confluence Cloud users?

Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud