cancel
Showing results for 
Search instead for 
Did you mean: 

New Function : Index - to index a table with a sequential number

It would be GREAT to have a function such as Index that would index a table and return a Table with an added column containing a sequential number based on the order of the Rows in the table.

 

Example:  Index(tableName, "indexColumn")   would return a table of the tableName table with an added column containing the sequential number of the row in the order of the table.

 

Why this Idea?  Because there are a lot of Ideas on the forum that revolve around this in some way - "collection with an index", "index for a gallery row", etc.   While it would be nice to have those individually, a quicker way to get there would be to provide an Index function that could be used for all of them.

 

The Function would be equivalent to the following (based on the mentioned syntax above):

 

ForAll(
    Sequence(CountRows(tableName)),
        Patch(Last(FirstN(tableName, Value)), {indexColumn: Value})
    )
)

 

Which is perfect at indexing a table...

But this would be MUCH more convenient as a Function in PowerApps.

 

I would not expect this to be delegable...just convenient!

Status: New