# Enter Data Manually

In previous sections, we demonstrated how to [import a CSV file into PowerTable](https://docs.powertable.com/explore-powertable/powertable-product-tour/build-your-first-app) and [connect to a database](https://docs.powertable.com/explore-powertable/create-table-app/connect-to-database) directly from PowerTable.&#x20;

This section explains how to manually enter data into PowerTable to build an app.&#x20;

**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.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FASlB0JGdM8ShVlROxDE5%2Fimage.png?alt=media&#x26;token=24852655-6f2e-4c5d-b910-297d41ee8563" alt=""><figcaption><p>Create a new item</p></figcaption></figure>

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F33fohxj2fjNG1tS1NIA0%2Fimage.png?alt=media&#x26;token=80ec3f00-8274-4f02-a0ec-6f9ce4b07561" alt=""><figcaption><p>Select 'PowerTable'</p></figcaption></figure>

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F0Cem66tqsyOPMU2aTqY5%2Fimage.png?alt=media&#x26;token=495e4b9b-9766-4f53-9422-50319fbb92aa" alt=""><figcaption><p>Create PowerTable item</p></figcaption></figure>

4. Click on **Create a New App** to create your app. You may also select 'Explore PowerTable' to [experience a sample PowerTable app](https://docs.powertable.com/explore-powertable/powertable-product-tour/explore-a-sample-app).

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FmRwGghk5AHGeX39Uv54p%2Fimage.png?alt=media&#x26;token=11117f1d-0f13-45bc-afa6-cb573487d7b7" alt=""><figcaption><p>Create a New App</p></figcaption></figure>

5. **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.**

   <figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2Fa7RhmSNyz8qhBFcMCaYL%2Fimage.png?alt=media&#x26;token=d7fccc8a-77fd-4c88-8782-8df5e1c1a130" alt=""><figcaption><p>Creating a new connection</p></figcaption></figure>

{% hint style="info" %}
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.**
{% endhint %}

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FPphyT8JXJTkT4UUB4lAy%2Fimage.png?alt=media&#x26;token=a094d6d8-56d3-4b52-9989-67ebdaec0759" alt=""><figcaption><p>Choosing an existing connection</p></figcaption></figure>

6. **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.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FheC1catj3TFxm8azxtZw%2Fimage.png?alt=media&#x26;token=ce5dc271-2a94-4f89-af29-aa63cd318962" alt=""><figcaption><p>Setup Connection</p></figcaption></figure>

7. **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.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F3pUTlkFhpWZ7zMb9fbVl%2Fimage.png?alt=media&#x26;token=26e86495-6fb0-441d-b2c5-d47de4d5cd28" alt=""><figcaption><p>Create new table</p></figcaption></figure>

8. Select the schema and enter a name for your table. Choose the option **Enter Data Manually** to manually enter the data. Click **Next.**

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FZhZxarWpYd2lnynBOtML%2Fimage.png?alt=media&#x26;token=8da8b2cf-5a97-41b8-bb0c-78d8b2b5cd0b" alt=""><figcaption><p>Enter table name</p></figcaption></figure>

9. **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.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FxYjC6Cua9jvBAcpiTP1m%2Fimage.png?alt=media&#x26;token=ad98c54f-55d6-4733-8eb9-1a9f9abe8db5" alt=""><figcaption><p>Add Column details</p></figcaption></figure>

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FiYDIrYunNekmlfHt7fUJ%2Fimage.png?alt=media&#x26;token=ea186a9e-90f4-453e-9b39-aa6f3289e257" alt=""><figcaption><p>Add Column</p></figcaption></figure>

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2Fu4A4xp2n00GWrXOCcTUY%2Fimage.png?alt=media&#x26;token=950d3f87-1fe1-4178-b4dd-8828091dbea0" alt=""><figcaption><p>Deleting a column</p></figcaption></figure>

12. Click **Finish** after entering all the column details.

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FrdaTYRmhL5qmM9uhxBqa%2Fimage.png?alt=media&#x26;token=293b932a-8400-4a44-b6c5-06a255cc1fc9" alt=""><figcaption><p>click 'Finish'</p></figcaption></figure>

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F2KwWxHr2eOgZRf9k82mk%2Fimage.png?alt=media&#x26;token=875ee0a9-309b-48a0-818e-7802edcebc55" alt=""><figcaption><p>Table created</p></figcaption></figure>

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

<figure><img src="https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FtfOwdVGrgNECfIfv7oxu%2Fimage.png?alt=media&#x26;token=ec6daf2a-fd6d-4a75-9f64-97510f9c9005" alt=""><figcaption><p>Inserting rows into the table</p></figcaption></figure>

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.
