Skip to main content

Notifications

Topic Creation & Management
Unanswered

Chat bot using an FAQ list as topics

Posted on by

Hi 

 

New to this - can I use an FAQ list from excel with my chat bot - with the first column my topic 

  • Expiscornovus Profile Picture
    Expiscornovus 1,708 on at
    Re: Chat bot using an FAQ list as topics

    Hi @Micksciara,

     

    It depends a bit what you are looking for. Generally speaking you can interact with an Excel file via the Call an action step when you are designing a Power Virtual Agent topic:

    https://docs.microsoft.com/en-us/power-virtual-agents/advanced-flow

     

    To give you an idea I created a small demonstration with an Excel File.

     

    1. A Excel File hosted on SharePoint. This Excel file contains a formatted table (Table1) with three columns. First column is called Topic.

     

    FAQExcel_tableexcel.png

     

    2. A Topic where the bot asks a question (multiple choices). These are the same as the topics in the Excel. The choice is stored in a varCategory which is used to lookup the question/answer pairs in the Excel file via a Power Automate flow.

     

    FAQExcel_topic.png

     

    3. The Design of the flow. The Category field receives a value from the varCategory which is used in the Filter Query field of the List rows present in a table action. This is to filter the Excel file and only retrieve the correct question/answer pairs for a specific topic.

     

    With two expressions in the Select and the output variable the response is formatting.

    concat('**Question**: ', item()?['Question'], decodeUriComponent('%0A'), '**Answer**: ', item()?['Answer'])

     

    join(body('Select'), decodeUriComponent('%0A'))

     

    FAQExcel_flow.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