msgext-northwind-inventory-csharp

page_type	description	products	languages
sample	This sample implements a Teams message extension that can be used as a plugin for Microsoft Copilot for Microsoft 365. The message extension allows users to query the Northwind Database.	office-teams copilot-m365	dotnet csharp

Northwind inventory message extension sample

This sample implements a Teams message extension that can be used as a plugin for Microsoft Copilot for Microsoft 365. The message extension allows users to query the Northwind Database.

Version history

Version	Manifest version	Date	Author	Comments
1.0.0	1.16	July 08, 2024	Jegadeesh V Wajeed Shaikh	Initial release for Csharp labs

Prerequisites

• Visual Studio 2022 17.10+
• Azure subscription
• Teams Toolkit for Visual Studio
• You will need a Microsoft work or school account with permissions to upload custom Teams applications. The account will also need a Microsoft Copilot for Microsoft 365 license to use the extension in Copilot.
• You will need to create local Azure Storage.

Setup and use the sample

For instructions on setting up and running the sample, see the lab exercises.

Example prompts for Copilot

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.

Single parameter prompts

• 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.

Multi-parameter prompts

• 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.