Skip to main content

Notifications

Calling Actions from Copilot Studio
Unanswered

Create connection to OneDrive Excel question for TABLE box.

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)

Categories:
  • cnboon Profile Picture
    cnboon 5 on at
    Re: Create connection to OneDrive Excel question for TABLE box.

    Thank you this help a lot!

  • govind031998 Profile Picture
    govind031998 6 on at
    Re: Create connection to OneDrive Excel question for TABLE box.

    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.

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,997

#3
Expiscornovus Profile Picture

Expiscornovus 1,708

Leaderboard

Featured topics