Deploying Dataverse Schema Changes via Unmanaged Solutions
Short answer
1. Create a new publisher; 2. Create a new unmanaged solution and select the correct publisher; 3. Add the table to the solution and add the new column; 4. Run the solution checker on the solution.
Question
You plan to add a new column to a system table in Dataverse and then move the changes to a test environment when they are complete. You create a new development environment to make the changes.
The changes must meet the following requirements:
• Must be clearly identified so that they are not confused with system components and components from other solutions.
• Must not affect any existing components in the test environment.
You need to prepare a solution for deployment to the test environment.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Key Takeaways
The main trap is using managed solutions or skipping the publisher step, which fails to isolate components or allow necessary schema modifications in target environments.
Learn the correct sequence for adding a column to a Dataverse system table using an unmanaged solution and custom publisher to ensure isolation and safety.
Common mistake: Candidates often skip creating a custom publisher or use managed solutions, leading to component conflicts or inability to modify schema in the test environment.
Expert Analysis
The scenario requires adding a column to a system table in Dataverse while ensuring changes are distinct from system components and do not impact existing test environment components. The correct sequence leverages Microsoft Power Platform solution management best practices.
First, you must create a new publisher. Publishers provide a unique prefix for all solution components, ensuring they are clearly identified and separated from system or other vendor components. This satisfies the requirement for clear identification.
Second, create a new unmanaged solution and associate it with the newly created publisher. Using an unmanaged solution is critical because managed solutions impose restrictions on modifications in target environments and can complicate the deployment of schema changes like new columns. An unmanaged solution allows full control during development and testing.
Third, add the system table to the solution and include the new column. By adding the table to the solution, you capture the schema change. Since the solution uses your custom publisher, the new column will be uniquely identified. Adding the table ensures the dependency is tracked.
Finally, run the solution checker. This tool validates that the solution meets compatibility requirements and does not contain errors that could break the target environment. It acts as a pre-deployment validation step to ensure the changes are safe and compliant before moving them to the test environment.
This sequence ensures isolation (via publisher), modifiability (via unmanaged solution), completeness (adding table/column), and safety (solution checker).
Official Reference
- https://learn.microsoft.com/en-us/power-platform/alm/solution-packager
- https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/create-solution
- https://learn.microsoft.com/en-us/power-apps/developer/dataplatform/customize-entity-schema
These links open the official vendor documentation in a new tab.
Exam Strategy
When asked about deploying schema changes, always prioritize creating a custom publisher for identification and using an unmanaged solution for flexibility. Remember to run the Solution Checker before any deployment to catch errors early.
Frequently Asked Questions
Why use an unmanaged solution instead of a managed one?
What is the role of a publisher in this process?
Discussion 1 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 1
-
exam_upskill 👍 11. Create a new publisher 2. Create a new unmanage solution and select correct publisher 3. Add the table to the solution and add the new column 4. Run the solution checker on the solution
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.