メインコンテンツへスキップ

コース

Intermediate Power Automate

中級スキルレベル

更新日 2026/07

Build reliable Power Automate cloud flows with triggers, branching, approvals, error handling, and production handover.

コースを無料で開始

Power PlatformArtificial Intelligence

3時間

16 ビデオ

57 演習

3,950 XP

修了証明書

何千もの企業の従業員が支持

チームのトレーニングを担当していますか？

Businessをお試しください

コース説明

Automating a business process is easy until the data is messy, the logic branches, and someone needs to approve before anything moves forward. This course takes you past the basics and into the patterns that make Power Automate flows reliable enough for production.

Choose the Right Trigger and Fetch Data Efficiently

Start by comparing Recurrence, Automated, and Manual triggers, then build a daily renewal sweep with time-zone-aware scheduling. Connect to SharePoint with Get items and OData Filter Queries to pull only the records you need, resolve people via Office 365 Users lookups, and attach contract documents with the right link-vs-attach security posture.

Branch, Route, and Handle Failures

Add Condition actions to split flows on contract value (with type-coercion safety nets), replace nested Conditions with Switch for multi-status routing, and configure run-after settings so one failed action doesn't kill an entire sweep. Learn the diagnostic loop: test, inspect run history, fix, and resubmit.

Route high-value renewals through Start and Wait for an Approval, swap binary Approve/Reject for Custom Responses, and branch on the Outcome. Then prepare for handover: share the flow with co-owners for continuity, assign run-only access for end users, and verify the pipeline is live.

A capstone exercise brings every piece together into one pipeline you can confidently hand to an operations team.

前提条件

このコースに受講要件はありません

1

Triggers that fit the job

Detect upcoming contract renewals before they lapse. Walk through the three Power Automate trigger families, pick the right one for a real-world automation problem, configure time zones so a scheduled flow fires when users expect, and add trigger conditions that stop the flow from running on weekends.

Picking the right trigger

Match the scenario to its trigger type

Why doesn't a Recurrence trigger fit here?

Scheduled triggers

Build the daily renewal sweep

Spot the wrong time-zone setting

Why are there no weekend runs?

Automated triggers and conditions

Build a "renewal submitted" automated flow

Add a weekday-only trigger condition

チャプターを開始

2

Acting on structured data

Fetch, filter, and enrich contract records using SharePoint Get items with OData queries, resolve responsible partners via Office 365 Users lookups, attach contract documents with the correct link-vs-attach security posture, draft notification emails with dynamic content, and write back an audit trail so the flow remembers what it has already done.

Getting data: fetching structured records

Add Get items for upcoming renewals

Where does this filter belong?

Why did Get items return 0 records?

Resolving people: the lookup pattern

Resolve the responsible partner's email

Which token gives the email address?

People-reference anatomy

Working with SharePoint documents

Look up the contract PDF and capture its link

Why does the recipient see "Access denied"?

Attach or link?

Notification and audit-trail write-back

Send notification and update the audit trail

What changed in the audit workbook?

Audit trail simulator

チャプターを開始

3

Conditional logic and reliability

Route contracts by value with Condition actions and by status with Switch, guarding against type-coercion gotchas and silent Default misses. Then add run-after failure branches so one broken connector call doesn't kill the entire sweep, and close the diagnostic loop with test, run history, and Show raw outputs.

Condition: branching on contract value

Branch the flow on contract value

Why does the Condition always take "If no"?

Switch: routing by status

Replace nested Conditions with a Switch

Spot the missing Default

Switch builder sandbox

Run-after: catching failures gracefully

Add a "log failure to SharePoint" branch

Run-after state picker

Why didn't the failure-handler fire?

Test, run history, and the diagnostic loop

Find and fix the seeded bug

Which Flow Checker warnings matter?

チャプターを開始

4

Approvals and the renewal pipeline

Route high-value renewals through the Approvals connector, swap binary Approve/Reject for Custom Responses, and branch on the Outcome (capital-A casing trap included). Prepare the flow for production with shared ownership, run-only access, and connection continuity, then assemble everything into a capstone pipeline.

Approvals fundamentals: Start and wait

Add an approval for high-value renewals

What does the approver see?

Why didn't the "If approved" branch run?

Approval types and custom responses

Replace Approve/Reject with custom responses

Approval-type sandbox

Match the scenario to the approval type

Sharing, ownership, and going to production

Inspect the Share dialog

Owner or run-only?

Why does this flow keep failing after handover?

The full renewal pipeline

Assemble the final renewal pipeline

Renewal pipeline report card

Congratulations!

チャプターを開始

Intermediate Power Automate

コース完了

修了証明書を取得

この修了書をLinkedInや履歴書、CVに追加しましょう
ソーシャルメディアや人事評価で共有しましょう今すぐ登録

19百万人を超える学習者と共にIntermediate Power Automateを始めましょう！

DataCamp for Mobileでデータスキルを磨きましょう

モバイルコースと毎日の 5 分間のコーディングチャレンジで、外出先でも進歩できます。