Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Updating/creating multiple records in the dataverse

(0) ShareShare
ReportReport
Posted on by

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

 

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,039 on at
    Re: Updating/creating multiple records in the dataverse

    Hi @surgulati 

     

    To make apply to each loop faster, enable concurrency control option in apply to each loop settings 

    Nived_Nambiar_0-1681700405586.png

     

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard