Select primary key of an existing table as the key for a dataflow

(0) Share

Report

Posted on by northwood

When I create a Dataflow to load a Dataverse table:

If I select "Load to new table", it lets me select my key from the source columns, and it generates that column as the unique key with the appropriate data type (i.e. Single line of text in my case). That works fine if I want to create a new table. It will insert/update/delete based on the value of the business key.
But if I already have a table, so I select "Load to existing table," the only option it offers for me to select as a key is the system column with a type of Unique Identifier. This is completely useless as a business key for insert/update/delete.

Is there a solution to allow me to use the business key of an existing table as the key for a dataflow?

Categories: