web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Adding rows iterative ...

Power Apps

Answered

Adding rows iterative rows to a table for each existing row

(0) Share

Report

Report

Posted on by nekinekic

20

If I have a table that has three columns as below

Category	User	Month
Red	Bob
Red	Tom

Is it possible to add 12 rows for each month in a year for each of the existing rows so that you get the below:

Category	User	Month
Red	Bob	1
Red	Bob	2
Red	Bob	3
...	...	...
Red	Bob	12
Red	Tom	1
Red	Tom	2
Red	Tom	3
...	...	...
Red	Tom	12

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

So you want the existing entry to be month 1 and then add 11 more rows for each one?

Was this reply helpful? Yes No
nekinekic 20 on at

Like (0)

Report
Copy link

Link copied!

yes exactly

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@nekinekic

The following formula will produce the results you are looking for:

Ungroup( ForAll(yourTableDataSource As _item, {item: ForAll(Sequence(12), Patch(_item, {Month:Value}))} ), "item" )

I hope this is helpful for you.

Was this reply helpful? Yes No
nekinekic 20 on at

Like (1)

Report
Copy link

Link copied!

This worked. Thank you so much!

Was this reply helpful? Yes No

Join the conversation