How to retrieve the sprint start date of previous value

Question

Hello 👋

In a Jira automation, I would like to retrieve the start date of the sprint from the old value when it has changed. My string is « when value changed : Sprint »

I tried using:

{{changelog.fields.customfield_10020.from.0.startDate.jiraDateTime}}

But neither of them works.

➡️ How can I do ?

Sébastien OZANNE · Answer

I will use API to fix my problem.

Trigger in Jira : current sprint or empty empty

In Power Automate and with API : I will check both scenarios easily.

Bill Sheboy · Answer

Thanks for that information, @Sébastien OZANNE

When the sprint changes for the work item, the Field Value Changed trigger can be used.  And, the {{changelog}} smart value may be used to find previous values:

* the fromString value will have the sprint name
* the from value will have the sprint id

To get the removed sprint's Start Date by its id value, you would need to use the REST API.

Or, if you know there is at least one other work item still in the current sprint, the Lookup Work Items action could be used with JQL to find an example work item, and then get the start date from there.

* action: lookup work items, with JQL of:

project = yourProject AND sprint IN openSprints()

* some action that needs the date...

Or, if you assume the current, active sprint has the latest date, please use:

Sébastien OZANNE · Answer

I would like to know the sprint start date of triggered issue to compare with the current datetime and to know if a story has been removed or added in the current sprint.

So, I can retrieve the {{issue.sprint.startDate.jiraDateTime}} when the field is not empty.

But in case of, a story is removed of the current sprint to be put in the backlog, the sprint becomes empty, so I need to retrieve the previous value.