How to Use SUM, COUNT, AVERAGE, MAX, MIN in Canvas PowerApps

Ram Prakash

5,266 Super User 2025 Season 1

Like(0)

Report

Introduction:

In this Blog we will see how to Use SUM, COUNT, AVERAGE, MAX, MIN in Canvas PowerApps.

Steps:

1. Navigate to https://make.powerapps.com

2. Click Apps

3. Select New and Select Apps

4. Click New App and select Start with Page Design

5. Select Blank Canvas template and Tablet

6. Create a collection like below and paste it in OnStart of the APP

ClearCollect(expenses,
{Item: "Travel", Value: 100},
{Item: "Food", Value: 300 },
{Item: "Hotel", Value: 895 },
{Item: "Hotel",Value: 1300},
{Item: "Accessories", Value: 50},
{Item: "Flight", Value: 800}
);

7. Now Add a label and you can configure expressions like blow

"Count Rows :  "& CountRows(expenses)

"Average :  "& Average(expenses,Value)

"Max :  "& Max(expenses,Value)

"Min :  "& Min(expenses,Value)

"Count Rows :  "& Sum(expenses,Value)

Conclusion:

This is how we can easily configure the Expressions in PowerApps