> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/create-a-table-app-with-powertable-sheets.md).

# 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](/documentation/readme/planning-sheets/how-tos/create-a-database-connection.md) and the [semantic model](/documentation/readme/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](/documentation/readme/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/v9x5CWcih4TWeQOTg9Iq" 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/64IknoGab86EFy2RGuWj" alt=""><figcaption></figcaption></figure>

3. **Select a Connection:** Choose a Fabric SQL connection if available. If there are no connections, you can create one by selecting [Create Connection](/documentation/readme/planning-sheets/how-tos/create-a-database-connection-for-collaboration.md).

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

4. **Database Name:** Select the destination Fabric SQL database to store the table data. Select **Add**.

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

5. Select **Connect**.

<figure><img src="/files/niMXtcR4TyAzc1OuIEWo" 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/FWqgW5F2fKfj2IzTlf0L" alt=""><figcaption></figcaption></figure>

6. Select the sheet that contains the data you want to import.

   * Enter a name for the table.
   * Review and, if necessary, modify the start and end cell ranges that contain the data to be imported.
   * Preview the imported data, and then select **Next**.

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

{% hint style="info" %}

#### Note

To import only the headers, select **Import header 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.

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

1. Review the detected column settings.
2. If the primary key is unselected, select the appropriate column as the primary key.
3. Configure columns as required:
   * Mark fields as **Mandatory** if they must contain values.
   * Set fields with distinct values as **Unique Key** to allow unique values.
   * Set a column as an **Identity Column** when you need PowerTable to generate unique, sequential values automatically. Only numeric columns and primary key columns can be configured as identity columns.
4. Modify column properties, including:
   * Length
   * Data type
   * Input type
   * Display name
5. Enter default values for columns, if required.
6. Optionally, select **Add Column** to create additional columns.
7. To create a composite primary key, select **Unique Combination**, and then select two or more columns to define a unique combination key.

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

8. Select **Finish**.

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

{% 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 %}

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

<figure><img src="/files/uDYR69v3yXfZSZyzfZUA" 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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/documentation/readme/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.