Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Dynamic Dataverse table creation using Model Driven app

(1) ShareShare
ReportReport
Posted on by

Hi,

 

Can we create a dataverse table dynamically through Model driven app by collecting table name and other required values?

  • Parvez Ghumra Profile Picture
    Parvez Ghumra 1,572 on at
    Re: Dynamic Dataverse table creation using Model Driven app

    @SriHarish Although this is technically possible, I would recommend that you don't deploy any code that does this in a non-development environment because the schema changes it would generate at runtime would be in an unmanaged state which is not recommended for non development environments 

  • ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Dynamic Dataverse table creation using Model Driven app

    Yes you could do an asynchronous plugin or you can write a console app that connects to Dataverse using the XrmTooling connection. 
    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/xrm-tooling/use-connection-strings-xrm-tooling-connect

     

    I imagine the use case would be to create multiple tables/columns over several environment uniformly. But you can also achieve this via solution imports & pipelines without code. 

  • bscarlavai33 Profile Picture
    bscarlavai33 513 on at
    Re: Dynamic Dataverse table creation using Model Driven app

    To add to what Ivan said, you would want to register a post synchronous plugin on your table that then uses the above code to create the tables dynamically. Curious what your use case is though since Power Platform already has great UIs to configure Dataverse tables, columns, forms, etc.

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/tutorial-write-plug-in

  • ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Dynamic Dataverse table creation using Model Driven app

    Yes the XRM API should allow you to programmatically create dataverse  tables. But you have to know C# to do it:

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-update-entity-definitions-using-web-api

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics