cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vsslasd
Level 8

Re: Performance with Patching to Azure

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

 

@v-monli-msft 
@PaulD1 

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
Level 8

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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,024)