Unexpected Response Behaviior

(1) Share

Report

Posted on by Donn Jenson

I created a simple copilot using a simple Dataverse table for its knowledge source. The table has 6 columns, firstname, lastname, email address, organization, phone number and message. Of course, there are also the system columns such as the record name that the Dataverse adds out of the box.

When I do a prompt like "give me a summary of al the records created on a certain date" it works and it includes some data from the message column. But if I ask which records contain a certain word in the message column, it tells me there are zero records even though I know there are some records containing that word. I know the copilot is seeing the message column but for some reason it won't search the message column. Does anyone know why the copilot is displaying this behavior?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vinoth Selvam 1,592 Super User 2025 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi DJ-26091853-0,

In General, when we specify the dataverse knowledge source directly to Copilot it provides response that are limited.

We need to customize more using Custom Actions or Custom Prompts to make it work better.

I have been trying using Custom Prompt using AI builder and it works extremely well. You can also try that approach which i given below. You can modify the prompts according to your requirements.

You can follow my below links.

https://msdcentral.site/co-pilot-studio-how-to-use-ai-builder-integrate-with-dataverse-in-co-pilot/

https://community.powerplatform.com/blogs/post/?postid=4dcb4681-1985-ef11-ac20-7c1e5246e2b5

Hope this can help.

Thanks.

Was this reply helpful? Yes No
Donn Jenson 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you Vinoth! I will check out your links and let you know how it goes.

Was this reply helpful? Yes No
Vinoth Selvam 1,592 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please do let know if that works for you !

Was this reply helpful? Yes No