Unanswered

How to rank summed gallery items, help appreciated

(0) Share

Report

Posted on by Jake_Daniels_9

Hello, I'm trying to create a leaderboard whereby the scores are grouped by team name (TeamAliasText) and summed by points. I am able to get the gallery to group and sum. But I cannot get the ranking to work 😞

This is what I have under items for the gallery,

SortByColumns(
AddColumns(
GroupBy('Game Scores',"TeamAliasText","GroupedItems"),
"Sum of Value",Sum(GroupedItems,Points)

),
"Sum of Value",
SortOrder.Descending
)

Current result:

Hoping to have, ranking on the left

Ungroup(
ForAll(
Sequence(CountRows('Game Scores')),
{
myRecord: Table(
Last(
FirstN( Sort('Game Scores', Points, SortOrder.Descending),
Value
)
)
),
RowNumber: Value
}
),
"myRecord"
)

I can't seem to get both of these working together.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CarlosFigueira on at

Like (0)

Report
You can use something like the expression below. If you "save" the sorted expression that you have, you can use a ForAll with the sequence of indices, and use the Patch function to merge the RowNumber record with the record from the sorted list.

With( { sorted: SortByColumns( AddColumns( GroupBy( 'Game Scores', "TeamAliasText", "GroupedItems"), "Sum of Value", Sum(GroupedItems,Points) ), "Sum of Value", SortOrder.Descending ) }, ForAll( Sequence(CountRows(sorted)), Patch( { RowNumber: Value }, Index(sorted, Value) ) ) )

Hope this helps!

Was this reply helpful? Yes No
Jake_Daniels_9 35 on at

Like (0)

Report

I get you now thank you so much! It works and that makes sense. Appreciate your solution.

Was this reply helpful? Yes No