Leaderboard with Difference

(1) Share

Report

Posted on by PowerDigitize_1

Hi all,

I am trying to create a fitness app with leaderboard which displays name and amount of weight lost in KG.

Data is recorded in one SharePoint list. So, we have current weight of all those registered. When we again add their new weight (which will be done 4 times throughout the challenge) it should calculate difference of initial weight and the latest weight recorded.

My current table has below columns:

-name

-email

-weight in KG

-Created Date and Time (SharePoint generated column)

Name	Email	weight in KG	Created Date and Time
Abc	Abc@abc.com	45	12/1/2023 3:45 PM
Xyz	Xyz@xyz.com	50	11/1/2023 1:20 PM
Abc	Abc@abc.com	43	5/2/2023 4:00 PM

Leaderboard should show Abc on top with 2 KGs lost followed by others. As initial weight of Abc was 45 kg and then in Feb it was 43 Kg.

Can you pls advise. Thanks!

@WarrenBelz

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @PowerDigitize_1 ,

You will need to add your actual field names here

Sort( AddColumns( GroupBy( Sort( SPListName, Created, Descending ), "Name", "Data" ), "Email", First(Data).Email, "Weight", First(Data).Weight, "DateTime", First(Data).Created, "Lost", Index( Data, 2 ).Weight - First(Data).Weight ), Lost, 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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
PowerDigitize_1 80 on at

Like (1)

Report

Thanks @WarrenBelz, it worked!!! Your solutions are always helpful in one go!!
Highly appreciate it! 😀

Was this reply helpful? Yes No
PowerDigitize_1 80 on at

Like (1)

Report

@WarrenBelz - Just one more question...how can I assign row numbers as well? For ranking?

Was this reply helpful? Yes No
CU11091259-0 6 on at

Like (1)

Report

I had a similar challenge when I was trying to set up a leaderboard for a fitness app. What worked for me was creating a column to track the weight difference between the starting weight and the most recent one.

Was this reply helpful? Yes No