How to Build a Salesforce Copilot Agent in Microsoft Teams in 20 Minutes

Developers can set up a read-only Microsoft Copilot Studio agent that connects to Salesforce and answers plain-English questions by auto-generating and running SOQL queries. The agent returns structured data, such as quote line items and margin figures, directly within Microsoft Teams. A key technical challenge involves Salesforce CPQ's managed package field names, which use the SBQQ__ prefix and do not match their display labels, causing the agent to guess incorrectly if not properly instructed. Placing the correct field names in the agent's Instructions box — rather than the tool's description field — reduced tool calls per query from four to six down to just one. The setup takes roughly 20 minutes and uses a single 'Execute a SOQL query' tool, keeping the agent strictly read-only.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in