When an excel file is added to sharepoint doc lib, excel connector throws error

(0) Share

Report

Posted on by Teresa24486

611

Hi,

I have a flow where when an excel file is added to sharepoint doc lib, excel connector throws error.

"body": {

"status": 404,

"message": "No table was found with the name '{B83DBAF7-7EF2-4853-8012-462DD3A39AB3}'.\r\nclientRequestId: 9078825e-6cbf-470f-b190-beecae36a9ff\r\nserviceRequestId: 0dcc2c52-d60c-41bf-bf6b-0dff55fdcc47",

"error": {

"message": "No table was found with the name '{B83DBAF7-7EF2-4853-8012-462DD3A39AB3}'."

"source": "excelonline-sea.azconn-sea.p.azurewebsites.net"

}

I have configured a workflow to fetch an email from outlook inbox and update the existing file in the sharepoint doc lib. The file gets updated in the checkout state, but my second flow where when an item is added to the SP doc lib it should list rows in excel which is not happening:

Please advise.

Categories:

Business Process Flows

I have the same question (0)

All responses (13)

Answers (1)

dbro 194 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

@Teresa24486, It sounds like the List rows present in a table action may not be finding the table name in the newly added excel doc. Does the excel file you added have the exact same table name as the action shows? I think it must in order for it to work properly.

Was this reply helpful? Yes No
Teresa24486 611 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi,
so my flow works in a way that the excel sheet is automatically added to the SP doc lib through a flow, after which the second flow runs, so in this case the excel connector doesn’t detect the table field of the file automatically. Can u pls advise.

Was this reply helpful? Yes No
dbro 194 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Is the file name and table name always the same of the newly created file? Is it possible o make it such?

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @Teresa24486
Please take a try to add Get Table action, then replace the table name with Table id.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Teresa24486 611 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @dbro,
The excel file name is exactly the same, but I think when the new file is created the table name changes, the custom value is pre-defined this way already.

Was this reply helpful? Yes No
Teresa24486 611 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @v-LilyW-msft,
I tried the steps you suggested and here is the error :

Was this reply helpful? Yes No
Teresa24486 611 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @v-LilyW-msft,
I tried the steps you suggested and here is the error ; please advise.

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @Teresa24486
From your output, the value of Get tables is empty.
Please make sure there is a Table in the added excel.
This is my test results.
Best Regards.

Was this reply helpful? Yes No
Verified answer

abm abm 32,585 Most Valuable Professional on at

Like (1)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @Teresa24486

After the trigger add a delay for a minute or so. If not you might get resource not found error. Then use Get Tables and list rows present in a table. This should work if you hardcode all the path by browsing and set the filename and path.

If you want to make it dynamic (Excel file name and table) please have a look at this blog by Josh Cook.

Get tables – Flow Alt Delete – Josh Cook [Microsoft MVP]

Thanks

Was this reply helpful? Yes No
Teresa24486 611 on at

Like (0)

Report

Re: When an excel file is added to sharepoint doc lib, excel connector throws error

Hi @abm,
I will check this out and give you an update. The error for the excel table isnt there, but the create condition did not work as expected. I had a few new records on the excel sheet which did not get updated on the SP list.

Was this reply helpful? Yes No