Power Apps Generate Row Numbers In A Collection

Generate row numbers for a Power Apps collection with this formula. Copy and paste this code into your own app.

// Generate row number code
ClearCollect(
    colSolution,
    ForAll(
        Sequence(CountRows(colMyCollection)),
        Patch(
            Last(FirstN(colMyCollection, Value)),
            {RowNumber: Value}
        )
    )
)

Here’s how it works:

The ForAll function returns a table of values with the row number included. First, we use the the CountRows function to determine how many rows are in the original collection and the Sequence function to generate the row number. Then we Patch the row numbers into the original collection and show them in a new column named RowNumber.

For more help with collections check out my Power Apps Collections Cookbook. There are over 50 examples and code you can copy + paste into your own apps.

Full Example: Generate Row Numbers

Input Collection

Start with this Power Apps collection named colVehicles.

Output Collection

Our goal is to add the row numbers from the Power Apps collection colVehicles and achieve this result.

Solution Code

Use this code to remove the duplicate rows from colVehicles.

//Create a collection
ClearCollect(colVehicles,
    {Year: 2016, Make: "GM", Model: "Yukon"},
    {Year: 2016, Make: "GM", Model: "Yukon"},
    {Year: 2016, Make: "GM", Model: "Yukon"},
    {Year: 2017, Make: "Nissan", Model: "Frontier"},
    {Year: 2018, Make: "Chevy", Model: "Silverado" },
    {Year: 2019, Make: "Honda", Model: "Ridgeline"},
    {Year: 2020, Make: "Ford", Model: "F150"},
    {Year: 2020, Make: "Ford", Model: "F150"},
    {Year: 2020, Make: "Ford", Model: "F150"},
    {Year: 2020, Make: "Ford", Model: "F150"}
);

// Generate row number code
ClearCollect(
    colSolution,
    ForAll(
        Sequence(CountRows(colVehicles)),
        Patch(
            Last(FirstN(colVehicles, Value)),
            {RowNumber: Value}
        )
    )
)

Questions?

If you have any questions about Power Apps Generate Row Numbers In A Collection please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.