Number the rows of a Gallery

(0) Share

Report

Posted on by Tomasteixeira

Sort(

AddColumns(

GroupBy(

'Certifications',Title,Email,UsersGroupedByEmail

Points,

Sum(UsersGroupedByEmail,If('Level'.Value="Max",100,0)

Points,SortOrder.Descending

)

Here's what I have as the "Items" for my Gallery. This works perfectly and they're displayed in rows. However, now I would like it to add a column after the sort that numbers the rows from 1 to N. I've tried various solutions online but none of them seem to work for my situation. Any help is appreciated!

Edit: I don't necessarily WANT an extra column. For example, if there's a way to simply toggle "display row number" or something like that in galleries, then thats fine too

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Tomasteixeira - you can use the Index function. E.g.:

With( { _data: Sort( AddColumns( GroupBy( 'Certifications', Title, Email, UsersGroupedByEmail ), Points, Sum( UsersGroupedByEmail, If( 'Level'.Value = "Max", 100, 0 ) ) ), Points, SortOrder.Descending ) }, ForAll( Sequence( CountRows(_data), 1, 1 ), Patch( {RowNo: Value}, Index( _data, Value ) ) ) )

Was this reply helpful? Yes No