Data Import & Export

Fix an Empty Excel Table Drop-Down in Power Automate

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 869 views

Question details

The user needs an Excel table to appear in the Power Automate Add a row into a table action.

Fix an Empty Excel Table Drop-Down in Power Automate
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the workbook location

Open OneDrive for Business or SharePoint and verify that the workbook is stored there and accessible to the account used by your flow.

2
Format the data as a table

Open the workbook in Excel, select the data range, and choose Insert > Table. Confirm the range and whether the table has headers.

3
Name and save the table

Select a cell in the table, open the Table Design tab, and enter a name in the Table Name field. Save the workbook.

4
Reselect 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.

Check the workbook location and create a named Excel table
Workbook access: If the workbook is locked or inaccessible, close it where possible and confirm the connector account has permission to edit it.
Free Microsoft Office alternative

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.

Open and edit spreadsheet data in a familiar interface.Work with Microsoft Excel XLS and XLSX formats.Use a free, lightweight office suite for everyday workbook tasks.
microsoft office alternative - wps office

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.