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

(1) Share

Report

Posted on by shurke4040

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

Categories:

Power Automate Flows