Answered

Sorting Groups of items in a Gallery

(1) Share

Report

Posted on by RathwynAE

I have a gallery that I would like to sort by 2 dimensions, but I want to sort both groups of items and within the groups. The app is to help run a meeting where teams present updates on their assigned items, so I need the items grouped by the team so that they are presenting at the same time. However, the order the teams should go in to present their updates in should be determined by the oldest item on the list, and then the order the team themselves should go in when presenting their items is by priority.

After researching not seeing anything that would do what I want (might be out there but I can't figure out a good search phrase for what I'm trying to do), my next thought was to add a column that would assign the date of the oldest item within a group to all items in that group so that SortByColumns would automatically keep the teams together, but I can't figure out how to do that either.

Here's some example data unsorted:

Item	Priority	Team	Age
ITEM10005	1	Team C	100 days
ITEM10021	2	Team A	44 days
ITEM10002	3	Team C	3 days
ITEM10035	4	Team E	135 days
ITEM10013	2	Team E	10 days
ITEM10014	1	Team M	23 days

This is how I'd like the data to be sorted in the gallery:

Item	Priority	Team	Age
ITEM10013	2	Team E	10 days
ITEM10035	4	Team E	135 days
ITEM10005	1	Team C	100 days
ITEM10002	3	Team C	3 days
ITEM10021	2	Team A	44 days
ITEM10014	1	Team M	23 days

Team E has the oldest item on the list, so Team E presents first. Of the two items assigned to Team E, the first on the list is the higher priority one even though that's not the oldest. Team C has the next oldest item assigned to them, so they are second, even though they also have the newest item. Of the two items assigned to Team C, the higher priority one is first. Teams A and M have one each, so these are in order from oldest to newest.

Anyone have any idea how to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi RathwynAE,

Try this in the gallery Items
With( { _Data1: AddColumns( DataSource, _Age, Value( First( Split( Age, " " ) ).Value ) ) }, With( { _Data2: AddColumns( GroupBy( _Data1, Team, Grouped ), _Max, Max( Grouped, _Age ) ) }, SortByColumns( AddColumns( _Data1, AgeSort, LookUp( _Data2 As _Data, _Data.Team = Team )._Max ), "AgeSort", SortOrder.Descending, "Priority", SortOrder.Ascending ) ) )

Please click 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 giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
RathwynAE 56 on at

Like (0)

Report

So this worked but it broke basically everything else in my app... suddenly my OnClick setting of the record in the gallery to a variable isn't working, my patch function throws an error, etc. It's acting like I created a collection? Do I have to add lookups to all these functions to return the correct record? How will that impact performance?

Was this reply helpful? Yes No