Answered

Delete row in excel table running slowly

(0) Share

Report

Posted on by DDCJOEE

242

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?

I have the same question (0)

All responses (6)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Re: Delete row in excel table running slowly

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.

Was this reply helpful? Yes No
DDCJOEE 242 on at

Like (0)

Report
Re: Delete row in excel table running slowly

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.

Was this reply helpful? Yes No
DDCJOEE 242 on at

Like (0)

Report

Re: Delete row in excel table running slowly

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?

Was this reply helpful? Yes No
Verified answer

Jcook 7,779 Most Valuable Professional on at

Like (0)

Report

Re: Delete row in excel table running slowly

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

Was this reply helpful? Yes No
DDCJOEE 242 on at

Like (0)

Report

Re: Delete row in excel table running slowly

That worked like a charm, thank you!

Was this reply helpful? Yes No
takolota1 4,944 Moderator on at

Like (0)

Report

Re: Delete row in excel table running slowly

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...

Was this reply helpful? Yes No