Power Automate runs routine office work for you: alerts, saving attachments, reminder emails, approvals, forms to Excel, and desktop automation. Eight lessons, each with a step-by-step guide you can follow in your own Microsoft 365 account.

1. 1Power Automate Lesson 1: What Power Automate Is (Cloud vs Desktop)Understand Power Automate: cloud flows vs desktop flows, triggers and actions, connectors, licences included with Microsoft 365, and what to automate first.
2. 2Power Automate Lesson 2: Your First Cloud Flow — Email AlertsBuild a flow that sends a Teams or mobile notification when an important email arrives: trigger conditions, dynamic content, testing and turning…
3. 3Power Automate Lesson 3: Save Email Attachments to OneDriveAutomatically save invoice attachments to a OneDrive or SharePoint folder: attachment trigger, Apply to each, file names with dates, and skipping signature…
4. 4Power Automate Lesson 4: Excel Table to Reminder EmailsSend reminder emails from an Excel table: scheduled trigger, List rows present in a table, filter by due date, send personalised emails…
5. 5Power Automate Lesson 5: ApprovalsBuild an approval flow: start and wait for an approval, approve from email, Teams or mobile, branch on the outcome, and record…
6. 6Power Automate Lesson 6: Forms to Excel and TeamsSend Microsoft Forms responses into an Excel table and post a summary to a Teams channel: get response details, add a row,…
7. 7Power Automate Lesson 7: Power Automate Desktop — Your First Desktop FlowAutomate Windows apps and websites with Power Automate Desktop: install, recorder, UI elements, variables, Excel actions and a flow that copies data…
8. 8Power Automate Lesson 8: Error Handling, Run History and Good HabitsKeep flows reliable: run history, Configure run after for failure branches, scopes for try/catch, notifications on failure, naming, ownership and documentation.

Related: save email attachments, Excel to email reminders, first desktop flow.