web

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

News and Announcements icon

Power Platform CommunityForums Power Apps best way to generate a...

Power Apps

Answered

best way to generate a leaderboard

(0) Share

Report

Report

Posted on by Antonioclk

Hi i have a sharepoint list with this format

Title	User	Score
Match	spiderman	10
Match	batman	15
Match	batman	8
Match	spiderman	7
Match	thor	1
Match	batman	8
Match	thor	7
Match	thor	2
Match	thor	2

i want to create a leaderboard showing something like

1) batman - 31 with 3 entries

2) spiderman - 17 with 2 entries

3) thor - 12 with 4 entries

how can i put that in a table? what's the code to get the number of entries and the total score for each user?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @Antonioclk ,

Try

AddColumns( GroupBy( SPList, "User", "Data" ), "TotalScore", Sum( Data, Score ), "Entries", CountRows(Data) )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation