skills.rest
promitdutta
promitduttaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

setup-datamodel

Automate Dataverse table, column, and relationship setup for Power Pages.

Updated Apr 5, 2026
Search Tags:#data model#Automation#Power Platform#Dataverse#Power Pages
One-click install
npx skills add https://github.com/promitdutta/power-platform-skills-qwen --skill setup-datamodel-promitdutta
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: setup-datamodel
Source: https://github.com/promitdutta/power-platform-skills-qwen/tree/main/skills/power-pages/setup-datamodel
Command: npx skills add https://github.com/promitdutta/power-platform-skills-qwen --skill setup-datamodel-promitdutta

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires node, PAC CLI, Git, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation of Dataverse tables, columns, and relationships, streamlining the process of setting up a data model for Power Pages.

Core Features & Use Cases

  • Automated Table Creation: Dynamically create tables in Dataverse based on a provided data model.
  • Column Management: Automatically add columns to existing tables based on the data model.
  • Relationship Establishment: Create one-to-many and many-to-many relationships between tables.
  • Use Case: When building a Power Pages site, this Skill can quickly set up the necessary data structure, saving time and reducing errors.

Quick Start

Run the 'setup-datamodel' skill to create the required Dataverse tables and relationships for your Power Pages site.

Frequently Asked Questions about setup-datamodel

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

FAQPage Schema
How do I automate creating Dataverse tables and relationships for Power Pages?▼

Automate Dataverse table creation by using the Power Platform CLI and OData API to dynamically generate tables, columns, and relationships from a provided data model. This approach streamlines setting up the data structure for Power Pages while reducing manual errors.

Can I use an AI-generated data model to setup Dataverse tables automatically?▼

Yes, you can use an AI-generated data model to setup Dataverse tables. The automation supports both manual and AI-generated data models, requiring user confirmation at each critical step before creating tables, columns, and relationships in the environment.

What do I need to install to automate Dataverse table creation?▼

To automate Dataverse table creation, you need to install Node.js, the PAC CLI, and Git. You also need configured access to your target Power Platform environment to execute the OData API calls for table and relationship management.

What is the best way to establish Dataverse relationships for a Power Pages site?▼

The best way to establish Dataverse relationships is using PAC CLI automation to create one-to-many and many-to-many connections. This ensures your Power Pages site data structure is consistently configured based on your defined data model.

Does this Dataverse automation tool support adding columns to existing tables?▼

Yes, this Dataverse automation supports column management by automatically adding new columns to existing tables. It uses the OData API to modify the schema based on your provided data model while prompting for user confirmation.

Why do I need user confirmation when setting up a Dataverse data model via CLI?▼

User confirmation is required when setting up a Dataverse data model to prevent unintended schema changes. The automation pauses at each critical step, ensuring you approve table creations, column additions, and relationship mappings before execution.

Related Skills

Explore More Software Engineering Skills→
microsoftmicrosoft
483

add-dataverse

Create Dataverse tables and generate TypeScript models and services for Power Apps.

Official
Advanced
glideappsglideapps
10

api

Manage Glide Big Tables data via REST API v2 and @glideapps/tables.

Official
Intermediate
korchard333korchard333
46

azure-openai

Integrate Azure OpenAI into Power Platform via server-side intermediaries.

Community
Advanced
promitduttapromitdutta

add-sample-data

Insert sample records into Power Pages Dataverse tables via OData API.

Community
Intermediate