Course
Intermediate Power Automate
IntermediateSkill Level
Updated 07/2026
Power PlatformArtificial Intelligence3 hr16 videos57 Exercises3,950 XPStatement of Accomplishment
Create Your Free Account
Continue with GoogleShow more optionsor
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Loved by learners at thousands of companies
Training a Team?
Try for BusinessCourse Description
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.
What you'll learn
- Differentiate Recurrence, Automated, and Manual triggers and determine which fits a given business scenario, including time-zone configuration and trigger conditions.
- Identify how to fetch, filter, and enrich structured data using Get items with OData Filter Queries, Office 365 Users lookups, and SharePoint document metadata.
- Assess when to use Condition versus Switch for branching logic, including type-coercion pitfalls and the role of a Default case in preventing silent misses.
- Determine how to configure run-after settings to catch failures and timeouts gracefully, keeping a multi-record sweep running when individual actions error.
- Evaluate the approval workflow options (Approve/Reject, Custom Responses, Sequential) and recognize how flow sharing, ownership, and connection management affect production reliability.
Feels like what you want to learn?
Start Course for FreePrerequisites
There are no prerequisites for this course1
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.
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
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
Is this course suitable for beginners?
You should be comfortable creating basic cloud flows in Power Automate before starting. The course assumes you know how to add actions, use dynamic content, and save a flow.
What tools and connectors does this course use?
You will work with SharePoint, Office 365 Users, Outlook, Excel Online (Business), and the Approvals connector inside Power Automate cloud flows. All exercises run in a browser-based course environment.
What will I be able to build after this course?
A production-grade cloud flow that fetches filtered data, resolves people, branches on business rules, catches failures, routes through approvals, and writes an audit trail, all scheduled and handed over for shared ownership.
Who will benefit from this course?
Business analysts, operations coordinators, IT admins, and citizen developers who already build simple flows and want to handle branching logic, error handling, approvals, and production handover confidently.
Join over 19 million learners and start Intermediate Power Automate today!
Create Your Free Account
Continue with GoogleShow more optionsor
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.