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

[Syndicate_Admin]

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?

[Syndicate_Admin]

Thanks so much - that's it.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin 

You can set the business key as a alternate key in Power Apps first, you can refer to the followng link.

Define alternate keys using Power Apps - Power Apps | Microsoft Learn

Then connect the key in dataflow, you can refer to the follwing link.

https://learn.microsoft.com/en-us/power-query/dataflows/get-best-of-standard-dataflows#choosing-a-ke...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.