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)

Transforming data

Data transformation refers to the process of converting data from one format to another. This could require simple or complex data manipulation, based on the nature of the data.

In most cases, the data that you retrieve from a data source is not in a format where it can be used as-is, and you might have to take some additional steps to clean it.

Examples of basic transformations include the following:

  • Changing data types
  • Filtering (rows and/or fields)
  • Creating conditional columns
  • Splitting columns
  • Renaming/reformatting

Some examples are as follows:

  • Getting rid of trailing spaces at the end of a text field
  • Reconciling multiple formats saved in a date field (such as Jan-19, Jan 2019, 01-19, and so on)
  • Concatenating Title, First Name, Last Name, and so on to get the person's name

Hence, the first step after retrieving...