Unanswered

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

(1) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

PrasadAthalye on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Are you suggesting I update the flow each time?

Was this reply helpful? Yes No
Mahlatse 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
skylitedave 652 on at

Like (0)

Report

I also faced this issue - here is the fix

When you specify the table within the "List Rows Present In Table" action in Flow, select the Custom option in the Table property and just type in the exact name of the table in excel - this forces the action to uses the table name not the GUID for the table name.
If delete and replace the excel file, the flow will still work as long as you have the same table name within Excel
DO NOT SELECT THE NAME FROM THE TABLE DROPDOWN or it wont work (it will use a guid rather than the table name)
I lost countless hours of sleep before I discovered this trick
Give me a thumbs up if this works for you

Was this reply helpful? Yes No