Error 404 on Excel operations

[Flag]

It is at least 3 days since the flows are starting to return me errors 404 while reading or modifying an Excel file, but the file or table exist to demonstrate that if executed shortly after by hand or by the call the problem does not occur.

Is there a logical explanation for that?

[v-yamao-msft]

Hi @Flag,

What’s your current situation? Are you still having the issue?

How is your flow created? Could you share a screenshot of your flow?

I have made the following flow with Excel actions Get rows and Insert row which is working properly, no 404 error returned.

Please take a try with it and feel free post back if you are still having the issue with more details.

Best regards,

Mabel

[Flag]

Hi @v-yamao-msft,

The issue is still present, it isn't appear everytime i use the Excel connector, but rather often.

The Excel connector is the one for OneDrive for bussiness, so I expect the problem to be either on the connector or on the OneDrive for bussiness.

For example, this loop that controls the rows of the Excel file continually returns 404 errors after at least 10 cycles successfully performed!

Thanks

[Flag]

As said,

[v-yamao-msft]

Hi @Flag,

Thanks for updating.

It seems that there is something wrong with the action Update row. The error message says Not Found. I am afraid that the item that is going to be updated cannot be validated by flow.

Please make sure you have specified proper Row id for each item.

I have made a flow likes below to test this issue, the error could not be reproduced.

Further, error message Not found means that a setting in an action of the flow doesn’t function as expected. You will need to click or tap the Edit button and then correct the problem inside the flow definition. Save the updated flow, and then click or tap Resubmit to try the run again with the updated configuration.

Please take a try with it on your side.

Best regards,

Mabel

[Flag]

Thanks for the tutorial @v-yamao-msft, but as i said the flow was working well until last week.
If i launch another, or more, times this flow it will complete without any error.

There is no error with the action Update ROW as the ID is taken directly from the actual row in the cycle.

I would like to maintain Flow as it is very simple to maintain or explain, but if it's so difficult to obtain a solution or assistance, i'll have to migrate all. Just to know this in time.

Thanks.