I am working on a simple flow to generate a report once a week, with items still stuck in a triage query in DevOps, and send an email out to requesters reminding them that their request is stuck with the triage mgr's comments on why it is stuck (usually missing data, etc).
In the DevOps template, there is an integer field used as a counter, that defaults to 3 when a new item is created. At the end of my workflow, that counter will be reduced by 1 every week. When it reaches "0", i will cancel the work item, and it will remove itself from the query.
My plan is to send the email with the query results every Monday to those requesters who created the Work item. The integer will be expressed with a header about how many weeks they have left to fix the ticket before it is cancelled.
The flow is formed like this:
The Compose expression is the standard for generating a table with borders: