Power Platform Community Forum Thread Details

I have these actions to create an excel sheet file inside sharepoint document library, and add a table to it:-

but sometimes the "Create table" action return this error:-

{
"status": 400,
"message": "A table can't overlap another table. \r\nclientRequestId: f3f293dc-3d6c-47ae-a508-0a7df6ad5b79\r\nserviceRequestId: c2fe6e58-3d4b-41d2-9f23-d320dc5f8f59",
"error": {
"message": "A table can't overlap another table. "
},
"source": "excelonline-uaec.azconn-uaec-001.p.azurewebsites.net"
}

so what could be causing this error? again sometime the flow work well and sometimes it return the above error

Thanks

Categories:

Building flows

Hi,

So from a purely "how it works", the script believes there is already a Table in that Sheet.

The question is, why does it think that.

It can be a caching issue.

It can be that you have multiple instances of the Flow running at the same time and its causing a collision.

It could be that there is a re-try happening because it failed or thought it did, when in fact it worked.

The question I have is, is there an actual Table in the file, after the fail message of the overlap?

If there is, then its one of the things above causing it.

If you are, or can, identify which one it is (see if there were multiple instances triggered at the same time) or retries, then you would need to add error handling in to verify that the Table really already exists.

Another thing is, you may need to be a Pause / Wait (Action) after your file create. So that it is in fact fully "created" which could also cause your issue.

Usually a 3-10 minute wait, removes these issues.

There you go.

cheers