Microsoft Flow Error 409 Adding row into a excel table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

frederikbisback 222 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

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.

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

Best regards,

Mabel

Was this reply helpful? Yes No
Petri_Riekki 4 on at

Like (1)

Report
Copy link

Link copied!

Hi!

@v-yamao-msft @frederikbisback @Anonymous

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!

Was this reply helpful? Yes No