Book Image

Microsoft 365 and SharePoint Online Cookbook - Second Edition

By : Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, Scott Brewster
Book Image

Microsoft 365 and SharePoint Online Cookbook - Second Edition

By: Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, Scott Brewster

Overview of this book

Microsoft 365 offers tools for content management, communication, process automation, and report creation. Microsoft 365 and SharePoint Online Cookbook maximizes workplace collaboration and productivity using SharePoint Online, Teams, OneDrive, Delve, M365 Search, Copilot, Power Platform, Viva, Planner, and Microsoft Forms. You will find thoroughly updated recipes for SharePoint Online, covering sites, lists, libraries, pages, web parts, and learn SharePoint Framework (SPFx) basics for building solutions. You will explore many Microsoft Teams recipes to prepare it to be your organization’s central collaboration hub. You will be able to unlock Power Platform potential with recipes for Power Apps to enable low-code/no-code app development and learn to automate tasks with Power Automate and Power Automate Desktop. The book teaches you data visualization with Power BI, and chatbot creation with Power Virtual Agents (Copilot Studio). Finally, you will also learn about the cutting-edge Copilot and Gen AI functionality in Microsoft 365 and Power Platform. By the end, you will be equipped with skills to effectively use Microsoft 365, SharePoint Online, and the Power Platform. Whether it's enhancing career prospects or improving business operations, this book is a perfect companion on your journey through the Microsoft Office 365 suite.
Table of Contents (15 chapters)
13
Other Books You May Enjoy
14
Index

Creating a canvas app from a blank template

Power Apps has several templates that give you a head start in creating an app; however, if you want to start from scratch, you can start with a blank template. The following example demonstrates how you can create an app from scratch. The app queries data from a spreadsheet in your OneDrive for Business. This demonstration only focuses on the basics and doesn't go into detail on building a fully functional solution.

It is recommended that you start with a template that closely resembles what you are trying to build. This will save you a lot of time and effort.

In the next section, we will build an app that gets a list of cars from an Excel spreadsheet that is stored in OneDrive for Business:

Figure 14: Sample Data Source

Although we can extend this app to add/update and delete records from the spreadsheet, our intention is to just introduce the users to the concept of a screen, a control, and a data connection.

Getting ready

You need...