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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Table Name greyed out

(0) ShareShare
ReportReport
Posted on by Super User 2024 Season 1

Hi there,

 

I intend to get values from Power Virtual Agent and insert into an Excel table.

 

First thing I noticed when creating the flow is that the Excel connector is asking for the Table name.

 

Using the Excel connector to add a row into a table shouldn't be a rocket science mission to build, but since the table name is greyed out and is asked in the connector, is quite amazing that the answer can't be found anywhere.

 

I have created an Excel file and placed inside a folder in the SharePoint, any help will be really appreciated.

 

Kind regards,

 

Fernando

 

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi!

     

    To use the excel connector for adding a row, you need to make sure that the excel file has a formatted table with column names. E.g., 

    yashag2255_0-1695043365050.png

    Once you have the table, provide all the information in the flow and you will be able to see the columns in the action as shown below: 

    yashag2255_1-1695043547664.png

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard