cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Solution Specialist
Solution Specialist

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.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

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}"
 

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?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

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.

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Are you suggesting I update the flow each time?

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.

Top Solution Authors
Top Kudoed Authors
Users online (3,493)