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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / PVA Bot to read the da...
Copilot Studio
Unanswered

PVA Bot to read the data from excel as response to the question

(0) ShareShare
ReportReport
Posted on by lalithanov20 2
Hi Experts, I am trying to create a PVA bot to answer queries with the response stored in the excel. Here is what i have done till now Step 1 : Post a message to Ask a question: message is read into a variable "question" Step 2 : Call a action, create a flow, which is following sub steps 1. Input 2. List row represent table Not sure how to print this data. How do we conditionally filter the excel data to only display the response to the questions posted.
Categories:
Calling actions from Copilot Studio
I have the same question (0)
  • lalithanov20 Profile Picture
    lalithanov20 2 on at

    output of excel

    issue               resolution

    What is AI       Artificial intelligence

    what is ML     Machine Learning

     

    here are snapshot of the flow that I have created

     

    lalithanov20_1-1659606566842.png

     

     

    lalithanov20_2-1659606632434.png

     

     

     

  • Pstork1 Profile Picture
    Pstork1 69,022 Most Valuable Professional on at

    Instead of using an OData query to filter the rows, I would just get all the rows. Then you can use a Filter Array action to filter out rows that do not contain a specific word or words. I would suggest finding a way to send just the keyword being requested to the flow and filter on that.  

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

News and Announcements

Welcome to the Power Platform Communities

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!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

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

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt
Welcome to the Copilot Studio forum!

Product updates

Microsoft Power Platform Community release plans