# Build your first app PowerTable is a native workload on Microsoft Fabric. This section will help you create your first app in a few simple steps. **There are several ways to create an app with PowerTable:**

	Option	Description
1	Import Spreadsheet	Import data from a spreadsheet and start building your app.
2	Connect to Database	Connect to an existing database table and build an app.
3	Type Data Directly	Enter data directly into the app to create a new table in the database.
4	Connect to Semantic Model	Connect to a semantic model to build a writeback-enabled app.

{% hint style="info" %} Note that in the above methods #1 to #3, the source and destination for the app will be the same - i.e., underlying database table. When you connect to a semantic model (method #4), the semantic model would be the source, and the destination will be the database table. You can use this method to build writeback-enabled applications. You also have the option of scheduling a refresh from the semantic model. {% endhint %} For now, we will explore method #1, where we import data from a CSV file and build an app. ## Create a New PowerTable item 1. Go to your Microsoft Fabric workspace folder. Click on **New item** to create a new item.

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

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

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

## Create a Database Connection When creating a new table or connecting to an existing table in a database, you need to select your preferred data store and establish a database connection. Your app synchronizes its data with this data store. 5. 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.**

{% hint style="info" %} If you already have a shared database connection 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 %}

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.

## Create a New Table 7. **Choose your table where the data will be stored:** Here, you have two options: * Select **Existing Table** to connect to an existing table in the database (or) * Select **New Table** to create a new table in the database. For our demonstration, we'll select **New Table** to create a new table and import our CSV data**.** We'll also choose a database schema (in this case— 'dbo').

8. Enter a name for the table and choose **Upload Excel/CSV.** {% hint style="info" %} Note that you can also choose to connect to an existing semantic model or enter data manually within the app. These are covered in the following sections. {% endhint %}

9. Select the file you want to upload.

10. Preview the uploaded data and click **Next.**

## Edit Column Properties (Optional) PowerTable detects column properties automatically. You can edit them if needed. Choose the primary key. You can also add additional columns in this step, using the **Add Column** option. After verifying the details, click **Finish.**

You have now successfully built your first app using PowerTable.

To get the most out of PowerTable, you will need to perform one or more steps listed below. We'll cover them in detail later. * Configuring field properties * Defining access control permissions * Configuring workflow approvals * Setting up automation including triggers, cascading updates, and email/Microsoft Teams notifications * ... and more. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.powertable.com/explore-powertable/powertable-product-tour/build-your-first-app.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.