cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SSantana
Level: Power Up

Microsoft Flow Error 409 Adding row into a excel table

Hello everyone,

 

I've built this flow with Typeform and Excel Online (Business) Connection.

 

The flow would insert a new row into an existing table in excel everytimea new response has been submitted on Typeform.

 

This flow was working fine a week ago and suddenly it started giving me the error:

 

Status Code: 409

 

 Error

Action 'Add a row into a table' failed
 
Error Details
This won't work because it would move cells in a table on your worksheet.
clientRequestId: ee29afd0-3516-4859-b7d3-e8eedab0e53a

 

 

Can anyone help me with that?

I tried creating the flow from scratch once again but still giving me the same error.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Microsoft Flow Error 409 Adding row into a excel table

Hi @SSantana,

 

As @frederikbisback suggested, 409 error code is a conflict error which will be returned when two processes are trying to update the same document simultaneously.

Please check whether the file is being updated by others.

According to your description, I have made a flow likes below which is working properly. No 409 error returned.

1.PNG

Please check it for a reference and try again on your side.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3

Re: Microsoft Flow Error 409 Adding row into a excel table

Dear,

 

Error code 409 is a conflict error, see following page: https://docs.microsoft.com/en-us/rest/api/searchservice/http-status-codes. Is there an second process running, that is using the file? Can you send me the flow in detail?

409 Conflict Returned when write operations conflict. This error is returned for resource updates, or during indexing when two processes try to update the same document simultaneously. Azure Search provides concurrency management for resource updates. For more information, see How to manage concurrency in Azure Search.

Community Support Team
Community Support Team

Re: Microsoft Flow Error 409 Adding row into a excel table

Hi @SSantana,

 

As @frederikbisback suggested, 409 error code is a conflict error which will be returned when two processes are trying to update the same document simultaneously.

Please check whether the file is being updated by others.

According to your description, I have made a flow likes below which is working properly. No 409 error returned.

1.PNG

Please check it for a reference and try again on your side.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Petri_Riekki
Level: Power Up

Re: Microsoft Flow Error 409 Adding row into a excel table

Hi!

 

@v-yamao-msft @frederikbisback @SSantana 

 

I'm getting this very same error. Problem doesn't occur if I personally run it, but when I'm trying to run it with my another test account error occurs. User should have all needed permissions. Is there any way to "release" excel from other processes or any other suggestions how to workaround this? Thank you!

 

 

409.JPG

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (4,253)