Collection with GroupBy, AddColumn and LookUp Columns

(1) Share

Report

Posted on by JM-14081323-0

Hello

how can I use GroupBy with lookup columns in the table please?

I have a joint table OperaceVNKN with columns Operace and VNKN (Operace is lookup column where it takes column Nazev from table Operace, VNKN is lookup column Seznam in table VNKN)

Tried this:

ClearCollect(
groupOpe;
AddColumns(
GroupBy(
OperaceVNKN;
Operace;
VNKN
);
skupOperace;
CountIf(OperaceVNKN;true)
)
)

Can anyone see a problem? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Jon Unzueta 1,827 Super User 2025 Season 2 on at

Like (0)

Report

@JM-14081323-0

Thanks for sharing your formula and context! You're close, but there are a few things to clarify when using GroupBy with lookup columns in Power Apps.

Problem Breakdown

You're trying to group a collection (OperaceVNKN) by two lookup columns: Operace and VNKN. However, GroupBy in Power Apps works best with text or primitive values, not complex records like lookup fields (which are actually records with nested properties).

Solution Approach

To group by the display values of the lookup columns (e.g., Operace.Nazev and VNKN.Seznam), you need to extract those values first using AddColumns, then group by the new columns.

Suggested Formula

ClearCollect(

    groupOpe,

    AddColumns(

        GroupBy(

            AddColumns(

                OperaceVNKN,

                OperaceNazev, Operace.Nazev,

                VNKNSeznam, VNKN.Seznam

            ),

            "OperaceNazev",

            "VNKNSeznam"

        ),

        "skupOperace",

        CountRows(ThisRecord[@AllItems])

    )

)

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.

Was this reply helpful? Yes No
Suggested answer

Jon Unzueta 1,827 Super User 2025 Season 2 on at

Like (0)

Report

@JM-14081323-0

Thanks for sharing your formula and context! You're close, but there are a few things to clarify when using GroupBy with lookup columns in Power Apps.

Problem Breakdown

You're trying to group a collection (OperaceVNKN) by two lookup columns: Operace and VNKN. However, GroupBy in Power Apps works best with text or primitive values, not complex records like lookup fields (which are actually records with nested properties).

Solution Approach

To group by the display values of the lookup columns (e.g., Operace.Nazev and VNKN.Seznam), you need to extract those values first using AddColumns, then group by the new columns.

Suggested Formula

ClearCollect(

    groupOpe,

    AddColumns(

        GroupBy(

            AddColumns(

                OperaceVNKN,

                OperaceNazev, Operace.Nazev,

                VNKNSeznam, VNKN.Seznam

            ),

            "OperaceNazev",

            "VNKNSeznam"

        ),

        "skupOperace",

        CountRows(ThisRecord[@AllItems])

    )

)

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.

Was this reply helpful? Yes No