azuretfsazure-devopsazure-boards

Azure DevOps Pull work items in tree level in Excel


While publishing into project, I can add Tree Level and keep Parent Child in different columns.

But when I pull the tasks, the parent(epic) child(task) come into single column.

How can I pull parent child in different columns.

List Type: Flat

^ This is giving some hints. But how to change it?

Appreciate any tips. Thanks.

enter image description here


Solution

  • Ok got it. Had to edit the query in Azure DevOps.

    Earlier the Query was just a single level. Now this is how the query looks:

    enter image description here

    And this is how the Excel looks:

    enter image description here