Skip to main content


Calling Actions from Copilot Studio

Using Power Virtual Agent to read an Excel and return the row through the chat in teams

Posted on by 2

Hi guys,


im pretty new to Power Virtual Agents and Power Automate and I just can’t get my Bot to read an Excel and return the row. 
My Table has just 2 columns, first one is for all abbreviations and the second one is the explanation of said abbreviations. 

I want to be able to search the explanation of an abbreviation by answering a question through the bot and then search the first column using the input and then return the second column through power virtual agents.
Is there someone who could help me to create this simple flow?


Also I’m sorry I know some have already asked this question, but because I’m not at all good in English it’s pretty hard for me to understand without screenshots of such a flow and I just can’t get it right :D.

thanks alot 


Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

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


WarrenBelz Profile Picture

WarrenBelz 138,030

RandyHayes Profile Picture

RandyHayes 76,308

Pstork1 Profile Picture

Pstork1 63,085


Featured topics