Showing results for 
Search instead for 
Did you mean: 
Advocate V
Advocate V

Flow doesn't wait for Excel Online - Add a row into a table to complete before moving to next action

I have a flow where I am adding a row to an excel online (stored in sharepoint document library) file, using the 'Add a row into a table'.

Immediately after that action, I am copying the file to a different folder.

the problem is, the flow progresses past the action 'add a row into a table' before the file update is actually complete, so the copy of the file doesn't contain my most recent addition. If I look at the file I originally added the row to, the data is present there, which seems like an automatic indication that the copy file action started before the file update was complete.


Is there any way to work around this?

Community Support
Community Support

Hi @  dave-jorgensen,

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


Please take a try to add a delay under the "Add a row into a table" action of Excel Online connector as screenshot below:




Please let me know if your issue could be solved.

Alice Zhang

Hi Alice. No need for me to post a screen shot of flow - it looks exactly like yours.

I overcame the issues in the same way (adding a delay).


I guess I expected the 'adding a row to a table' to be a synchronous event, and that the flow would wait for that to actually complete before moving to the next action in the flow. Obviously that's not the case. Having to delay the flow artificially to overcome this works, but is pretty irritating and I'm sure causes lots of confusion / issues with users.


I understand that some actions, it's fine if they are asynchronous. Other times, users require an action to be synchronous, and certainly expect it to be so.


It would be ideal if actions had 2 things:

  1. Some indication that the flow doesn't actually wait for the operation to complete before moving on
  2. A flag to force the flow to wait for the operation to complete before moving on

Really isn't a solution. The issue is, the flow doesn't wait for the action to complete.

putting in a delay is just recognizing that yes, the flow doens't wait for the action to complete, so we artificially wait. What if the 'behind the scenes' stuff in the action takes a long time, or server is slow, and now takes more than 1 minute? Then suddenly what you thought would work, doesn't. Extremely unreliable. That's why we need flow to actually wait for the action to complete

I'm having exactly the same problem. The question is i'm trying 5 sec delay, 20 sec delay, going to raise to 1 minute delay. But if the excel file has more lines than my test what delay time it will be the appropriate ?


Well i'm fighting with Flow to populate an excel file form a blank excel with a table inside and had lots of barriers.

Begining with the obligation to have a template in blank, beucase excel doesn't acepts dynamic data on the file location and now when i thougth, ok, lets arrange a workaround this happens.


Super frustrating.

Anybody ever come up with a better solution?  As noted above, simply waiting doesn't guarantee that the updates actually occur.  In the settings there is a an "Asynchronous Pattern" option, which I thought might change the behavior and force synchronous operation, but no such luck. 




We've been aware of this and it continues to haunt us. If adding mutliple rows, we've had to add a delay between each row added so we don't innundate the server.  Back searching for a setting to run the updates in synchronous mode, and have posted an idea on the FLOW Ideas site:  Please vote it up. 

In the mean time, we are just adding manual delays and crossing our fingers that they are long enough / we don't ever hit the server when it's too busy. 

Hey @ryanperrymba 

Have you found a solution for this? I have already voted up your idea. I've run into this problem multiple times now and it makes all my flow very unreliable!

Guess you could try:

  1. Count rows in excel file ( eg 10)
  2. Update Excel by adding row
  3. Loop until rows = 11
    1. Wait a little bit
    2. Count rows in excel file

thanks dave!

Frequent Visitor

The sad thing is, the connector can see the data as 'present' before it's actually written to the file. I have a Do-Until loop that uses the List Rows from a Table action to compare the number of rows to the expected value, and it's still missing a row in the final file. The row is present in the output of the last run of the Do-Until loop, but not in the spreadsheet file itself. Very frustrating! All I want to do is generate a spreadsheet and attach it to a list item...

Helpful resources



Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,050)