Aggregation in subgrids/ views 

Feature: Component Power Apps grid control and feature Enable aggregation (preview) 

Overview: In the subgrids or views, we can now use the aggregation feature including sum/average/min/max for number/ currency columns. In the past, if we wanted to aggregate, we had to consume one roll-up field to do, or we had code from the technical side. 

Configuration and result: 

  How to enable aggregation in subgrid:

• 1. Add component

  2. In Get more components > Search and add Power Apps grid control

3. Enable aggregation
   
   After adding Power Apps grid control, we need to enable aggregation

4. Save and publish

5. Back to the apps, add expected aggregations

6. Check the result 

How to enable aggregation in view 

1. In table control (classic mode) > add new control 

2. Add component Power Apps grid control 

3. Edit Enable aggregation (preview) and change the option to Yes

4. Back to the Demo App, add expected aggregations

5. Check the result 

Limitations:

• Cannot add aggregation in groups of lines.

• Cannot format decimal for currency columns.

• Cannot save selected aggregations after refreshing the page.

• Only support aggregation: Sum/ Average/ Min/ Max