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