Power Platform Community Forum Thread Details

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

Categories:

General topics