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 

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
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.

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!

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