Daily Activity Log Email

End-of-day reporting is the first thing that slips when the day runs long. This flow reads what actually changed in Planner, writes it to the SAL Report list for the record, and leaves a ready-to-send Outlook draft so the lead only reviews and clicks send.

A recurrence trigger runs Monday to Friday at 18:20 in the Europe/Rome timezone. List tasks pulls the plan, a filter keeps items updated today, Apply to each appends HTML rows and creates SAL Report entries, and Create event/Send an email (V2) with 'Save as draft' leaves the summary in the lead's mailbox.

1. 1

   Create a Scheduled cloud flow with a Recurrence trigger: Frequency Day, Interval 1, Time zone (UTC+01:00) Amsterdam/Berlin/Rome, At these hours 18, At these minutes 20, On these days Monday to Friday.

2. 2

   Add Initialize variable 'ReportHTML' (String) at top level, immediately after the trigger.

3. 3

   Add Planner → List tasks for the plan you track.

4. 4

   Add Data Operation → Filter array on the tasks, condition: the task's completedDateTime or lastModifiedDateTime is greater than or equal to startOfDay(utcNow()).

5. 5

   Add Apply to each over the filtered body. Inside, append an HTML <tr> with title, percent complete and due date to ReportHTML.

6. 6

   Still inside the loop, add SharePoint → Create item on the 'SAL Report' list with Title, TaskStatus, LogDate = utcNow() and Owner.

7. 7

   After the loop add Compose 'EmailBody' wrapping ReportHTML in a table with a heading containing formatDateTime(utcNow(),'dd MMM yyyy').

8. 8

   Add Office 365 Outlook → Send an email (V2), set To to the team lead, Subject to 'Daily activity — [date]', Body to EmailBody, and in Advanced options set Importance Normal. To leave a draft instead, use the Graph-based 'Create draft' pattern via Send an HTTP request with Office 365 Outlook.

9. 9

   Add a Condition before sending: if the filtered array is empty, terminate as Succeeded instead of emailing an empty report.

Paste this into Power Automate Copilot to scaffold the flow.

Create a scheduled cloud flow that runs Monday to Friday at 18:20 in the Rome timezone. Initialize a string variable ReportHTML, list Planner tasks, filter to tasks modified today, loop them appending HTML table rows to ReportHTML and creating an item in the SharePoint list 'SAL Report', then compose an HTML summary and send it by email to the team lead, terminating early if nothing changed today.

Captures are added as each step is published.

• Recurrence trigger and schedules
• Date and time functions
• Send an email V2