Hi
Anyone know how to create an auto-increment ID column for collection. I attach the screenshot of collection.

Hi
Anyone know how to create an auto-increment ID column for collection. I attach the screenshot of collection.
Hi @Leo_yz,
Yes, auto-incremented IDs can be applied using code similar to the following:
ClearCollect(
colAnimals,
{Name: "Lion"},
{Name: "Tiger"},
{Name: "Bear"}
);
ClearCollect(
colAnimalsWithNumbering,
ForAll(
Sequence(CountRows(colAnimals)),
Patch(
Index(
colAnimals,
Value
),
{RowNumber: Value}
)
)
)If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.