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

Re: Performance with Patching to Azure

And does not Collect(SQLTable, Collection) only insert rows rather than update ?

 

@v-monli-msft 
@PaulD1 

Highlighted
Super User
Super User

Re: Performance with Patching to Azure

 Hi @vsslasd 

 

Yes, the collect method is used for adding multiple new records in one step.

 

Have you looked into the UpdateIf function?

 

Note that perform any record operations on a SQL table it must have a primary key defined, or PowerApps will treat it as Read-Only.

Highlighted
Post Patron
Post Patron

Re: Performance with Patching to Azure

Thank you, Paul.
Interesting.
We have been using Patch, and didn't know you could use the UpdateIf for a SQL Table.

So, if we can understand how to integrate a sample Collection into the UpdateIf statement to a SQLTable and understand if ForAll is appropriate (or not), we should be set to move forward !

Your input is much appreciated. There isn't any documentation which describes the various methods and the pros and cons of each... which would be a great topic for an article someone could publish!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

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

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

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 (11,030)