Power Apps Dataflows needs to support upsert (insert and/or update). Currently Dataflows only supports insert/create and delete operations (if enabled). This means that every time a Dataflow is ran will insert duplicate records. If an alternate key is defined then those records will fail during the run because of duplicate key. If delete records is enabled, then all records will be deleted and created per run. There are several keys issues with this: Upon delete, all history and auditing history are lost Harder to determine records that changed after a Dataflow run. Modified On will always be the Created On Unnecessary triggers (i.e. plugins, flows, workflows, etc) could be invoked upon create and/or delete Performance: additional redundant delete and create transactions are executed when nothing changed
... View more