Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Answered

Editable sub-grid with Rows & Columns transposed.

(0) ShareShare
ReportReport
Posted on by

I want to create an Editable sub-grid with Rows & Columns transposed. In my scenario, there are more are like twenty fields and two records so User Experience wise it makes more sense to have records being displayed as column of a table and columns of an Entity as a row in a table. And it needs to be an editable grid. Has anyone already worked on this approached? 

  • Verified answer
    Re: Editable sub-grid with Rows & Columns transposed.

    So I fixed this issue using a embedded Canvas app with the transposed rows and columns. Pretty cool. I figure we can use PCF as well which is lot cooler than canvas app and faster than embedded canvas app but canvas app is quicker to implement so no worries.

  • Hemant Gaur Profile Picture
    Hemant Gaur on at
    Re: Editable sub-grid with Rows & Columns transposed.
    It's the debug harness support which facilitates testing locally on client and data set support is WIP.

    You can create a solution and deploy/test directly in CDS model app.

    Please see -https://docs.microsoft.com/en-us/powerapps/developer/component-framework/create-custom-controls-using-pcf#deploying-your-powerapps-component-framework-components
  • iamishan9 Profile Picture
    iamishan9 2 on at
    Re: Editable sub-grid with Rows & Columns transposed.

    I can't test this table grid sample. I get this error

     `Support for dataset is coming soon..`
    https://docs.microsoft.com/en-us/powerapps/developer/component-framework/sample-controls/table-grid-control
  • Hemant Gaur Profile Picture
    Hemant Gaur on at
    Re: Editable sub-grid with Rows & Columns transposed.

    Hi Summit, please take a look at the table grid example in the sample controls. Since the component owns rendering of the table, rows and columns can be easily swapped.  Note that editability of the grid required lot of custom validation on the field types based on metadata so ensure that the types you are exposing are well understood. Also the clientAPI/PBL for the record editing will not fire as it would have with the field editing on the form. Server side PBL or plugins should be evaluated.  We have OOB editable grid which handles much richer interactions, please evalaute that too.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard