cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
summitb
Power Participant
Power Participant

Editable sub-grid with Rows & Columns transposed.

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
summitb
Power Participant
Power Participant

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.

View solution in original post

4 REPLIES 4
HemantG
Power Apps
Power Apps

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.

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-...

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-usin...
summitb
Power Participant
Power Participant

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.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (57,787)