getting-started-with-model-driven-custom-pages.md

Getting Started with Syncfusion PowerApps Pivotview Code Component in Model-Driven Application (Custom Pages)

This article provides a step-by-step guide for setting up a PowerApps model-driven application with Custom pages (Canvas) and integrating the Syncfusion PowerApps Pivotview code component.

PowerApps Model-Driven is a versatile platform for creating structured applications with a focus on data-centric design. It offers a guided approach, allowing users to build efficient business processes and workflows within a predefined data model.

Prerequisites

• Published Syncfusion PowerApps solution package

Create a new Dataverse table

Syncfusion PowerApps Pivotview code component requires data to be loaded from a data source. Follow the steps provided in Create a new Dataverse table section to create a new table in Dataverse using the CSV in the Pivotview code component data folder. Skip this step if you have an existing table with data.

When creating the Dataverse table using CSV file, ensure the column names and data types match those in the table below:

Column Name	DataType
Sold	Whole.none
Amount	Currency
Country	SingleLine.Text
Products	SingleLine.Text
Year	SingleLine.Text
Quarter	SingleLine.Text

Note

When setting up a Dataverse, make sure that the table columns are assigned the correct data types to prevent data loading issues in the PivotView code component.

Create a PowerApps model-driven application

To create a model-driven application, follow the steps below:

1. In the PowerApps portal, navigate to the Apps tab located in the left navigation pane and select the Start with a page design option.

2. Opt for the Blank page with navigation option and assign a meaningful name for your model-driven application. Proceed by clicking create.

3. The PowerApps platform will generate a blank model-driven application based on your specifications. You are now ready to start building your application.

4. To incorporate custom page into your application, click on the Add Page button. Select Custom Page & select Create custom page option. And assign a meaningful name for your custom page. Proceed by clicking Add.

5. The PowerApps platform will generate a blank custom page based on your specifications in a new tab. You are now ready to start building your custom page (Canvas).

6. Use any layouts & import the Syncfusion PowerApps Pivotview code component to the custom page. Configure the data source for the Pivotview code component by accessing the list of Dataverse tables. This step ensures that the Pivotview code component is seamlessly connected to the relevant data.

7. Once the data is loaded, include the necessary pivotViewConfig data for the Pivotview code component by accessing the pivotViewConfig property and paste the PivotView config data. Also, customize the other Pivotview code component properties in the property pane.

Note

Update the flexible height, width, and other properties of the Pivotview code component to suit your application requirements. Also, refer to the Pivotview Canvas documentation for additional information.

8. Save the custom page and publish the changes to add it in the model-driven application.

9. After that in the previously created model-driven application, click on the Publish button to make the changes live.

Note

For more information, refer to the Create an blank Model-Driven app in PowerApps.

Publish the Syncfusion PowerApps Pivotview application

After publishing the application, click the play button to preview the published application. You can also share the published application with your users.

See Also

• Getting Started with the Syncfusion PowerApps Pivotview Code Component in Canvas Application

• Getting Started with the Syncfusion PowerApps Pivotview Code Component in Model-Driven Application (Form)

• Getting Started with the Syncfusion PowerApps Pivotview Code Component in PowerPages