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

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (69,135)