Announcements
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
Generative Answers over SharePoint will respond based on files stored in Document Libraries, but currently it does not support excel. You can, however, try using a word document with a collection of questions and answers.
As for removing links, I'm not sure it's advised as copilots should be transparent about the facts that ground their responses, but it can be done: uncheck "send a message", store the response in a variable, and remove the citations:
Open "properties" for your Gen Answers node:
Remove citations from the answer stored in a variable:
Sorry for dragging up an old topic but has anyone managed to achieve removing citations from an answer stored as a variable in an automated way?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
sannavajjala87 206 Super User 2026 Season 1
11manish 147
Haque 119
