Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ypSIfSMqW+POEL9rA7KIel
Power Apps - Microsoft Dataverse
Answered

Managing Dataverse Schema Changes

Like (0) ShareShare
ReportReport
Posted on 1 Aug 2021 18:22:43 by 83

When building a PowerApp which has Dataverse for storage, are there recommended best practices for managing data schema changes (e.g., adding or dropping columns or tables) as new versions / upgrades of the PowerApp get released into AppSource

 

As a reference point, in other environments, one can use something like Liquibase to track, version, and deploy database changes as an application gets upgraded. What should someone do to address this issue with PowerApp / Dataverse ?

 

Thank you for any guidance !

Categories:
  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 17 Feb 2023 at 19:43:41
    Re: Managing Dataverse Schema Changes

    @dfladung, I would say the best practices and tools are with solutions and the Build Tools and GitHub actions. More info: https://learn.microsoft.com/power-platform/alm/devops-build-tools and https://learn.microsoft.com/power-platform/alm/devops-github-actions  

    Cheers

  • dfladung Profile Picture
    2 on 15 Feb 2023 at 16:23:33
    Re: Managing Dataverse Schema Changes

    As an addendum to this question, tools like Flyway and Liquibase allow both DDL and DML updates. If I needed to perform the equivalent of DML operations as part of a solution upgrade, is the recommendation to use Power Automate as part of a staged upgrade?

  • Chris1969 Profile Picture
    83 on 05 Aug 2021 at 13:34:09
    Re: Managing Dataverse Schema Changes

    Thank you! Just what I needed, and I really appreciate your help.

  • Chris1969 Profile Picture
    83 on 05 Aug 2021 at 13:33:46
    Re: Managing Dataverse Schema Changes

    Thank you so much - this is very helpful and exactly what I needed

  • Verified answer
    EricRegnier Profile Picture
    8,714 Most Valuable Professional on 01 Aug 2021 at 22:32:32
    Re: Managing Dataverse Schema Changes

    Hi @Chris1969,

    The simplest approach especially if you're new to Dataverse is with solutions. Solutions are used to move changes/configuration/customizations/schema between environments and/or save/backup them. You can save that solution into a repository and  you can even unpack (a bit more advance) the solution to decompose the solution into xml files per component type. You can then commit those files into source control (eg Azure DevOps) to gain all the goodness of versioning and conflict resolution.

    More on solutions: https://docs.microsoft.com/powerapps/developer/data-platform/introduction-solutions 

    More on unpacking solutions: https://docs.microsoft.com/power-platform/alm/use-source-control-solution-files 

    Hope this helps!

     

  • ChrisPiasecki Profile Picture
    6,389 Most Valuable Professional on 01 Aug 2021 at 19:15:54
    Re: Managing Dataverse Schema Changes

    Hi @Chris1969,

     

    Dataverse components all have metadata that keeps track of the version it was introduced and its current version. In its raw form (unpacked) it's in either a human readable format such as XML or YAML, which can then be stored in a version control system such as Github or Azure are Repos.

     

    If using one of the above tools, there are Microsoft extensions for exporting, Importing, unpacking, packing solutions etc to help manage the lifecycle of your Dataverse and other Power Platform components.

     

    Have a look at Power Platform Application Lifecycle Management on Microsoft Docs, it goes into depth on all the platform capabilities and tooling to help with this.

     

    https://docs.microsoft.com/en-us/power-platform/alm/basics-alm

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

Overall leaderboard

Featured topics

Loading started