Skip to content

Using Tallyfy MCP server with Microsoft Copilot Studio

Overview

Microsoft Copilot Studio adds MCP support for organizations that need AI agents connected to business systems. Connect Tallyfy’s MCP server with Copilot Studio to build agents that automate workflows, manage processes, and interact with your Tallyfy data through natural language.

This guide covers configuring Tallyfy’s MCP server with Copilot Studio, working with enterprise features, handling limitations, and production practices.

Copilot Studio MCP support status

MCP server support is generally available in Copilot Studio as of early 2026:

  • Transport: Streamable HTTP only (SSE is deprecated)
  • MCP resources: Files and images supported in responses
  • Enterprise features: VNet integration, DLP, multiple auth methods
  • Admin visibility: MCP-enabled agents visible in M365 admin center
  • Platform integration: Native Power Platform connector infrastructure
  • Prebuilt connectors: GitHub, Asana, Jira, Dataverse, Dynamics 365, Microsoft Fabric
  • Governance: MCP governed by Agentic AI Foundation under Linux Foundation (December 2025)

Prerequisites

  • Microsoft Copilot Studio license (trial or paid)
  • Tallyfy API key from your organization settings
  • Power Apps or Power Automate access (for custom connectors)
  • Generative Orchestration enabled in your Copilot Studio agent
  • Environment in a supported region (check Microsoft docs for availability)

Setting up Tallyfy MCP server with Copilot Studio

Integration flow overview

This diagram shows how Tallyfy’s MCP server connects with Copilot Studio through Power Platform infrastructure.

Diagram

What to notice:

  • Setup involves multiple Microsoft services (Azure, Power Apps, Copilot Studio) configured in sequence
  • Authentication happens at the Power Apps connector level using your Tallyfy API key
  • DLP policies add a security layer for enterprise deployments

Multi-agent orchestration pattern

Copilot Studio can coordinate multiple specialized agents for workflows like employee onboarding.

Diagram

What to notice:

  • The Primary Agent acts as an orchestrator, delegating to specialized agents
  • Each agent creates and manages its tasks through Tallyfy’s API
  • All progress is monitored through Tallyfy’s tracker view

Enterprise deployment architecture

Recommended architecture for large organizations needing high availability and security.

Diagram

What to notice:

  • Multiple MCP server instances provide high availability behind a load balancer
  • Security is layered with WAF, DLP policies, and VNet isolation
  • Managed identities remove the need to store credentials in code
  1. Connect to Tallyfy’s MCP server

    Tallyfy provides a hosted MCP server at https://mcp.tallyfy.com that exposes 40+ tools for managing tasks, processes, templates, users, and automation. You don’t need to build your own MCP server - instead, you’ll create a connector that points to Tallyfy’s existing server.

    The server uses OAuth 2.1 with PKCE for authentication. Discovery starts at /.well-known/oauth-authorization-server (per RFC 8414), and scopes use dot notation like mcp.tasks.read, mcp.processes.write, etc.

  2. Create an OpenAPI specification

    Create a YAML file describing the MCP server for the Power Platform connector:

    swagger: '2.0'
    info:
    title: Tallyfy MCP Server
    description: MCP server for Tallyfy workflow management
    version: 1.0.0
    host: mcp.tallyfy.com
    basePath: /
    schemes:
    - https
    paths:
    /mcp:
    post:
    summary: Tallyfy Workflow Management Server
    x-ms-agentic-protocol: mcp-streamable-1.0
    operationId: InvokeMCP
    parameters:
    - name: Authorization
    in: header
    required: true
    type: string
    description: Bearer token for authentication
    responses:
    '200':
    description: Success
    securityDefinitions:
    apiKey:
    type: apiKey
    in: header
    name: Authorization
  3. Create a custom connector in Power Apps

    1. Navigate to your Copilot Studio agent
    2. Go to ToolsAdd a toolNew toolCustom connector
    3. In Power Apps, select New custom connectorImport OpenAPI file
    4. Import your YAML specification and configure authentication
  4. Configure authentication

    In the connector configuration:

    • Set authentication type to API Key
    • Configure the header name as Authorization
    • Set the prefix to Bearer
    • Test the connection with your Tallyfy API key
  5. Add the MCP connector to your agent

    Back in Copilot Studio:

    1. Select ToolsAdd a toolModel Context Protocol
    2. Choose your Tallyfy MCP connector from the list
    3. Authorize the connection with your credentials
    4. Select Add to agent or Add and configure
  6. Configure DLP policies (optional)

    For enterprise deployments:

    1. Navigate to Power Platform Admin Center
    2. Create DLP policies to control data flow
    3. Apply policies to your Copilot Studio environment
    4. Configure connector classifications (Business/Non-Business/Blocked)
  7. Test the integration

    In your Copilot Studio agent, try queries like:

    "Find all open tasks assigned to the sales team"
    "Show me overdue processes for customer onboarding"
    "Create a task for reviewing the Q4 budget"

Practical examples

Multi-agent orchestration

User prompt:

Start the employee onboarding process for Jane Smith, assign tasks to HR and IT, and schedule training sessions.

What happens:

  1. Primary agent receives the request
  2. Delegates to HR agent for documentation tasks via Tallyfy
  3. Delegates to IT agent for system access setup
  4. Delegates to Training agent for session scheduling
  5. Monitors progress across all sub-agents
  6. Reports consolidated status back to you

Power Platform integration

User prompt:

When a new sales opportunity is created in Dynamics 365, start our proposal process in Tallyfy and create a Teams channel for collaboration.

What happens:

  1. Power Automate flow triggers on Dynamics 365 opportunity
  2. MCP server creates Tallyfy process instance
  3. Teams connector creates a dedicated channel
  4. Agent monitors and reports progress

Enterprise compliance workflow

User prompt:

Review all completed audit processes this quarter and generate a compliance report with any violations highlighted.

What happens:

  1. Queries Tallyfy for audit process data
  2. Analyzes completion times against SLAs
  3. Checks for required approvals
  4. Generates formatted report in SharePoint
  5. Routes to compliance team if violations are found

Copilot Studio features for MCP

Enterprise security and governance

  • VNet integration - isolate MCP traffic within your network
  • Data Loss Prevention (DLP) - apply policies to prevent data exfiltration
  • Azure AD authentication - use your existing identity management
  • Compliance certifications - inherit Microsoft’s compliance framework

Power Platform integration

  • Power Automate flows - trigger workflows from MCP actions
  • Power Apps integration - build custom UIs for Tallyfy data
  • Dataverse storage - store workflow metadata in Microsoft’s database
  • Power BI reporting - create dashboards from Tallyfy analytics

Multi-agent orchestration

  • Delegate tasks between specialized agents
  • Maintain context across agent handoffs
  • Central monitoring of multi-agent workflows
  • Built-in error handling and fallback mechanisms

Tools and prompts framework

  • Prompt library - create and share custom prompts across agents
  • Tool catalog - browse and install prebuilt MCP connectors
  • Version control - track changes to tools and prompts
  • Testing framework - validate tools before deployment

Limitations

Licensing complexity

  • MCP requires Generative Orchestration (additional cost)
  • Message limits vary by plan (25K to 200K messages/month)
  • Some features need Power Platform licenses too
  • Multi-agent orchestration may still be in preview for some customers

Regional availability

  • MCP available in limited regions initially
  • Data residency requirements may restrict usage
  • Preview features often US-only at launch

Connector development overhead

  • Must create OpenAPI specifications
  • Power Apps/Automate knowledge needed
  • Testing takes longer than direct MCP connections
  • Versioning and updates require republishing

Performance considerations

  • DLP policy evaluation adds processing time
  • VNet routing increases response times (10-50ms typically)
  • Large result sets require pagination
  • Rate limits are shared across Power Platform

Ideal use cases

Enterprise workflow automation

"When a purchase order exceeds $50,000 in Dynamics 365, initiate our approval workflow in Tallyfy, notify team leads in Teams, and track in Power BI."

Compliance and audit management

"Monitor all SOX compliance processes, ensure proper segregation of duties, and generate audit reports with full trail documentation."

Cross-functional process orchestration

"Coordinate our product launch process across marketing, sales, and operations teams, with each department's agent handling their specific tasks."

Intelligent process mining

"Analyze our customer service processes to identify bottlenecks, suggest optimizations, and automatically implement approved changes."

Regulated industry workflows

"Manage our FDA submission process with full audit trails, approval chains, and automatic compliance checking at each step."

Security considerations

  1. Network security - deploy within VNet for isolation, use Private Endpoints, implement WAF rules, enable DDoS protection
  2. Authentication - use Azure AD, implement service principal auth for server-to-server, apply conditional access policies, enable MFA
  3. Data protection - classify data sensitivity levels, apply DLP policies, enable encryption at rest and in transit
  4. Monitoring - enable Azure Monitor, configure anomaly alerts, maintain audit logs for compliance

Deployment architectures

Basic (small organizations)

[Copilot Studio] → [Custom Connector] → [Tallyfy MCP Server] → [Tallyfy API]

Enterprise (large organizations)

[Copilot Studio]
↓ (VNet Integration)
[API Management]
↓ (Private Endpoint)
[App Service Environment]
├── [MCP Proxy Instance 1]
├── [MCP Proxy Instance 2]
└── [Load Balancer]
↓ (Managed Identity)
[Tallyfy MCP Server]

Hybrid (multi-cloud)

[Copilot Studio] → [ExpressRoute] → [On-premises Proxy] → [Tallyfy MCP Server]
↘ ↗
[Azure Proxy] → [Tallyfy MCP Server]

Best practices

  1. Start with prebuilt connectors - use Microsoft’s MCP connectors as templates
  2. Implement retry logic - handle transient failures gracefully
  3. Use managed identities - never store credentials in code
  4. Monitor usage - track message consumption against limits
  5. Plan for scale - design for multi-agent scenarios from the start
  6. Test extensively - use Copilot Studio’s testing framework

Known issues and workarounds

  1. SSE not supported - use Streamable HTTP for all implementations
  2. Tool naming conflicts - prefix Tallyfy tools to avoid collisions with other MCP servers
  3. Large payloads - implement pagination for result sets over 100 items
  4. Session timeout - implement keep-alive mechanisms for long-running operations
  5. Regional latency - deploy connectors in same region as Copilot Studio
  6. Resource rendering - files and images in responses may need extra handling in custom UIs
  7. Admin center visibility - MCP-enabled agents must be registered to appear in M365 admin center

Future outlook

  • Continued GA expansion - more features and regions over time
  • Agent 365 expansion - unified control plane for AI agents across Microsoft’s platform
  • Better debugging tools - more visibility into MCP interactions
  • Expanded connector marketplace - more prebuilt enterprise connectors (GitHub, Asana, Jira already available)
  • Zero-trust architecture - support with full M365 admin governance
  • Performance optimizations - reduced latency and higher throughput

Microsoft is a founding member of the Agentic AI Foundation, ensuring continued commitment to MCP as an industry standard.

Summary

Copilot Studio’s MCP support takes more setup effort than simpler alternatives, but you get strong security and compliance features, deep Microsoft integration, multi-agent coordination, and enterprise-grade architecture. If you’re already using Microsoft tools, it’s a natural fit for workflow automation with Tallyfy.

Integrations > MCP server

Tallyfy’s MCP Server lets you control workflows through AI assistants like ChatGPT, Claude, and Gemini - searching tasks, managing processes, editing templates, and building automations using plain English instead of API calls.

Mcp Server > Using Tallyfy MCP server with Claude (text chat)

Claude Desktop provides native MCP integration that lets you connect Tallyfy’s workflow tools through a local server script so you can search tasks and manage processes using natural language chat while combining multiple MCP servers for cross-platform automation like onboarding employees across Tallyfy and Slack and GitHub simultaneously.

Byo Ai > Microsoft Copilot integration

Microsoft 365 Copilot integrates with Tallyfy through API plugins and Azure AD OAuth2 authentication to bring email documents Teams conversations and SharePoint data into workflow automation while enforcing enterprise security policies like conditional access and data loss prevention through the Microsoft Graph API and optional Power Platform extensions.

Mcp Server > Using Tallyfy MCP server with ChatGPT

ChatGPT Enterprise Team and Education users can connect to Tallyfy’s MCP server using OAuth 2.1 with PKCE to manage workflows through natural language with full read/write capabilities via Developer Mode though the text-based interface has limitations for visual workflows form interactions and real-time collaboration making it best suited for complex searches analysis automation planning and template optimization.