Skip to main content

Notifications

Calling Actions from Copilot Studio
Unanswered

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

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 1,997 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

     

     

     

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