Group the collection based on 2 columns

(0) Share

Report

Posted on by Sandy94

Hi,

In Custom Page, I have created a collection in below format:

I want to group this collection with column "Group" (lookup) and then with column "Grp Type" (choice). If Grp Type column is blank, grouping can be done with Group column alone.

I am supposed to display the table in below format after grouping:

Since I am new to custom page, facing bit difficulty in building the logic in PowerFx.

Looking for help in this!!

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report
Hi,
It is possible to achieve what you want but it is not performatic (if you have a big collection it may brake your app), I would suggest you to group your collection twice, like this:
GroupBy( GroupBy( AddColumns( ColName, // your collection "GroupText", Group.Value ), "GroupText", 'Grp Type', "Group1" ), "GroupText", "Group2" )
But if you really need it, reply this message and I will help you 🙂

Was this reply helpful? Yes No