Back to Projects

Microsoft-Power-Automate-Flows

Built an end-to-end document automation system using Power Automate to reduce manual processing effort significantly.

View Source Code

System Overview

What the project does

A portfolio of enterprise‑grade Microsoft Power Automate workflows that combine Azure AI (OCR & OpenAI) to automate document classification, data extraction, email attachment handling, identity verification, and CRM integration (Zoho, Google Sheets, Outlook, SharePoint, Teams).

Key features

  • AI‑driven document classification and multi‑document OCR extraction
  • LLM‑based field extraction with prompt engineering
  • Automated email attachment intake and dynamic folder creation
  • KYC‑style identity document processing using Azure Document Intelligence
  • End‑to‑end orchestration with error handling, audit logging, and OAuth2 authentication
  • Modular, production‑style architecture and documentation (design, logic, sample outputs)

    • Tech stack

    Microsoft Power Automate, Azure Document Intelligence (OCR), Azure OpenAI (GPT), Outlook/SharePoint/OneDrive, Google Sheets, Zoho Creator REST APIs, Microsoft Teams, JSON/REST, OAuth2.

    Use case

    Deployable automation for banking/finance (KYC, loan processing), legal document digitization, CRM & back‑office workflow automation, compliance, and insurance/finance operations to replace manual data entry and verification.

    Architecture Details

    This system integrates multiple components for a seamless automation flow. Structural interpretation based on project focus:

    Backend Infrastructure

    Core execution layer for robust data processing and API handling.

    AI / Logic Core

    Intelligent decisioning via models or logical workflow rules.

    Tech Stack

    IntegrationAutomationAPIs

    Key Capabilities

    • ▹ Custom workflow execution
    • ▹ Data transformation and routing
    • ▹ Extensible architecture