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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Create connection to O...
Copilot Studio
Unanswered

Create connection to OneDrive Excel question for TABLE box.

(0) ShareShare
ReportReport
Posted on by 5

I am new to create chatbot. 

The question I hope someone can enlighten me is:

I am creating flow using the Power Virtual Agents Flow Template. I did an Add an Action and selected Excel Only then select Get a row. This gets to a table to enter the connection.  I am ok with the boxes labeled, Location, Document Library and File. However, the box labeled Table. the list of value is No Item and Enter custom value

Q1 : Now my source Excel has a worksheet name ABC, I am assuming the Table is referring to the Worksheet. Is that right? Anyone can point out for me?

Q2: Problem is the list of values  for Table is No item. Can someone shade some light here what is the Table refers / relates to in Excel source?

(Refer to picture in attachment)

Capture.JPG
I have the same question (0)
  • govind031998 Profile Picture
    6 on at

    Hi cnboon,

    you have to convert the excel data into a table. So in excel, select all ur data -> insert -> table.

    save your excel and create your flow again.

  • cnboon Profile Picture
    5 on at

    Thank you this help a lot!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 130 Super User 2026 Season 1

#2
Valantis Profile Picture

Valantis 122

#3
chiaraalina Profile Picture

chiaraalina 33 Super User 2026 Season 1

Last 30 days Overall leaderboard