From powercat-canvas-apps
Read the YAML files of an existing Canvas App and replace Power FX data source calls with equivalent Dataverse table calls. USE WHEN the user wants to migrate, replace, or update data source references in pa.yaml files to point to Dataverse tables.
How this skill is triggered — by the user, by Claude, or both
Slash command
/powercat-canvas-apps:migrate-to-dataverseThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Read the YAML files of the current Canvas App and replace all Power FX data source calls with Dataverse equivalents for the following requirements:
Read the YAML files of the current Canvas App and replace all Power FX data source calls with Dataverse equivalents for the following requirements:
$ARGUMENTS
Before making any changes, you MUST read and internalize the technical reference document:
${CLAUDE_PLUGIN_ROOT}/references/TechnicalGuide.md — Technical best practices, control selection, validation workflow, formulas, layout strategiesRead this file before planning any edits.
Before reading or editing any YAML files, call the sync_canvas MCP tool to ensure a local copy of the canvas app YAML is present and up to date. This pulls the current app state from the coauthoring session into local .pa.yaml files.
Only proceed after sync_canvas completes successfully.
Call list_data_sources to enumerate all data sources connected to the current authoring session. This is the authoritative list of Dataverse tables (and other connectors) available for mapping.
After the call completes, share a discovery summary with the user:
Discovery complete. Available data sources ([N] total):
Name Type Key Columns [Table Name] Dataverse / SharePoint / … [column names]
For each Dataverse table identified, call get_data_source_schema to retrieve the full column list and Power Fx types. This information is required to map source columns to destination columns accurately.
Read every .pa.yaml file produced by sync_canvas. For each file:
SharePoint.GetItems, Filter('MyList', …), Patch('MyList', …), LookUp, Collect, ClearCollect, etc.).Filter, Patch, LookUp, Collect, etc.).Using the schemas retrieved in step 1, produce a mapping table for every data source call found:
Proposed Mapping Plan
Source Expression Source Column Dataverse Table Dataverse Column Notes Filter('Orders List', Status = "Open")Status cr123_orderscr123_statusType match: Text … … … … …
Rules for column selection:
Title → cr123_name).⚠ needs manual review.Text column to a Choices column without an explicit conversion formula.Present the plan to the user and ask for approval before making any changes:
Does this mapping plan look correct?
- Approve and apply changes
- I'd like to adjust the mapping first
If adjustments are requested, update the mapping plan accordingly and re-present.
Once the plan is approved, update every affected .pa.yaml file:
${CLAUDE_PLUGIN_ROOT}/references/TechnicalGuide.md (use = prefix, wrap multi-line formulas correctly, etc.).OnVisible initialization patterns — replace collection sources but keep the collection/variable structure if it exists.Announce progress for each file:
Updating [filename].pa.yaml ([N] of [Total])…
Call compile_canvas after updating all files. Fix any compilation errors before finishing. Report the result:
Repeat validate → fix until all files compile clean.
When all files pass validation, present a final summary:
Migration complete.
File Expressions Replaced Status [filename].pa.yaml [N] Compiled Source replaced: [original data source names] Target: [Dataverse table names used] Columns requiring manual review: [list any ⚠ flagged columns, or "none"]
Searches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.
Implements vector databases with Pinecone, Weaviate, Qdrant, Milvus, pgvector for semantic search, RAG, recommendations, and similarity systems. Optimizes embeddings, indexing, and hybrid search.
npx claudepluginhub microsoft/power-cat-skills --plugin powercat-canvas-apps