What problem does it solve? Canvas Power Apps formulas against SharePoint lists silently return wrong or partial results when they don't delegate, and procedural coding habits produce slow, non-idiomatic Power Fx. This Skill authors correct, delegable formulas from the start and fixes delegation warnings, Patch failures, and state-management confusion. ## Core Features & Use Cases - Delegation-first formula authoring: Rewrites non-delegable patterns (Search, in-operator, IsBlank predicates, aggregates) into delegable Filter/StartsWith/Or-of-equals forms, backed by a full SharePoint delegation matrix in delegation.md. - State and write-back guidance: Chooses the right scope (Set, UpdateContext, With, Collect, App.Formulas) and writes correct Patch/SubmitForm code including Choice, Lookup, and Person column record shapes. - Performance and error handling: Applies Concurrent, caching, named formulas, IfError/Notify patterns, and the data-row-limit-1 testing technique. - Use Case: A gallery over a 6,000-item Orders list shows only 500 rows with a blue underline under Search. The Skill rewrites it as a delegable Sort(Filter(...StartsWith...)) so SharePoint filters server-side and all rows are searchable. ## Quick Start Ask the assistant to write or fix a Power Fx formula for your canvas app, for example to make a gallery filter delegate to SharePoint or to Patch a record with Choice and Person columns.
