Answered

How to make a ranked leaderboard?

(0) Share

Report

Posted on by skiingdave

I've got a Sharepoint list whose columns are Email, Display Name, and Points for each daily quiz people take. I'm trying to create a ranked leaderboard in a Gallery that shows a Ranking (1, 2, 3...), the display name, and total points.

So far, I can use the below code to add up each person's points and sort the resulting table, which I can display in the Gallery. I just want to add a Ranking column to show what place each person is in. I think I need to use CountRows and Sequence somehow, but I'm not sure exactly what I need.

SortByColumns(
 AddColumns(
 GroupBy('2024PrismaticaQuestionHistory', ParticipantEmail, ParticipantName, GroupedScores),
 'Total Points',
 Sum(GroupedScores, Points)
 ), 
 "Total Points",
 SortOrder.Descending
)

I'm still pretty new to PowerApps but what I'd like to do is assign the table returned by AddColumns to a variable and then operate on that, but I'm not sure how. Thanks for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

TuongDoan 573 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
First, collect you sorted table to a collection:

ClearCollect(RankedTable,SortByColumns( AddColumns( GroupBy('2024PrismaticaQuestionHistory', ParticipantEmail, ParticipantName, GroupedScores), 'Total Points', Sum(GroupedScores, Points) ), "Total Points", SortOrder.Descending ))

Then add indexes,

ForAll( RankedTable, Collect( Indexed, { id: CountRows(Indexed) + 1, Value: Value } ) );

Then put the table Indexed in Gallery's item property

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Was this reply helpful? Yes No
skiingdave 24 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, @TuongDoan . I understand how it's supposed to work (I think). I put all this in the screen's OnVisible handler. PowerApps complains that the second "Value" in the Value: Value line isn't valid (Name not recognized). I tried changing that to ThisRecord but that also doesn't seem to work.

I also did
ForAll(
RankedScoreTable,
Collect(
Indexed,
{
id: CountRows(Indexed) + 1,
name: ThisRecord.ParticipantName,
totalpoints: ThisRecord.'Total Points'
}
)
);
But this resulted in a blank gallery. The gallery's Items is set to Indexed.

Was this reply helpful? Yes No
skiingdave 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Wait! I just needed to refresh the page so the OnVisible would fire.

Was this reply helpful? Yes No