What is the best way to build a QnA chatbot in PVA that has predefined QnA pairs in 2 columns viz "Question' and "Answer" in an excel? The excel with be stored in a Sharepoint Document Library. Also, I want the chatbot to be able to give the respective answer to the question and not give the link to the full document.
Greatly appreciate any help in this regard
Hi @saurabhun
If you don't want to give the link to the document you will have to call a power automate flow, pass the user question, find the answer in your XLS document using Power Automate and return the answer to your chatbot.