Fix an Empty Excel Table Drop-Down in Power Automate
Question details
The user needs an Excel table to appear in the Power Automate Add a row into a table action.

- Product
- Power Automate and Excel Online (Business)
- Device & OS
- not provided
- Scenario
- Configuring a flow to add a row to a table in an Excel workbook.
- Observed behavior
- The Table drop-down is empty when configuring the action.
Identify the workbook and the account used by the Excel Online (Business) connection. Confirm that the account can open the workbook in OneDrive for Business or SharePoint.
Check the workbook location and create a named Excel table
Use this solution to make sure the connector can find an accessible workbook with a table.
Open OneDrive for Business or SharePoint and verify that the workbook is stored there and accessible to the account used by your flow.
Open the workbook in Excel, select the data range, and choose Insert > Table. Confirm the range and whether the table has headers.
Select a cell in the table, open the Table Design tab, and enter a name in the Table Name field. Save the workbook.
In Power Automate, open the Add a row into a table action. Select the correct Location and Document Library, browse to the workbook in File, and open the Table drop-down again.

Refresh the Excel connection and recreate the action
Use this if the workbook and named table are correct but the table list is still empty.
Manage Excel Workbooks with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with Excel files. Its format compatibility helps you move existing workbooks into WPS, though it does not fix Power Automate connector issues.

Frequently Asked Questions
Why does Power Automate show no tables in my workbook?
The workbook may be in an unsupported location, the data may not be formatted as an Excel table, or the connection may have stale metadata. Check the workbook in OneDrive for Business or SharePoint, then use Insert > Table in Excel.
Is a worksheet the same as an Excel table?
No. A worksheet can contain ordinary cells without a table. Select the data and choose Insert > Table, then save the workbook before selecting it in Power Automate.
Which account needs access to the workbook?
The account used by the Excel Online (Business) connection needs access to the workbook. Check the connection under Data > Connections and verify that account can open and edit the file.
What should I do if the table still does not appear?
Repair or sign in to the Excel Online (Business) connection under Data > Connections, reselect the workbook, and recreate the Add a row into a table action if necessary.




