Answered

Adding a ID column to a Collection

(0) Share

Report

Posted on by MicroMarc365

101

I would like to add a column with an ID number to a collection. I've tried the formula below, but it is not working for me.

ClearCollect(
 colSolution,
 ForAll(
 Sequence(CountRows(colVehicles)),
 Patch(
 Last(FirstN(colVehicles, Value)),
 {RowNumber: Value}
 )
 )
)

Can anyone advice me on what I should do?

Categories:

Building Power Apps

All responses (5)

Answers (2)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MicroMarc365 , Can you try this:

ClearCollect( colSolution, ForAll( Sequence(CountRows(colVehicles)) As var, Patch( Last(FirstN(colVehicles, var.Value)), {RowNumber: var.Value} ) ) )

EDITED:

If the above code didnt work then check below posts:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Auto-Increment-ID-on-Collect/td-p/1867260
https://powerusers.microsoft.com/t5/Building-Power-Apps/Adding-incremental-column-to-collection/td-p/314504

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@MicroMarc365 ,

Assuming colVehicles exists with the data you want, that should work (a small improvement below) - what result are you getting ?

ClearCollect( colSolution, ForAll( Sequence(CountRows(colVehicles)), Patch( Index( colVehicles, Value ), {RowNumber: Value} ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
MicroMarc365 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Do I need to replace "Value"?
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@MicroMarc365 ,

I have fixed the post - try now. You should have a new column called RowNo
MicroMarc365 101 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked! Thank you so much!
How can I add a number to each row that is created?
Example:
ID
Animal
1
Dog
2
Cat
3
Fish