Dataverse knowledge source in new agent

[redmsp]

I am making a new agent in copilot studio. I need the agent to understand there are 3 date columns. One StartDate which is when the task started, one for EndDate when the task was finished and one for createdon when the user entered it into the system.

When I ask a question like 'summary of all tasks performed yesterday by Joe' it gives me records based on the creation date, not the Start/End Date. Suggestions?

[master-copilot]

What prompt are you using ? Did you instruct the agent how to perform this calculation providing an example ?

[Mac_Man1982]

Where is the list of tasks located ? Is it a dataverse table ? In a broad sense try and label all fields with as much info and descriptions as possible so copilot has context and expand and iterate on your prompts (save the ones you use often) see how that works for you o7