cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Patch a collection - ForAll()? Any other way?

I am still learning and I want to verify one of my standard practices I have built into apps. If I have a collection of records and I want to Patch all those records (maybe not all columns) into a SQL table is there any way other than a 

ForAll(Collection,
 Patch(SQLTable)
)

to do it? There isn't something I am missing that is like patch this whole collection into an sql table right?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Patch a collection - ForAll()? Any other way?

@BrianHFASPS 

That's pretty much the method to use.  There's not a lot of ways you can go around it as far as automatically combining the two.

You might take a look over this article on bulk updates, but, everything pretty much boils down to ForAll.

 

I hope that helps shed some light for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Patch a collection - ForAll()? Any other way?

@BrianHFASPS 

That's pretty much the method to use.  There's not a lot of ways you can go around it as far as automatically combining the two.

You might take a look over this article on bulk updates, but, everything pretty much boils down to ForAll.

 

I hope that helps shed some light for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,693)