I’ve long being using Update action of the Dataverse connector to do “upserts”, and it just turned out there are, now (have been for a while?), two separate actions:
Update a row
Upsert a row
Behind the scenes “Upsert a row” is the old good “UpdateRecord” action. And “Update a row” is a new “UpdateOnlyRecord” action. Which is great, btw, since this means this is all backward compatible
But, of course, moving forward we need to remember to choose “Upsert” rather than “Update” in such cases, since “Update” action will fail if the record being updated does not exist yet.
