cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Create Table - A table can't overlap another table.

Hi All, can you please help me to identify which the problem is here?

 

I'm trying to create a table with power automate, this is my flow

 

1. Run Desktop Flow: in the desktop flow I get an excel from sharepoint shared folder (from locally) I delete the worksheet with a table inside it, I create another worksheet putting inside it the data unformatted, save the excel

 

2. Add a delay, to let the file modification be available on sharepoint online

 

3. Create a table from the unformatted data of point (1)

 

The first time it works, but from the second one it give me the "A table can't overlap another table. " error.

 

Any suggestion?

 

Thanks

14 REPLIES 14
CFernandes
Super User
Super User

Hello @Anonymous 

 

The error "A table can't overlap another table. " error is because you already have a table in place in the excel file.

 

If you delete the old table manually, save the Excel file I am sure the Power Automate will not error out. Note: There is no action to delete the table

 

Before you create your table make sure you do a Get Tables and see what ranges other tables are using.  Then make sure your new table is outside of those ranges.

 

CFernandes_0-1618232898537.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi @CFernandes

 

many thanks, but in the power automate desktop flow, I completely delete the worksheet and create a new one with new data, then in the service I create the table... so the table does not exist in excel once I try to create another table...

 

so --> delete worksheet and table inside it --> create new worksheet --> paste unformatted data --> try to create a new table on that data --> Error 

 

Thanks

Hello @Anonymous,

 

Ohh OK. I do not have Power Automate Desktop installed right now on my box so cannot test.

 

I would also request you to move/create a new question on https://powerusers.microsoft.com/t5/Power-Automate-Desktop/bd-p/MPADesktop as this is related to Power Automate Desktop.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi @CFernandes, it is not matter of power automate desktop but of power automate cloud since I create the table on the service after the running of power automated desktop flow that save the excel file on the sharepoint online directory.

 

Capture.PNG

 

Thanks,

@Anonymous Are you using the same Table ranges? If you try different Tables Ranges do you get the same error?

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi @CFernandes, the table range is dynamic on rows number but by repeating the test several times, it is the same. But the thing I cannot understand is that there is no table on the online excel, but power automate get this error like it exists ... it seems like matter of cache ... I don't know....

Hey @Anonymous 

 

You are right, it happened to me on a live demo - See 21:08 in the video https://www.youtube.com/watch?v=4Xzobptejp4

 

I had to create new excel file to get around that problem. I am out of idea's right now.

Anonymous
Not applicable

@CFernandes, thanks for checking. We wait then for a technical solution

GrifoDeGrifis
Regular Visitor

I guess a solution never arrived from microsoft... 

ElBaz
New Member

I'm kind of having the same issue except the flow seems to work, even though it says it failed. I receive an excel file via email and it gets transferred to a folder on SharePoint via a flow. It then it's supposed to get converted to a table via a flow. The flow runs says it failed, but when I open the file, it has been converted to a table.  

ElBaz_1-1660315180568.png

 

I think I figured it out. After the file is created the flow runs, but then it wants to run again because the file was also modified. 

PumpkinPie
New Member

I've got the same issue. my excel sheet is alway clean with no table created, but it always showing this error. Occasionally, when it got through, but there is other error showing the source is not existed. In summary, steps with "create table" is not stable in real practice. 

LuciusNoir
Regular Visitor

LuciusNoir_0-1661852160545.png

Sooo, my flow is updating the .xlsx that already has a table in range A:O with just plain data, ultimately deleting that table. Then the Create Table node creates a new table in range A:O. 

 

I've encountered the error in question several times already, and a simple .xlsx template replacement was fixing the issue (just like @CFernandes's video example). Well, not anymore...

 

I've been running above flow for months now. Doesn't work anymore, all of a sudden. 

dhock
Kudo Collector
Kudo Collector

I'm having this issue as well. My flow takes a spreadsheet that is created automatically (report from a database) and does not have a table already in it. Most of the time it works fine, but sometimes, it seems that the default table (Table1) is already there when the Create Table action runs. I'm suspecting it actually gets created by the flow when the Create Table action doesn't work the first time. The Create Table action itself has a totally different table name specified ("Timesheets"). When it retries, it gets the error about a table not being able to overlap another.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,461)