Copilot Studio - Copilot Studio Skills Development

Get detail infomation from data

Like (2) Share

Report

Posted on 31 Mar 2025 05:16:50 by ZY-20030516-0

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:

Extensibility

All responses (5)

Answers (0)

Suggested answer

Michael E. Gernaey 38,415 Super User 2025 Season 1 on 31 Mar 2025 at 23:33:16

Like (0)

Report

Get detail infomation from data

hi @ZY-20030516-0

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 8 on 31 Mar 2025 at 11:11:40

Like (0)

Report

Get detail infomation from data

Hi @Michael E. Gernaey ,

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 .

Snipaste_2025-03-...
Michael E. Gernaey 38,415 Super User 2025 Season 1 on 31 Mar 2025 at 08:40:53

Like (0)

Report

Get detail infomation from data

Hi @ZY-20030516-0

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 8 on 31 Mar 2025 at 07:09:21

Like (0)

Report

Get detail infomation from data

HI @Michael E. Gernaey ,

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 38,415 Super User 2025 Season 1 on 31 Mar 2025 at 06:03:42

Like (0)

Report

Get detail infomation from data

Hi @ZY-20030516-0

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

Community site session details

Get detail infomation from data

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Get detail infomation from data

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates