Edit

Unable to find Excel Online table in Microsoft Flow

  • Article
  • 2 minutes to read

This article provides a resolution for the issue that you can't find Excel Online table in Microsoft Flow.

Applies to:   Power Automate
Original KB number:   4527553

Symptoms

When trying to access information in an Excel spreadsheet that is not formatted as a table, you may not be able to see a table present in the drop-down menu.

Screenshot shows that the Excel table drop-down menu has no table.

Entering a custom value that does not exist or leaving the table input blank will produce an error that begins with Error executing the api.

Cause

This error occurs because the data in the Excel spreadsheet is not formatted as a table.

Screenshot shows that the Excel data is not formatted as a table.

Resolution

To fix this issue, format the data in the Excel spreadsheet as a table.

To create a table from scratch, follow these steps:

  1. Select the cells you want to include in the table.
  2. Select Insert > Table > Ok.

To convert existing data into a table, follow these steps:

  1. Select the cells containing the data you want to convert into a table.
  2. Select Home > Format as Table.
  3. Select the type of table you want and select Ok.

Headers will automatically be included in the table, which will default to Column1, Column2, and so on. They can be renamed by double-clicking and typing a new header name.

Screenshot shows the Excel data is formatted as a table.

For more information, see Create and format tables.