Answered

Failed to retrieve dynamics inputs. Error details: 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'Not Found'

(0) Share

Report

Posted on by EricYangMaBos

Hi All,

When I tried to add a row to a table in Excel (tried both Excel Online For Business, and Excel Online (Business)) with Power Automate automated cloud flow, I got the error message in the attached picture. I followed step by step to Table. My table name is called Sheet1 in spreadsheet but it seems the connector cannot read the table name. I'm using my business account to test it. Has any experienced this error? How did you solve this problem?

Thanks so much!

Eric

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Pstork1 69,226 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you sure you are accessing a Table and not a Worksheet? The default worksheet in Excel is called Sheet1, but that isn't a Table. To get a table you need to highlight the values you want and got to the Insert menu and Insert a Table. By default that will be called Table1, although you can rename it.

Was this reply helpful? Yes No
EricYangMaBos 14 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much! Table is one of the steps of this workflow: Location->Document Library->File->Table->Item. In my Excel worksheet, I only have a sheet called "Sheet1". Power Automate cannot find this "Sheet1" by itself. So, I enter custom value as Sheet 1. Then, above error message popup which I cannot move to next step. I also need your help for Item, what should I fill for Item?

Have a great day!

Eric

Was this reply helpful? Yes No
Verified answer

Pstork1 69,226 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

As I said in my reply. Power Automate can't read just a plain worksheet. It can only read tables, not just worksheets. This article shows how to create a table in Excel. Create a table in Excel - Microsoft Support

Was this reply helpful? Yes No
Verified answer

EricYangMaBos 14 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much for your help. It works now. I really appreciate your help and kindness. Have a great day!

Eric

Was this reply helpful? Yes No