power-apps-editable-table

Builds editable spreadsheet-style grids in canvas Power Apps using collection-backed galleries and bulk Patch saves.

Updated Jul 25, 2026
One-click install
npx skills add https://github.com/RorySullivan1/powerapp_taskmaster --skill power-apps-editable-table-rorysullivan1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: power-apps-editable-table
Source: https://github.com/RorySullivan1/powerapp_taskmaster/tree/main/.claude/skills/power-apps-editable-table
Command: npx skills add https://github.com/RorySullivan1/powerapp_taskmaster --skill power-apps-editable-table-rorysullivan1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Canvas Power Apps has no native editable grid control, so users who need to edit many rows at once are stuck with slow form-per-row screens or read-only data tables. This Skill provides the complete pattern for building an editable table: a staging collection bound to a gallery with per-row inputs, add/insert/delete row operations, and a single bulk save back to the data source. ## Core Features & Use Cases - Staging-collection grid design: Load a delegable working copy into a collection, bind the gallery to it, and let users edit freely without per-keystroke network calls. - Row lifecycle management: Add rows with client-side TempIds, delete rows with a tracked colDeletes collection, and reconcile everything on save. - Bulk save with correct Patch semantics: Branch on ID > 0 to merge updates onto existing records and inserts onto Defaults(Source), avoiding duplicate rows and silent no-ops. - Use Case: Build a timesheet grid where employees enter a week of hours across multiple project rows, then save all entries to a SharePoint list with one button. ## Quick Start Ask the AI to build an editable grid screen in a canvas Power App that stages SharePoint list rows in a collection and saves all edits with one bulk Patch.

Frequently Asked Questions about power-apps-editable-table

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build an editable grid in Power Apps?▼

Power Apps has no native editable grid, so bind a gallery to a staging collection and place input controls in each row with Default set to ThisItem fields. On save, harvest values from Gallery.AllItems and Patch them back to the data source in one pass.

How to save multiple gallery rows to SharePoint at once in Power Apps?▼

Use ForAll over Gallery.AllItems with one Patch per row, branching on whether the row has a real ID. Update existing rows by merging onto the looked-up record and create new rows by merging onto Defaults(Source), then reload the collection to pick up server-assigned IDs.

Why does my Power Apps Patch create duplicate rows instead of updating?▼

Duplicates happen when an update is merged onto Defaults(Source) instead of the existing record. Branch on ID greater than zero: existing rows patch onto their looked-up record, while only genuinely new rows use Defaults(Source).

Does the editable gallery pattern work with large SharePoint lists?▼

Yes, but the initial ClearCollect that stages the collection must use a delegable Filter, or only the first 500 or 2000 rows load. Also note that Patch inside ForAll sends one request per row, which is slow for very large grids.

How do I delete rows from an editable Power Apps gallery?▼

Remove the row from the staging collection with Remove(colGrid, ThisItem) for the UI. If the row already exists in the source, also record it in a separate deletes collection and reconcile those removals against the data source on save.