$ loading_
Add the Excel Online connector to read and write workbook data.
The material shows a prompt-oriented skill for adding the Excel Online (Business) connector to a Power Apps project, with no standalone secret or remote endpoint declared and an open-source origin. Caution is still warranted because its intended use involves reading/writing Excel data in OneDrive/SharePoint and running local project commands, but these are standard capabilities for this type of skill and no concrete high-risk red flags are evident.
The material and provided checks indicate no additional secrets or environment variables are required. It only refers to using an existing Power Apps/connector connection ID, with no sign of requesting new credentials, exporting tokens, or suspicious secret collection.
The skill is explicitly meant to connect to Excel Online (Business) and read/write workbook data stored in OneDrive or SharePoint. Although no separate remote host is declared, its normal operation inherently interacts with Microsoft cloud services, which is expected network egress within the stated function.
The README includes steps to run local commands such as `/list-connections`, `npx power-apps add-data-source`, and `npm run build`, indicating local command execution and project builds. This is a standard capability for a development-oriented skill, with no evidence of privilege escalation or unrelated command execution.
The material shows access to local project files (such as `power.config.json`, `memory-bank.md`, and generated service files) and configuration for reading/writing specified workbooks and tables in OneDrive/SharePoint. The access scope aligns with the declared function, with no clear sign of excessive authorization.
The source is an open-source GitHub repository under the Microsoft organization, making the code auditable and materially lowering supply-chain risk. Although the license is unspecified, stars are low, and maintenance status is unknown, the source credibility and auditability still support a low-risk rating for this dimension.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "add-excel" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/power-platform-skills/main/plugins/code-apps/skills/add-excel/SKILL.md 2. Save it as ~/.claude/skills/add-excel/SKILL.md 3. Reload skills and tell me it's ready
Add the Excel Online (Business) connector to my Power Apps code app and connect it to a sales workbook stored in OneDrive.
The app is configured with the Excel connector and can access tables in the specified OneDrive workbook.
Add the Excel Online (Business) connector in a Power Apps code app to read product table data from an inventory workbook on SharePoint.
The app can read table records from the SharePoint Excel workbook for display or analysis.
Help me add the Excel Online (Business) connector to a Power Apps code app so user-submitted data can be written to an Excel workbook in SharePoint.
The app is enabled to write to Excel and can save new business records to the specified cloud workbook.
📋 Shared Instructions: shared-instructions.md - Cross-cutting concerns.
Check for memory-bank.md per shared-instructions.md.
Ask the user:
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.
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 filesbody 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).
npm run build
Fix TypeScript errors before proceeding. Do NOT deploy yet.
Update memory-bank.md with: connector added, workbook/table configured, build status.
Review and fix Power Pages security headers, CSP, CORS, cookies, and embedding settings.
Run an end-to-end Power Pages security review with a consolidated HTML report.
Test deployed Power Pages sites with browsing, crawling, and API verification.
Add a data source or connector to a Power Apps code app.
Add Azure DevOps to Power Apps for work items, bugs, pipelines, and API calls.
Set up Power Platform Pipelines for automated Power Pages deployments.
Connect SharePoint to Power Apps for lists, documents, and site integration.
Add a OneDrive for Business connector for file operations in Power Apps.
Add the Office 365 Outlook connector for email and calendar features.
Add any Power Platform connector to a Power Apps code app.
Add a Copilot Studio connector to Power Apps code apps for agent integration.
Add Dataverse tables to Power Apps code apps with generated TypeScript services.