Add Excel
Apps & Automationadd-excelAdd 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.
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
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
- 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:
- Where is the workbook? (OneDrive or SharePoint)
- Workbook file name
- 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"anddrive: "me"for OneDrive personal files- For SharePoint, use the site path and drive ID
- The
bodyis 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.