Power Platform Community Forum Thread Details

Dear,

My ERP system periodically exports JSON formatted files, which I want to load in my Dataverse table.
The files have a unique key on each row which I identified as unique.

However, when I load the JSON files periodically, the keys aren't recognized and the table creates many duplicates.
I hoped that existing records are recognized and updated instead of created again.

Any idea how to avoid the issue?

Thanks a lot,

Categories:

Microsoft Dataverse with Power Apps