Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 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.
  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Re: PVA Bot to read the data from excel as response to the question

    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.  

  • lalithanov20 Profile Picture
    lalithanov20 2 on at
    Re: PVA Bot to read the data from excel as response to the question

    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

     

     

     

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics