How-tos

Build a no-code table app with PowerTableBuild a no-code table app with PowerTable In this article, you learn how to create a table app with PowerTable sheets. Important…Connect PowerTable sheet to a semantic modelConnect PowerTable sheet to a semantic model In this article, you look at the steps to connect to a semantic model from…Connect to a DatabaseConnect to a Database Manage your master and transactional data by connecting your existing databases to PowerTable. After establishing the connection, you…Enter Data ManuallyEnter Data Manually This article explains how to manually enter data into PowerTable to build an app. You'll enter data to create…Data managementData management Insert, import, duplicate, and delete rowsInsert, import, duplicate, and delete rows Powertable provides multiple ways to add, import, copy, duplicate, and delete rows in a table. You…Add Columns - OverviewAdd Columns - Overview As your business requirements evolve, you may need to capture new types of information in your tables. Powertable…Configure column propertiesConfigure column properties Configuring column properties helps ensure data accuracy and consistency in the database. By defining appropriate data types, constraints, default…Set up row and column access controlSet up row and column access control Data security and integrity are essential in collaborative environments where multiple users work on a…Manage ColumnsManage Columns Use Manage Columns to control column visibility, width, order, configuration, and access permissions. To open the Manage Columns panel, select…Configure layoutsConfigure layouts Create data entry formsCreate data entry forms Forms allow you to collect data from users and write them directly to your database. Important This feature…Approval flowApproval flow Create automationCreate automation This article explains how to automate some common repetitive tasks such as cascaded data updates between database tables.Collaborative CommentingCollaborative Commenting Data-level commentary is commonly used in real-life scenarios. PowerTable allows you to add comments to individual cells, rows, and columns…Export powertable sheetExport powertable sheet Export powertable sheets to Excel and PDF so you can work with, share, and analyze your data outside of…Conditional FormattingConditional Formatting The conditional formatting feature in powertable sheets helps highlight specific data based on defined conditions. You can use conditional formatting…Audit logAudit log Audit logs provide a comprehensive record of changes made to a table. In powertable, the audit log helps you track…Create slowly changing dimensionsCreate slowly changing dimensions Use Type 2 and Type 3 slowly changing dimensions (SCDs) to track changes to dimension data. In this…Explore and organize dataExplore and organize data PowerTable provides several options to help you search, organize, and analyze data in a table. You can search…Appearance settingsAppearance settings Customize the appearance of your table by changing text formatting, spacing, row height, row highlighting, and gridline settings. Adjust row…

Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.

BUILT ON