#PowerPlatformTip 93: ‘Add RowNumbers’

TL;DR: Add dynamic row numbers to any Power Apps gallery with a With/ForAll/Sequence formula that indexes each record in-app, no delegation issues.

💡 Challenge

Incorporating a row number feature in PowerApps galleries and other elements can significantly enhance user interaction and data management. However, understanding how and where this operation is executed is vital.

✅ Solution

Implement a row numbering system within your app to provide real-time, dynamically updated row numbers for each item in your data sets.

🔧 How It’s Done

Use the following formula (thanks to Matthew Devaney) to add a row number to each record:

With({locLoadedData: YOUR DATA},
    Ungroup(
        ForAll(
            Sequence(CountRows(locLoadedData)),
            {myRecord: Table(Index(locLoadedData, Value)), RowNumber: Value}
        ),
        "myRecord"
    )
)

Replace YOUR DATA with your specific formula. This operation is executed within the app, ensuring it’s regenerated with each app load or data refresh.

🎉 Result

Every time your app loads or the data is refreshed, each item in your gallery or data set will have an accurate and updated row number.

🌟 Key Advantages

🔸 Enhanced user experience with clear data referencing.
🔸 Real-time, in-app data processing for up-to-date row numbering.
🔸 No external processing or storage required.
🔸 Delegation concerns are mitigated as the process is internal, making it suitable for large datasets.

🎥 Video Tutorial

🛠️ FAQ

1. Can I apply this technique to any data source in PowerApps?

Yes. As long as you can load your data into a local variable or collection, you can use the With({locLoadedData: …}) approach and generate dynamic row numbers.

2. How can I adjust the starting value of the row numbers?

You can customize the Sequence function by adding start or step parameters, or simply add/subtract an offset to Value in the record formula.

3. Will this method update row numbers automatically on data refresh?

Yes. Since the row numbering logic is part of your app’s formula, it recalculates whenever the app loads or the data source is refreshed, ensuring accurate numbering.