web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Where can I find the '...
Power Apps
Unanswered

Where can I find the 'optimized APIs for bulk data operations' documents?

(0) ShareShare
ReportReport
Posted on by

I have seen it in wave2 document: https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/data-platform/use-optimized-apis-bulk-data-operations?source=recommendations

 

We are very eager to use this feature to improve performance when some business logic need to do bulk update/insert.

 

I saw in October it should became public preview, but I can't find it anywhere. Can somebody help? Thanks in advance.

I have the same question (0)
  • cchannon Profile Picture
    4,702 Moderator on at

    AFAIK this still isn't properly documented. The only documented message is the ExecuteMultiple: https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/xrm-webapi/online

     

  • camer314 Profile Picture
    173 on at

    if its now end of November and this feature has sunk without a trace from the roadmap?

     

    Wayback machine has archive of original page but now that page no longer exists. I fear that the functionality has been pulled or delayed indefinitely.

  • cchannon Profile Picture
    4,702 Moderator on at

    Wave 1 '23 plan should come out in Jan. 🤷‍♂️

  • camer314 Profile Picture
    173 on at

    This is a weird one because bulk update is literally the same message and mechanics as single update except with an array payload instead of record. You would think this would have been standard functionality 3 years ago. Unfortunately for me, this is the exact functionality, or lack of, that is impacting our use of the platform in a big way.

  • cchannon Profile Picture
    4,702 Moderator on at

    OK, well if all you are looking for is to send an array of transactions in one message, I think you should take another look at executeMultiple. There are limitations, to be sure, but this does let you do exactly as you've suggested: throw a whole stack of transactions at the db all in one actual request.

     

    There's also a walkthrough code sample that shows exactly how to use it.

  • camer314 Profile Picture
    173 on at

    Thanks @cchannon,

     

    I was hoping to get support directly in a PCF control, as part of a canvas app, which executeMultiple does not support. But yes, I could, at a stretch, have a server side implementation using the .NET SDK as per your link and my PCF communicates with that

  • cchannon Profile Picture
    4,702 Moderator on at

    Ah, OK. I missed that you were trying to do this from a PCF in canvas app. Yeah, that does add a fair bit of complexity.

     

    But, it is worth noting that the webAPI object is not supported in PCFs in canvas apps, not the webAPI itself. So, it would still be considered a supported approach to have your own MSAL get token silent, then call the webAPI directly by REST message. Not the easiest thing to put together, but at least it wouldn't require an extra server-side component.

  • Community Power Platform Member Profile Picture
    on at

    executeMultiple is not supported in plugin, any request in plugin have to executed one by one. That's the pain point while the document in topic said the new api could be used in plugin.

    I understand the idea of Microsoft trying to make any complex logic should not happened in plugin, but in real world it is inevitable that have to implement some critical business logics in plugin, than it become a performance issue when the logic need to have bulk update/insert.

  • camer314 Profile Picture
    173 on at

    Thanks @cchannon. Yes that is another solution, although it is likely we will have server side components anyway, but this may be a neater approach given the necessity to double hop if we do use an api.

  • Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at

    plugins have a timeout of 2 minutes, let's say you need to create100 records from the plugin, you can't know if they will be created under 2 minutes or not (for example these records can have sync plugins registered too), an executeMultiple also if works as expected probably will not solve this kind of issues. Plugins are meant for short transactions, working on records that require a "multiple" message usually is not.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard