Add sequence number column in Collection in power app

[Lalit_Kadam]

Hi,

I want to add sequence number column in collection. I am using Sequence function but it is creating all sequence  number in each row.

I want out put like below.

Collection :-

Brand name, Brand description, Brand value

Br1,   Description, 1200

I need extra column 

Sequence number , Brand name, Brand description, Brand value

1,    Br1,   Description, 1200

2,    Br2,   Description, 1400

3,    Br3,   Description, 1500

Please suggest.

Regards,

Lalit Kadam

[Adrian_Celis]

Hi @Lalit_Kadam 

Let's say your original data is a collection named OriginalCollection. Try this:

//Clear the collection first
Clear(CollectionWithSequenceNumbers);
//For each item in the original collection, add a sequence number
ForAll(OriginalCollection,
    Collect(CollectionWithSequenceNumbers,
        Last(FirstN(AddColumns(OriginalCollection,"Sequence Number",CountRows(CollectionWithSequenceNumbers)+1),CountRows(CollectionWithSequenceNumbers)+1)))
);