Custom Grid Totals PCF Control

(2) Share

Report

Posted on by mmeisels

Seeking a PCF control that works against any Dynamics grid
The control should add an additional line on the bottom of the grid that would sum up any number (int, decimal, money)
The sums should always stay on the bottom of the grid
See attached image

Categories:

Power Apps Pro Dev & ISV

Grid Totals.jpg

I have the same question (0)

All responses (3)

Answers (0)

Hemant Gaur on at

Like (0)

Report

Out of the box is not available for customization/update and the scenario is not possible currently. Compositing support is in the roadmap which wuld allow controls to be nested and that would be another way to enable this scenario.

To acheive this using the currently available framework capability, you can replace the grid with the custom html table and add the desired totals as additional rows with custom formatting. Sample table grid component is a great starting point which replaces the grid with the simple HTML table. See - https://docs.microsoft.com/en-us/powerapps/developer/component-framework/sample-controls/table-grid-control

Note that the cusom component can be configured at the view level so you can create a dedicated view - Products with totals and cofigure your control to it. View level configuration can be done via cutomization -> entity -> views -> Click on view where config is desired -> custom controls and add the right control.

Outside custom component, you can also try using charts like car chart to show the totals adjacent to the grids. Please refer to - https://docs.microsoft.com/en-us/dynamics365/customer-engagement/basics/create-edit-chart

hemant

Was this reply helpful? Yes No
Avigail Soroka 6 on at

Like (1)

Report

What is the status of this on the roadmap? Is there any additional information available? @HemantG

Was this reply helpful? Yes No
Hemant Gaur on at

Like (0)

Report

Aggregation is not on the immediate roadmap for the grid control . Team was focused on getting the brand new grid for the Power Apps teams integration announced yesterday- check it out - https://powerapps.microsoft.com/en-us/blog/introducing-microsoft-dataflex-a-new-low-code-data-platform-for-microsoft-teams/

As I pointed building this using PCF is possible. Check this one PCF gallery from Nino Joseph, might be helpful.

https://pcf.gallery/aggregate-grid/

hemant

Was this reply helpful? Yes No