PowerShell turns Planner task history into a weekly progress report
Reviewed by Helen Jones
Tony Redmond has extended an earlier Planner reporting workflow that stores weekly open-task counts in a SharePoint list. The new PowerShell report groups the last six Saturday snapshots by person, adds a six-week average, and includes a downloadable script.
The earlier workflow emailed task owners and gave coordinators a list of weekly figures, but it still made them inspect rows to understand whether work was closing over time. This report turns those snapshots into a trend that exposes persistent backlogs and uneven progress. It is most useful for teams that already collect reliable weekly Planner data and can run an unattended Microsoft Graph script safely.
Analysis
Pilot the report against one plan and six weeks of snapshots. Check the Graph permissions, compare the output with Planner, and only then schedule it for wider reporting.
Source note
Pulse published by Collab365 Spaces, reviewed by Helen Jones on . Cite as "Planner task history turns into a six-week progress report", Collab365 Spaces. 2 sources referenced.