Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - Copilot Studio Skills Development
Answered

Get detail infomation from data

(2) ShareShare
ReportReport
Posted on by 18
Hello ,
 
I have a data table in Excel file, which contains 150000 rows of data. I have attached this file to the knowledge folder. When I enter a certain associated serial number, I hope the agent can return me detailed associated values, but the current agent cannot do so, I tried to put the data in the SharePoint list and associate it, but it couldn't return a clear value to me,  Is there any other way to input the serial number and receive detailed information from the agent .
 
 
Categories:
  • JR-06030924-0 Profile Picture
    10 on at
    Get detail infomation from data
    Inst it so that Excel files are not supported in knowledge base? Frequently asked questions about Copilot in SharePoint - Microsoft Support
  • ZY-20030516-0 Profile Picture
    18 on at
    Get detail infomation from data
    Thanks @Michael E. Gernaey ,  I  forgot I can setup some word to let the converssion in specfical topic ,  aWhen a conversation occurs within a specific topic, the success rate of replies is much higher
  • Verified answer
    Michael E. Gernaey Profile Picture
    42,666 Super User 2025 Season 1 on at
    Get detail infomation from data
     
    is the field a string or a number?
     
    I see the trigger says unknown intent can you fix that.
     
    What are your Boost conversational coverage settings?
     
    Could I ask for a small example. Like a single row, where it has the input and the output on the same line so I can see your data. Even if you make up fake data in Excel, as long as its a good fake thats ok. I can even try to repro it myself if I had one of your files.
  • ZY-20030516-0 Profile Picture
    18 on at
    Get detail infomation from data
     
    please see the agent answer ,  I input the number and I am sure the number in the knowledge , but agent can not find it in knowledge .
  • Michael E. Gernaey Profile Picture
    42,666 Super User 2025 Season 1 on at
    Get detail infomation from data
     
    Thank you for the response. Can you give a bit more clarification about what the answer s you are getting?
     
    Can you share the exact steps you are taking and what it responds with please. using pictures.
     
    thanks!!
     
  • ZY-20030516-0 Profile Picture
    18 on at
    Get detail infomation from data
     
    I used to upload the entire table as knowledge, but the results were not good. So I split this database into 35 tables and created an index file, which marked the file name corresponding to which serial number .  I haven't done any other operations yet
     
  • Michael E. Gernaey Profile Picture
    42,666 Super User 2025 Season 1 on at
    Get detail infomation from data
     
    Please share pictures of your configuration, knowledge etc. We really need to see what you did and what you are doing to help you. Anything else would be bad guessing

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >