web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding a column of seq...

Power Apps

Unanswered

Adding a column of sequences

(0) Share

Report

Report

Posted on by russrimm1

85

Hi all,

I have a collection "colData" with a single column of values.

For each row in colData, I want to add a column called "Year" that starts with 2000.

So colData looks like this:

Value

123

456

I want my final collection to look like this (ultimately it'll increment up to the current year).

Year Value

2000 123

2001 456

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @russrimm1 , You can use the function AddColumns in collection
AddColumns(colData, "Year" ,Sequence( Year(Now()) + 1 - 2000, 2000, 1 ))

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

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
russrimm1 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @ANB, I apologize but when I add this to my collection using:

ClearCollect(coltest2,AddColumns(collData, "Year" ,Sequence(
Year(Now()) + 1 - 2000,
2000,
1
)))

I end up with each of my Values in the first column, but a table containing all of the years in the 2nd column.

Was this reply helpful? Yes No

Join the conversation