cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

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
Advocate V
Advocate V

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,275)