Fabric Plan Community Logo
Sign in

How-tos

Create a table appCreate a table appUpdate table dataUpdate table data Use the PowerTable sheet to edit and update data directly in the database without writing code. Before saving, preview…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…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 layoutsCreate data entry formsCreate data entry forms Forms allow you to collect data from users and write them directly to your database. Forms can be…Approval flowApproval flowAutomationAutomationCommenting 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…Configure data security in PowerTableConfigure data security in PowerTable This article explains how to configure data security in PowerTable by using roles, policies, and user attributes.…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…Appearance settingsAppearance settings Customize the appearance of your table by changing text formatting, spacing, row height, row highlighting, and gridline settings. Adjust row…
Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.