web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : a5zhrkjjNyKzDMEt8ZNnuM
Power Automate - Building Flows
Unanswered

Select Table from Excel in Flow

Like (3) ShareShare
ReportReport
Posted on 11 Jul 2018 16:56:16 by

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!

I have the same question (0)
  • v-yamao-msft Profile Picture
    on 13 Jul 2018 at 01:59:08
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete