add-connector

Adds any Power Platform connector to a Power Apps code app. Generic fallback for connectors not covered by a specific skill.

npx skills add https://github.com/microsoft/power-platform-skills --skill add-connector

πŸ“‹ Shared Instructions: shared-instructions.md - Cross-cutting concerns.

Add Connector (Generic)

Fallback skill for any connector not covered by a specific /add-* skill. For common connectors, prefer the dedicated skills:

  • /add-dataverse -- Dataverse tables
  • /add-azuredevops -- Azure DevOps
  • /add-teams -- Microsoft Teams
  • /add-excel -- Excel Online (Business)
  • /add-onedrive -- OneDrive for Business
  • /add-sharepoint -- SharePoint Online
  • /add-office365 -- Office 365 Outlook (calendar, email, contacts)
  • /add-workiq -- Work IQ (M365 Copilot Search)

Workflow

  1. Check Memory Bank β†’ 2. Identify Connector β†’ 3. Add Connector β†’ 4. Inspect & Configure β†’ 5. Build β†’ 6. Update Memory Bank

Step 1: Check Memory Bank

Check for memory-bank.md per shared-instructions.md.

Step 2: Identify Connector

If $ARGUMENTS is provided or the caller already specified the connector, use it directly and skip the question below.

Otherwise, ask the user which connector they want to add. Browse available connectors: Connector Reference

Before proceeding, check if the connector has a dedicated skill. If it does, delegate immediately and STOP:

Connector API nameDelegate to
shared_a365copilotchatmcp/add-workiq
sharepointonline/add-sharepoint
teams/add-teams
excelonlinebusiness/add-excel
onedriveforbusiness/add-onedrive
azuredevops/add-azuredevops
office365/add-office365
commondataservice/add-dataverse

Invoke the appropriate skill with the same $ARGUMENTS and do not continue this skill's workflow.

Common connector API names:

  • sharepointonline, teams, excelonlinebusiness, onedriveforbusiness
  • azuredevops, azureblob, azurequeues
  • office365, office365users, office365groups
  • sql, commondataservice

Step 3: Add Connector

First, find the connection ID (see connector-reference.md):

Run the /list-connections skill. Find the connector in the output. If none exists, direct the user to create one using the environment-specific Connections URL β€” construct it from the active environment ID in context (from power.config.json or a prior step): https://make.powerapps.com/environments/<environment-id>/connections β†’ + New connection β†’ search for the connector β†’ Create.

# Non-tabular connectors (Teams, Azure DevOps, etc.)
pa app add data-source --connector <connector-api-name> -c <connection-id>

# Tabular connectors (SharePoint, Excel, SQL, etc.) -- also need dataset and table
pa app add data-source --connector <connector-api-name> -c <connection-id> -d '<dataset>' --table '<table>'

Parameter reference:

  • --connector (apiId) -- connector name (e.g., sharepointonline, teams). On the flat power-apps binary this is --api-id/-a.
  • -c (connectionId) -- required for all non-Dataverse connectors. Get from /list-connections.
  • -d (dataset) -- required for tabular datasources (e.g., SharePoint site URL, SQL database). Not needed for Dataverse.
  • --table (table) -- table/list name for tabular datasources (e.g., SharePoint list, Dataverse table logical name). On the flat power-apps binary this is --resource-name/-t.

Step 4: Inspect & Configure

After adding, inspect the generated files. Generated service files can be very large -- use Grep to find specific methods instead of reading the entire file:

Grep pattern="async \w+" path="src/generated/services/<Connector>Service.ts"

Files to check:

  • src/generated/services/<Connector>Service.ts -- available operations and their parameters
  • src/generated/models/<Connector>Model.ts -- TypeScript interfaces (if generated)
  • .power/schemas/<connector>/ -- connector schema and configuration

For each method the user needs:

  1. Grep for the method name to find its signature
  2. Read just that method's section (use offset and limit parameters on Read)
  3. Identify required vs optional parameters and response type

Help the user write code using the generated service methods.

Step 5: Build

npm run build

Fix TypeScript errors before proceeding. Do NOT deploy yet.

Step 6: Update Memory Bank

Update memory-bank.md with: connector added, configured operations, build status.

More skills from microsoft

oss-growth
microsoft
OSS growth hacker persona
agent-framework-azure-ai-py
microsoft
Build Azure AI Foundry agents using the Microsoft Agent Framework Python SDK (agent-framework-azure-ai). Use when creating persistent agents with AzureAIAgentsProvider, using hosted tools (code interpreter, file search, web search), integrating MCP servers, managing conversation threads, or implementing streaming responses. Covers function tools, structured outputs, and multi-tool agents.
development
airunway-aks-setup
microsoft
Set up AI Runway on AKS β€” from bare cluster to running model. Covers cluster verification, controller install, GPU assessment, provider setup, and first deployment. WHEN: "setup AI Runway", "onboard AKS cluster", "install AI Runway", "airunway setup", "deploy model to AKS", "GPU inference on AKS", "KAITO setup on AKS", "run LLM on AKS", "vLLM on AKS", "set up model serving on AKS", "AI Runway controller".
devops
appinsights-instrumentation
microsoft
Guidance for instrumenting webapps with Azure Application Insights. Provides telemetry patterns, SDK setup, and configuration references. WHEN: how to instrument app, App Insights SDK, telemetry patterns, what is App Insights, Application Insights guidance, instrumentation examples, APM best practices.
devops
applicationinsights-web-ts
microsoft
Instrument browser/web apps with the Application Insights JavaScript SDK (@microsoft/applicationinsights-web). Use for Real User Monitoring (RUM) β€” page views, clicks, AJAX/fetch dependencies, exceptions, custom events, and browser-side GenAI agent traces correlated to backend OpenTelemetry traces. Covers SDK Loader Script and npm setup, framework extensions (React, React Native, Angular), Click Analytics, telemetry initializers, and OTel GenAI semantic conventions for agent/tool/model spans emitted from the browser.
devops
azure-ai-anomalydetector-java
microsoft
Build anomaly detection applications with Azure AI Anomaly Detector SDK for Java. Use when implementing univariate/multivariate anomaly detection, time-series analysis, or AI-powered monitoring.
development
azure-ai-language-conversations-py
microsoft
Implement Conversational Language Understanding (CLU) using the azure-ai-language-conversations Python SDK. Use when working with ConversationAnalysisClient to analyze conversation intent and entities, building NLP features, or integrating language understanding into applications.
development
azure-ai-ml-py
microsoft
Azure Machine Learning SDK v2 for Python. Use for ML workspaces, jobs, models, datasets, compute, and pipelines. Triggers: "azure-ai-ml", "MLClient", "workspace", "model registry", "training jobs", "datasets".
development