web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Get answers from a txt...
Copilot Studio
Unanswered

Get answers from a txt or docx file saved in onedrive

(0) ShareShare
ReportReport
Posted on by 3,273

Hello community.

I have been trying to figure out this thing. But it has been almost impossible.

 

Can I develop a chat bot where the user ask for a question and the bot look in a document or text file and retrieve possible answers? Please no premium.

 

Thanks in advance for any help.

Categories:
I have the same question (0)
  • nikviz Profile Picture
    242 on at

    Hi
    You can try one of these 3 methods

     

    1) You can store your question and corresponding answer in an excel in one drive. When user asks a question build a logic using power automate to look into the excel and pull the corresponding answer.

    However, this will work if the user asks the exact wordings as you will have it in your question sheet (as this is a regular expression match).

    Or Instead of questions, have key word phrases which are comma separated or in array and use "contains" logic to pull the corresponding answer.

    2) Consider each question as a Topic and create a topic with trigger words which user may ask and spawn an answer.

    The problem with this would be if there are too many questions, you would have to create that many topics.

    3) Build an AI model (NLP) using BERT/SBERT/ChatGPT where your entire Q&A corpus is trained. When the user asks a question, your AI model is called and based on the word similarity your answer is returned.

    I have written on how to implement this here:
    https://medium.com/@nikviz/integrate-ai-language-models-with-power-virtual-agent-pva-36e357b76734 

  • Sajarac Profile Picture
    3,273 on at

    Hey @nikviz , Thank you very much for your prompt response. Great post BTW.

    Sadly premium stuff always is a limitation.

    But many many thanks for this.

    Regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 303

#2
chiaraalina Profile Picture

chiaraalina 108 Super User 2026 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 94 Moderator

Last 30 days Overall leaderboard