Power App for organizing a dimension table with drag and drop.

[CBO2404]

How can I manage a dimension table, dim_product, where I can organize the list of products into categories and subcategories?
For example, level1 = "All Products" with two level2 items: level2 = "External Products" and "Internal Products", and under each level2 item, level3 would contain the actual product names.

I want to be able to create categories and drag and drop products under them using the mouse.

The product list should be loaded from a source — a dimension table in a lakehouse (e.g. Fabric or Synapse) — and any changes (e.g. category assignments) should be written back to that same source.
Of course, I can do this directly in the dataset using DAX code to create a new column, but I want a non-technical user to be able to do it.

Can I use PowerApps for this, and is there an example (to download) of someone who has done this?

[v-saisrao-msft]

Hi @CBO2404,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi @CBO2404,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Power Apps Canvas App that presents your dim_product table in a drag and drop UI using the Power Apps, allowing users to assign products into categories and subcategories. A useful starting point for this is Microsoft’s guide on enabling drag & drop in Power Apps with PCF, and the PCF overview explains how to build reusable components. 

Enabling drag & drop in canvas-based Power Apps with PCF | Microsoft Learn 

Power Apps component framework overview in Microsoft Dataverse - Power Apps | Microsoft Learn 

You can use Dataverse as an intermediate storage layer and link it with Fabric using Azure Synapse Link: 

Link your Dataverse environment to Microsoft Fabric and unlock deep insights - Power Apps | Microsof... 

Use Power Automate to create a flow that connects to the Fabric Lakehouse via the SQL Analytics Endpoint. The flow can be triggered from a "Save" button in the app and execute SQL commands to update the category fields in the Lakehouse table: 

Greenfield lakehouse on Microsoft Fabric - Azure Architecture Center | Microsoft Learn.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.