cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vsslasd 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.

vsslasd 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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

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!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We're launching a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Emergency Response & Monitoring Solution

Emergency Response & Monitoring Solution

Microsoft has created a regional government emergency response and monitoring solution that is built on Power Apps and Power BI.

Top Solution Authors
Top Kudoed Authors
Users online (5,995)