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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
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())

Was this reply helpful? Yes No
Sukesh_Reddy Microsoft Employee on at

Like (0)

Report

Thank you @Expiscornovus, this helped me a lot.

Was this reply helpful? Yes No