Answered

Making a ranking system based on a Gallery

(0) Share

Report

Posted on by Juan2004

Hello, I'm trying to create a rank system based on a Gallery. I have an SP list with all the users. It has a Code column and a Score Colum.

I'm trying to display the users using a Gallery in ascending order. I already did this in my application but now I'm missing a number beside them so the user can see their position.

I would like to be able to display the number position depending on the user's score. (I accept changes on the SP if it is necessary.)

The gallery is already sorted. Now i just need to add the number by it's side depending on the position.

Thank You very much!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Juan2004

For yoursortedtable make the Items property of the gallery and add a label with text ThisItem.RowNumber:

Ungroup( ForAll( Sequence(CountRows(yoursortedtable)), { myRecord: Table( Last( FirstN( Yoursortedtable, Value ) ) ), RowNumber: Value } ), "myRecord" )

Was this reply helpful? Yes No
Juan2004 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your response. The solution that you gave me worked perfectly! But could you tell me how to arrange the gallery based on the score?

Now I have the Gallery with the numbers but it is not organized in descending order.

Thank you.
-Juan

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Juan2004

Sure,

Ungroup( ForAll( Sequence(CountRows(splist)), { myRecord: Table( Last( FirstN( Sort(splist, Score, Descending), Value ) ) ), RowNumber: Value } ), "myRecord" )

Was this reply helpful? Yes No