cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DDCJOEE
Advocate III
Advocate III

Delete row in excel table running slowly

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?

 
1 ACCEPTED SOLUTION

Accepted Solutions

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

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

6 REPLIES 6
v-alzhan-msft
Community Support
Community Support

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.

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.

 

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?

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

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





That worked like a charm, thank you! 

takolota
Super User
Super User

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,406)