After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Kursbeskrivning
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.
Förkunskapskrav
Det finns inga förkunskapskrav för den här kursen
Kursplan
Kursöversikt
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 XP
- Match the scenario to its trigger type100 XP
- Why doesn't a Recurrence trigger fit here?50 XP
- Scheduled triggers50 XP
- Build the daily renewal sweep100 XP
- Spot the wrong time-zone setting50 XP
- Why are there no weekend runs?50 XP
- Automated triggers and conditions50 XP
- Build a "renewal submitted" automated flow100 XP
- Add a weekday-only trigger condition100 XP
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
Kurs
slutförd
