Enter Data Manually

In previous sections, we demonstrated how to import a CSV file into PowerTable and connect to a database directly from PowerTable.

This section explains how to manually enter data into PowerTable to build an app.

The source and destination will be the same; we will enter data to create a table and then writeback the subsequent changes to the same database. Let us look at the steps.

1. Go to your Microsoft Fabric workspace folder. Click on New item to create a new item.

Create a new item

1. Select PowerTable from the list of items. You may want to add it to your favorites by clicking on the star icon.

Select 'PowerTable'

1. Enter a name for your PowerTable app and select the workspace. Click on Create.

Create PowerTable item

1. Click on Create a New App to create your app. You may also select 'Explore PowerTable' to experience a sample PowerTable app.

Create a New App

1. Creating a new database connection: The next step is to create a new database connection to your preferred data source. Your app synchronizes its data with this data store. Follow the steps below to create a new connection:

   • Click on New Connection.

   • Choose your preferred data platform. We'll connect to the Fabric SQL database.

   • Click Next.

   

   Creating a new connection

If you already have shared database connections or a private connection to the required data store, skip step 5. Instead, click on the 'Existing Connection' tab, select the one you want to use, and then click Next.

Choosing an existing connection

1. Setup Connection: Enter the connection type and a unique connection name. Select the workspace and the database from the list of options and click Next. Your new private connection is now created.

Setup Connection

1. Choose your table where the data will be stored: Here, you have two options:

   1. Select Existing Table to connect to an existing table in the database (or)

   2. Select New Table to create a new table in the database.

   We'll select New Table to create a new table and type in the data.

Create new table

1. Select the schema and enter the table name. Choose the option Enter Data Manually to manually enter the data. Click Next.

Enter table name

1. Add Column Details: Start creating your table by adding the column name, primary key, and other relevant details like length, precision, scale, etc., wherever applicable.

Add Column details

1. Add Column: Click on '+ Add Column' at the top to add a new field/column.

Add Column

1. You can use the bin icon to delete a column.

Deleting a column

1. Click Finish after entering all the column details.

click 'Finish'

The table has been successfully created using PowerTable, with the configured columns.

Table created

You can now insert rows into this table using the Insert Row option.

Inserting rows into the table

With this table app, you can start working on your data, adjusting it as necessary and setting up features like approvals, workflows, and access control. These are covered in the following sections.