$ loading_
Add Dataverse tables to Power Apps code apps with generated TypeScript services.
The material indicates this skill mainly guides adding or creating Dataverse tables for Power Apps code apps, and it is system-labeled as prompt-only and open-source. It does not itself require secrets or declare fixed remote endpoints, but its documentation references later authentication and remote operations via Azure CLI and the Dataverse API, so overall it is low risk with some caution around real Dataverse access and permissions during use.
The metadata and material indicate the skill itself does not require secrets or environment variables. The README only mentions Azure CLI/Dataverse API authentication when performing real Dataverse operations, which is part of external service usage rather than the skill itself collecting or storing credentials.
Although the system marks it as prompt-only and no fixed remote host is declared, the documentation explicitly instructs connecting to the user's own Dataverse environment URL to query/create tables. This implies intended data and metadata exchange with relevant Microsoft Dataverse endpoints; this is a normal functional capability, but users should watch what is sent.
Per the objective checks, this is a prompt-only skill rather than an executable tool. The PowerShell/Azure CLI commands in the README are operational guidance and do not mean the skill itself automatically launches processes or executes code on the local machine.
The skill is intended to review existing Dataverse tables, create new tables, generate models/services, and potentially query Dataverse data. In real use, this means interacting with business schema and cloud-hosted data models. The material also notes System Administrator/System Customizer roles may be required, which are elevated business permissions and should be constrained by least privilege.
The source is the open-source GitHub repository microsoft/power-platform-skills, making the material auditable and lowering risk. While the license is not declared, stars are low, and maintenance status is unknown, these indicate some maturity uncertainty, but there are no clear supply-chain red flags such as closed-source exfiltration, suspicious install scripts, or unrelated endpoints.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "add-dataverse" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/power-platform-skills/main/plugins/code-apps/skills/add-dataverse/SKILL.md 2. Save it as ~/.claude/skills/add-dataverse/SKILL.md 3. Reload skills and tell me it's ready
Add the Accounts, Contacts, and Opportunities Dataverse tables to my Power Apps code app and generate the corresponding TypeScript models and data services.
The selected tables are connected, with TypeScript models and service code generated for querying and app use.
Create a new Dataverse table called Project Requests with fields for requester, department, budget, status, and submission time, then add it to my Power Apps code app and generate TypeScript models and services.
The new table and fields are created, added to the app, and accompanied by TypeScript data models and access services.
Add the Cases Dataverse table to the app, generate TypeScript services, and show an example of filtering records by status and reading detailed fields.
Integration code for the Cases table is generated, along with service-based query examples for further data access development.
📋 Shared Instructions: shared-instructions.md - Cross-cutting concerns.
References:
Two paths: existing tables (skip to Step 5) or new tables (full workflow).
Check memory bank for project context. Ask the user:
account, contact, cr123_customentity)If tables already exist: Skip to Step 5.
If creating new tables:
contact for people, account for organizations)EnterPlanMode, present ER model with tables, columns, relationships, and creation orderExitPlanModeSee api-authentication-reference.md for full details.
az account show # Verify Azure CLI logged in
# Find your Dataverse environment URL:
# In make.powerapps.com → Settings → Developer resources → Web API endpoint
# It looks like: https://<org-name>.crm.dynamics.com/api/data/v9.2/
# Use the base URL: https://<org-name>.crm.dynamics.com
$api = Initialize-DataverseApi -EnvironmentUrl "https://<org>.crm.dynamics.com"
$headers = $api.Headers
$baseUrl = $api.BaseUrl
$publisherPrefix = $api.PublisherPrefix
Requires System Administrator or System Customizer security role.
Always query existing tables first before creating:
$existingTables = Invoke-RestMethod -Uri "$baseUrl/EntityDefinitions?`$filter=IsCustomEntity eq true&`$select=SchemaName,LogicalName,DisplayName" -Headers $headers
See table-management-reference.md for Find-SimilarTables, Compare-TableSchemas, and Build-TableNameMapping functions.
Present findings to user with AskUserQuestion:
Get explicit confirmation before creating. Create in dependency order:
Use safe functions from table-management-reference.md:
New-DataverseTableIfNotExistsAdd-DataverseColumnIfNotExistsAdd-DataverseLookupIfNotExists (from data-architecture-reference.md)For each table:
npx power-apps add-data-source -a dataverse -t <table-logical-name>
Can add multiple tables by running the command for each one.
The command generates:
…
Set up Power Platform Pipelines for automated Power Pages deployments.
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.
Integrate Power Automate cloud flows into Power Pages with generated metadata and code.
Create Dataverse tables, columns, and relationships from a proposed site data model.
Connect AI to Microsoft Dataverse for everyday record CRUD operations.
Generate sample Dataverse records for testing and demoing a Power Pages site.
Build, query, deploy, and manage Microsoft Dataverse environments with specialist AI skills.
Lets AI query and manage Microsoft Dataverse data, metadata, and environments.
Add and verify a data source or connector in Power Apps Studio.