Power Automate training · curricula & formats
Power Automate rarely fails on technology — but on unclear governance, missing Power Fx depth, or citizen developer initiatives without guidance. This page shows role-specific curricula, cloud flow practice, desktop flow RPA, and Power Fx workshops — instead of a generic "Power Automate basics course".
Selection criteria
Six criteria by which any Power Automate training offer must be measured. When comparing providers — ask exactly these points. Worded vendor-neutral so you can also classify the answers from competitors.
01 · Cloud flows + desktop flows
Power Automate combines API-based cloud flows (Outlook, SharePoint, Salesforce, SAP) with UI-based desktop flows (classic RPA). A complete training covers both worlds — and especially the interplay: cloud flow triggers desktop flow for legacy systems without an API. Trainings that only cover cloud flows leave out a central piece.
02 · Power Fx + expressions
Real Power Automate value creation begins with Power Fx — the Excel-like formula language for conditions, loops, data manipulation, and error handling. A good training covers JSON parsing, array operations (filter(), map()), dynamic content, and variable composition. Pure drag-and-drop training reaches its limits quickly.
03 · Connector depth
Standard connectors (Microsoft 365, SharePoint, OneDrive) are quickly explained. Premium connectors (Salesforce, SAP, SQL, HTTP) require deeper understanding of authentication, throttling, and data mapping. Custom connectors for company-specific APIs are their own topic. A good training covers all three worlds.
04 · AI Builder + Copilot
AI Builder (pre-trained AI models for form recognition, text analysis, translation) and Microsoft Copilot in Power Automate (flow generation from natural language) are firmly integrated in the platform in 2026. A current training covers both tools — including the cost logic of AI Builder credits.
05 · Governance & DLP
Power Automate rollouts without governance become unmaintainable in year two — hundreds of unused flows, no owner mapping, data in uncontrolled external services. A good training covers data loss prevention policies (DLP), environment strategies, and tenant settings — especially for admins.
06 · Pricing transparency
Are day rates, fixed-price packages, and travel costs openly communicated? Does the provider explain what an in-house day really costs — or do you get a flat-rate offer without breakdown? Good training providers lay out the math.
These six points are market standard for good training selection. In the next section we show where arades GmbH delivers reliably against each point.
arades as your Power Automate training partner
arades GmbH has been automating Microsoft processes since the early SharePoint Workflow days — through Microsoft Flow to today's Power Automate world. This platform history makes the difference: we know which concepts remain stable and which trends are better ignored.
We train cloud flows (triggers, actions, connectors, conditions) and desktop flows (UI automation, hosted RPA, picture-in-picture mode) in the same curriculum. The focus is on the interplay — when a cloud flow triggers a desktop flow for a legacy system, the architecture question is particularly important.
Power Fx is the Power Platform formula language that combines Excel logic with lambda concepts. Our Power Fx workshops cover JSON parsing, array operations (filter, map, sort), dynamic content with security aspects (untrusted input), and error handling patterns. Optionally, deepening in expression builder, inline code actions, and external test tools.
Standard connectors (Microsoft 365, SharePoint, OneDrive, Teams) as a basis. Premium connectors (Salesforce, SAP, SQL, HTTP, REST APIs) with OAuth, service principals, and throttling behavior. Custom connectors for company-specific APIs — spec auto-import, OpenAPI schemas, policy templates. From real implementation practice.
Practical exercises with AI Builder (form recognition for invoice processing, text classification for service tickets, translation for multilingual use cases) and Microsoft Copilot in Power Automate (flow generation from natural language). Including credit logic — what does an AI Builder call cost and when is the jump to premium worth it.
Data loss prevention policies as protection against data outflow into uncontrolled services. Environment strategies (dev, test, prod, sandbox per business area). Power Platform Admin Center walkthrough. Citizen developer governance: when do we let staff build themselves, when do we need review processes? From mid-market rollout projects.
Public online dates: from €1,000 net/person for 1–3 days. In-house training from 8 participants: fixed price per training day from €2,800 net, on-site plus transparently calculated travel costs. On-demand videos in subscription model. RPA coaching for internal citizen developer programs as a day rate.
Role curricula
A defined syllabus per role with clear depth. Modules are combinable — an in-house training can, e.g., combine citizen developer basics with a Power Fx excerpt from the pro developer curriculum.
Curriculum 1 · Citizen developer
Cloud flows without code: triggers (manual, Outlook, SharePoint, schedule), standard connectors, conditions, loops, simple approval workflows with the Approvals connector. Outlook-to-SharePoint routines, Teams notifications, OneDrive file processing. Target audience: staff without IT background.
Curriculum 2 · Pro developer
Premium connectors with OAuth and service principals, custom connectors with OpenAPI spec, JSON handling and schema parsing, Power Fx expressions in depth (filter, map, sort, variable constructs), error handling with try/catch/finally patterns, webhook-based integration, performance tuning for high-volume flows.
Curriculum 3 · RPA expert
Install and configure Power Automate for Desktop, UI automation with selector strategies, picture-in-picture mode for parallel work, hosted RPA (attended and unattended), process mining to identify automation candidates, best practices for more stable selectors, recovery strategies for failed flows.
Curriculum 4 · Power Platform admin
Power Platform Admin Center, environment strategies (dev/test/prod/sandbox), data loss prevention policies (DLP) — connector classification, tenant settings, license management (Per User, Per Flow, Process Plan, Hosted Process Plan), monitoring and capacity reports, audit logs, citizen developer governance with approval workflows.
Formats
Online-live, on-site, or on-demand — depending on team, geography, and timeframe. All formats can be combined with adoption guidance.
Format 1 · Online-live
Live training via Microsoft Teams with the trainer's screen sharing and parallel hands-on on your own tenants. 2–4 hours per session, multiple sessions spread over several weeks — protects daily business and deepens through pauses between sessions.
Format 2 · On-site
In-house training at your location — typically 1–3 contiguous training days. Particularly effective for intensive topics with whiteboard discussions, RPA selector exercises, and group work. Economical from 8 participants.
Format 3 · On-demand + coaching
Structured video library in subscription model, supplemented by weekly live office hours with the trainer. Suitable for distributed teams, individual pace, and onboarding of new citizen developers. No time pressure.
Frequently asked questions
Public online-live training per participant (1–3 days, from about €1,000 net per person). In-house training from 8 participants as a fixed price per day (from about €2,800 net/day, on-site plus travel costs). On-demand videos in subscription model. RPA coaching for internal citizen developer programs as an individual or small-group format.
Citizen developers (cloud flows without code, standard connectors, simple approval workflows), pro developers (premium connectors, custom connectors, JSON handling, Power Fx, expression builder, error handling), RPA experts (desktop flows, UI automation, hosted RPA), and Power Platform admins (DLP policies, environments, tenant governance).
Cloud flows automate API-based processes via connectors (Microsoft 365, Dynamics 365, SQL, SharePoint, third-party APIs like Salesforce or SAP). Desktop flows automate UI interactions on Windows desktops and web apps without an API — classic RPA. Both worlds often combine: a cloud flow triggers a desktop flow for legacy systems. In our training we cover both separately and the interplay.
For simple cloud flows with standard connectors: no. Citizen developer training conveys conceptual understanding (triggers, actions, conditions, loops) without code. For advanced scenarios — JSON handling, custom connectors, complex Power Fx expressions — basics in JSON and lambda-like thinking are helpful but not a must. Pro developer training systematically deepens these topics.
Yes, that's explicitly the advantage of an in-house training. Before the training date, we collect 3–5 typical automation use cases from your organization (approval workflows, Outlook-to-SharePoint, approval processes, data migration routines) and use them as the exercise basis. That makes the training directly actionable.
Power Automate is the execution layer for AI-supported automation. AI Builder provides pre-trained AI models (form recognition, text analysis, translation, object recognition) that are integrated in flows. Microsoft Copilot in Power Automate generates flows from natural language descriptions. In our training we show both tools in practice — including the cost logic of AI Builder credits.
Both. Public online dates for common topics (cloud flows basics, desktop flows introduction, citizen developer enablement) — useful for individuals and small groups. In-house training for mid-market rollouts from 8 participants with exercises on your concrete automation use cases.
Further reading
Six follow-up topics that typically become relevant after the Power Automate training selection.
Engineering overview of our Power Automate service spectrum — cloud flows, desktop flows, AI Builder, custom connectors, governance.
Per User, Per Flow, Process Plan, Hosted Process Plan — four licensing models for Power Automate, transparent math.
Power Apps, Power Automate, Power BI, Power Pages — the Power Platform overview. When Power Automate is only one building block.
DAX workshops, data modeling, dashboard design. Role-specific curricula for end users, data analysts, pro developers, and admins.
Response in under 4 hours, established Microsoft escalation path. Pay-per-hour, Application Care, or Strategic Care for Power Automate landscapes.
Calculate yourself what your Power Automate licenses would cost with the right mix of Per User, Per Flow, and Process Plan.
30 min · free · no obligation
Tell us about your team structure and your automation status. We listen, classify, and propose a suitable curriculum — format, duration, adoption guidance. If a different training path fits better, we say so.
