Gallery GroupBy

(1) Share

Report

Posted on by RJF61

1,231

I have the following for the Items of a gallery...

With(
    {
        _Data:
        Filter(
            ShortFormII_ACstData,
            Order = DataCardValue35.Text
        )
    },
    Filter(
        _Data,
        Value(Text('CostElement')) >= 800000
    )
)
 
Is it possible to GroupBy this information?

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

WarrenBelz 151,271 Most Valuable Professional on at

Like (0)

Report
Gallery GroupBy

Hi @RJF61,

Just add it the bottom part - you are already "local" with the output of _Data, so there are no Delegation restrictions after that.
With( { _Data: Filter( ShortFormII_ACstData, Order = DataCardValue35.Text ) }, GroupBy( Filter( _Data, Value(Text('CostElement')) >= 800000 ), GroupedColumnName, Grouped ) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
RJF61 1,231 on at

Like (0)

Report

Gallery GroupBy

Hi @WarrenBelz Thanks for the response. Believe I was making this too difficult.

Do I need to use AddColumns/ShowColumns to display and then subtotal on the cost in the right column? Essentially I want the GroupBy column with a subtotal and a "nested gallery" of the individual items below...

Shops Sheet Metal $ 1,594.58

AZones IAQ Tech $####

AZones Electrical $####

Was this reply helpful? Yes No
WarrenBelz 151,271 Most Valuable Professional on at

Like (0)

Report
Gallery GroupBy

Hi @RJF61,

Using your grouped field name and assuming that CostElement is the numeric field to be totalled, your Parent gallery Items would be
With( { _Data: Filter( ShortFormII_ACstData, Order = DataCardValue35.Text ) }, AddColumns( GroupBy( Filter( _Data, Value(Text('CostElement')) >= 800000 ), YourGroupedField, Grouped ), Sum( Grouped, CostElement ) ) )

and your Child gallery Items would be
ThisItem.Grouped

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No