Hello Community,
i have a dataflow thatis checking a datasource for new data in comparsion with a dataverse table.
The dataverse table has the UID "tablenameID" and a primary key "error_id".
While loading the flow into the dataverse, i would like to
- update the existing data in the table (i.e. error_status = fixed)
- create new data in the table (i.e. error_status = open)
I can choose a primary key in the loading screen and select the existing UID "tablenameID" as a primary key.
All existing data has a primary key, the update works fine.
The problem is the new data, which has a primary key value of "null" and therefore the flow crashes with the error:
{"message":"Invalid type for entity id value","cdsErrorCode":"0x80040203","HelpLink":"http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80040203&client=platform","InnerErrorMessage":"Invalid type for entity id value","
I can not load the results in two queries (update existing data, add new data) because both of them would address the same table.
Is there a trick how to get the job done that im overlooking ?
Greetings,
Seb
