Book Image

Microsoft 365 and SharePoint Online Cookbook

By : Gaurav Mahajan, Sudeep Ghatak
Book Image

Microsoft 365 and SharePoint Online Cookbook

By: Gaurav Mahajan, Sudeep Ghatak

Overview of this book

Microsoft Office 365 provides tools for managing organizational tasks like content management, communication, report creation, and business automation processes. With this book, you'll get to grips with popular apps from Microsoft, enabling workspace collaboration and productivity using Microsoft SharePoint Online, Teams, and the Power Platform. In addition to guiding you through the implementation of Microsoft 365 apps, this practical guide helps you to learn from a Microsoft consultant's extensive experience of working with the Microsoft business suite. This cookbook covers recipes for implementing SharePoint Online for various content management tasks. You'll learn how to create sites for your organization and enhance collaboration across the business and then see how you can boost productivity with apps such as Microsoft Teams, Power Platform, Planner, Delve, and M365 Groups. You'll find out how to use the Power Platform to make the most of Power Apps, Power Automate, Power BI, and Power Virtual Agents. Finally, the book focuses on the SharePoint framework, which helps you to build custom Teams and SharePoint solutions. By the end of the book, you will be ready to use Microsoft 365 and SharePoint Online to enhance business productivity using a broad set of tools.
Table of Contents (22 chapters)

Connecting to data sources

Power Apps lets you build business applications that use data from line-of-business applications. Using Power Apps, you can build apps that work with local as well as connected data sources.

Connected data sources are external to Power Apps such as Excel spreadsheets, SharePoint lists, OneDrive for Business, Dropbox, and SQL Server.

Local data sources save the data in data tables within Power Apps. Collections are one such data source that gets stored within the Power App when the Power App is saved and published.

We will see how you can connect to data sources in this recipe.

Getting ready

You need Power Apps plan included in your Microsoft 365 subscription in order to build a Power App. Download the Cars.xlsx file from Chapter 14 folder in the GitHub repository of this book here and save the file in your OneDrive for Business.

How to do it ...

To connect to a...