Running a Wiql DevOps query in Power Automate

Power Platform - General

WIQL stands for Work Item Query Language used in Azure DevOps, similar to SQL
Power Automate can send a query to DevOps using a REST API to execute the WIQL query
The post is part of the Power Automate and DevOps series
To write WIQL, install the Wiql Playground extension in the organization
Construct the query in DevOps Queries, matching criteria for work items
Use the Wiql code to assign tasks to a specific email address in Power Automate
Handle the output of the HTTP call by parsing JSON and looping through workItemRelations
WIQL can be used in Power Automate to duplicate hierarchies and delete hierarchies, requiring skill in writing the query to achieve specific tasks.

Registered users can view the full text for FREE!