Skip to content
OrionStats
Log inStart learning
← Project Lab
PROJECT 33Intermediate

Power Automate: Logs and Automated Emails

Business scenario

Store managers must be emailed when their daily sales file is missing, and the team wants a log of every report sent.

Problem statement

Design and build a Power Automate flow that checks for expected files, emails managers when files are missing, sends the daily summary, and logs every run.

Learning objectives

  • Design triggers, conditions and actions
  • Implement error handling (scopes, run-after)
  • Maintain a run log

Instructions

Use a SharePoint/OneDrive folder and an Excel/SharePoint list as the log. If you lack a Microsoft 365 licence, submit a detailed flow design (screenshots or diagram) and pseudo-steps.

Tasks

  1. Flow design diagram.
  2. Build with try/catch scopes.
  3. Log table schema and sample.
  4. Test cases including failure paths.

Deliverables

  • Flow export or design document
  • Log sample
  • Test evidence

Evaluation rubric

CriterionWeightExcellentProficientDevelopingInsufficient
Flow design25%Correct triggers and logic.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Error handling25%Failures caught and reported.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Logging20%Complete audit trail.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Testing15%Failure paths tested.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Presentation15%Concise, well-labelled outputs a manager can act on without explanation.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.