Power Platform Community Forum Thread Details

I'm trying to sync a json variable with dataverse each 5 seconds with 100 records. I have a custom dataverse table and the json does not contain een guid as a key, but the key is a text-value.

A alternate key is available on the custom dataverse table.

Because of the performance I would like to use the power automate Upsert command. The row-id seems only to accept guid values. Alternative row-ids give a 404 error.

I tried the classic list command with conditional insert or update, but this causes too low performance.

How can I manage the frequent upsert with ~100 records each 5 seconds only using power apps/power automate with a good performance?

Categories:

Building flows