How to get all product backlog items from Azure DevOps with Power Automate/Agent Flows - The easy way

Recently, I played around with Azure DevOps again and I found a better and easier way to get all the product backlog items from Azure DevOps in Power Automate or Agent Flows. Here is the last blog post for reference: https://www.matthiasschmitz.com/post/how-to-get-all-product-backlog-items-from-azure-devops-with-power-automate

Here is the action that you need to use to retrieve all different kind of items from Azure DevOps:

There is also some documentation from Microsoft if you want to dive deeper into this topic. It is all about the Wiql API: https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql?view=azure-devops-rest-7.1

In my example above I wanted to retrieve all items that are tasks, assigned to me, where the state is To Do or In Progress and have it ordered in descending order.

One of the good things about this API is that if you do not specify a project you get the items from all the projects. This is a big benefit if you want a general overview of all your tasks for example.

I still think there should be a standard connector that allows you to this without writing the API call yourself :)

🚀🚀🚀

If you have questions or are interested in starting a project together, feel free to book a meeting with me: Book time with Matthias Schmitz

🚀🚀🚀