Azure Copilot Studio

<!-- AUTO-GENERATED by export-skills.py — DO NOT EDIT -->
---
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)

| Category | Connectors |
|---|---|
| **ERP** | SAP (RFC, BAPI, IDoc, ABAP -- one of the most mature), Oracle ERP Cloud, Dynamics 365 |
| **CRM** | Salesforce (full CRUD + triggers), HubSpot, Dynamics 365 Sales |
| **ITSM** | ServiceNow (incidents, changes, problems), Jira |
| **HR** | Workday, SuccessFactors, BambooHR |
| **Cloud** | AWS (S3, SQS, SNS, Lambda), GCP (BigQuery, Pub/Sub, Storage) |
| **Data** | Snowflake (ODBC/REST), SQL Server, PostgreSQL, Oracle DB, Cosmos DB |
| **Productivity** | SharePoint, OneDrive, Outlook, Teams, Google Workspace |
| **Communication** | Slack, Twilio, SendGrid |

## 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

```json
{
  "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)

```python
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](https://learn.microsoft.com/en-us/microsoft-copilot-studio/)
- [Power Platform Connectors](https://learn.microsoft.com/en-us/connectors/connector-reference/)
- [Azure Logic Apps Connectors](https://learn.microsoft.com/en-us/connectors/connector-reference/)
- [Azure OpenAI On Your Data](https://learn.microsoft.com/en-us/azure/ai-services/openai/concepts/use-your-data)

<!-- Source: .faos/custom/skills/cloud/azure/ai-agents/azure-copilot-studio/SKILL.md -->