web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Common Data Model defi...
Power Apps
Answered

Common Data Model definitions to Dataverse

(0) ShareShare
ReportReport
Posted on by itsopaz 9

I have Common Data Model  schemas for my tables, is there a way of using those schema json files to create these tables.

 

Web API can be used to define tables, but the json schema used is EntityMetadata type and not CDM json schema. (Out of the box tables in dataverse (business unit, teams etc.) are based on the CDM). 

 

Converting the files by hand is not really a option and creating these tables using the interface is too manual. Do i need to write some kind of JSON to JSON converter or is there some better options for this kind of process.

Categories:
Microsoft Dataverse with Power Apps
I have the same question (0)
  • Verified answer
    Jonathan Manrique Profile Picture
    Jonathan Manrique 2,695 on at

    Hi @itsopaz 

     

     

    In principle, what you ask cannot be done, that is what the user interface that allows you to create the tables is for.

    Then there are tools developed by third parties using the Microsoft SDK that can allow you certain functionalities.

    One of them is the XRMToolBox and in it there is a plugin that allows you to duplicate the tables, that is, you have a table A and you need to create a B with the same fields, you can do it

     

    Jmanriquerios_0-1706274560040.png

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    You can accept more than one post as a solution
    Follow me on Linkedin, I talk about Power Platform
    www.linkedin.com/in/jonathan-manrique-rios

     

     

  • ivan_apps Profile Picture
    ivan_apps 2,189 Moderator on at

    I’m a bit confused by what you mean by you have Common Data Model schemas for your tables. Do you mean you have a set of custom tables that are common for your organization? Or are you extending Microsoft’s CDM by adding fields to the existing tables?

     

    If you are trying to automatically create new tables based on a schema you have, I would recommend creating a console app or WPF desktop app and use the SDK - it’s C# so it’s pro-code but you could target many environments this way.

     

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/org-service/create-custom-entity

     

    Alternatively you can deploy your custom tables as solutions to your org? Perhaps using pipelines or ALM accelerator to deploy to every environment in your tenant?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 493 Most Valuable Professional

#2
11manish Profile Picture

11manish 479

#3
Haque Profile Picture

Haque 328

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans