Unanswered

workflow

(0) Share

Report

Posted on by jeyeline

119

Hi,
In Azure DevOps, we have multiple categories of work items like CR, Feature, Epic, etc. In order to track the work items and their effectiveness in supporting the progress of the project, we would like to have an automatic alert to the project team members with the content of the work items in their bucket provided that the work item aging should be more than 3.

Can anyone help us in setting up the alert or any other ways to accomplish this?

Would like to get the ideas for these. Thanks!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @jeyeline,

Just to double check. You mean if one specific project team member has more than 3 works items assigned to them which are all passed their target date you want to setup a one-time alert for this?

Normally I would suggest to use WIQL in a Send an HTTP request to Azure DevOps for this:

https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.1&tabs=HTTP

Was this reply helpful? Yes No
jeyeline 119 on at

Like (0)

Report

Actually, it is not the way. My concern is, that a project may have multiple team members and they do have a lot of work items assigned to them. We want to track the work items whose aging is more than 3 days which is the difference between the work item' created date and today's date.

So the mail trigger condition is work items with more than particular days of aging and not in closed status. The mail content should be the list of work items satisfying the condition.

Hope the question is clear!

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report
Hi @jeyeline,

In that case it might be easier to just use a query for this. You can use that in a Get query results action.

Below is an example

1. Below is the sample Aging work items query

2. Below is a flow setup.

3. First A Select is used to get a list of people which are assigned to work items

4. The apply to each uses a union function to get a distinct list of assigned to people to loop through

union(body('Select'),body('Select'))

5. A filter array is used to find all items matching to the current assigned to user.

@equals(item()?['System.AssignedTo'], items('Apply_to_each'))

6. A condition is used to check how much items this person has (3 or more)

length(body('Filter_Array'))

7. If that is the case an email is sent.

slice(items('Apply_to_each'), add(indexOf(items('Apply_to_each'), '<'),1), -1)

Was this reply helpful? Yes No
jeyeline 119 on at

Like (0)

Report

Thank you so much for the response. I tried the solution. However, I am getting a different error while executing it."Some of the connections are not authorized yet. If you just created a workflow from a template, please add the authorized connections to your workflow before saving."

Could you please help on this?

Attaching the screenshot for reference.

power flow.png

Was this reply helpful? Yes No
jeyeline 119 on at

Like (0)

Report

Hi,

Getting the following error. Would you please help this out?

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @jeyeline,

When I look at your screenshot the Select outputs looks a bit different to my outputs. It should return one array with only the assigned to values.

Can you make sure you switched the Map field of the Select to text mode with the button on the right side?

Was this reply helpful? Yes No
jeyeline 119 on at

Like (0)

Report

Thanks for your solution. I did correct a few things and it works for me. Attached here are the rules and triggered email.

powerAutomate.png

poweredit.png

Was this reply helpful? Yes No