Scheduling DevOps Query results on email

Question

The Requirement is that: 1. I have a Query created in my account in Azure DevOps which fetches me a list of all active work items in my current sprint. This is required for a regular followup with my team on a daily basis. 2. The work of extracting the list and sending it to my team as to be done manually.

Is there a way in which the Query saved in my DevOps account be executed on a scheduled basis (may be twice a day) and be sent over as an email to a pre-configured mailing list?

Any feature in DevOps or tool, if any, may be suggested. Thus avoiding the need to code using DevOps API for achieving the same.

Answer 1

This is not supported out of the box. Please take a look on this developer community topic. Reading the comments you may find this:

• extension: Scheduled Work Item Query
• code for above mention extension: github

So this extension should give you what you want.