Mastering Minimum Value Extraction with GroupBy in PowerApps

Mastering Minimum Value Extraction with GroupBy in PowerApps

“Mastering Minimum Value Extraction with GroupBy in PowerApps”

Finding Minimum Values using GroupBy in PowerApps

When handling data collections, there may be times when you need to group by a specific field and determine the minimum value of each group. A classic example of this is tracking travel expenses. In this tutorial, we’ll dive deep into an illustrative case on how to achieve this using PowerApps. If at any point you feel stuck or require technical assistance, don’t hesitate to contact us.

Case Study: Travel Expenses

Consider a collection named travelExpensesSample which has recorded travel expenses for various items.

Date Item Value
1/1/2020 Hotel 1050
1/1/2020 Food 30
1/2/2020 Food 75
1/3/2020 Hotel 1300
1/3/2020 Food 50
1/4/2020 Flight 800

Our goal is to extract the minimum expense value for each item, resulting in a new collection named groupedExpensesSample.

Solution Code:

// Initializing the collection
    {Date: Date(2020,1,1), Item: "Hotel", Value: 1050},
    {Date: Date(2020,1,1), Item: "Food", Value: 30 },
    {Date: Date(2020,1,2), Item: "Food", Value: 75 },
    {Date: Date(2020,1,3), Item: "Hotel",Value: 1300},
    {Date: Date(2020,1,3), Item: "Food", Value: 50},
    {Date: Date(2020,1,4), Item: "Flight", Value: 800}

// Grouping by items and finding minimum value for each
        "Minimum Value", Min(AllItems,Value)

Reference: Collect, Clear, and ClearCollect functions

With the provided code, you can now efficiently group by any field and find the minimum value with ease. This method is extremely useful when summarizing large datasets and looking for patterns.


Grouping data and finding specific aggregate values, like the minimum, is an essential skill when managing databases or collections in PowerApps. The approach we’ve discussed here provides a clear roadmap to efficiently categorize and summarize your datasets. Remember, if you need any further clarification or assistance with PowerApps or any technical topic, feel free to reach out to us. Our team is always here to help, ensuring you get the most out of your projects.

About The Author