Weekly Outlook Task Completion Report

Overview

This flow compiles all completed Outlook tasks for the current week and generates a summary email that is sent to the user and their manager. The flow runs on Friday mornings, queries Outlook for tasks marked complete in the past 7 days, and formats a professional HTML report showing task name, completion date, and category for productivity tracking and management visibility.

Use Case

Managers need visibility into team productivity without manual status reporting, and team members benefit from a structured weekly accomplishment summary for self-reflection and documentation. This flow solves the problem by automatically aggregating task completion data from Outlook and distributing a professional weekly digest that empowers clear communication of progress and impact.

The flow is ideal for teams that:

• Automated Friday morning summary of all completed tasks for the week
• Professional HTML email format — easy to forward to stakeholders
• Tracks productivity metrics — completion dates and categories visible
• Includes both personal copy and manager copy for accountability
• Eliminates manual status report writing
• Integrates with existing Outlook task management workflow

Flow Architecture

Environment Variables

Connectors & Connections

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Deploying to another environment

Import the solution into the target environment, update flowlibs_ManagerEmailAddress with the manager's email, update flowlibs_ReportSubjectLine with the preferred subject, bind the Outlook 365 connection to the organizational mailbox, adjust the recurrence trigger day/time as needed, and turn the flow on.

Change report frequency

Edit the Recurrence trigger to run on a different cadence (e.g., Monday morning, bi-weekly) by changing the frequency and interval values.

Include task priority

Add a Priority column to the HTML table so high-impact work is called out visually in the email.

Filter by category

Add a Filter Array action after List Completed Outlook Tasks to keep only tasks from specific categories or projects before building the table.

Add task duration

Calculate the time between task creation and completion (e.g., div(sub(ticks(completedDateTime), ticks(createdDateTime)), 864000000000)) and append it as a Days Open column for effort metrics.

Export to Excel instead of email

Replace the Send Email actions with Create File in OneDrive or SharePoint to save reports as Excel workbooks for long-term trend analysis.

Include incomplete / overdue tasks

Add a second List Tasks + Apply to each branch for overdue or incomplete tasks and append a second HTML table to highlight blockers alongside completed work.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

addDays(utcNow(), 1)

addDays(utcNow(), -dayOfWeek(utcNow()))

items('For_each_completed_task')?['categories']

status eq 'Completed' and dateCompleted ge '@{variables('varStartDate')}'