News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Select Table from Exce...

Power Automate - Building Flows

Unanswered

Select Table from Excel in Flow

(3) Share

Report

Report

Posted on by Community Power Pla...

I tried to build my first flow by inserting a row into a test excel file table that is stored on MS teams in a test group.

In the excel file I used the table options to create a table with headings.

When I follow the instructions the file is easily connected to Flow, however once I get to the dropdown "Table" no options appear.

How can I name the table in Excel? Or did I insert the table incorrectly into excel?

How can I create a table that can be connected to the "insert a row into a table action"?

thanks in advance!

All responses Img

All responses (1)

Answers Img

Answers (0)

v-yamao-msft on at

Like (0)

Report

Re: Select Table from Excel in Flow

Hi @Anonymous,

To format an Excel file into a table, and rename the table in Excel, please check the following docs:

Create or delete an Excel table

Rename an Excel table

When using the Excel action Inset row, once you connected to the connection, the Excel tables that stored in the cloud storage account would be selected, then you could select the table you want to use by clicking the dropdown of Table name field.

Please have a try with it on your side and feel free reply if you need more help.

Best regards,

Mabel Mao

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans