I want to get the data source used and referenced to answer questions in Copilot Studio

Hello Hashimoto, Mirai,
You’re on the right track: the Conversation Transcript table in Dataverse only logs interactions for Copilot Studio agents in web or test chat—not for Teams or Microsoft 365 Copilot conversations. To capture knowledge URLs for all channels, you’ll need a custom approach.

The default Transcript table stores basic metadata but does not include Teams/M365 Copilot sessions and usually omits knowledge-source URLs unless specifically configured. To reliably capture these URLs, enable ContentLocation in Copilot Studio’s knowledge settings or build a custom Dataverse logging table (e.g., CopilotKnowledgeLog) that stores the conversation ID, question, answer, and the extracted source URL.

Use Power Automate to write entries to this table by triggering on each Copilot response, parsing the response payload, and mapping ContentLocation to your URL field. For Teams/M365 Copilot, capturing requires the Direct Line API or a custom connector because those channels don’t log into Dataverse automatically.

Enhance the solution by enabling “Include links in responses,” mapping SharePoint/OneDrive URLs, and applying security, retention, and governance best practices.

Reference Document:
https://microsoft.github.io/TechExcel-Designing-your-own-copilot-using-copilot-studio/docs/Ex05/Ex05.html

To get the data source used and referenced to answer questions in Copilot Studio, you can utilize the knowledge sources configured in Copilot Studio. When you set up your Copilot, you can select various knowledge sources such as public websites, SharePoint, Dataverse, and file uploads. Each of these sources can provide the necessary URLs for the content used in the answers.

In your Power Automate flow, you can configure it to collect the relevant data from the Conversation Transcript table, but since it doesn't record Teams and Microsoft 365 Copilot conversations, you may need to create a custom page or a custom logging mechanism to capture this information. Make sure to include the ContentLocation property in your custom data setup, which can hold the URL for the citation of the source content.

By doing this, you will be able to track the knowledge URLs used in the answers generated by Copilot Studio.