Power Automate (Azure DevOps)

[CN77]

Hi,

I would like to create a flow, in which a receive an e-mail when specific work item has been updated. 

I do not seem to be able to specify it more specifically than to 'Area Path'.

So, for instance when a feature changes status from 'New' to 'Active' then I would like to receive an e-mail.

Ideally, I would actually prefer having an Excel cell change status from 'New' to 'Active' e.g.

I hope someone can help me 🙂

[Expiscornovus]

Hi @CN77,

You could use a servicehook and POST to a When a HTTP request is received trigger action url. Jon Russell has written a nice blog about this approach:

https://www.jondoesflow.com/post/service-hooks-for-azure-devops-http-request-in-power-automate

In your case the servicehook could look like the below:

Alternatively, you could also use the When a work item is updated action and check via a HTTP request what the latest updates are. The drawback of this approach is that the flow will trigger for every update. That is why I would prefer the servicehook one.

Below is the setup with a when a work item is updated approach

1. Uri for the Send an HTTP request action

ProjectName/_apis/wit/workItems/@{triggerOutputs()?['body/fields/System_Id']}/updates?api-version=6.0

2. Expression for the condition action which checks if the System.State field of a Feature work item is equal to In Progress in the last record of the Updates table.

reverse(body('Send_an_HTTP_request_to_Azure_DevOps')['value'])[0]['fields']['System.State']['newValue']