OpenParable
Skip to content
← Back to skills

Add Excel

Apps & Automation
add-excel

Add Excel is an Agent Skill for apps & automation published in the microsoft/power-platform-skills repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Adds Excel Online (Business) connector to a Power Apps code app. Use when reading or writing Excel workbook data from OneDrive or SharePoint.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/microsoft/power-platform-skills/blob/HEAD/plugins/code-apps/skills/add-excel/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/add-excel, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

📋 Shared Instructions: shared-instructions.md - Cross-cutting concerns.

Add Excel Online

Workflow

  1. Check Memory Bank → 2. Gather → 3. Add Connector → 4. Configure → 5. Build → 6. Update Memory Bank

Step 1: Check Memory Bank

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

Step 2: Gather

Ask the user:

  1. Where is the workbook? (OneDrive or SharePoint)
  2. Workbook file name
  3. Which table(s) in the workbook to access

Step 3: Add Connector

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

Run the /list-connections skill. Find the Excel Online (Business) connection 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.

Excel Online is a tabular datasource -- requires -c (connection ID), -d (drive), and -t (table name in workbook):

# OneDrive workbook
npx power-apps add-data-source -a excelonlinebusiness -c <connection-id> -d 'me' -t 'Table1'

# SharePoint workbook -- dataset is the document library path
npx power-apps add-data-source -a excelonlinebusiness -c <connection-id> -d 'sites/your-site' -t 'Table1'

Run for each table the user needs.

Step 4: Configure

AddRowIntoTable -- adds a row to an Excel table:

// OneDrive workbook
await ExcelOnlineBusinessService.AddRowIntoTable({
  source: "me",
  drive: "me",
  file: "MyWorkbook.xlsx",
  table: "Table1",
  body: { column1: "value1", column2: "value2" } // Flat object, NO "items" wrapper
});

// SharePoint workbook
await ExcelOnlineBusinessService.AddRowIntoTable({
  source: "sites/your-site",
  drive: "drive-id",
  file: "SharedWorkbook.xlsx",
  table: "Table1",
  body: { column1: "value1", column2: "value2" }
});

Key points:

  • source: "me" and drive: "me" for OneDrive personal files
  • For SharePoint, use the site path and drive ID
  • The body is a flat key-value object matching column headers -- do NOT wrap in { items: ... }

Use Grep to find specific methods in src/generated/services/ExcelOnlineBusinessService.ts (generated files can be very large -- see connector-reference.md).

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, workbook/table configured, build status.