Forum Discussion
Power Platform Dataflow Upsert Error
For anyone else running into this issue, I concatenated the 13 fields in my source query and created a new column in my target Dataverse table called "Merge_Key". Then instead of creating the key on 13 columns I created it on this 1 new column and the merge operation worked. I don't understand why, but seems to be working now.
For anyone else running into this issue, I concatenated the 13 fields in my source query and created a new column in my target Dataverse table called "Merge_Key". Then instead of creating the key on 13 columns I created it on this 1 new column and the merge operation worked. I don't understand why, but seems to be working now.
Hi scottexe24
Check the following article, it might be helpful.
Field mapping considerations for standard dataflows - Power Query | Microsoft Learn
According to my understanding on the article, using a combination of fields as an Alternate Key for Upsert operation was supposed to work.
Best Regards,
Jing