How to get all product backlog items from Azure DevOps with Power Automate

Normally you would think it should be quite easy to retrieve the product backlog items (PBIs) from Azure DevOps since it is all Microsoft and there are super nice connectors but it actually is not.

To be fair there is the "List work items" action but you need to enter the Work Item IDs and when you just want to retrieve all PBIs without entering all the numbers this just does not make any sense.

At first glance this action was the most helpful one of all the actions there are:

But stay with me. There is one that solved my struggle and maybe yours too: Get query results

For this to work you need to enter your organization and project name but way more important you need to add the query.

The query you define directly in Azure DevOps and that is probably the most important step.

You go to the Query Editor and define the query exactly to your liking. Very important is to define the columns you want to see because Power Automate only retrieves the columns that are selected in the editor.

In my case I wanted to create kind of an effort impact matrix with the PBIs and therefore I wanted to see those data in an app. In this example you see that only the four columns I selected in the editor are visible in my Power Automate flow run.

I hope this will be of help for you when you want to retrieve Azure DevOps PBIs in Power Automate.

Cheers!