Skip to main content

Notifications

Calling Actions from Copilot Studio
Answered

Items in Excel table do not match

Posted on by 6

Hello Everyone,

 

I'm quite new to VPA, however I have been using for a while power apps.

I'm now trying to pass information from VPA to an excel file. I create a table with Excel placed in OneDrive business and call the routine "Add a row into a table". 

carlosnt78_0-1692778434709.png

Everything looks "almost" fine, however when select the table I see items I never entered 

Item/notes

Item/State

Item/City 

carlosnt78_1-1692778491815.png

 

I have no idea what they are and additionally VPA gives an error because of that 

How can rid of them? 

Thanks

  • Carlo S. Profile Picture
    Carlo S. 6 on at
    Re: Items in Excel table do not match

    thanks @Expiscornovus !

    That was indeed the issue! I was using the suggested/pre-made actions and that apparently does not work well for me. Did as you suggested and indeed those fields disappeared.

     

    Thanks a lot!

     

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 1,708 on at
    Re: Items in Excel table do not match

    Hi @carlosnt78,

     

    This could be fields which have been previously used in the action.

     

    The easiest way to get rid of this is by removing the Add a new row into a table action and adding it back again to your flow.

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