Sprint smart value into email

[Shir Avtabi]

Hi all,

we are creating an automation based on a few lookup issues and lookup tables to get a list of Jiras that were created or closed during the last sprint on each sprint completion into an email. 

We unsuccessfully tried to get the sprint name and dates into the email as well, with the smart values below:

{{issue.sprint}}

{{sprint.endDate.jiraDate}}

{{sprint.endDate.last.jiraDate}}

We also tried to use those smart values in a lookup table and the best we could get was a list of issue keys. Considering that we used the "sprint completion" trigger, is there a way to get those sprint details in the email? 

Thanks!

[Charlie Misonne · Accepted solution]

What is the trigger for your automation rule? 

sprint can return multiple sprint so you might have to use something like

{{sprint.endDate.last.jiraDate}} as explained in this answer. However I think it should be {{sprint.last.endDate.jiraDate}} 

[Shir Avtabi]

Thanks!

We tried with sprint completion trigger, but it didn't return anything with this smart value either.

Also tried to create a variable but it didn't work as well.

[Charlie Misonne]

Hi @Shir Avtabi 

You marked my answer as accepted. Does that mean the notation I suggested solved your issue?

[Shir Avtabi]

Hi Charlie, thank you.

After trying multiple smart values I eventually gave up on entering the sprint name and dates into the email.