And does not Collect(SQLTable, Collection) only insert rows rather than update ?
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.
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!
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!