Power Platform Community Forum Thread Details

I want to fetch the predecessors of all work item of type "Feature" in ADO

For example: I will have user stories as predecessors to some Features.

I want to fetch these in Power automate to do further operations.

I have tried using HTTP request but, its not working for me at this point. I have passed the PAT.
I did some exploration to find that I got to parse the JSON output once the HTTP request is successful to know each predecessor ID.

Please let me know if you have any inputs on the above two. Also, do suggest if there is a better way to extract predecessors of a work item using Power automate

Categories:

Building flows

You don't have to use a Personal Access Token for this. Interaction with work items is allowed via the Send an HTTP request to Azure DevOps action.

In that action you can use a WIQL query which looks for work items with a LinkType System.LinkTypes.Dependency-Reverse (Predecessor) and where the Source work item ID of that link is your Feature work item.

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

Below is an example

URI

@{variables('ProjectName')}/_apis/wit/wiql?api-version=7.1-preview.2

Body

{
 "query": "SELECT [System.Id],[System.AssignedTo],[System.State],[System.Title],[System.Tags]
FROM workitemlinks
WHERE ([System.Links.LinkType] = 'System.LinkTypes.Dependency-Reverse')
 AND ([Source].[System.Id] = '@{variables('WorkItemId')}')"
}