I am building a flow to import data from an Excel table into a SharePoint list. When I import the row, I want to delete it so that we don't accidentally import something twice. The delete row function works reliably, but I have been finding that it slows the flow to a crawl. Without deleting the row, I can import over 200 items in less than 5 minutes. Adding in the delete row function makes it take over an hour. Has anyone else experienced this or found a way to make the delete row function run faster?
Solved! Go to Solution.
Hi @DDCJOEE ,
Could you please share a screenshot of the configuration of your flow?
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, I get this error message with a red banner when trying to upload a screenshot: "You do not have permission to upload images."
I can, however, describe my flow step by step. It's a short one.
In an earlier version of the flow, I did two Apply to Each functions, and found that the import could be done in minutes, but the delete took over an hour. Housing them each in one Apply to Each still keeps the overall execution time at over an hour.
I just now had to create a duplicate of this Flow for another similar process that we use. Everything about the flow is the same, except for the Excel Online doc and Sharepoint list. Interestingly, the copy of the Flow, which otherwise performs all the same steps is able to run and delete the row inside of the Apply to Each within minutes (i.e. is much faster). Wondering if maybe the issue lies in the Excel Online Doc somehow?
If you’re deleting all the rows you upload from something like a List rows action, then you could use a batch delete at the end of the flow for all those records.
Also you may be able to use batch create & batch update for SharePoint
Keep up to date with current events and community announcements in the Power Automate community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!