Using Microsoft Copilot Studio to Build Chatbots That Answer Questions and Take Action
Regular 50 minute session for SQLBits 2026TL; 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.
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
-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's other proposed sessions for 2026
AI Beyond the Hype; Practical Solutions for Real Businesses - 2026
Automating Multilingual Document Translation with Microsoft Fabric and Azure AI - 2026
Demystifying AutoML; Building Machine Learning Models with Azure - 2026
Responsible AI in Practice for the Microsoft Data Platform - 2026
Understanding the Complete Data Journey: From Business Problem to Prediction in Microsoft Fabric - 2026
Unlocking Insight from Text Using Azure AI Language Studio - 2026
Lewis Prince's previous sessions
Fast and Efficent Text Analysis using Azure's Language Cognitive Service
We will go on a whirlwind tour of Azure Cognitive Services Language Studio, to show the wealth of tools available there, and then talking in particular about Key Word Extraction, Sentiment Analysis and Opinion Mining. We will apply these concepts through Language Studio APIs via Python on Customer Reviews data to then feed into a Power BI report to show how we can really squeeze so much more useful data out of chunks of text!
Copilot Studio: Guiding Your Chatbot Takeoff with AI Aviation!
I will talk you through how I created the Copilot chatbot for the SQLBits website.
The SQLBits Website ChatBot with Copilot Studio: How I built the chatbot for this events website)
I will talk you through how I created the Copilot chatbot for the SQLBits website.
Model Creation in Azure AutoML and Ingestion Through Excel
We will go through a brief introduction to what Machine Learning is and some of its applications. we will then explore why AutoML should be used by all; as a great starting point for anyone new to Machine Learning, as well as a time saving tool for those more experienced. Finally, we will expose a model as an endpoint and understand how we can use it. Specifically in this case how to use it in excel via VBA.
Technologies I will demonstrate are:
- Azure Machine Learning Studio
- VS code (with Azure Machine Learning Studio extension)
- Python
- VBA