Answered

create a flow to calculate age of the Azure Devops workitem.

(0) Share

Report

Posted on by Sukesh_Reddy Microsoft Employee

Hi Team,

I am querying the work items from ADO query, looking out for a solution to get created date for each work item and subtract it with today's date and calculate the age of the workitem.

is this possible?

I have seen couple of solutions online with SharePoint that is not applicable with this scenario...

Thanks in advance.

All responses (2)

Answers (1)

Sukesh_Reddy Microsoft Employee on at

Like (0)

Report

Re: create a flow to calculate age of the Azure Devops workitem.

Thank you @Expiscornovus, this helped me a lot.
Verified answer

Expiscornovus 31,891 Most Valuable Professional on at

Like (0)

Report
Re: create a flow to calculate age of the Azure Devops workitem.

Hi @Sukesh_Reddy,

You can use a Select action to add the Age key/property and use an expression with the dateDifference function with the Created Date and Today's Date (utcNow function) to calculate the age of each work item.

Below is an example

dateDifference(item()?['System.CreatedDate'], utcNow())