_TJ's avatar
_TJ
Frequent Visitor
7 months ago

Fabric Lists

Hello Fabric Community!

I'm excited to submit Fabric Lists for the Fabric Extensibility Toolkit Contest!

 

What is Fabric Lists?

Fabric Lists is a workload for Microsoft Fabric that empowers business users to create and manage their own data tables with a simple, intuitive interface - directly within Fabric.

 

What problem does it solve?

Say goodbye to:

  • Manual tables and Excel imports
  • Unmanaged Power Apps
  • Hidden SharePoint lists
  • Unreliable imports that break due to user changes (renaming columns, wrong date formats, missing data)
  • Entering data manually in SQL Management Studio or even worse: in the Power Query editor
  • Endless CASE WHEN statements hardcoded in your queries
  • Mystery edits with no audit trail - Fabric Lists has built-in tracking of who created and modified each row

Now business users can manage their budget and mapping tables themselves, without creating headaches for the data or IT department.

Who is it for?

Business users who need to maintain reference data, mapping tables, or simple datasets - with IT maintaining governance and control through Lakehouse integration.

Key Features

  • No backend required - Data stored as CSV directly in Lakehouse Files section
  • Type-safe columns - Prevent data entry errors with datatype validation
  • Built-in auditing - Automatic tracking of creation and update timestamps
  • Inline editing - Fast, Excel-like editing experience
  • Search functionality - Quickly find the data you need
  • Automation triggers - Execute notebooks or pipelines on save or via custom buttons
  • Shortcut Transformation ready - Automatically transform CSV to managed tables for SQL endpoint access

 

Screenshots

Lakehouse connection

 

Basic list

 

Inline editing

 

Data types

 

Bulk edit


Action buttons

Action buttons

 

Action on save; execute notebook or pipeline


Demo Video



 

 

GitHub Repository

https://github.com/daxternl/fabric-extensibility-toolkit

 

Future Roadmap:

  • Advanced filtering capabilities
  • Advanced validation (regex support)
  • Multi-value fields for one-to-many relations
  • Dropdown fields based on other lists
  • Bulk edit calculations to easily manage budgets
  • Change Data Capture with history rollback
  • SQL backend option for enhanced performance

Why Fabric Lists?

This workload bridges the gap between business user needs and IT governance. Data stays in your Lakehouse, users get a simple interface, and IT maintains full control - all without requiring external tools or backends.

I'd love to hear your feedback and answer any questions!

 

 

 

 

 

 

 

No RepliesBe the first to reply