Hi
I have the following Dataverse tables
1) Cases
2) Case categories
3) Reference categories
We have a requirement to create about 150 records in "Case Categories" when a new Case is created i.e. linking a case to "Reference Categories" based on the fields in the new Case. ("Case categories" has additional fields as well that can be later edited by the user)
We are currently using Power Automate flow to do this triggering the flow on saving flow (later needs to be modified to trigger the flow on the update of the case as well). This is working functionally fine but takes more than 10 minutes as "Case Categories" records are being created in the loop one at a time. (nb: there is some additional complexity that is not mentioned but the key issue is that records are being created in the loop one by one.)
Is there any way (e.g. similar to PATCH function) to create and update records in the Dataverse in the bulk. (nb: Looking for something equivalent to SQL update/insert with appropriate from clause joins which takes just milliseconds for similar outcome)
Thanks
Hi @surgulati
To make apply to each loop faster, enable concurrency control option in apply to each loop settings
Here apply to each loop can loop 50 items parallely at same time at max.
Hope this helps 🙂
Mark it as solution if it resolves your query