How to create automated workflows in Power Automate

How to Create Automated Workflows in Power Automate

Microsoft Power Automate is a cloud-based automation platform included in Microsoft 365 E3/E5 subscriptions and available as a standalone product (Premium at $15/user/month as of April 2026). It connects to over 1,000 services with pre-built connectors and supports custom API calls.

Step 1: Choose a Starting Point

Navigate to flow.microsoft.com and click "Create." Select from:

• Automated cloud flow — Trigger-based (event from a connected service starts the flow)
• Instant cloud flow — Manual trigger (button press, mobile app, or Power Apps)
• Scheduled cloud flow — Time-based (runs at specified intervals)
• Start from a template — 10,000+ pre-built templates for common scenarios

Templates are the fastest starting point. Search for the scenario (for example, "save email attachments to OneDrive") and customize the pre-built flow.

Step 2: Add a Trigger

Every flow starts with exactly one trigger. Common triggers include:

• When a new email arrives (Outlook connector)
• When an item is created (SharePoint connector)
• When a form is submitted (Microsoft Forms connector)
• When a row is added (Excel Online, Dataverse)
• When an HTTP request is received (custom webhook)

Configure the trigger by selecting the specific mailbox, SharePoint list, or form, and optionally set conditions to filter which events initiate the flow.

Step 3: Configure Actions

Click "New step" to add actions. Each action connects to a service and performs an operation:

• Send an email (Outlook, Gmail)
• Create item (SharePoint, Dataverse)
• Post message (Teams, Slack)
• Start an approval (Power Automate Approvals)
• Update a row (Excel, SQL Server)
• HTTP (call any REST API)

Use dynamic content tokens from the trigger and previous steps to populate action fields.

Step 4: Add Conditions and Branching

Insert a "Condition" control to create if/else branching. For example, if the email subject contains "urgent," route to a manager for approval; otherwise, file it in a standard folder. Conditions support AND/OR logic with comparisons (equals, contains, greater than).

Step 5: Save and Test

Click "Save" in the top toolbar. Then click "Test" and choose "Manually" to trigger the flow with sample data. Review the run history to verify each step executed correctly. Green checkmarks indicate success; red exclamation marks show errors with detailed messages.

Practical Example: Purchase Approval Workflow

1. Trigger: When a new Microsoft Forms response is submitted
2. Action 1: Parse the form response (requester name, item, cost, justification)
3. Condition: If cost is greater than $500
   • Yes: Start approval with VP and Finance Manager
   • No: Start approval with direct manager only
4. Action 2: If approved, send confirmation email and create a row in the Purchases Excel sheet
5. Action 3: If rejected, send rejection notification with comments

Licensing Notes (April 2026)

• Microsoft 365 E3/E5: Includes standard connectors (Office 365, SharePoint, Teams)
• Power Automate Premium ($15/user/month): Adds premium connectors (Salesforce, SAP, SQL Server) and desktop flows (RPA)
• Power Automate Process ($150/month per bot): Unattended desktop automation