Delete row in excel table running slowly

[DDCJOEE]

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?

[v-alzhan-msft]

Hi @DDCJOEE ,

Could you please share a screenshot of the configuration of your flow?

Best regards,

Alice       

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.

[DDCJOEE]

Hello,

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.

• The flow is triggered in the Excel Online Doc with the For a Selected Row.
• List Rows Present in a Table to capture how many items to import.
• Apply to Each using the Value from List Rows Present in a Table
  • Create Item with fields from the spreadsheet.
  • Delete a Row using a Key Column named "Order Number" with the Key Value being the Order Number for that specific row.

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.

[DDCJOEE]

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?

[Jcook · Accepted solution]

In the loop turn on parallelism to a bigger number. This can be done within the settings (three dots) of the loop.

Note that depending on your license this may fail due to too many requests

-Josh

[DDCJOEE]

That worked like a charm, thank you! 

[takolota]

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.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Delete/td-p/1634375

Also you may be able to use batch create & batch update for SharePoint 

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-Extern...