Forum Discussion
DataflowsError
thanks for response , actually for extraction i give say 9 am , the power automate flow runs when extraction is successful but the trigger point for final report is when transformation is complete but both transformation and report starts running parallely even in if else condition
Hi ArvindJha,
What you're running into is a common behavior in Power Automate, actions placed after each other don't automatically wait for the previous ones to complete unless explicitly configured to do so.
Even if you're using if/else conditions, if both branches or steps aren’t nested properly or controlled with "Configure Run After", Power Automate may still attempt to run them in parallel, especially if the actions don’t have a true dependency link.
Best Regards,
Hammad.
Community Support TeamThanks for the response but i dont find a way for dependency , transformation runs when extraction is successful but final dataset starts running in parallel
Power Automate doesn’t provide native dependency handling like a full orchestration tool, which makes this little tricky when you are chaining multiple dependent steps.
To enforce a true dependency, especially where the final dataset refresh must wait for the transformation to complete, you’ll need to explicitly check the status of the transformation dataflow before triggering the dataset refresh.
You can try it practically by these few steps:
* After triggering the transformation dataflow, use a loop with “Get dataflow refresh status”.
* Now inside the loop, check if the status is "Completed".
* Only after confirming completion, proceed to trigger the dataset refresh.
This polling approach ensures the dataset won’t refresh until the transformation is actually finished, even if Power Automate tries to run the steps in parallel.
Best Regards,
Hammad.