Microsoft Power Automate: A Complete Guide to No-Code Business Process Automation for Indonesian Companies
The average employee at an Indonesian company spends 2-3 hours a day on repetitive administrative tasks — forwarding email, copying and pasting between spreadsheets, requesting approvals, and generating routine reports. Microsoft Power Automate exists to let anyone, with no programming background, automate those tasks in minutes. With more than 1,000 connectors to popular applications and deep integration with the Microsoft 365 ecosystem, Power Automate is the most accessible entry point into business process automation.
This article covers the Microsoft Power Automate platform comprehensively — from the basics of cloud flows through to desktop automation, from a simple approval workflow to enterprise-scale integration. It includes tutorials, comparisons with other platforms, and real use cases from Indonesian companies already using Power Automate productively.
Understanding Microsoft Power Automate
Microsoft Power Automate (formerly Microsoft Flow) is part of the Microsoft Power Platform, alongside Power Apps, Power BI, and Power Virtual Agents. The platform is built around a "citizen developer" philosophy — empowering business users to build their own automation without depending on the IT team.
Power Automate comprises two complementary capabilities:
Cloud Flows
Cloud flows run entirely in the Microsoft cloud and connect services through connectors. There are three types:
- Automated flows: Triggered automatically by a specific event. For example: "When a new email arrives from @ojk.go.id, save the attachment to SharePoint and notify the compliance team in Teams."
- Instant flows: Triggered manually by a user, usually via a button in the mobile app or Teams. For example: "Tap a button to submit an expense report from a photo of a receipt."
- Scheduled flows: Run on a defined schedule. For example: "Every Monday at 08:00, generate the weekly sales report and send it to management."
The Cloud Flows (Triggers & Actions) module of the Power Automate Essentials course covers all three hands-on with real-world scenarios.
Desktop Flows
Desktop flows (formerly UI Flows) automate desktop applications — including legacy software with no API. Power Automate Desktop uses recording or drag-and-drop actions to build automation that interacts with a Windows application's UI.
Desktop flows bridge the modern cloud and the legacy applications still widely used in Indonesian companies, such as:
- Desktop-client core banking applications
- Legacy ERP (SAP GUI, custom Visual Basic applications)
- Government reporting applications (e-SPT, SIPP, the OJK portal)
- Mainframe terminal emulators
The Desktop Flows Introduction module establishes when and how to use desktop automation as a complement to cloud flows. For more advanced coverage, the Power Automate Advanced: Integration & API course covers hybrid scenarios.
The Connector Ecosystem
Power Automate's core strength is its connector ecosystem. A connector is a pre-built bridge to a third-party service or application. Microsoft provides more than 1,000 connectors, including:
Microsoft Connectors
- SharePoint: Trigger on file upload, create/update list items, manage permissions
- Outlook: Process email, manage the calendar, send automatic replies
- Teams: Post messages, create channels, manage membership, send adaptive cards
- Excel Online: Read/write rows, create tables, run scripts
- OneDrive: File management, conversion, sharing
- Dynamics 365: CRM automation, sales pipeline, customer service
- Dataverse: Database operations for the Power Platform
Popular Third-Party Connectors
- Productivity: Google Workspace, Slack, Trello, Asana, Jira
- Social: Twitter, LinkedIn, Facebook
- Database: SQL Server, MySQL, Oracle, PostgreSQL
- ERP/CRM: SAP, Salesforce, HubSpot
- Storage: Dropbox, Box, Google Drive, Azure Blob
- Communication: Twilio (SMS), SendGrid (email)
Custom Connectors
For applications with no built-in connector, you can create a custom connector from an OpenAPI (Swagger) definition. That opens the door to integrating internal corporate APIs. This module is covered in depth in the Power Automate Advanced course.
Tutorial: Building an Approval Workflow
Approval workflows are among the most popular Power Automate use cases in Indonesian companies. The Approval Workflows module covers this hands-on. Here is an outline of building a leave approval workflow:
The Scenario
An employee submits a leave request through a form, the approval goes to their direct manager, and if approved the shared calendar updates and HR is notified. If rejected, the employee receives a notification with the reason.
The Components Used
- Trigger: "When a new response is submitted" (Microsoft Forms)
- Action — Get response details: Retrieve the form submission data
- Action — Start and wait for an approval: Send the approval request to the manager. Power Automate has a built-in approval system that sends notifications to email and Teams with Approve/Reject buttons inline.
- Condition: Check the approval outcome (Approved or Rejected)
- If Approved:
- Create an event in the shared calendar (Outlook)
- Update the SharePoint list status to "Approved"
- Send an email notification to HR
- Post a message to the team's Teams channel
- If Rejected:
- Update the SharePoint list status to "Rejected"
- Email the employee with the reason for rejection
A workflow like this can be built in 30-45 minutes without writing a single line of code. That is the fundamental strength of Power Automate — democratising automation so a business analyst or HR administrator can build their own solution.
Integrating SharePoint, Teams, and Outlook
The Office 365 Automation Workshop module focuses on integrating the three Microsoft productivity pillars most used in Indonesian companies:
SharePoint Automation
- Document approval: A new file in a document library triggers an approval flow, and approved files move to a "Published" folder
- List management: A new SharePoint list item triggers a workflow (project request → assignment → tracking, for instance)
- Metadata extraction: Uploaded files have their metadata extracted automatically using AI Builder
Teams Automation
- Adaptive cards: Send an interactive card to Teams so users can act directly from the chat (approve, reject, enter data)
- Channel management: Automatically create a channel and add members for a new project
- Meeting notes: Post the meeting summary and action items to the channel once the meeting ends
Outlook Automation
- Email classification: Auto-label and forward email based on sender, subject, or content
- Attachment processing: Save attachments to SharePoint/OneDrive automatically according to rules
- Auto-response: Automatic replies for specific email (an enquiry from the customer portal, for example)
Power Automate vs UiPath: An Objective Comparison
The two platforms are often compared, but they actually occupy different sweet spots:
Power Automate Is Stronger At:
- Cloud-first integration: If your workflow mainly involves cloud services (Microsoft 365, SaaS apps), Power Automate is more seamless
- Cost efficiency: Many capabilities are already included in the Microsoft 365 licence your company probably holds
- Citizen developer enablement: A simpler interface and a lower learning curve for business users
- Approval workflows: A mature built-in approval system integrated with Teams and Outlook
- Rapid prototyping: From idea to working automation in hours
UiPath Is Stronger At:
- Desktop/legacy automation: Handling complex desktop applications more robustly
- Enterprise-scale RPA: Orchestrator provides far more comprehensive governance and management capability
- Complex logic: Workflows with intricate decision trees and layered exception handling
- AI/ML integration: Document Understanding and Computer Vision for processes involving unstructured data
- Cross-platform: Not tied to the Microsoft ecosystem
Many Indonesian companies adopt a hybrid strategy: Power Automate for cloud workflows and lightweight automation built by business users, UiPath for complex desktop automation and critical business processes needing enterprise-grade governance.
Real Use Cases in Indonesian Companies
1. Invoice Processing Automation
The scenario: The finance department of an FMCG company in Jakarta receives 300-500 vendor invoices a month in assorted formats (PDF, scan, email). The Accounts Payable team processes each one by hand: verifying the data, matching it against the PO, keying it into the ERP, and requesting approval from whichever manager is authorised for that amount.
The Power Automate solution: Invoices arrive by email and attachments save automatically to SharePoint. AI Builder (a Form Processing model) extracts the invoice data. The flow matches it against POs held in a SharePoint list. The approval routes to the appropriate manager based on the amount. Once approved, the data is pushed into the ERP via a custom connector. Status tracking is available in a Power BI dashboard.
The result: Processing time per invoice fell from 15 minutes to 3 minutes, including approval time. The first month alone saved 80 working hours.
2. Employee Onboarding Automation
When a new employee joins, HR has to create an email account, add them to the relevant Teams groups, assign training in the LMS, send welcome kit information, schedule an orientation meeting, and raise an equipment request. With Power Automate the whole sequence is triggered from a single entry in a "New Employees" SharePoint list.
3. Report Automation with Excel
For companies still heavily reliant on Excel — which is most Indonesian companies — combining Power Automate with Excel Power Query is remarkably powerful. A scheduled flow can gather data from multiple sources, run the Power Query transformation, generate a formatted report, and distribute it to stakeholders, entirely automatically.
4. Customer Enquiry Response
Enquiries arriving by email or web form are classified automatically by keyword, assigned to the relevant team via Teams, and the customer receives an auto-acknowledgment. SLA tracking ensures every enquiry gets a response inside the agreed window.
Governance and Security
For enterprise deployment, governance is the primary concern. Power Automate provides:
- Data Loss Prevention (DLP) policies: Administrators can restrict which connectors may be used together — blocking a flow that sends SharePoint data to a personal Gmail account, for instance
- Environment management: Separate environments for dev, test, and production
- Audit logging: Every flow creation, modification, and execution is recorded in the Microsoft 365 audit log
- Conditional access: Integration with Azure AD conditional access policies
- Admin analytics: A dashboard covering flow usage, error rate, and adoption metrics
For non-IT professionals wanting a broader understanding of process automation without being tied to one platform, the Process Automation for Non-IT Professionals course offers a more holistic perspective.
What the Course Covers
The Power Automate Essentials course takes participants from conceptual understanding to building and deploying production-ready automation. The module map:
- Introduction to Power Automate: The Power Platform ecosystem, where Power Automate sits in the automation landscape, the licensing model, cloud versus desktop flows, mapping use cases to business needs.
- Cloud Flows (Triggers & Actions): The three cloud flow types, trigger configuration, action chaining, expressions and functions, error handling, variable management, testing and debugging.
- Approval Workflows: The built-in approval system, multi-stage approval, conditional approval routing, approval history and audit trail, integration with Teams adaptive cards.
- Desktop Flows Introduction: Installing Power Automate Desktop, recording mode, the action library, variable handling, UI element targeting, hybrid flows (cloud trigger + desktop execution).
- Office 365 Automation Workshop: An end-to-end project building automation across SharePoint, Teams, Outlook, Excel, and Forms. Participants build an approval workflow, report automation, and an email processing system.
Related Courses to Broaden Your Skills
- Power Automate Advanced: Integration & API — Custom connectors, HTTP actions, API integration, advanced expressions
- Microsoft Power Platform Essentials — Power Apps + Power BI + Power Automate as one ecosystem
- Excel Power Query: Report Automation — Powerful data transformation to complement Power Automate
- Process Automation for Non-IT Professionals — A way of thinking about automation for business users
FAQ: Microsoft Power Automate
Is Power Automate free if the company already has Microsoft 365 licences?
Partly. A Microsoft 365 licence (E1/E3/E5, Business Basic/Standard/Premium) includes Power Automate for Microsoft 365, which allows cloud flows using standard connectors. Premium connectors (SAP, Salesforce, database connectors), desktop flows, and AI Builder require a Power Automate Premium or Per-flow licence. Evaluate which connectors you need before choosing a licence tier.
Can Power Automate automate legacy desktop applications such as core banking?
Yes, through Power Automate Desktop (PAD). PAD can interact with any Windows application — including software built on older technology such as Win32, Java, Citrix, and terminal emulators. For very complex desktop automation with extensive exception handling, UiPath or a dedicated RPA platform may be more robust. PAD suits medium-complexity desktop automation.
How many flows can one user create?
With a Microsoft 365 licence, each user can create an unlimited number of flows. What is capped is the number of API calls per day (depending on licence tier, typically 6,000-10,000 calls per user per 24 hours on a standard licence). For high-volume scenarios, a Power Automate Premium licence raises the limit.
How do you keep data secure when using Power Automate?
Data in Power Automate is protected by the same Microsoft Azure security infrastructure as Microsoft 365. Additional steps worth taking: (1) implement DLP policies to prevent data leakage, (2) use separate environments for development and production, (3) review flow permissions periodically — flows run under the creator's credentials, so make sure access follows the principle of least privilege, (4) enable audit logging and review it regularly. In regulated industries, confirm data residency compliance with OJK and Bank Indonesia requirements.
Power Automate vs Zapier — which is better?
If your company already sits inside the Microsoft 365 ecosystem, Power Automate is almost always the better choice: deeper integration, better cost efficiency (already bundled in the M365 licence), and desktop flow capability that Zapier lacks. Zapier is stronger if you make heavy use of non-Microsoft SaaS (Google Workspace plus assorted SaaS tools) and need very fast setup. On pricing, Power Automate is more cost-effective at high volume.