![]() The primary reason is the size of the payload that it returns from SharePoint. The “Get Items” from SharePoint in Power Automate is very slow. Why is the SharePoint Get Items action so slow? But it does make the flow more complicated.Ĭombine SharePoint API & Flow Parallel branches for Performance Finally, using parallel execution to retrieve chunks of SharePoint list data simultaneously increases speed further.Use the REST API in Flow to get over 5000 items from SharePoint It is almost the same as using “Get Items”, but drastically faster. If the performance gained from the “Select” action still does not meet your requirements, switch to using the SharePoint API.If you are already using the “Get Items” method but need it to be a bit faster, enhance the speed of it by adding the “Select” action.Get more than 5000 items from SharePoint with Power Automate If your flow is not time sensitive, just use the standard “Get Items” action with a “Do Until” Loop in Power Automate.Here are some suggestions on what method may work best for you: The right method to use, depends on your circumstances. The fundamental principal behind each method is a “Do until” loop which collects the entire contents of a SharePoint list into an array. The table shows the results from six variations on three different themes. Retreiving same data with SharePoint API and four parralel queries Retreiving same data with SharePoint API and two parralel queries Here is how long it took Power Automate to execute the flow with execute each method: Method It’s 7 columns wide, 17,000 rows of data. Links to my sample data and all the flows created are at the end of the post. Since I originally wrote this post, I have figured out a method that is even easier and faster! Check it out here. A good user experience is essential for application acceptance.Įventually, I was able to reduce the amount of time that the Flow takes to retrieve the items from 2 minutes down to 8 seconds! That’s 13 times faster! I used Power Automate to get the data but found the standard “Get Items” action to be too slow. My requirement is to return 17,000 SharePoint list items to a PowerApp. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |