web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Group the collection b...

Power Apps

Answered

Group the collection based on 2 columns

(0) Share

Report

Report

Posted on by Sandy94

2

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation