Showing results for 
Search instead for 
Did you mean: 
vsslasd Post Patron
Post Patron

Re: Performance with Patching to Azure

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



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.

vsslasd Post Patron
Post Patron

Re: Performance with Patching to Azure

Thank you, Paul.
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

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,407)