![]() 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 |