Send weekly report on project status from the Milestones sample app
The Milestones sample app allows users to create milestones for a team and track their progress using work items and work item status. The app can be extended further to send weekly emails to project managers or person creating the project with a list of all the work items and their status.
In this article, we'll learn how to create a Power Automate flow to send a project weekly report to the person who created the project with the work items listed along with their status.
Watch this video to learn how to send weekly report on project status from Milestones app:
Prerequisites
To complete this exercise, we'd need the ability to log in into Teams that will be available as part of select Microsoft 365 subscriptions, and will also need to have the Milestones sample app for Teams installed. This app can be installed from https://aka.ms/TeamsInspection.
Create the Power Automate flow
Sign in to Power Automate.
Select the environment that has the same name as the Team in which the app is installed.
Select +Create to create a new flow.
Select Start from blank – Automated cloud flow.
Select Skip to go to the next screen.
Update the flow title, and select Recurrence as the flow trigger.

Update the Recurring trigger values as shown below.

Add the following steps to the flow.
List rows steps – renamed to List Projects.
Table Name – "Projects"
Expand Query – "createdby"

List rows – renamed to List Work Items.
Table Name – "Project Work Items"
Filter Rows – "_msft_project_id_value eq @{items('Apply_to_each_2')?['msft_projectid']}"
Expand Query – "msft_WorkItemStatus_id($select=msft_name)"
Note
As soon as we select the Project ID in the Filter Rows field, the flow would put the List Work Items step into an Apply to Each container in which we would add more steps that would be needed.
Create HTML table – renamed to Create HTML table – Work Items.
From – the value from the previous step – "@{outputs('List_Work_Items')?['body/value']}"
Columns – "Custom"
Add the columns to the table:
Header Value WorkItemName Name from the List Work Items step WorkItemStatus Work Item Status from the List Work Items step

Send an email (v2).
To: "Created by Primary Email from the List Projects step."
Subject: "Project Work Item Status for [Name](Name from the List Projects step)."
Body: Output from the Create HTML table step.

Save the flow.
Select the Test button on the top right and select manually.
Data set up before testing the Power Automate Flow
Before testing the flow, we need to make sure we have some data with projects and work items within each project in the Milestones app.
Open Teams and run the Milestones app.
Create a new project.
Create Work Items under that project.
Test the Power Automate Flow
Go back to https://powerautomate.microsoft.com and open the flow.
Select Test on the top right.

Run the flow.
Check inbox for emails with weekly status – We should see one or more emails in the inbox for each Project.
