How to rank rows?

(1) Share

Report

Posted on by CU21082154-0

But How would you write an expression that ranks rows based on their DateTime column in a Power Apps canvas app?

I'm looking to display a rank for each row for a group of bike racers.

The 'Finishing Position' is not in the Dataverse table so it will need to be added as a collection variable.

Any suggestions on how to approach this?

I tried:

CountRows(
Filter(
colSortedResults,
Not(IsBlank('Finish Time')) &&
'Finish Time' < ThisRecord.'Finish Time'
)
) + 1

But this returned all riders with a '1' as their 'Finishing Position'.

I also tried:

If(
IsBlank(nt_finish_time),
Blank(),
CountRows(
Filter(
colSortedResults,
Not(IsBlank(nt_finish_time)) &&
nt_finish_time <= ThisRecord.nt_finish_time
)
)
)

But this returned all riders with a '3' as their Finishing Position'.

What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Nandit 1,568 Moderator on at

Like (1)

Report
Hi CU21082154-0,

Can't we just sort the records by Finish Time and add an index to it, starting from 1 - count of records?

Here's a code that I have added to a button to first sort the data in Ascending, save it in a collection, and then add a Rank to it -

ClearCollect( colRanks, AddColumns( SortByColumns( Results, 'Finish Time', SortOrder.Ascending ), Rank, 0 ) ); ClearCollect( colRanks, ForAll( Sequence(CountRows(colRanks)), Patch( Last( FirstN( colRanks, Value ) ), {Rank: Value} ) ) )

Here's a screenshot:

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No