Skip to main content

Notifications

Copilot Studio - Topic Creation & Management
Unanswered

Chat bot using an FAQ list as topics

(0) ShareShare
ReportReport
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 31,144 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

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,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics