Power Automate Power Automate

Level-500-Referenz zu Cloud Flows, Desktop Flows, Triggern, Aktionen, Fehlerbehandlung, Approvals, Process Mining, DLP, Solutions, PowerShell und Management APIs. Level 500 reference for cloud flows, desktop flows, triggers, actions, error handling, approvals, process mining, DLP, solutions, PowerShell, and management APIs.

3 3

Cloud-Flow-Haupttypen Primary cloud flow types

30+ 30+

Wichtige Triggerfamilien Important trigger families

RPA RPA

Desktop und Hosted Machines Desktop and hosted machines

DLP DLP

Governance und Connector Control Governance and connector control

⚠️ Jeder Flow ist ein Laufzeitsystem ⚠️ Every flow is a runtime system

Zuverlässige Automatisierung erfordert Trigger-Hygiene, Idempotenz, Fehlerpfade, Wiederholungsrichtlinien, Parallelitätskontrolle und den bewussten Einsatz von Connection References. Reliable automation requires trigger hygiene, idempotency, error paths, retry policies, concurrency control, and deliberate use of connection references.

Cloud Flows Cloud flows

Automated, instant, scheduled Automated, instant, scheduled

Trigger-Katalog Trigger catalog

Connector-basierte Einstiege Connector-driven entry points

Aktionen und Expressions Actions and expressions

Control flow, data ops, HTTP Control flow, data ops, HTTP

Desktop, Approvals, Mining Desktop, approvals, mining

RPA und Prozesssteuerung RPA and process control

Admin und APIs Admin and APIs

PowerShell, Management, Solutions PowerShell, management, solutions

Cloud Flows, Ausführungsmodell und Solutions Cloud flows, execution model, and solutions

Power Automate Cloud Flows existieren als automatisierte, manuell gestartete und zeitgesteuerte Flows. In Enterprise-Szenarien zählt zusätzlich, ob ein Flow solution-aware ist, Child Flows nutzt, über Environment Variables parametrisiert wird und ob Trigger idempotent genug für wiederholte Zustellung sind. Power Automate cloud flows exist as automated, manually triggered, and scheduled flows. In enterprise scenarios it also matters whether a flow is solution-aware, uses child flows, is parameterized through environment variables, and has triggers that are idempotent enough for redelivery.

Flow-Typ Flow type	Startsignal Start signal	Typischer Einsatz Typical usage	Besonderheit Special consideration
Automated Flow Automated flow	Ereignis aus Connector oder System Event from connector or system	When an item is created, Dataverse row change When an item is created, Dataverse row change	Concurrency, SplitOn und Retry sauber konfigurieren Configure concurrency, SplitOn, and retry carefully
Instant Flow Instant flow	Benutzeraktion per Button oder API User action by button or API	Mobile button, Teams button, selected item Mobile button, Teams button, selected item	Identität des auslösenden Benutzers bewusst auswerten Deliberately evaluate the identity of the invoking user
Scheduled Flow Scheduled flow	Recurrence Recurrence	Nightly sync, housekeeping, reporting Nightly sync, housekeeping, reporting	Zeitzone, Drift und Laufzeitfenster prüfen Review time zone, drift, and execution window
Child Flow Child flow	Aufruf aus anderem Flow Invocation from another flow	Geteilte Fehlerbehandlung oder Wiederverwendung Shared error handling or reuse	Nur in Solutions mit Connection References verfügbar Available only in solutions with connection references

JSON JSON


{
  "type": "OpenApiConnectionWebhook",
  "inputs": {
    "host": {
      "connectionName": "shared_sharepointonline",
      "operationId": "OnUpdatedItems",
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
    },
    "parameters": {
      "dataset": "https://contoso.sharepoint.com/sites/ops",
      "table": "6d2f9d0d-1f0a-4a42-8f8f-c7d0dbf2eb5f"
    }
  },
  "splitOn": "@triggerOutputs()?['body/value']"
}

Trigger-Katalog, Trigger Conditions, SplitOn und Concurrency Trigger catalog, trigger conditions, SplitOn, and concurrency

Trigger Trigger	Connector Connector	Szenario Scenario	Hinweis Note
Recurrence Recurrence	Schedule Schedule	Zeitgesteuerte Jobs Scheduled jobs	Zeitzone und Parallelitätsgrenzen definieren Define time zone and concurrency limits
Manual trigger Manual trigger	Built-in Built-in	Button, mobile, Testläufe Button, mobile, test runs	Für Parameter- und Demo-Szenarien For parameterized and demo scenarios
When an HTTP request is received When an HTTP request is received	HTTP HTTP	Externe Systeme oder Webhooks External systems or webhooks	JSON Schema und Auth separat designen Design JSON schema and auth separately
When a row is added, modified or deleted When a row is added, modified or deleted	Dataverse Dataverse	Geschäftsobjekte und ERP-nahe Events Business objects and ERP-adjacent events	Change Type und Scope bewusst wählen Choose change type and scope intentionally
When a row is selected When a row is selected	Dataverse Dataverse	Benutzeraktion aus model-driven App User action from a model-driven app	Instant-Pattern mit Dataverse-Kontext Instant pattern with Dataverse context
When an item is created When an item is created	SharePoint SharePoint	Listeneingänge List entries	Hohe Eventfrequenz und Trigger Conditions beachten Mind high event frequency and trigger conditions
When an item is modified When an item is modified	SharePoint SharePoint	Statusübergänge State transitions	Endlosschleifen mit Modified By / Flags verhindern Prevent loops with Modified By / flags
For a selected item For a selected item	SharePoint SharePoint	Benutzer startet Workflow für Listenelement User starts workflow for a list item	Guter Einstieg für Instant Flows Good start for instant flows
When a file is created When a file is created	SharePoint SharePoint	Dokumentenbibliotheken Document libraries	Dateigröße und Virenscan-Latenz beachten Consider file size and virus scan latency
When a file is created in a folder When a file is created in a folder	OneDrive OneDrive	Persönliche Dateiablagen Personal file stores	Unternehmensweit Governance-Frage Governance question at enterprise scale
When a new email arrives When a new email arrives	Outlook Outlook	Postfach-Automatisierung Mailbox automation	Anhänge und Spam-Sonderfälle prüfen Review attachments and spam edge cases
When a new email arrives in a shared mailbox When a new email arrives in a shared mailbox	Outlook Outlook	Funktionspostfächer Shared mailboxes	Servicekonten und Berechtigungen berücksichtigen Consider service accounts and permissions
When a Teams webhook request is received When a Teams webhook request is received	Teams Teams	Eingehende Teams-Integrationen Incoming Teams integrations	Mit Adaptive Cards kombinieren Combine with adaptive cards
When keywords are mentioned When keywords are mentioned	Teams Teams	Bot-nahe Trigger Bot-adjacent triggers	Governance für Kanalrauschen definieren Define governance for channel noise
When a channel message is added When a channel message is added	Teams Teams	Überwachung oder Moderation Monitoring or moderation	Throttling in aktiven Kanälen einplanen Plan for throttling in active channels
When a response is submitted When a response is submitted	Forms Forms	Formularbasierte Prozesse Form-based processes	Antwort-ID immer persistieren Always persist response ID
When a task is completed When a task is completed	Planner Planner	Task-Follow-ups Task follow-ups	Abhängigkeit zu Group/Plan-Kontext beachten Observe dependency on group/plan context
When a new tweet is posted When a new tweet is posted	X/Twitter X/Twitter	Social Monitoring Social monitoring	Connector-Lebenszyklus und Compliance prüfen Review connector lifecycle and compliance
When an event is added When an event is added	Office 365 Users/Calendar Office 365 Users/Calendar	Kalenderintegration Calendar integration	Serie versus Einzeltermin unterscheiden Distinguish recurring from single events
When a SQL row is modified When a SQL row is modified	SQL SQL	Line-of-business-Reaktionen Line-of-business reactions	Wasserzeichen oder CDC bevorzugen Prefer watermarks or CDC
When messages are available in a queue When messages are available in a queue	Service Bus Service Bus	Asynchrone Integrationen Asynchronous integrations	Dead-letter und Peek-Lock mitdenken Design dead-letter and peek-lock
When a work item is updated When a work item is updated	Azure DevOps Azure DevOps	ALM-Prozesse ALM processes	Noise durch Feldfilter reduzieren Reduce noise with field filters
When an incident is created When an incident is created	Sentinel Sentinel	Security Operations Security operations	Sicherheitsfreigaben und PII beachten Observe security approvals and PII
When an opportunity is updated When an opportunity is updated	Dynamics 365 Dynamics 365	CRM-Prozesse CRM processes	Plugin- und Flow-Kaskaden abstimmen Align plugin and flow cascades
When an order is created When an order is created	SAP SAP	ERP-Ereignisse ERP events	On-premises Gateway und Queueing beachten Observe on-premises gateway and queueing

Aktionen, Datenoperationen, Expressions und Fehlerbehandlung Actions, data operations, expressions, and error handling

Aktion Action	Familie Family	Nutzen Value
Condition Condition	Kontrollfluss Kontrollfluss	Vergleicht Werte und verzweigt Prozesse Compares values and branches the process
Switch Switch	Kontrollfluss Kontrollfluss	Mehrere Alternativpfade auf Basis eines Ausdrucks Multiple alternate paths based on an expression
Scope Scope	Kontrollfluss Kontrollfluss	Strukturiert Try/Catch/Finally-ähnliche Blöcke Structures try/catch/finally-like blocks
Apply to each Apply to each	Kontrollfluss Kontrollfluss	Iteriert über Arrays oder Datensätze Iterates over arrays or records
Do until Do until	Kontrollfluss Kontrollfluss	Wiederholt Schritte bis Abbruchbedingung erfüllt ist Repeats steps until an exit condition is met
Compose Compose	Datenoperation Datenoperation	Zwischenspeichert einen Ausdruck Stores an intermediate expression
Initialize variable Initialize variable	Variable Variable	Legt String-, Integer-, Float- oder Array-Variablen an Creates string, integer, float, or array variables
Set variable Set variable	Variable Variable	Aktualisiert Variablenwerte Updates variable values
Increment variable Increment variable	Variable Variable	Zähler- und Sequenzlogik Counter and sequence logic
Append to array variable Append to array variable	Variable Variable	Sammelt Ergebnisse Collects results
Parse JSON Parse JSON	Datenoperation Datenoperation	Erzeugt typed tokens aus JSON Creates typed tokens from JSON
Select Select	Datenoperation Datenoperation	Projiziert Arrays in schlankere Strukturen Projects arrays into slimmer structures
Filter array Filter array	Datenoperation Datenoperation	Filtert lokale Arrays Filters local arrays
Join Join	Datenoperation Datenoperation	Verkettet Array-Werte zu Text Joins array values into text
Create HTML table Create HTML table	Datenoperation Datenoperation	Rendert tabellarische Mail-Inhalte Renders tabular mail content
Create CSV table Create CSV table	Datenoperation Datenoperation	CSV-Ausgabe erzeugen Generates CSV output
Terminate Terminate	Kontrollfluss Kontrollfluss	Beendet Flow mit definiertem Status Ends flow with a defined status
Delay Delay	Zeit Zeit	Wartet definierte Zeit Waits a defined time
Delay until Delay until	Zeit Zeit	Wartet bis Zeitstempel Waits until a timestamp
HTTP HTTP	Integration Integration	Beliebige REST-API aufrufen Calls any REST API
HTTP with Microsoft Entra ID HTTP with Microsoft Entra ID	Integration Integration	Geschützte APIs mit OAuth aufrufen Calls protected APIs with OAuth
Send an email (V2) Send an email (V2)	Outlook Outlook	Benachrichtigung oder Aktionsmail Notification or action mail
Create item Create item	SharePoint SharePoint	Listenelement anlegen Create a list item
Update item Update item	SharePoint SharePoint	Listenelement aktualisieren Update a list item
Get items Get items	SharePoint SharePoint	Listendaten laden Load list data
List rows List rows	Dataverse Dataverse	Dataverse-Datensätze lesen Read Dataverse records
Add a new row Add a new row	Dataverse Dataverse	Datensatz anlegen Create a Dataverse row
Perform a bound action Perform a bound action	Dataverse Dataverse	Serverseitige Business-Logik aufrufen Invoke server-side business logic
Run script Run script	Excel Online / Office Scripts Excel Online / Office Scripts	Tabellen und Arbeitsblätter per Script verarbeiten Process worksheets and tables via script
Post adaptive card and wait for a response Post adaptive card and wait for a response	Teams Teams	Menschliche Interaktion im Chat Human interaction in chat
Start and wait for an approval Start and wait for an approval	Approvals Approvals	Genehmigungen mit Zustandsrückgabe Approvals with state return

Expression Expression	Wofür What for	Beispiel Example	Hinweis Note
coalesce coalesce	Fallback-Wert bei null Fallback when null	@coalesce(triggerBody()?['title'], 'n/a') @coalesce(triggerBody()?['title'], 'n/a')	Schützt gegen fehlende Felder Protects against missing fields
if if	Inline-Verzweigung Inline branching	@if(equals(variables('Mode'), 'Prod'), 'High', 'Low') @if(equals(variables('Mode'), 'Prod'), 'High', 'Low')	Gut für kompakte Ausdrücke Good for compact expressions
empty empty	Array oder String auf Inhalt prüfen Check whether an array or string has content	@empty(body('Get_items')?['value']) @empty(body('Get_items')?['value'])	Vor Schleifen und Indizierungen verwenden Use before loops and indexing
items items	Aktuelles Element im Loop Current item in a loop	@items('Apply_to_each')?['id'] @items('Apply_to_each')?['id']	Loop-Name stabil halten Keep loop name stable
outputs outputs	Aktionsergebnis lesen Read action output	@outputs('Compose') @outputs('Compose')	Für größere Objekte Compose sinnvoll Compose is useful for larger objects
triggerOutputs triggerOutputs	Kompletten Trigger lesen Read the complete trigger	@triggerOutputs()?['headers']['x-ms-file-last-modified'] @triggerOutputs()?['headers']['x-ms-file-last-modified']	Für Header und Metadaten hilfreich Helpful for headers and metadata
utcNow utcNow	Laufzeitzeitstempel Runtime timestamp	@utcNow() @utcNow()	Mit formatDateTime kombinieren Combine with formatDateTime
addDays addDays	Datumsarithmetik Date arithmetic	@addDays(utcNow(), 7) @addDays(utcNow(), 7)	Timezone erst später formatieren Format timezone later
formatDateTime formatDateTime	Datumsformatierung Date formatting	@formatDateTime(utcNow(), 'yyyy-MM-dd') @formatDateTime(utcNow(), 'yyyy-MM-dd')	Culture-spezifische Ausgabe bewusst wählen Choose culture-specific output deliberately
guid guid	Eindeutige IDs Unique IDs	@guid() @guid()	Nützlich für Korrelationen Useful for correlations
union union	Mengenvereinheitlichung Set union	@union(variables('A'), variables('B')) @union(variables('A'), variables('B'))	Duplikate werden entfernt Duplicates are removed
intersection intersection	Schnittmenge bilden Build intersections	@intersection(variables('A'), variables('B')) @intersection(variables('A'), variables('B'))	Gut für Berechtigungslogik Good for authorization logic

Expression Expression


@and(
  equals(triggerBody()?['Status'], 'Ready'),
  greaterOrEquals(int(triggerBody()?['Amount']), 1000),
  not(empty(triggerBody()?['Owner']))
)

Desktop Flows, Approvals, Business Process Flows und Process Mining Desktop flows, approvals, business process flows, and process mining

Desktop/RPA-Baustein Desktop/RPA building block	Beschreibung Description	Wann relevant When relevant	Hinweis Note
Recorder Recorder	Erfasst UI-Schritte in Windows- oder Weboberflächen Captures UI steps in Windows or web interfaces	Schnelles Prototyping Rapid prototyping	Resilienz später mit Selektoren nachziehen Harden later with selectors
UI Automation UI automation	Interagiert mit Fenstern, Controls und Dialogen Interacts with windows, controls, and dialogs	Legacy-Apps ohne API Legacy apps without APIs	Stable selectors und Fehlerpfade definieren Define stable selectors and error paths
Web Automation Web automation	Browser-Aktionen mit DOM-Bindung Browser actions with DOM bindings	Portale, Legacy-Webapps Portals and legacy web apps	Browser-Versionen und MFA berücksichtigen Consider browser versions and MFA
Excel Automation Excel automation	Arbeitsmappen lesen und schreiben Reads and writes workbooks	Finanz- oder Operations-Prozesse Finance or operations processes	Office Desktop versus Online unterscheiden Distinguish Office desktop from online
Attended Bot Attended bot	Läuft mit Benutzerinteraktion Runs with user interaction	Service Desk und Front Office Service desk and front office	Lizenz und Benutzerkontext einplanen Plan for license and user context
Unattended Bot Unattended bot	Läuft ohne Benutzer Runs without a user	Backoffice-Verarbeitung Back-office processing	Maschinenpools, Credentials und Audit sichern Secure machine pools, credentials, and auditing
Hosted Machines Hosted machines	Von Microsoft betriebene RPA-Laufzeit Microsoft-operated RPA runtime	Schnelle Skalierung ohne eigene VMs Fast scaling without your own VMs	Goldenes Image und Secrets-Strategie definieren Define a golden image and secrets strategy
Approvals Approvals	Sequenzielle, parallele oder benutzerdefinierte Freigaben Sequential, parallel, or custom approvals	Menschliche Entscheidung im Prozess Human decision inside the process	Timeout und Eskalation festlegen Define timeout and escalation
Business Process Flow Business process flow	Stufenbasierte Führung im Dataverse Stage-based guidance in Dataverse	CRM- und Case-Szenarien CRM and case scenarios	Führt Benutzer, ersetzt aber keinen Workflow Guides users, but does not replace a workflow
Process Mining Process mining	Analysiert Ablaufdaten für Engpässe Analyzes event data for bottlenecks	Kontinuierliche Optimierung Continuous improvement	Sauberes Event Logging ist Voraussetzung Clean event logging is a prerequisite

Admin Center, DLP, Solutions, PowerShell und Management APIs Admin center, DLP, solutions, PowerShell, and management APIs

Admin-Thema Admin topic	Wichtige Fragen Key questions	Werkzeuge Tools	Best Practice Best practice
Flow Sharing Flow sharing	Wer besitzt, wer betreibt, wer überwacht? Who owns, who operates, who monitors?	Run-only users, co-owners, service accounts Run-only users, co-owners, service accounts	Prod-Flows nie nur an Einzelpersonen hängen Never bind production flows to only one person
DLP DLP	Welche Connectoren dürfen Daten kombinieren? Which connectors may combine data?	Business vs non-business connector groups Business vs non-business connector groups	Regelmäßig gegen Shadow IT und Ausnahmen prüfen Review regularly against shadow IT and exceptions
Analytics Analytics	Welche Flows schlagen fehl oder verbrauchen viel? Which flows fail or consume heavily?	Admin center analytics, CoE kit Admin center analytics, CoE kit	Erfolgsraten und Retry-Muster überwachen Monitor success rates and retry patterns
Solutions Solutions	Sind Flows transport- und releasefähig? Are flows transportable and release-ready?	Managed solutions, deployment pipelines Managed solutions, deployment pipelines	Alle produktiven Flows solution-aware bauen Build every production flow as solution-aware
Licensing Licensing	Wo werden Premium-Connectoren oder RPA genutzt? Where are premium connectors or RPA used?	Power Platform licensing reports Power Platform licensing reports	RPA, AI Builder und HTTP-Konnektoren besonders prüfen Review RPA, AI Builder, and HTTP connectors carefully

PowerShell PowerShell


Install-Module Microsoft.PowerApps.Administration.PowerShell -Scope CurrentUser
Add-PowerAppsAccount

Get-AdminFlow |
    Select-Object DisplayName, EnvironmentName, CreatedBy, State

Get-AdminFlowOwnerRole `
  -EnvironmentName "Default-12345678-aaaa-bbbb-cccc-1234567890ab" `
  -FlowName "11111111-2222-3333-4444-555555555555"