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

Getting Started with Syncfusion PowerApps Spreadsheet 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 Spreadsheet 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 Spreadsheet 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 Spreadsheet 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
Customer Name	SingleLine.Text
Model	SingleLine.Text
Color	SingleLine.Text
Payment Mode	SingleLine.Text
Delivery Date	SingleLine.Text
Amount	Currency

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 Spreadsheet 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 a new 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 Spreadsheet code component to the custom page. Configure the data source for the Spreadsheet code component by accessing the list of Dataverse tables. This step ensures that the Spreadsheet code component is seamlessly connected to the relevant data. Also, customize the Spreadsheet code component properties in the property pane.

Note

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

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

8. 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 Spreadsheet 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 Spreadsheet Code Component in Canvas Application