22-25 April 2026

Using Microsoft Copilot Studio to Build Chatbots That Answer Questions and Take Action

Regular 50 minute session for SQLBits 2026

TL; DR

Chatbots can do more than answer questions. This session shows how to quickly build task-driven chatbots with Copilot Studio that use SharePoint and web content, integrate with Teams, and automate actions like emails and spreadsheet updates.

Session Details

This session demonstrates how powerful, task-driven chatbots can be created quickly using Microsoft’s Copilot Studio, with minimal technical effort. Attendees will see how chatbots can answer questions, automate actions, and integrate directly into everyday tools used across the organisation.

Through live demonstrations, we will build two chatbots based on different real-world use cases, using websites and SharePoint directories as knowledge sources. These bots will then be exposed instantly to Microsoft Teams, showing how conversational AI can be delivered to users without custom front-end development.

Beyond answering questions, the session shows how chatbots can be configured to perform actions, such as sending emails and writing data to spreadsheets. Alongside the demos, we will cover the core principles of effective chatbot design and discuss practical applications and benefits across a range of business scenarios.

By attending this session, you will learn how to design and build chatbots using existing content sources, how to deploy chatbots quickly into channels such as Microsoft Teams, how to enable chatbots to perform real actions like sending emails and updating spreadsheets, how these tools fit into the wider Copilot ecosystem, and how to identify use cases where conversational AI can deliver meaningful business value.

This session is aimed at data and technology professionals who want to understand how conversational AI can move beyond simple Q&A and become a practical, productivity-boosting tool within the Microsoft platform.

3 things you'll get out of this session

-How to design and build chatbots using existing content sources
-How to deploy chatbots quickly into channels such as Microsoft Teams
-Identify use cases where conversational AI can deliver meaningful business value

Speakers

Lewis Prince

thedatarhino.wordpress.com