After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
课程介绍
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.
A capstone exercise brings every piece together into one pipeline you can confidently hand to an operations team.
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.Approve, Share, and Ship
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 trigger50 经验值
- Match the scenario to its trigger type100 经验值
- Why doesn't a Recurrence trigger fit here?50 经验值
- Scheduled triggers50 经验值
- Build the daily renewal sweep100 经验值
- Spot the wrong time-zone setting50 经验值
- Why are there no weekend runs?50 经验值
- Automated triggers and conditions50 经验值
- Build a "renewal submitted" automated flow100 经验值
- Add a weekday-only trigger condition100 经验值
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.
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.
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.
Intermediate Power Automate
课程完成
