Build an Order App from Excel with Copilot Code (Full Transcript)
[00:00:00] Speaker 1: In this video, I'll show you how to build your own app using copilot code without writing a single line of code. We'll start with a spreadsheet of customer orders and turn it into an interactive app where we can track sales, manage orders, and see which products are selling best. And a quick disclosure, Microsoft is sponsoring this video, but as always, I'll show you exactly how it works and the results that I get. I'm Kevin and let's dive in. To get started, head over to the copilot app and sign in with your work account. Over on the left-hand side, click on code. This opens copilot code where you can create working solutions simply by describing what you want. Now copilot code's availability depends on when you're watching and your organization's access and settings, so you might not see it just yet. In the center of the screen, there's a prompt box where you can enter instructions. With WorkIQ, you can reference your emails, Teams chats, and other files so copilot can draw on the context of your work. Right over here, you can choose which AI model to use, and if we go back, you can also adjust the effort settings. For now, I will leave those to copilot with auto. At the bottom, there are also some suggested prompts if you're looking for inspiration. I have an idea for what I want to build, so let's jump straight in. I have a spreadsheet for my small business, The Kevin Cookie Company. It contains customer orders, including the type of cookie, the quantity, price, and whether each order has been fulfilled. Instead of managing everything in a spreadsheet, I want to turn this into an app where I can see how the business is doing and also keep track of all the different orders that still need to go out. Back in copilot, I'll drag in my spreadsheet to attach it. Then here in the prompt field, I'll describe the app I want to build. Feel free to pause if you'd like to read it. If you'd like to follow along, I've included both the spreadsheet and the prompt in the video description below. Over here, let's send that. Copilot will now generate the app based on our instructions and spreadsheet. Copilot is asking whether I want to save the order data to SharePoint. This would allow the app to work with data stored outside the app and keep it updated across sessions. I'll keep the data within the app itself to keep things simple. I'll select no, keep it local, and here it is. Copilot has finished building our app. Let's take a look at what it created. From a spreadsheet, Copilot created this entire order dashboard complete with charts, filters, and all of our customer orders. Now right here at the top, we can see our total sales. We have 120 customer orders and also how many orders are still pending. And there we see our best-selling cookie. It looks like it's double chocolate. That is a tasty one. Now down below, we have a chart showing us which cookies are selling the best. We can switch between the number of cookies sold and the revenue generated. And here's something neat. These charts are fully interactive. If I click on double chocolate, the entire dashboard updates to show just those orders. Over on the right, we can see a breakdown of orders by status. I can click on pending to see just the orders that still need to go out. And down below, we have a table with all of our customer orders. I can search for a specific customer, like let's say Sophia. Now, I could also filter by the cookie type. And here, I can also filter by the order status. And along with that, I can also sort all of the columns. And all of this came from a single prompt and our Excel spreadsheet. We didn't have to write any code. Now, this app already looks pretty good, but there's something missing. We can view the customer orders, but we can't add new ones or update existing ones. Let's head back to Copilot Code and add in those capabilities. In the bottom left corner, I'll enter the following prompt. Feel free to pause if you'd like to read it. Then over here, let's send it. Now, Copilot will update our existing app and add the new functionality. It's all finished making our changes. Let's scroll down a little bit, and let's try adding a new order. I'll click here, type in the customer name. Let's go with double chocolate, and we'll go with 20 cookies. Over here, I'll choose a delivery date, and we'll leave the status set to pending. Down below, I'll click on create order, and there it is. The new order appears in the table, and the dashboard updates automatically. We can also update existing orders. I'll scroll down, and here's an order from Isabella. It turns out this has actually been fulfilled, so I'll select this, change it to fulfilled, and if we scroll right up above, the dashboard reflects the change. If you're curious, you can also look at the files and code that Copilot generated behind the scenes. Up on top, let's open a new tab and then select files. Here, we can see all the files that power this app, but as you've seen, we didn't have to write or edit any of this code ourselves. Up on top, let's close out of this view. When we first created our app, Copilot created a working preview for us. Since then, we've made some changes, including the ability to add new orders and also edit existing orders. Those changes are currently only in our preview. This lets us continue making improvements and testing them without affecting the published version. Now that we're happy with everything, in the top right-hand corner, let's click on publish to make these latest changes available, and just like that, the updated app is live. Now, I could click right here to open the app in its own browser tab, and here's our finished app. If I click on home in the top left-hand corner, I can see all the apps I've created along with any apps that others have shared with me. To share the app, let's head back to Copilot. Back in Copilot, in the top right-hand corner, I'll click on the share icon. Here, I can choose to share the app with specific people, or I could also make it available to everyone in my organization. I'll leave it set to everyone in my organization, and then right over here, I'll click on copy link. Now, I could send this link to a colleague, and they can open the app directly in their browser. And that's how you can turn your context into a working app using Microsoft Copilot Code. And, of course, apps is just one example of what you can create in Copilot Code. You can also create dashboards and internal apps, although some capabilities are still rolling out. If you'd like to try it yourself, I've included the spreadsheet and the prompts in the description below. Thanks for watching, and I'll see you in the next video.
- Copilot Code can generate an interactive app from a spreadsheet and a natural-language prompt.
- The generated dashboard can include key sales metrics, charts, filtering, search, sorting, and order-status views.
- Users can choose to keep data local to the app or store it in SharePoint for persistent, shared data.
- Additional functions, such as creating and editing orders, can be added through follow-up prompts.
- Changes can be tested in preview before publishing the updated app.
- Published apps can be shared with individuals or everyone in an organization via a link.
- Feature availability may vary based on rollout timing and an organization's Copilot access and settings.