I'm looking for some help to design a flow in power automate.
The Problem:
Currently my team are creating tasks directly on the board and not under the PBI which means it takes the default area path. I need to update all of these area paths manually to match the projects Area Path.
Solution:
I want a flow to run daily in the morning which takes my epics (Projects) gets the area path and then updates all nested children to the same area path.
Issue with Solution:
There could be up to 3 levels of children so I cant use the get children as I would have to get an apply to each inside an apply to each inside an apply to each. Which just isn't great.
I then thought I could use the ADO Query and get the parent/child tree I was hoping I could loop through these and it would be in the same order but it seems to return the results very different to ADO. So I cant just take the epic Area Path then update everything until the next epic. But as these aren't in the correct order I cant. There may be a way to order these correctly which would be great.
But any ideas are welcome.


Report
All responses (
Answers (