cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Excel table name is overwritten, error: "No Table Name was found..."

Hello -

My ultimate objective is to automatically add a new occurrence of a CSV file into an existing SharePoint List.  I could not find a simple way to load the CSV directly, so I am manually creating an Excel Table called Bundle Quotes.xlsx.

 

Question #1 - is there an automated way a newbie can implement loading the CSV directly, and avoid the problem below?   There could be 1 - 5 files per day and each contains 30 -100 records.

 

I keep the same Bundle Quotes.xlsx name and with each new CSV file, I replace the Bundle Quotes.xlsx.  However, I have an issue with the File/Table value of "Table1" getting overwritten when I replace the excel table.  Error: No table was found with the name '{00000000-000C-0000-FFFF-FFFF00000000}'.

 

Question #2 - how do I load multiple excel tables with the same file name?

 

Question #3 - is there a simpler approach to load and manage the files?  The file name does not have to be consistent,  I assumed it would keep the Flow easier.   Dynamic names and moving files around to different folders seems more complex to me being a rookie.

 

Thanks in advance for your help!

 

Before - the Bundle Quotes.xlsx initial version and the Flow works fine.

BartHannah_1-1599844461666.png

 

After - For the 2nd file, I replaced the original excel table with a new version and it 'breaks' the Table value in the Flow

BartHannah_0-1599844414152.png

 

7 REPLIES 7
Highlighted
Post Prodigy
Post Prodigy

Re: Excel table name is overwritten, error: "No Table Name was found..."

Can you Create another folder called, processed and move the file there once its processed. This way you get a fresh file every time.

 

Mark this as an answer if it resolves your issue.

Highlighted
Regular Visitor

Re: Excel table name is overwritten, error: "No Table Name was found..."

I tried it and moved the file.  When I trigger to run the flow, it loads the same file again and does not recognize the new version in the folder the Flow is pointing to.  I noticed the Table name on the 'successful' run below as the odd name from the original error message, but this run worked somehow and loaded the original file again?

 

Inputs

List rows present in a table

{
    "host": {
        "apiId""subscriptions/427976e2-4271-4308-afb8-d28d53a6ad06/providers/Microsoft.Web/locations/westus/runtimes/msmanaged-na/apis/excelonlinebusiness",
        "connectionReferenceName""shared_excelonlinebusiness",
        "operationId""GetItems"
    },
    "parameters": {
        "source""groups/36925a82-543a-492c-9def-f5150d6b0579",
        "drive""b!SGCr07FYCUmK85nUDmvQHOyE9GYbsExKv1m8v2kS4WlaJnitY6N0Q4IzoJ6rE59I",
        "file""01JF5NDLLIMPZDW6IIYNELL2P6OLEZSC57",
        "table""{00000000-000C-0000-FFFF-FFFF00000000}"
 
Highlighted
Post Prodigy
Post Prodigy

Re: Excel table name is overwritten, error: "No Table Name was found..."

I think that is because Excel internally maintains GUID for every file and with the same name it just considers it as same version.

 

Can you append datetime every time loading the file and then use the same logic to read the file?

Highlighted
Regular Visitor

Re: Excel table name is overwritten, error: "No Table Name was found..."

Probably, but I do not know how to do that.  Since I have to open the CSV file, Format as Table and save as xlsx, I could save to a different name....just need guidance to do it.

Highlighted
Post Prodigy
Post Prodigy

Re: Excel table name is overwritten, error: "No Table Name was found..."

Just load the file with different name every time...

Highlighted
Regular Visitor

Re: Excel table name is overwritten, error: "No Table Name was found..."

Are you suggesting I update the flow each time?
Highlighted
New Member

Re: Excel table name is overwritten, error: "No Table Name was found..."

Hi @BartHannah  did you find the best way to fix the problem ,i am having the same issue

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,419)