Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables
Power BI | Power Apps | Power Automate | SQL | VBA | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
LEARN THIS HANDS ON
Power Apps & Power Automate
You’ve probably built more than a few “classic” cloud flows in Power Automate that call APIs, update Dataverse, or orchestrate approvals. Now you’re seeing agent flows, Copilot Studio, and “agent skills” everywhere and wondering: is this a new product, a new runtime, or just marketing? This article walks through what agent flows are, how they differ from classic flows, and how to decide when to use them.
We’ll use a realistic scenario: an operations team that built a lot of scheduled and event-driven flows to keep CRM data clean and respond to customer emails. They now want a Copilot-style agent that can answer customer queries in Teams and email, and they’re trying to reuse their existing flows without rebuilding everything. Agent flows are the bridge—if you understand how they work.
Imagine an internal support team:
The team quickly hits a wall:
This is exactly the gap agent flows are meant to fill: connecting conversational agents to structured automation in a predictable way.
An agent flow is a Power Automate cloud flow that is:
In other words, it’s a standard Power Automate flow with a specific trigger and data contract so the agent can call it reliably.
Compared to the flows you already know:
Trigger model
Caller
Inputs/outputs
Usage context
Under the hood, they still use the same Power Automate engine and connectors. The change is mainly how they’re surfaced and how they interact with Copilot Studio.
Agent flows are part of the integration between Power Automate and Copilot Studio (the evolution of Power Virtual Agents and related capabilities). The basic pattern is:
The core technical piece is the agent skill trigger (naming and UI can vary slightly depending on environment and region, but the behaviour is consistent):
At a high level:
Back to the support team:
CreateSupportCase with parameters like:
customerNameissueSummaryprioritycaseId and caseUrl to the agent.The classic Dataverse create/update logic is still in Power Automate. The difference is that the agent now orchestrates when that logic runs.
You can reuse a lot of your classic patterns, but you need to design for:
Agent flows work best when their inputs are:
Practical tips:
The agent doesn’t see your flow’s UI; it only sees the output object.
Best practice for outputs:
Example pattern for our support scenario (conceptually, not code):
caseId: "12345"caseUrl: "https://..."status: "Created"userMessage: "I’ve created case 12345 and assigned it to the Support queue."The agent can:
caseId and status to decide on follow-up actions.userMessage directly in the conversational reply if appropriate.Classic flows often log errors or send an email and move on. For an agent flow, this leads to confusing conversations.
For agent flows:
A simple approach:
success: true/falseerrorCode: text (empty when success is true)errorMessage: text (empty when success is true)Then define in Copilot Studio how the agent should respond when success is false.
Agent flows are better suited to:
Keep long-running orchestration in classic flows triggered by:
You can still start those classic flows from an agent flow if needed (for example, by writing a record that a separate flow listens to), but don’t try to cram a full multi-hour process into a single agent skill.
Most teams want to avoid rewriting everything. You can often reuse classic logic with some restructuring.
Good candidates for conversion to agent flows:
Poor candidates:
A common pattern:
This gives you:
In Copilot Studio:
For our support team:
Experienced practitioners usually ask: “Under whose identity does this run?”
Agent flows:
That means:
For the support agent:
You should be explicit with stakeholders that:
Agent flows sit on the same underlying platform as classic flows, so most familiar constraints apply. The key differences are about expectations.
Because agent flows are called mid-conversation:
Practical guidance:
Agent flows are subject to:
You should:
Let’s crystallise the impact on our scenario.
CreateSupportCaseSkill – called by the agent to create cases.UpdateCaseStatusSkill – called to change status.GetCaseSummarySkill – called to summarise a case.What changed:
When you see “agent flows Copilot Studio” in documentation or UI, think of them as API-style skills your agent can call, not a replacement for your existing flows. Start by identifying one or two high-value actions (like “create case” or “get customer summary”), wrap them in small, explicit agent flows with clear inputs/outputs, and let your agent call those. Once that pattern is working, extending your classic automation into the conversational world becomes incremental rather than a full rebuild.
This article reflects the shift from standalone cloud flows to agent-driven skills in Power Automate, especially in environments where teams are layering Copilot Studio agents on top of existing automation.
Professionals who want to apply these patterns to their own data can explore Excelgoodies' Power Automate Course programme - taught live by instructors, with certification awarded once a real project is running at work.
Insights compiled through ongoing industry research and discussions within the Excelgoodies Analytics Community.
Power Automate
New
Next Batches Now Live
Power BI
SQL
Power Apps
Power Automate
Microsoft Fabrics
Azure Data Engineering