# Build a no-code table app with PowerTable

In this article, you learn how to create a table app with PowerTable sheets.

{% hint style="info" %}

#### Important

This feature is in preview.
{% endhint %}

### Prerequisites

Before you begin, make sure that you have the following prerequisites in place:

* Connections established to the [Fabric SQL database](/planning-sheets/how-tos/create-a-database-connection.md) and the [semantic model](/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model-sp.md) that contain the data for your PowerTable.
* A [Plan item](/planning-sheets/how-tos/creating-a-planning-sheet.md#create-a-planning-sheet) created in your Fabric workspace.

### Ways to create a table

You can use one of these four approaches to create a table:

* Upload Excel or CSV file to import data
* Connect to an existing database table
* Enter data directly into the table app
* Connect to a semantic model

In the article below, you learn how to upload an Excel or a CSV file to create a PowerTable sheet.

### Create a PowerTable sheet

1. In your plan, select **New PowerTable Sheet** or select the **PowerTable** icon on the landing page. Enter a name for the sheet and select **Create**.

<figure><img src="/files/jWnbCXixsC2W6nULkw2y" alt=""><figcaption></figcaption></figure>

2. Select **Create a New App** to create your app. You can also select **Explore PowerTable** to experience a sample PowerTable app.

<figure><img src="/files/fAkBxk8JV841TeEmV2pN" alt=""><figcaption></figcaption></figure>

3. **Select a Connection:** Choose a Fabric SQL connection. You can also create a new connection if required.

<figure><img src="/files/7MHpA6HtolwlqZoBO7rJ" alt="" width="375"><figcaption></figcaption></figure>

4. **Database Name:** Select the Fabric SQL database. The metadata for your app is stored here. Select **Add**.

<figure><img src="/files/sW01vep7XNnIav0oPEei" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}

#### Note

When a new Plan item is created in a workspace, a Fabric SQL database is automatically created for that workspace. This database stores all the plan app metadata for workspace users. You can choose this database.
{% endhint %}

5. Select **Connect**.

<figure><img src="/files/SOzjxJ3rk3y2LYSHFQ1e" alt="" width="375"><figcaption></figcaption></figure>

### Create a table

Select a table for the data to be stored in. There are two options:

* Select **Existing Table** to connect to an existing table in the Fabric SQL database, OR
* Select **New Table** to create a new table in the database. This option is shown in the next steps.

To create a new table and import the CSV data, follow these steps:

1. Select **New Table**.
2. Choose the database schema.
3. Enter a **Table Name**.
4. Select **Upload File** in the **Import Data** section.
5. Select the space to upload the CSV or Excel file from your local system.

<figure><img src="/files/gyznpCarIpK94Bkg5Wrl" alt=""><figcaption></figcaption></figure>

6. Preview the data and select **Next**.

<figure><img src="/files/rOwkxdEdr45AfYv75qfj" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}

#### Note

To import only the table structure, select **Exclude records and import table structure only**.
{% endhint %}

{% hint style="info" %}

#### Note

There are also [other ways to create a new table.](#ways-to-create-a-table)
{% endhint %}

#### Configure columns

PowerTable sheets automatically detect column properties and rename any unsupported column names to match the supported format. You can review and modify them as needed.

1. Review the detected column settings.
2. Select the **primary key** if unselected.
3. Modify column properties, such as the data type, input type, and display name.
4. Enter default values wherever required.
5. Optionally, add columns using **Add column**.
6. Select **Finish**.

{% hint style="info" %}

#### Note

In this step, you can **enable Slowly Changing Dimensions (SCDs)** by turning the toggle. For a table, this is a one-time configuration that cannot be modified later.
{% endhint %}

<figure><img src="/files/o9gopZ5WUwXsHIWFNIAU" alt=""><figcaption></figcaption></figure>

7. The table app is created successfully in PowerTable with the configured columns and values. Select **Save** to save your table.

<figure><img src="/files/YAZ3h2AYYFD7i5N8ntpZ" alt=""><figcaption></figcaption></figure>

#### Write back changes to source

You can update your data table and sync changes with the source database.

1. To edit a cell in the table, double-click it, enter the value, and select **Enter**.
2. With **Preview Changes**, you can preview the changes.
3. Select **Save to Database**, then **Proceed** to save the changes instantly (unless an approval workflow is enabled).

<figure><img src="/files/8XdvJF6jzrRoSDfP5W9o" alt=""><figcaption></figcaption></figure>

The source database is updated.

4. Select **PowerTable > Audit**. The audit trail records all changes in detail, including the Row ID, action type, modified columns, previous values, new values, user name, and timestamp.

<figure><img src="/files/7AOLem0lClAgN9ewCAwM" alt=""><figcaption></figcaption></figure>

### Next steps <a href="#next-steps" id="next-steps"></a>

After creating your first PowerTable application, explore these other features:

* **Reference data management**: Manage master and reference data centrally while maintaining synchronization with enterprise data platforms. PowerTable sheets provide support for bulk insert/update, lookups, formulas, cascading updates, audit tracking, CRUD permissions, SCD support, and native Microsoft Fabric SQL DB integration.
* **Project management**: PowerTable sheets provide Gantt layouts and timeline views to manage project schedules, track progress, and monitor dependencies.
* **Workflow management**: Approval workflows enable governance over sensitive data updates by routing change requests through designated approvers.
* **Operational automation**: Event‑driven automation enables teams to automate repetitive processes such as record updates and notify them via email/Teams notifications.
* **Collaborative data management**: Comments, threaded discussions, mentions, and notifications allow teams to collaborate directly within the data application.
* **Productivity**: Use forms for structured data collection and insertion without coding. Use the master-detail view, cross-tab view, and resource layout for time management, task management, tracking, and resource planning.
* **Connected planning**: Link PowerTable tables to plans so updates in PowerTable sheets become inputs for a plan. This process allows a change in your revenue forecast to automatically flow into headcount, cash flow, and operational plans.


---

# 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.fabricplan.com/powertable-sheets/how-tos/create-a-table-app-with-powertable-sheets.md?ask=<question>
```

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.