page_type | description | products | languages | |||
---|---|---|---|---|---|---|
sample |
This sample implements a Teams message extension that can be used as a plugin for Microsoft 365 Copilot. The message extension allows users to query the Northwind Database. |
|
|
This sample implements a Teams message extension that can be used as a plugin for Microsoft 365 Copilot. The message extension allows users to query the Northwind Database.
Version | Manifest version | Date | Author | Comments |
---|---|---|---|---|
1.0 | 1.16 | November 15, 2023 | Bob German Garry Trinder Rabia Williams |
Initial release for Ignite 2023 labs |
1.1 | 1.16 | December 7, 2023 | Bob German | Parameters are now passed by name not value |
- Node.js 18.x
- Visual Studio Code
- Teams Toolkit
- You will need a Microsoft work or school account with permissions to upload custom Teams applications. The account will also need a Microsoft 365 Copilot license to use the extension in Copilot.
For instructions on setting up and running the sample, see the lab exercises.
Here are some ideas for prompts to try. If you don't get the result you expect, try typing "new chat" and then trying again.
-
Find Chai in Northwind Inventory
-
Who supplies discounted produce to Northwind?
-
Find high revenue products in Northwind. Have there been any ad campaigns for these products?
[!NOTE] The ad campaign details are in the sample documents.
-
Find northwind dairy products that are low on stock. Show me a table with the product, supplier, units in stock and on order. Reference the details for each product.
(then)
OK can you draft an email to our procurement team asking them if we've had any delivery issues with these suppliers?
-
Find Northwind beverages with more than 100 units in stock
(then)
What are the payment terms for these suppliers?
[!NOTE] The answer to the 2nd question is in the sample documents.
-
We’ve been receiving partial orders for Tofu. Find the supplier in Northwind and draft an email summarizing our inventory and reminding them they should stop sending partial orders per our MOQ policy.
[!NOTE] The MOQ policy is in one of the sample documents.
-
Northwind will have a booth at Microsoft Community Days in London. Find products with local suppliers and write a LinkedIn post to promote the booth and products.
(then)
Emphasize how delicious the products are and encourage people to visit our booth at the conference
-
What beverage is high in demand due to social media that is low stock in Northwind in London. Reference the product details to update stock.
[!NOTE] There is a document that discusses a social media campaign for one of the products in the sample documents.