M365.FM - Modern work, security, and productivity with Microsoft 365

Stop Waiting: Automate Multi-Stage Approvals with Copilot Studio


Listen Later

You spend half your day waiting for approvals. Someone’s on vacation, someone else “didn’t see the email,” and by the time a decision finally arrives, the context that justified the request has expired. Corporate purgatory: progress paused by people who swear they’re busy.Now, picture a system that simply doesn’t wait. A workflow that moves forward the instant conditions are met. Enter Microsoft Copilot Studio’s Agent Flows—the bureaucracy killer disguised as automation.Here, AI becomes your first approver. It reads the data, evaluates it against policy, and gives an informed “approve or reject” before any human blinks. Only borderline cases ever reach a manager’s inbox, which means speed without sacrificing oversight. And unlike legacy approval flows that collapse under conditional complexity, these AI-driven ones scale—branching, validating, and auditing themselves along the way.In this walkthrough, I’ll show you how to build a multi-stage, conditional approval system that decides faster than your colleagues can find the “Reply All” button. You’ll learn how to: set up an AI stage with custom approval logic, add targeted human reviews, design dynamic conditions that reroute intelligently, and integrate real document validation for compliance.By the end, you’ll have an automated process that knows when to think like a machine and when to defer to human judgment.Stop following a queue. Start letting logic lead.Section 1: The Problem with Traditional ApprovalsTraditional approval chains are a tragic remix of the same inefficiency: someone submits a form, emails fly, spreadsheets drift out of sync, and between forwarding loops, nobody remembers which version was final. Each participant adds delay, not value. The process doesn’t manage the work—it manufactures latency.Typical Power Automate approval flows try to solve this, but they stall once you introduce nuance. A single approval path works fine if you only need one “Yes” or “No.” The moment you add management layers, spending thresholds, or specialized rules, the design begins to splinter. You end up nesting conditions like Russian dolls—inelegant, fragile, and impossible to debug six months later. One broken connector, and the entire system silently fails.Humans become the bottlenecks—or to be brutally accurate, latency nodes. Every message they receive becomes another asynchronous round trip. Email as an approval mechanism is like using carrier pigeons in a fiber-optic world. It technically works, but it shouldn’t.Enter Microsoft Copilot Studio. This is not just an incremental version of Power Automate. It introduces Agent Flows—approval systems powered by AI, yet fully integrated into your organization’s data sources, roles, and logic structures. It bridges deterministic policy enforcement with adaptive decision-making. The brilliance lies in how it separates stages: automated where you want speed, human where you still require validation.Think of it as hierarchy re-engineered. The AI stage evaluates fixed rules—amount limits, category types, date ranges—with clinical efficiency. Then, if a decision teeters on ambiguity, the process escalates to human oversight without forcing every trivial case to queue up.This alone eliminates exponential delay. Instead of ten people performing serial reviews, AI handles eighty percent instantly, routing only outliers. And yes, Copilot Studio tracks everything through its Dataverse backbone, producing verifiable logs without your team needing to dig through mailbox archives.Previous workflows were built for humans. Agent Flows are built around them—keeping people in the loop only when interpretation, not repetition, is required. Once you see how this architecture functions, traditional approvals will feel primitive, like balancing checkbooks by candlelight.The stakes are simple: compliance, consistency, and scale. Modern operations drown without automated validation, and AI-assisted logic is now the baseline for reliability. When you migrate from static flows to conditional, auditable Agent Flows, you stop managing approvals reactively and start treating them as living systems. The difference is not just speed—it’s structural sanity.Section 2: Building the AI Stage — Teaching the First ApproverNow comes the interesting part—training your first digital bureaucrat. The AI stage is the logical gatekeeper of your approval process. Its job is not to “think” like a human but to perform structured reasoning at superhuman consistency. It reads instructions, checks them against inputs, and outputs one of two verdicts: Approved or Rejected. No politics. No coffee breaks.You begin by defining a new Agent Flow. At creation, the AI stage sits front and center like an empty exam paper waiting for its question key. The trigger usually comes from Dataverse—a record added or modified in your claims or expense table. Once a claim is created, this stage activates, evaluates the data, and decides accordingly.Inside the stage, the most important field is the Instruction Prompt—the brain of the operation. This is where you describe the approval logic in plain but rigorous language. Write it as if you’re instructing a lawyer who never improvises. For example: “Approve the claim if the amount is less than 500, the description supports physical or mental health, and the purchase date is within 30 days of submission. Reject if any rule fails.” That’s it—binary clarity.Next, define your dynamic inputs. Think of them as variables feeding real data into your logic. You’ll most likely include an amount, a description, and a purchase date. Each is added as “content”—text or number inputs that the AI will parse when making a decision. Copilot Studio classes these inputs by type: Text, Number, or Image/Document. Choose correctly, because mixing types—say, a number stored as text—confuses both humans and machines.Beneath each input, provide sample data for testing. This acts as scaffolding while you calibrate logic. For instance, enter an example claim like “Fitness yoga mat,” amount “300,” purchase date “August 22.” When you hit “Test,” Copilot Studio runs the reasoning model—GPT-based under the hood—and outputs a decision plus an explanation. If the outcome matches your expectation, good; if not, your instructions lack determinism.And that’s where most beginners mess up. Broad or ambiguous phrasing—“reasonable expense,” “recent purchase”—is AI poison. The system can’t read corporate mood; it needs mathematical definitions. So, refine your instructions relentlessly until the test results are consistent. Every time you reword, you’re tuning the judgment engine for reproducibility. The pattern you want is identical input producing identical output every time—machine logic, not office gossip.Once your prompt yields reliable decisions across multiple test cases, you’ve effectively trained your AI approver. Now, inject the real dynamic data using tokens pulled from Dataverse: claim amount, details, purchase or submission date. These replace your test values during live runs. From that point on, the AI evaluates each claim in context, returning an approval verdict the moment new data appears.Before declaring victory, run iterative tests. Change the amount to 600—does it reject? Change the date to three months ago—does it flag as invalid? Add a nonsensical claim like “iPad purchase”—does it detect the mismatch? Each pass should demonstrate consistent cause and effect. If responses fluctuate, the issue is your prompt clarity, not the AI model.When consistent patterns emerge, establish a naming convention for your content variables—prefixes like strClaimAmount for strings or numPurchaseDate for numeric values. This tiny discipline prevents chaos when you expand later into multi-branch logic.At this stage, your automated approver can now make independent decisions based on policy without supervision. But automation isn’t dictatorship; it’s delegation. The machine handles speed and precision, not judgment. For borderline scenarios, you’ll need escalation—a human in the loop to review what the AI declines or deems uncertain. That’s where the next stage comes into play, and that’s how authority gets shared between silicon and staff.Section 3: Adding Human Oversight — Multi-Stage and Conditional LogicOnce your AI stage is confidently judging claims, you can add what bureaucracies ironically call “the human touch.” In Copilot Studio, that means a manual stage—a checkpoint where a real person gets to exercise discretion. Think of it as your safety valve: everything predictable flows past automatically; anything nuanced lands on a manager’s desk.You start in the approval designer by adding a Manual Stage right after the AI one. This creates a second gate in your Agent Flow. The handoff is conditional—only if the AI’s verdict equals “Approved” do we proceed to the human stage. If the AI says “Rejected,” the process ends right there. Why waste time asking managers to confirm what policy already disqualified? Efficiency is selective attention dressed as automation.Let’s set up an example scenario. Suppose an employee submits an expense claim for gym membership. The AI approves it because all criteria fit the policy. Now, that decision triggers a manager-level manual stage called “Manager Approval.” Under the hood, you configure this stage with a title like Claim Approval Request from [Claim Submitter]—those variables pull data dynamically from Dataverse. The Assign To field is where you define who receives the task, typically the claimant’s manager.To automate this routing, Copilot Studio lets you integrate the Office 365 Users connector. First, grab the user record of whoever created the claim—using the Get Row by ID action on the user table in Dataverse. That retrieves the submitter’s information. Next, the Get Manager action fetches that user’s manager via their primary email. Pass that result back into your manual stage as a variable like strManagerEmail. Result: no h

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support.

If this clashes with how you’ve seen it play out, I’m always curious. I use LinkedIn for the back-and-forth.
...more
View all episodesView all episodes
Download on the App Store

M365.FM - Modern work, security, and productivity with Microsoft 365By Mirko Peters (Microsoft 365 consultant and trainer)