Answered

Excel Create table throwing an error - A table with the name already exists

(0) Share

Report

Posted on by sid-poly

There is an automation being performed where the latest file based on the creation date is taken from SharePoint Documents. From there we need to create a table in the worksheet and then use the table to add it in the list present on the SharePoint

When this action is being performed, there is an error thrown that a table with the name already exists. Is there a way where we can tweak this to get this working?

Help appreciated

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

First step is to check if there is already a table with this name in the Excel file.
If so you either need to remove the existing table first or choose another name for the new table.

Was this reply helpful? Yes No
sid-poly 6 on at

Like (0)

Report

Yes that can be checked. There is also another issue being faced with an error - A table can't overlap another table. This comes after the new table is created which shouldn't happen.

Can you help on this too? Is it the right thing or is it wrong? @okeks

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

For me it sounds like the table you want to create is already there.
Excel doesn't allow to share cells between 2 different tables.

There are also more restrictions on tables from the Excel side.

To give more advice I would need to see the Excel file and the flow.

Was this reply helpful? Yes No
sid-poly 6 on at

Like (0)

Report

@okeks
The table is getting created in a step in a for each loop

Throws an error. If there is a new file being placed, that consists of RAW data then the error seen is

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @sid-poly ,

If table already exists in one of the excels returned by Get files (properties only) Action , this error might will appears.

If i want to create table in all excel files uploaded today i would do this:

1. Here is my Folder.
2. Here is my flow.
Created gt '@{addDays(utcNow(),-1)}'
Result Screenshots:

In addition, maybe you could try the following flow:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

@v-yujincui-msft

My flow is returning the same error 'A table can't overlap another table'.

However, there is no table in the excel file.

I can't figure out what else to do? Thoughts?

Was this reply helpful? Yes No