Microsoft Power Automate for End Users
Participant resources for the two-day Microsoft Power Automate for End Users course: step-by-step chapter notes with screenshots, copy-paste values, a printable course book and sample files.
You do not need a GitHub account to use anything on this page.
Version 2.0, last updated 4 October 2026.
Program Flow
How to Use This Site
Each chapter has a Notes page with point-and-click steps and screenshots, and a Copy-paste page with every flow name and text value you type during the exercises. You’ll write just a few short expressions on the main path: one each in Chapters 4, 5 and 7, each with a step-by-step explanation. Anything more is in optional Going further boxes.
To copy a value: open the chapter’s copy-paste page, find the value, and click the copy icon in the top-right corner of the grey box. Then paste it into Power Automate. Copying from the box is safer than copying from the PDF, which can add line breaks or change the quotation marks.
Download: all course files (ZIP). Save the ZIP, then right-click it and choose Extract All before you open any file.
To read offline or print: download the course book (PDF). It has every chapter’s notes and copy-paste values in one file.
Course Scenario
Throughout the course you automate the work of one training coordinator.
You coordinate training for a small organisation. Course materials arrive by email, session details live in an Excel register, requests need approval, and participants need reminders.
Each chapter takes one of those manual tasks and turns it into a flow:
| Stage | What happens |
|---|---|
| Plan | Learn how flows work and write a plan before building anything |
| Prepare | Set up the OneDrive folders, Excel register, test email, Forms and Teams destinations |
| Collect | Save PDF attachments from training emails to OneDrive automatically |
| Report | Send the coordinator a one-click summary table from the Excel register |
| Remind | Send weekly reminders to every participant on a schedule |
| Approve | Route a training request form through an approval and post the result to Teams |
| Refine | Filter reminders to upcoming incomplete sessions, count them and summarise the week |
| Brief | Build a personal morning briefing with variables and parallel branches |
| Design | Use Copilot to plan a flow, then review and correct its suggestion |
| Release | Watch the trainer package the finished flow in a solution for another environment |
Chapters
| Day | # | Chapter | Copy-paste | What you will do | Time |
|---|---|---|---|---|---|
| 1 | 01 | Understand Power Automate | Copy-paste | Learn triggers, actions and flow types, find your way around Power Automate, and plan an automation | 45 min |
| 1 | 02 | Prepare your training workspace | Copy-paste | Create the OneDrive folders, the Excel register and a test email | 30 min |
| 1 | 03 | Save email attachments automatically | Copy-paste | Build an automated flow that saves PDF attachments to OneDrive | 50 min |
| 1 | 04 | Create and distribute an Excel summary | Copy-paste | Build an instant flow that emails one summary table from Excel, and write your first expression | 60 min |
| 1 | 05 | Send weekly training reminders | Copy-paste | Build a scheduled flow that sends a personalised reminder for each row | 40 min |
| 2 | 06 | Process a training approval | Copy-paste | Connect Forms, Approvals and Teams in one flow | 75 min |
| 2 | 07 | Capstone | Copy-paste | Filter weekly reminders, count them with a variable and send a coordinator summary | 65 min |
| 2 | 08 | My morning briefing | Copy-paste | Use variables and parallel branches to email yourself a daily briefing | 70 min |
| 2 | 09 | Plan an automation with Copilot | Copy-paste | Review and refine a Copilot flow plan | 30 min |
| 2 | 10 | Move automations with solutions | Copy-paste | Watch a flow being packaged for another environment (trainer demo) | 60 min |
| Any | 11 | Desktop flow: currency lookup | Copy-paste | Build a desktop flow that loops through Excel, searches Google in Edge and writes each rate back | 45 min |
| Any | 12 | Desktop flow: PDF invoices to Excel | Copy-paste | Build a desktop flow that reads a folder of PDF invoices and logs each number, date and total in Excel | 50 min |
| Any | 13 | Extra practice | Copy-paste | Four small personal flows for fast finishers and practice after the course | Self-paced |
Sample Data
The file TrainingRegister.xlsx in the Chapter 2 folder is a ready-made Excel workbook with the tblTraining table and six fictional records. Only use it if your trainer tells you to, instead of building it yourself. Chapters 2 to 7 use it.
test-files.zip holds the fictional email attachments for Chapters 2 and 3: CourseOutline.pdf, TrainerPhoto.jpg and SessionNotes.docx.
Before You Start
- Use only the fictional data in these files. Never put real names, email addresses or company documents into the practice resources.
- Keep your flows turned off until your trainer asks you to test them.
- Only send test emails to the addresses your trainer has approved.
What to Learn Next
These free Microsoft Learn resources pick up where the course ends.
- Build and optimize cloud flows in Power Automate: expressions, error handling and troubleshooting slow flows.
- Demonstrate the capabilities of Microsoft Power Automate: a wider tour of what Power Automate can do.
- Microsoft Certified: Power Platform Fundamentals (PL-900): a beginner certification if you want proof of your skills.
- Power Automate documentation: the official reference for every connector and action.
Need Help?
During the course, ask your trainer. After the course, contact the training coordinator who arranged your class.
Last updated: October 2026 | Trainer: Asraf
© Asraf Jaafar Sidik, Microsoft Certified Trainer. These materials are for course participants’ personal use. Please don’t redistribute or resell them.