How-tos

Create a table appCreate a table app 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 AutomationAutomation Commenting and collaborationCommenting and collaboration Commenting and collaboration features enable you to add contextual discussions directly within the PowerTable sheet. Use these capabilities with…Export to ExcelExport to Excel Export PowerTable sheets to Excel so you can work with, share, and analyze your data outside of PowerTable. This…Export to PDFExport to PDF Export various PowerTable layout views to PDF to generate a static, shareable snapshot of your project data. PDF exports…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…Configure security settings in PowerTableConfigure security settings in PowerTable Use the security settings in PowerTable to control access to data stored in a database. You can…

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

BUILT ON