Official agent skill

Add Data Source

by microsoft in microsoft/power-platform-skills

Guide the user to add a data source, connection, or API connector to a Canvas App via Power Apps Studio, then verify and continue.

OfficialMITAuto-check passedDocuments & Office

Install Add Data Source

skills CLI
$ npx skills add microsoft/power-platform-skills --skill add-data-source -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install microsoft/power-platform-skills add-data-source --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/microsoft/power-platform-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/canvas-apps/skills/add-data-source .claude/skills/add-data-source && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
add-data-source
GitHub stars
967
Used in
1 other repo
Token cost
~1.1k tokens
SKILL.md length
583 words
Files
1
Skills in repo
87
Repo updated
First seen
Licence
MIT

At a glance

Guide the user to add a data source, connection, or API connector to a Canvas App via Power Apps Studio, then verify and continue.

  • Works in 5 steps: Identify the Connection Type → Inform the User → Wait for Confirmation → …
  • The user asks to add a data source
  • SKILL.md covers Phase 0 — Identify the…, Phase 1 — Inform the User, Phase 2 — Wait for Confirmation and Phase 3 — Verify the Connection, plus 1 more section
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Add Data Source is an agent skill from microsoft/power-platform-skills, published by the product's own GitHub organization. Guide the user to add a data source, connection, or API connector to a Canvas App via Power Apps Studio, then verify and continue. USE WHEN the user asks to add a data source, add a connection, add an API, add a connector, connect to SharePoint / Dataverse / SQL / Excel / OneDrive / Teams / Office 365, or any similar request to make new data available to the app. DO NOT USE WHEN the user is asking to list or describe existing data sources — call listdatasources or listapis directly instead.

Its SKILL.md is about 1.1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Documents & Office, covering Cloud office suites and Excel spreadsheets. It works with Microsoft SharePoint, Microsoft Excel, Microsoft OneDrive and Microsoft 365. The repository describes itself as: A plugin marketplace for GitHub Copilot and other AI agents that provides Power Platform development plugins, including reusable skills, agents, and commands for building and… The licence is MIT.

When your agent uses it

  • The user asks to add a data source
  • Add a connection
  • Add a connector
  • Connect to SharePoint / Dataverse / SQL / Excel / OneDrive / Teams / Office 365

Example prompts

  • “/add-data-source”

Requirements

  • Pre-approved tools (allowed-tools): AskUserQuestion, mcp__canvas-authoring__list_data_sources, mcp__canvas-authoring__list_apis, mcp__canvas-authoring__get_data_source_schema, mcp__canvas-authoring__describe_api

Workflow steps

5 steps, taken from the step headings in SKILL.md.

  1. Identify the Connection Type
  2. Inform the User
  3. Wait for Confirmation
  4. Verify the Connection
  5. Continue

What it can do on your machine

Read from SKILL.md and the folder at commit 5ef4e4f. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • AskUserQuestion
    • mcp__canvas-authoring__list_data_sources
    • mcp__canvas-authoring__list_apis
    • mcp__canvas-authoring__get_data_source_schema
    • mcp__canvas-authoring__describe_api

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Add Data Source loads about 1.1k tokens when it runs. Until then it costs about 129 tokens; SKILL.md has 583 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~129
When it runs · the whole SKILL.md, loaded when a task matches
~1.1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from microsoft/power-platform-skills at commit 5ef4e4f, republished under its MIT licence (© microsoft). 583 words, ~1,106 tokens.

Download SKILL.mdSave it as .claude/skills/add-data-source/SKILL.md (or your agent's skills folder).
name
add-data-source
description
Guide the user to add a data source, connection, or API connector to a Canvas App via Power Apps Studio, then verify and continue. USE WHEN the user asks to add a data source, add a connection, add an API, add a connector, connect to SharePoint / Dataverse / SQL / Excel / OneDrive / Teams / Office 365, or any similar request to make new data available to the app. DO NOT USE WHEN the user is asking to list or describe existing data sources — call list_data_sources or list_apis directly instead.
allowed-tools
AskUserQuestion, mcp__canvas-authoring__list_data_sources, mcp__canvas-authoring__list_apis, mcp__canvas-authoring__get_data_source_schema, mcp__canvas-authoring__describe_api
version
1.0.0
author
Microsoft Corporation
user-invocable
false

Data sources, connections, and API connectors cannot be added by the coding agent — they must be added through the Power Apps Studio interface. This skill informs the user, guides them to add the connection in their Studio session, verifies it is available via the MCP server, and then continues with any pending work.

Phase 0 — Identify the Connection Type

From the user's request, determine what they want to add and how to verify it:

Request typeVerify with
Data source (SharePoint list, Dataverse table, SQL table, Excel file, OneDrive, etc.)list_data_sources
API / connector (Office 365 Users, Teams, custom connector, etc.)list_apis
UnclearBoth list_data_sources and list_apis

Note what the user is trying to add so you can look for it by name in Phase 3.

Phase 1 — Inform the User

Explain that this step requires action in their Studio session. Tell the user:

  • The coding agent cannot add data sources or connections programmatically — this must be done directly in Power Apps Studio.
  • To add the connection, follow these steps in their open Studio session:
    1. Open the Data panel in the left sidebar
    2. Click Add data
    3. Search for the data source or connector they want (e.g., "SharePoint", "Dataverse", "SQL Server", "Office 365 Users")
    4. Follow the authentication prompts and select the specific table, list, file, or dataset
  • Once added, the connection will be available to the MCP server and you can continue.

Phase 2 — Wait for Confirmation

Use AskUserQuestion to pause until the user has completed the steps in Studio:

"Please add the data source or connection in your Power Apps Studio session. Reply here when it's ready and I'll verify the connection before continuing."

Do not proceed until the user confirms they have added it.

Show full SKILL.md (295 more words)Show less

Phase 3 — Verify the Connection

Once the user confirms, call the appropriate MCP tools to check that the connection is now available:

  • If the request was for a data source: call list_data_sources
  • If the request was for an API / connector: call list_apis
  • If the type was unclear: call both in parallel

Scan the results for the connection the user added:

Found — Confirm to the user that the data source or connection is now visible to the agent. Include the exact name as returned by the MCP tool (this is how it must be referenced in Power Fx formulas). If it is a data source, call get_data_source_schema to retrieve its column names and types, and include the schema summary in your response so it is ready for use in edits. Similarly, for APIs/connectors, call describe_api to retrieve the available endpoints and their parameters, and include the schema summary in your response.

Not found — Inform the user that the connection is not yet visible. Ask them to:

  1. Confirm they completed the Studio steps and the connection appears in the Data panel there.
  2. Check that their Studio session is still active (the MCP server must be connected to a live coauthoring session).
  3. Let you know when ready to try again.

Use AskUserQuestion to wait for their follow-up, then re-run Phase 3.

Phase 4 — Continue

After the connection is confirmed:

  • If the user had a pending task (e.g., "add SharePoint as a data source, then build a gallery"), continue with that work now using the verified connection name and schema.
  • If adding the connection was the only request, summarize what was confirmed (connection name, type, and schema if applicable) and suggest a natural next step (e.g., building a screen or gallery that uses the new data).

© microsoft, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in plugins/canvas-apps/skills/add-data-source of microsoft/power-platform-skills.

Open the folder on GitHubat commit 5ef4e4f

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in microsoft/power-platform-skills, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Add Data Source next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Add Data Source compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Add Data Source this skillmicrosoft/power-platform-skills9671 repos~1.1kAutomated safety check: PassMIT
aai-cli Microsoft 365aai-labs/agent-barn109—~1.2kAutomated safety check: PassApache-2.0
Sharepoint Safe HTMLpnp/sharepoint-skills131—~6.4kAutomated safety check: PassMIT
Defender For Storagevinayaklatthe/microsoft-security-skills175—~2kAutomated safety check: PassMIT
Msgraphcodemie-ai/codemie-code294—~4.1kAutomated safety check: PassApache-2.0
Workiqmicrosoft/work-iq1k—~15kAutomated safety check: PassCustom licence

Similar skills

  • aai-cli Microsoft 365

    aai-labs/agent-barn

    Guides work with Outlook, OneDrive, SharePoint, Teams, Excel, To Do and Planner through aai-cli's Microsoft Graph commands, starting from which service owns the data.

    109 GitHub stars~1.2k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Sharepoint Safe HTML

    pnp/sharepoint-skills

    Creates accessible, single-file HTML artifacts that render reliably in SharePoint, OneDrive, Teams, File Viewer, and embedded iframe preview surfaces.

    131 GitHub stars~6.4k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Defender For Storage

    vinayaklatthe/microsoft-security-skills

    Guidance for Microsoft Defender for Storage — threat protection for Azure Storage accounts (Blob, Files, Data Lake Gen2).

    175 GitHub stars~2k tokensUpdated 3 mo ago
    Documents & OfficeAuto-check passed
  • Msgraph

    codemie-ai/codemie-code

    Work with Microsoft 365 services via the Graph API — emails, calendar events, SharePoint sites (read and write), Teams chats and channel messages, OneDrive files, OneNote notebooks, Planner task…

    294 GitHub stars~4.1k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Workiq

    microsoft/work-iq

    Official

    WorkIQ tools for Microsoft 365 workplace data and actions. An agent skill from microsoft/work-iq.

    1k GitHub stars~15k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Workiq Preview

    microsoft/work-iq

    Official

    WorkIQ tools for Microsoft 365 workplace data and actions. An agent skill from microsoft/work-iq.

    1k GitHub stars~3.3k tokensUpdated today
    Documents & OfficeAuto-check passed

More from microsoft/power-platform-skills

All 87 skills in this repo
  • Manage Firewall

    microsoft/power-platform-skills

    Official

    Inspects and configures the web application firewall (WAF) in front of a Power Pages production site.

    967 GitHub stars~4.5k tokensUpdated today
    Auto-check: notes
  • Manage Headers

    microsoft/power-platform-skills

    Official

    Inspects and configures the security headers a Power Pages site sends to browsers — Content Security Policy, frame and clickjacking protection, cross-origin sharing, cookie behavior, and related…

    967 GitHub stars~3k tokensUpdated today
    Auto-check: notes
  • Scan Code

    microsoft/power-platform-skills

    Official

    Scans a Power Pages site project for security issues in source code and dependencies.

    967 GitHub stars~3.4k tokensUpdated today
    Auto-check: notes
  • Scan Site

    microsoft/power-platform-skills

    Official

    Runs a security scan on a deployed Power Pages site, fetches the latest scan report, and produces a plain-language summary.

    967 GitHub stars~3.2k tokensUpdated today
    Auto-check: notes
  • Setup Datamodel

    microsoft/power-platform-skills

    Official

    Creates Dataverse tables, columns, and relationships for a Power Pages site based on a data model proposal.

    967 GitHub stars~4k tokensUpdated today
    Auto-check: notes
  • Add Server Logic

    microsoft/power-platform-skills

    Official

    Creates, edits, and manages Power Pages Server Logic files — server-side JavaScript that runs securely on the Power Pages runtime.

    967 GitHub stars~18k tokensUpdated today
    Auto-check: notes

Questions about Add Data Source

What does Add Data Source do?

Guide the user to add a data source, connection, or API connector to a Canvas App via Power Apps Studio, then verify and continue. Add Data Source is an agent skill from microsoft/power-platform-skills, published by the product's own GitHub organization. Guide the user to add a data source, connection, or API connector to a Canvas App via Power Apps Studio, then verify and continue.

When should I use Add Data Source?

Add Data Source fits situations like: the user asks to add a data source; add a connection; add a connector; connect to SharePoint / Dataverse / SQL / Excel / OneDrive / Teams / Office 365.

How do I install Add Data Source in Claude Code?

Run `npx skills add microsoft/power-platform-skills --skill add-data-source -a claude-code`. Or copy the skill folder (plugins/canvas-apps/skills/add-data-source in microsoft/power-platform-skills) into .claude/skills/add-data-source in your project. Claude Code loads it when a task matches its description.

How do I install Add Data Source in Codex?

Run `npx skills add microsoft/power-platform-skills --skill add-data-source -a codex`. Or copy the skill folder (plugins/canvas-apps/skills/add-data-source in microsoft/power-platform-skills) into .agents/skills/add-data-source in your project. Codex loads it when a task matches its description.

Can I use Add Data Source in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add microsoft/power-platform-skills --skill add-data-source -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/add-data-source, .gemini/skills/add-data-source, .github/skills/add-data-source and .opencode/skills/add-data-source in your project.

What does Add Data Source need to run?

SKILL.md names no scripts, command-line tools or credentials: Add Data Source is instructions for the agent only. Its frontmatter pre-approves these tools: AskUserQuestion, mcp__canvas-authoring__list_data_sources, mcp__canvas-authoring__list_apis, mcp__canvas-authoring__get_data_source_schema, mcp__canvas-authoring__describe_api.

Does Add Data Source access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Add Data Source safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Add Data Source use?

Add Data Source is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Add Data Source use?

About 1.1k tokens (SKILL.md is roughly 4.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Add Data Source?

Skills that share tags, products or a category with Add Data Source: aai-cli Microsoft 365 (aai-labs/agent-barn, 109 stars), Sharepoint Safe HTML (pnp/sharepoint-skills, 131 stars), Defender For Storage (vinayaklatthe/microsoft-security-skills, 175 stars) and Msgraph (codemie-ai/codemie-code, 294 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Add Data Source?

microsoft (a GitHub organization, an official publisher) maintains it in microsoft/power-platform-skills, which has 967 GitHub stars. The repository holds 87 skills in this directory. The repository was last updated on October 6, 2026.

Source: microsoft/power-platform-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.