This article provides a step-by-step guide for setting up a Power pages application and integrating the Syncfusion Chart code component.
Power Pages is a low-code platform in the Microsoft Power Platform family, designed for creating secure and responsive external-facing business websites. It facilitates rapid development without extensive coding, integrates with data sources, and inherits robust security features from Microsoft Azure, making it a versatile tool for diverse website needs.
Syncfusion PowerApps Chart 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 Chart 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 |
---|---|
Primary | SingleLine.Text |
VietnamX | Whole.none |
VietnamY | Decimal |
CanadaX | Whole.none |
CanadaY | Decimal |
MalaysiaX | Whole.none |
MalaysiaY | Decimal |
EgyptX | Whole.none |
EgyptY | Decimal |
IndonesiaX | Whole.none |
IndonesiaY | Decimal |
Note
- The primary columns in Dataverse will be in SingleLine.Text type. So, the
Primary
columns is declared to be primary & other columns will be in respective chart supported data type. - When setting up a Dataverse, make sure that the table columns are assigned the correct data types to prevent data loading issues in the Chart code component.
To add the Syncfusion PowerApps Chart code component to the Dataverse table, follow the steps below:
-
In the Dataverse table, find the
Forms
tab in the Data experiences pane to streamline data management. Locate theInformation
form with the main form type to define how users interact with and organize data effectively. -
Within the left navigation pane of the
Information
form, locate theComponents
tab. Here, click onGet more components
at the bottom of the tab.
- A window will appear. Switch to the
Build by others
tab at the top and import the built code component namedSfChart
from the published solutions.
-
Create a new section in the form, opting for a
1-column tab
from thepopular
section. Rename this tab as Chart View to clearly delineate its purpose. This tab will be utilized to render the Chart code component. -
Within the
More Components
section, select theSfChart
component. Configure the DataSource property of the Chart code component by accessing the list of Dataverse tables created previously with respective table views. This step ensures that the Chart code component is seamlessly connected to the relevant data.
-
Once the data is loaded, include the necessary series data for the Chart code component by accessing the
series
property and paste the Series config data and customize other properties in the property pane.. -
The output of the Chart code component will appear as shown below. Click the
Save and publish
button at the top right corner of the PowerApps portal. This action commits the changes made to the form, ensuring that the Syncfusion PowerApps Chart code component is now an integral part of the Dataverse table.
To create a Power Pages application, follow the steps below:
-
In the Power pages portal, click the
Start from blank
option to create a new Power Pages application. And provide a meaningful name for your Power Pages application. Subsequently, clickcreate
to proceed. -
The Power Pages platform will generate a blank Power Pages application based on your specifications. You are now ready to start building your application. The created application will be listed in
Active sites
tab. Now. clickEdit
the application to proceed.
-
Then update the header title and logo by clicking the
Edit site header
button in the header section. And change the theme of the application toMoss
in theTheme
section. Finally, click theSave
button to save the changes. -
Add new section by clicking the
ADD A SECTION
button. And create a heading by choosingText
component.
- Now click the
Form
button under the title component to add the previously created table form contains Syncfusion Chart code component. And choose theNew Form
option to select a new form. In that, select the previously created table and its form. Finally, click theok
button to save the changes.
- click the
New permission
button on top of the form to add the permission for the Dataverse table. And select the necessary permission for the table. Finally, click theok
button to save the changes.
-
After updating the permission, click
Edit form
on the form component and selectdata
tab on left pane. On that, click theOpen Portal Management app
button under configuration section to open the portal management app in new tab. -
In the opened Portal Management app, click the
Basic Form Metadata
tab of theInformation
table form. and create two new form metadata by clicking theNew Basic Form Metadata
button. And provide the necessary details for the form metadata forChart View
tab and the code component. Finally, click theSave
button to save the changes. check below screenshots for reference.
-
After updating the form metadata, navigate to the Power pages portal and click the
ok
button on the form component to save the changes. Finally, click theSync
on the top right corner of the Power pages application to synchronize the changes. -
Now, click the
Preview
button on the top right corner of the Power pages application and clickDesktop
to preview the application in new tab. The output of the Chart code component will appear as shown below.