Start RowNumber at 1 instead of 0

(0) Share

Report

Posted on by aishak12

104

All,

I am creating a gallery with rows and it is starting at row 0. Is there another way for the rows to start at row 1.

The gallery is connected to my collection and my code for the row label is

ThisItem.rowNumber

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The gallery is just displaying the value of rowNumber for a record in your collection. I think you need to take a look at how that rowNumber value is being added to the collection.

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I'm not sure where the data is coming from for the rowNumber field. If you are trying to generate a row number in the collection this code will work:

ForAll (CollectionName, Collect(CollectionNumbered, Last(FirstN(AddColumns(CollectionName, "RowNumber", CountRows(CollectionNumbered)+1), CountRows(CollectionNumbered)+1 ) ) ) )

If all you need if for those numbers to start at 1 you could just set the property to

ThisItem.rowNumber +1

or if the data is text you could use

Value(ThisItem.rowNumber) +1

Obviously if you are using that to find a specific row you will need to subtract the 1 before the search

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aishak12 :

I'm not sure what's the meaning of 'start at row 1'.

If you want to skip the first row (row 0) of the collection,you could set the gallery's items property to:

Sort(Filter(YourCollection,rowNumber<>0),rowNumber)

If you want the rowNumber in the collection to start at 1, then you can update your collection with this formula.

UpdateIf(YourCollection,true,{rowNumber:rowNumber+1})

Best Regards,

Bof

Was this reply helpful? Yes No