Power Platform Community Forum Thread Details

Copilot Studio Agent capabilities with multiple dataverse table as knowledge source

I'm creating an agent that have 3 Dataverse tables as knowledge source.

This can be a short summary of the tables

- product table

- price table

- processes table

The product table have a lookup to the price table (N:1 relation)

The processes table have a lookup to the price table (N:1 relation)

I've tried any sort of prompt, instruction or description to let the agent be able to reason on these tables, but I am never able to have a result for my questions.

One of the question i would like the agent to be able to answer/solve is: "Between all the products that have the field X populate with the value Y give me which is the one that have the max an minimum price.". The chain of thought for this question should be: query the product table with the filter "field X = Y" and then for the set of data retrieved taking in consideration all the related rows in the table "price table" and then going with the max - min for a specific row.

Am I giving to much capabilities to copilot studio or I am probably doing something wrong

Thanks so much

Categories:

General

Quick Links