It's been said that I love automation. It's true, and I'm sharing some
微软
Power Automate flows that might help you, too.
As an operational team, we have incoming requests (which we've automated into Azure DevOps). Each morning at the start of the workday, its handy for everyone to have visibility of the incoming work that's not been seen or picked up yet. This keeps us on-point, lean and up to date.
These ADO queries produce:
- Any new/unassigned stories
- Any user stories that are aging (been open for 12 days old or more)
- This flow is triggered every Monday to Friday at 7:30 AM.
- It retrieves the first query results from Azure DevOps for new/unassigned stories. Note that this flow assumes you've setup this query already, which is not covered in this article.
- It creates an HTML table with links to Azure DevOps work items.
- Now, it performs a bit of housekeeping and replaces certain characters in the HTML tables. This is because the flow treats HTML as a string and produces it as '<', which needs replacing with '<'
- It then retrieves the second ADO query result, for aging user stories.
- It creates another HTML table with links to Azure DevOps work items and their assignees.
- It performs the HTML housekeeping again.
- Lastly, it posts a message in our group chat with the tables and additional information output in a nice format for the team to read.
