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

[Anonymous]

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.

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

[PrasadAthalye]

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.

[Anonymous]

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

[PrasadAthalye]

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?

[Anonymous]

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.

[PrasadAthalye]

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

[Anonymous]

Are you suggesting I update the flow each time?

[Mahlatse]

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