web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate create a flow to calcu...

Power Automate

Answered

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

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,943 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

Thank you @Expiscornovus, this helped me a lot.

Was this reply helpful? Yes No

Join the conversation