Question

A cloud flow is triggered when a Dataverse 'Order' row is created. The flow updates a shared 'Daily Totals' row by reading its current value, adding the order amount, and writing the result back. During peak hours, hundreds of orders are created within seconds, and users report that the daily total is frequently lower than expected because concurrent flow runs overwrite each other's updates. You must ensure updates are applied accurately without dropping any order amounts. What should you configure?

Accepted Answer

Enable concurrency control on the trigger and set the degree of parallelism to 1 so runs process sequentially.

Answer

Increase the trigger's concurrency control degree of parallelism to the maximum of 50 to process more runs at once.

Answer

Add a retry policy with exponential backoff to the Dataverse update action.

Answer

Move the read-add-write logic into a child flow and call it with 'Run only when a new item is added'.