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!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.