Power Automate is Microsoft's answer to the question: How do we automate business processes in a cloud-first world? This article shows you the full potential.

Types of Flows

Cloud Flows

The most common flow type for cloud-based automation:

Automated Flows Start automatically on a trigger:

• New email in Outlook
• New entry in SharePoint
• Form submission
• Webhook from external system

Instant Flows Manually started via button:

• Mobile app button
• Teams action
• SharePoint context menu
• Power Apps button

Scheduled Flows Time-based execution:

• Daily at 8:00 AM
• Every Monday
• First of every month

Desktop Flows

Robotic Process Automation (RPA) for local applications:

• Attended: User starts and observes
• Unattended: Runs on virtual machine without user
• UI Automation: Simulate clicks and inputs
• API Integration: Direct system connection where possible

Practical Examples

Example 1: Vacation Request

A classic approval process:

1. 1Trigger: Microsoft Forms submission
2. 2Get Manager: Retrieve supervisor from Azure AD
3. 3Approval: Send approval email
4. 4Condition: Approved or rejected?
5. 5Update: Save result in SharePoint
6. 6Notify: Inform requester

Example 2: Invoice Processing

AI-powered document processing:

1. 1Trigger: Email with attachment
2. 2AI Builder: Analyze invoice
3. 3Extract: Extract amount, date, supplier
4. 4Validate: Check against orders
5. 5Route: To appropriate approval based on amount
6. 6Archive: Store in SharePoint

Example 3: Legacy System Integration

Desktop Flow for ERP without API:

1. 1Trigger: New order in Dataverse
2. 2Open: Start ERP application
3. 3Navigate: Navigate to order form
4. 4Enter: Enter data
5. 5Submit: Submit order
6. 6Capture: Read back order number
7. 7Update: Update Dataverse

AI Builder Integration

Available Models

• Document processing: Invoices, receipts, forms
• Text analysis: Sentiment, categorization, extraction
• Object detection: Analyze images
• Predictions: Based on historical data

Custom Models

Train your own models:

• Upload example documents
• Mark relevant fields
• AI Builder learns automatically
• Use the model in flows

Connectors and Integrations

Premium Connectors

Extended capabilities with Premium license:

• Dataverse: Full Power Platform integration
• HTTP: Call any REST APIs
• SQL Server: Direct database queries
• SAP: Enterprise ERP integration

Custom Connectors

Connect your own APIs:

• Import OpenAPI/Swagger definition
• Configure authentication
• Define actions and triggers
• Use across the entire tenant

Error Handling and Monitoring

Best Practices for Robust Flows

• Try-Catch Pattern: Scope with Configure Run After
• Retry Policies: Automatic retry on failures
• Parallel Branches: Parallelize independent actions
• Variables: Store states between steps

Monitoring

• Run History: Track all executions
• Analytics: Success rates and run times
• Alerts: Get notified on failures
• Process Advisor: Identify bottlenecks

Performance Optimization

Tips for Faster Flows

• Avoid unnecessary loops
• Use filters instead of post-processing conditions
• Batch operations instead of individual calls
• Parallelize independent branches

Mind the Limits

• 5,000 actions per flow run
• 100,000 triggers per day (depending on license)
• 30-day history retention
• Timeouts on long operations

CNEXT Power Automate Services

We help with automation:

• Process analysis: Which processes are suitable?
• Development: We build your flows
• RPA Setup: Desktop Flows infrastructure
• Training: Empower your employees

Contact: cristiano.rego@cnext.ch