The Work Gym

Courses / Business systems

Power Automate

Build cloud and desktop flows, inspect each run and recover from failures.

Start lesson 1 Practice interview Take the assessmentPractice the first unit of every course. No account needed.

56lessons

320checked exercises

13projects, cases and exams

Prepares you for Operations roles and PL-900 objectives

Projects, case studies and mock exams

Project · IntermediateSupplier inbox triage

Northline Supply's service coordinator needs a testable triage flow for supplier requests.

6 steps · 18 min Project · IntermediateWeekly Excel report

Cedar Vale's operations lead needs a weekly Excel reporting routine.

6 steps · 18 min Project · IntermediateExpense approval flow

Harbor Works' finance coordinator needs a recoverable expense decision record.

6 steps · 18 min Project · AdvancedRecoverable dispatch handoff

Juniper's dispatch coordinator needs a visible recovery path and a per-request support handoff.

6 steps · 18 min Project · AdvancedMonthly desktop file cleanup

Finch's operations analyst needs a monthly merge suitable for a workbook handoff.

6 steps · 18 min Case study · AdvancedMonthly reconciliation case

Maple Field's lead asks whether the monthly Ready output can be handed off despite duplicate rows and a missing archive.

6 steps · 15 min Case study · ExpertEnvironment and ownership case

Choose a maintainable access and ownership plan from the supplied evidence.

6 steps · 18 min Case study · ExpertPartial failure and retry case

Choose recovery scope from run evidence and duplicate-write risk.

6 steps · 18 min Project · ExpertInspectable operations handoff

Birch Lane's operations lead needs a maintainable report handoff.

6 steps · 15 min Mock exam · ExpertPower Automate fundamentals mock

Choose appropriate flow types, connectors, controls, and operational checks.

20 questions · 30 min

Practice Power Automate with cloud action cards, typed expressions and a desktop designer in your browser. Start with triggers and dynamic content, then build routing, approvals and Excel and SharePoint workflows. Run fictional events through your flows and inspect their messages, file writes and per-action inputs and outputs. Continuing projects build an inbox triage routine, a weekly report, expense approvals and monthly file cleanup. Later work covers recovery, connections, environments and safe repeated updates. Original interview sets and a timed PL-900-style Power Automate fundamentals mock cover the manually configured automation topics practiced here. The mock is limited to those objectives; it is not a complete or official PL-900 exam. All connectors and desktop applications use local fictional fixtures.

Beginner

Flow foundations

Choose triggers and connect actions with dynamic content.

4 lessons

1Cloud and desktop flow typesMatch event, button and schedule requirements to the correct flow type.4 exercises · 12 minFree

2Action cards and run historyConfigure connector fields and inspect their recorded effects.4 exercises · 12 minFree

3Dynamic content from a triggerUse event fields rather than hardcoded sample values.4 exercises · 12 minFree

Practice setFoundations practiceReview flow types, action order and dynamic fields on a new service desk.Free

Expressions and types

Build text and local dates without losing value types.

4 lessons

5Text expressionsBuild labels and extract delimited text without hardcoded sample values.4 exercises · 12 minWith a plan

6Date expressions and local timeFormat event dates and keep a local date distinct from a UTC date.4 exercises · 12 minWith a plan

7Value types in expressionsKeep numbers, booleans and arrays distinct from strings that resemble them.4 exercises · 12 minWith a plan

Practice setExpression practiceCombine text, dates and typed decisions on a fresh fulfillment feed.With a plan

Decisions and iteration

Route requests and process exactly the intended records.

4 lessons

9Conditions and branchesSend the right effect on both the true and false paths.4 exercises · 12 minWith a plan

10Switch cases and defaultRoute one value through named cases and retain an explicit default.4 exercises · 12 minWith a plan

11Apply to each and array scopeProcess the correct array and read the current item within the loop.4 exercises · 12 minWith a plan

Practice setBranching practiceRoute workshop work orders and process the intended records.With a plan

Intermediate

Data operations

Parse and shape data into a checked inbox workflow.

5 lessons

13Variables and accumulationInitialize a typed value before updating or accumulating it.4 exercises · 12 minWith a plan

14Compose and Parse JSONParse a payload with a deliberate schema and inspect its typed fields.4 exercises · 12 minWith a plan

15Filter array and SelectFilter the source rows before projecting the fields for downstream actions.4 exercises · 12 minWith a plan

ProjectSupplier inbox triageNorthline Supply's service coordinator needs a testable triage flow for supplier requests.With a plan

Practice setData operations practiceReview typed variables, parsing and array shaping on store returns.With a plan

Connected reporting

Read tables and lists and send useful summaries.

5 lessons

18SharePoint list and file actionsRead and update list items, then create and retrieve a library file.6 exercises · 12 minWith a plan

19Excel Online table actionsRead table rows and write with a deliberate table name and key column.4 exercises · 12 minWith a plan

20Outlook and Teams notificationsSend useful messages to the intended person or channel.4 exercises · 12 minWith a plan

ProjectWeekly Excel reportCedar Vale's operations lead needs a weekly Excel reporting routine.With a plan

Practice setConnector practiceReview table reads, keyed writes and targeted notifications.With a plan

Approvals and scheduling

Collect decisions and configure recurring work.

5 lessons

23Approval creation and waitingCreate an assigned approval and distinguish creation from a response.4 exercises · 12 minWith a plan

24Approved and rejected outcomesBranch on the actual approval outcome and preserve the rejection path.4 exercises · 12 minWith a plan

25Recurrence and schedulingSet a repeat interval and time zone that match the business clock.4 exercises · 12 minWith a plan

ProjectExpense approval flowHarbor Works' finance coordinator needs a recoverable expense decision record.With a plan

Practice setApproval and schedule practiceReview decisions, pending requests and recurring local-time work.With a plan

Advanced

Failures and recovery

Recover failed connector work and bound repeated checks.

5 lessons

28Scopes and run afterGroup work and recover its failed outcome through explicit run-after settings.4 exercises · 12 minWith a plan

29Do until and bounded repetitionChange loop state and stop within a deliberate iteration limit.4 exercises · 12 minWith a plan

30HTTP request and responseChoose method and endpoint and use the response body without inventing success.4 exercises · 12 minWith a plan

ProjectRecoverable dispatch handoffJuniper's dispatch coordinator needs a visible recovery path and a per-request support handoff.With a plan

Practice setReliability practiceRead failures and preserve correct effects across recovery paths.With a plan

Desktop automation

Use desktop variables, loops, Excel and a simulated application.

6 lessons

33Desktop variables and messagesSet desktop values and inspect them before later actions use them.4 exercises · 12 minWith a plan

34Desktop conditions and loopsIterate a list with the current-item variable and route records deliberately.4 exercises · 12 minWith a plan

35Desktop Excel automationRead worksheet data into a variable and write the intended rows.4 exercises · 12 minWith a plan

36Desktop UI automation and debuggingLaunch a simulated app, target a named element and inspect extracted data.4 exercises · 12 minWith a plan

ProjectMonthly desktop file cleanupFinch's operations analyst needs a monthly merge suitable for a workbook handoff.With a plan

Practice setDesktop automation practiceReview current-item scope, worksheet writes, UI elements and debugging.With a plan

Files and reconciliation

Merge files and data tables while preserving exceptions.

5 lessons

39Desktop files and foldersRead a folder deliberately and preserve file identity during a handoff.4 exercises · 12 minWith a plan

40Desktop data tables and duplicate policyBuild, merge and filter row collections without accidental deduplication.4 exercises · 12 minWith a plan

41OneDrive file actionsList folder children, read content and create a new named report.4 exercises · 12 minWith a plan

Case studyMonthly reconciliation caseMaple Field's lead asks whether the monthly Ready output can be handed off despite duplicate rows and a missing archive.With a plan

Practice setFile and table practiceReview folder scope, blank content, duplicate policy and output identity.With a plan

Expert

Connections and access

Choose environments, connections and sharing deliberately.

4 lessons

44Connections and service accessMatch each connector to its own connection and separate access from flow logic.4 exercises · 12 minWith a plan

45Environments and sharingSeparate test resources from production and distinguish running from editing.4 exercises · 12 minWith a plan

Case studyEnvironment and ownership caseChoose a maintainable access and ownership plan from the supplied evidence.With a plan

Practice setGovernance practiceReview environment identity, service connections and sharing roles.With a plan

Production handoff

Avoid duplicate writes and hand over inspectable workflows.

4 lessons

48Safe updates and repeated eventsUse stable keys and inspect existing state before repeating a write.4 exercises · 12 minWith a plan

Case studyPartial failure and retry caseChoose recovery scope from run evidence and duplicate-write risk.With a plan

ProjectInspectable operations handoffBirch Lane's operations lead needs a maintainable report handoff.With a plan

Practice setOperations handoff practiceReview keyed writes, partial failures and maintainable handoffs.With a plan

Interviews and certification

Explain decisions and complete a timed fundamentals assessment.

5 lessons

Interview setFoundationsExplain triggers, actions, connections, and the choice of cloud or desktop work.With a plan

Interview setFlow logicDiagnose typed conditions, collection inputs, schemas, and approval outcomes.With a plan

Interview setOperational judgmentExplain failure recovery, repeat-safe writes, local dates, and access boundaries.With a plan

Mock examPower Automate fundamentals mockChoose appropriate flow types, connectors, controls, and operational checks.With a plan

Practice setExpert practiceCombine established cloud and desktop patterns on fresh operational data.With a plan