Weekly closed work report in Azure DevOps
Every Monday, email a report of work items whose Closed Date is in the last 7 days in Azure DevOps.
To use this template, you'll need to set up recipients, filters, and timezone before enabling the automation. This ensures that the report is sent to the correct people and includes the relevant work items.
Prerequisite: Install Automations App on your Azure DevOps organization
Trigger — Schedule
This trigger initiates the automation every Monday at 09:00 (UTC). It sets the schedule for when the report should be generated and sent.
Configured in this template
- Occurrence: Every Mon at 09:00 (UTC)
You can customize
- Change the day or time to suit your reporting needs.
- Adjust the timezone if your team operates in a different region.
Get — Search work items
This step searches for work items whose Closed Date is within the last 7 days. It uses field conditions to ensure only relevant items are included in the report.
Configured in this template
- Field conditions:
- - Closed Date >= @Today-7
- - Closed Date < @Today
- logic: and
You can customize
- Modify field conditions to include different work item types.
- Use a shared query for more complex search criteria.
Action — Send customized email
This action sends an HTML email listing the work items found in the previous step. The email includes links to each work item, making it easy for recipients to access details.
Configured in this template
- To: (empty — add recipients)
- From: notifications@documentero.com
- Subject: `Closed last week (
{items.Count}items)` - Body (HTML): `<p>Work items closed in the last 7 days:</p><ul>
{#Items}<li><a href="{Url}">#{Id}{Title}</a></li>{/Items}</ul>`
You can customize
- Add multiple recipients to the 'To' field.
- Customize the email body to include additional details or formatting.
Full automation
Common questions
How do I weekly closed work report in Azure DevOps?
What fields must be filled before enabling the automation?
Can I change the type of work items included in the report?
How can I test this automation?
How do I change the schedule or timezone?
Visual Studio Marketplace
Automations
Automate Azure DevOps workflows with triggers, actions, conditions, and scheduled rules.
Other Schedule & bulk templates in Automations.
Stale work report
Every Monday, email incomplete work items not changed in 14+ days (Closed Date empty). Adjust the stale window, or add work item types (Bug, User Story, Task) if the list is too broad.
Unassigned work report
Every Monday, email incomplete work items with no assignee, excluding Proposed (New, To Do, …). Closed Date empty.
Close resolved work after 30 days
Daily, find items in the Resolved state category unchanged for 30+ days, set State to Completed (Closed or Done for the work item type), and add a comment (max 50 per run; the rest wait for the next day).
Bulk assign from a query
On a schedule, run a shared query and set Assigned To on matching items (max 50).