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

I have the same question (0)

All responses (5)

Answers (2)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No
MicroMarc365 101 on at

Like (0)

Report

Do I need to replace "Value"?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@MicroMarc365 ,

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

Was this reply helpful? Yes No
MicroMarc365 101 on at

Like (0)

Report

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

Was this reply helpful? Yes No