You’re offline. This is a read only version of the page.
14
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
Thanks so much for your help. It works now. I really appreciate your help and kindness. Have a great day!
Eric
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
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
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.
Share
Report
All responses (
Answers (
