web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

ForAll Patch

(0) ShareShare
ReportReport
Posted on by 2

Hi. 

 

I'm trying to create new rows in Table 2 when I press a button, based on the number of rows in Table 1. 

 

So if there is 20 rows in Table 1 it will create 20 rows in Table2 with Table2.ID = Table1.ID

 

I have the following code attached to OnSelect on my button. but It doesn't work. Any idea where I'm wrong? 

 

I am using dataverse for my data. 

 

 

 

ClearCollect(colLokationIds;table1);;

ClearCollect(colLokationIds; ShowColumns(table1; "cr677_nykolonne"))
ForAll(
 colLokationIds,
 Patch(
 table2,
 Defaults(table2),
 {LokationId: LokationId}
 )
);

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,923 Most Valuable Professional on at

    In the forall you need to reference the record to access the value.  Something like this

    ClearCollect(colLokationIds;table1);;
    
    ClearCollect(colLokationIds; ShowColumns(table1; "cr677_nykolonne"))
    ForAll(
     colLokationIds,
     Patch(
     table2,
     Defaults(table2),
     {LokationId: thisRecord.LokationId}
     )
    );

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard