How can I create row numbers in a collection?

[pwrappr01]

I have a collection I am creating from a SharePoint list. I would like to add row numbers to it so I can reference each item in the collection individually. Any ideas?

[mdevaney · Accepted solution]

@pwrappr1
Every SharePoint list includes an ID field by default. It is a unique row number you can reference individually. Does that work for you?

If you want to make a new column with a unique row number I suggest you check out this blog post by forum user Tim Leung: http://powerappsguide.com/blog/post/generating-row-numbers

Note: you may have to unhide the column to see it in your SharePoint List webpage but PowerApps will already be pulling this field in.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[datamaster]

Hi @pwrappr01  I have a blog post on https://officepoweruser.com/how-to-make-a-gallery-control-automatically-scroll-in-powerapps/ that creates a row number. I think this will help you!

------------------------------------------------------------------------------OfficePowerUser.com------------------------------------------------------------------------ 
If this post helps answer your question, please click on “Accept as Solution” to help other members. If you thought this post was helpful, please give it a Thumbs Up. 

[pwrappr01]

@mdevaney  and @datamaster , thank you both for responding. What worked for me was the link @mdevaney provided. Really helpful.

[animeking]

This is a great solution, but how can you sort the new collection? I tried using the Sort(Gallery1, Points, Descending), but it's not working. I'm trying to make this work for our leaderboard solution. I hope someone can revisit this and help me out. Thank you!