Answered

Leaderboard in PowerApps

(0) Share

Report

Posted on by BT168 Microsoft Employee

I am trying to make a leaderboard in PowerApps using a Gallery. The aim is to add up the values of all entries inputted by one user and rank them based on how many "Miles" they have logged.

So far, my gallery Items formula is:

Sort(GroupBy(MilesChallenge, "Title","Miles"), CountRows(Miles), SortOrder.Descending)

Based on watching this video: https://www.youtube.com/watch?v=q42ibovAqZc

*Miles Challenge is my data source

However, instead of CountRows, I want to use Sum.

Within the gallery, to add up all the Miles someone has logged I have the formula:

Sum(Filter(MilesChallenge,Title=ThisItem.Title),Miles) & " Miles"

However when I try to swap CountRows(Miles) with the above formula it doesn't seem to like that and no data is shown, just a delegation warning about it potentially not working for large data sets.

Can anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,327 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BT168 ,

Neither Sum nor GroupBy are Delegable.

Assuming Miles is the field name, you need

Sort( AddColumns( GroupBy( MilesChallenge, "Title", "OtherData" ), "TotalMiles", Sum( OtherData, Miles ) ), Title, Descending )

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.

Was this reply helpful? Yes No
BT168 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you that's worked! However when a new user adds an entry, they automatically get added to the bottom the leaderboard, regardless of if their score is the highest. Is there a formula I can put in to a refresh button on the leaderboard?

Was this reply helpful? Yes No
WarrenBelz 156,327 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BT168 ,

Refreshing the data source

Refresh(MilesChallenge)

probably should do the job - and change the filter to

Sort( AddColumns( GroupBy( MilesChallenge, "Title", "OtherData" ), "TotalMiles", Sum( OtherData, Miles ) ), TotalMiles, Descending )

Was this reply helpful? Yes No