Azure Copilot Studio

name: azure-copilot-studio description: Microsoft Copilot Studio patterns for building low-code AI bots with 1,000+ Power Platform connectors. Use when creating enterprise chatbots connected to SAP, Salesforce, ServiceNow, Oracle, or other systems via Power Platform. tags: [azure, copilot, power-platform, low-code]

Microsoft Copilot Studio

Build enterprise AI bots using Microsoft Copilot Studio with 1,000+ Power Platform connectors to SAP, Salesforce, ServiceNow, Oracle, and other enterprise systems.

When to Use

• Building low-code/no-code AI chatbots connected to enterprise systems
• Leveraging Power Platform's 1,000+ pre-built connectors for enterprise integration
• Creating Copilot plugins that extend Microsoft 365 Copilot
• Implementing AI bots with Azure OpenAI models and enterprise data grounding

Power Platform Enterprise Connectors (Key Selection)

Patterns

1. Copilot Studio + Power Automate Flow

User asks: "What's the status of PO 4500001234?"

Copilot Studio:
  1. Extracts intent: purchase_order_status
  2. Extracts entity: PO number = 4500001234
  3. Triggers Power Automate flow:
     --> SAP Connector: GET /API_PURCHASEORDER_PROCESS_SRV/A_PurchaseOrder('4500001234')
     --> Transform response (DataWeave/expressions)
     --> Return to Copilot Studio
  4. Generates natural language response with PO details

2. Azure Logic Apps for Complex Orchestration

{
  "definition": {
    "triggers": {
      "When_Copilot_requests_data": {
        "type": "Request",
        "kind": "Http"
      }
    },
    "actions": {
      "Query_SAP_Order": {
        "type": "ApiConnection",
        "inputs": {
          "host": { "connection": { "name": "@parameters('$connections')['sap']['connectionId']" } },
          "method": "get",
          "path": "/CallRfc",
          "queries": { "rfcName": "BAPI_SALESORDER_GETDETAIL", "parameters": "{...}" }
        }
      },
      "Enrich_with_Azure_OpenAI": {
        "type": "ApiConnection",
        "inputs": {
          "host": { "connection": { "name": "@parameters('$connections')['azureopenai']['connectionId']" } },
          "method": "post",
          "path": "/openai/deployments/gpt-4o/chat/completions",
          "body": {
            "messages": [
              { "role": "system", "content": "Summarize this SAP order data for a business user." },
              { "role": "user", "content": "@body('Query_SAP_Order')" }
            ]
          }
        }
      }
    }
  }
}

3. Azure OpenAI On Your Data (RAG)

import openai

client = openai.AzureOpenAI(
    azure_endpoint="https://my-resource.openai.azure.com/",
    api_key="...",
    api_version="2024-08-01-preview",
)

response = client.chat.completions.create(
    model="gpt-4o",
    messages=[{"role": "user", "content": "What is our refund policy?"}],
    extra_body={
        "data_sources": [{
            "type": "azure_search",
            "parameters": {
                "endpoint": "https://my-search.search.windows.net",
                "index_name": "enterprise-knowledge-base",
                "authentication": {"type": "system_assigned_managed_identity"},
                "query_type": "vector_semantic_hybrid",
                "embedding_dependency": {
                    "type": "deployment_name",
                    "deployment_name": "text-embedding-ada-002",
                },
            },
        }],
    },
)

Enterprise Security

• Azure Private Link for model access (no public internet)
• Managed Identity authentication (no API keys)
• Azure Key Vault for secret management
• Customer-managed encryption keys (CMK)
• Content filtering and responsible AI controls
• FedRAMP High, HIPAA, SOC 2, ISO 27001, PCI DSS

Anti-Patterns

• Building custom connectors when Power Platform connectors exist -- always check the catalog first
• Using Copilot Studio for complex data transformations -- use Power Automate or Logic Apps
• Skipping Azure AD integration -- always use SSO for enterprise bots
• Not setting up content safety filters in Azure OpenAI -- required for enterprise use

References

• Copilot Studio Documentation
• Power Platform Connectors
• Azure Logic Apps Connectors
• Azure OpenAI On Your Data