Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Microsoft 365 and SharePoint Online Cookbook
Microsoft 365 and SharePoint Online Cookbook

Microsoft 365 and SharePoint Online Cookbook: A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Copilot and more , Second Edition

Arrow left icon
Profile Icon Mahajan Profile Icon Scott Brewster Profile Icon Sudeep Ghatak Profile Icon Nate Chamberlain
Arrow right icon
Free Trial
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (22 Ratings)
Paperback Feb 2024 640 pages 2nd Edition
eBook
NZ$31.99 NZ$46.99
Paperback
NZ$40.99 NZ$58.99
Subscription
Free Trial
Arrow left icon
Profile Icon Mahajan Profile Icon Scott Brewster Profile Icon Sudeep Ghatak Profile Icon Nate Chamberlain
Arrow right icon
Free Trial
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (22 Ratings)
Paperback Feb 2024 640 pages 2nd Edition
eBook
NZ$31.99 NZ$46.99
Paperback
NZ$40.99 NZ$58.99
Subscription
Free Trial
eBook
NZ$31.99 NZ$46.99
Paperback
NZ$40.99 NZ$58.99
Subscription
Free Trial

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Microsoft 365 and SharePoint Online Cookbook

Introduction to SharePoint Online

SharePoint Online is part of the Microsoft 365 ecosystem that facilitates collaboration and productivity in organizations by empowering its users with tools to create and share content. At its core, SharePoint is a content management system that gives its users places, such as sites, lists, and libraries, where they can create and store documents and data. It also lets its users collaborate on this content by allowing it to be securely shared with others within or outside the organization. Users are also able to securely find this content through the powerful Microsoft Search capability.

Additionally, SharePoint enables an organization to effectively communicate through rich pages, engaging tools, and web parts. We will go over these areas in more detail throughout the book, first introducing them in Chapter 3, Modern Sites in SharePoint Online.

SharePoint integrates well with a lot of other tools within and outside of the Microsoft 365 ecosystem...

Getting to the SharePoint start page

The SharePoint start page is the central location that shows you relevant content from all the SharePoint sites that you have access to in your organization. From here, you can easily get to the sites that you are following, frequently visit, or have recently visited. This page also lets you search for content across all the SharePoint sites that you may have access to.

This recipe shows you how to log in to Microsoft 365 and then browse to the SharePoint Online home page from there.

Getting ready

To be able to browse to the SharePoint start page, your organization should have purchased one of the Microsoft 365 products that contain SharePoint. In addition, they should have assigned you a license to use SharePoint Online.

How to do it...

You can follow these steps to access the SharePoint Online home page:

  1. Browse to www.office.com and click the Sign in button.
  2. Log in using your email ID and password.
  3. You...

Creating a modern site

SharePoint provides various templates or site types so that you can create sites. These templates use similar building blocks but create slightly different sites in the end that help target different collaboration and communication goals. These templates differ from each other in various ways, such as how they store information, how they present it, and even the features that they offer.

This recipe shows you how to create a site using the Team site template, which is the most commonly used site template for team collaboration.

Getting ready

Your organization should do the following before you can create sites from the SharePoint start page:

  • Grant you access to SharePoint as part of the Microsoft 365 suite
  • Enable the creation of sites from the SharePoint start page
  • Enable the creation of modern sites in your Microsoft 365 environment

How to do it...

To create a new site from the SharePoint start page, follow these...

Viewing site contents

The Site contents page in SharePoint provides a one-stop view of all the lists, libraries, and other apps within the site. Any subsites within that site will also appear here. Provided you have appropriate access, you can also add new lists, libraries, pages, apps, and subsites to the site from this page.

Getting ready

You should have at least Read or View access to a site in order to be able to view the contents within that site.

How to do it...

To view the contents of your site, follow these steps:

  1. Browse to your site in SharePoint.
  2. Click on the settings icon in the top-right corner of any page on the site and then click Site contents, as shown in the following screenshot:

Figure 2.15: Opening the site settings to reach the Site contents page

  1. You will be directed to the Site contents page, as shown in the following screenshot:

Figure 2.16: Viewing Site contents from Site settings > Site...

Creating a list

A SharePoint list is a table-like container that stores information similar to an Excel spreadsheet or a database table. A key difference between Excel files or database tables and lists is that the information in lists is automatically shared with and available to other users that have access to those lists.

This recipe shows you how to create a new list from scratch. For illustrative purposes, we will use this list to store details of the products from our company’s product line. This list will contain the following columns to store the product information:

  • Title
  • Code Name
  • Product Line
  • Date Released
  • Notes

Getting ready

You will need either Edit, Design, or Full Control permission on the site where you’d like to create the list. You will usually have this permission if you are part of the Site owners or Site members groups for the site where you would like to create the list.

How to do it...

...

Adding an item to a list

You can add items to lists in various ways. This recipe will show the most used method to add items to the representative list we created as part of the previous recipe. The other methods to add list items will be covered in greater detail in Chapter 4, Lists and Libraries in SharePoint Online. Even though this recipe uses the Products list as an example, the steps provided here can be used to add items to any list.

Getting ready

You will need Contribute permissions or higher for the list you would like to add the new item to. You will usually have this permission if you are part of the Site owners or Site members groups for the site containing the list.

How to do it...

To add a new item to a list, follow these steps:

  1. Browse to the list where you’d like to add the new item.

    You can also access the lists and libraries through the Site contents page. The Viewing site contents recipe earlier in this chapter shows...

Creating a document library

A library is a secure place in SharePoint where you can upload, create, edit, and manage files for online sharing and collaboration with your team. Just like lists, each library comes with key built-in columns that automatically store default information about each file, such as who created the file and when, and who last modified it and when. You can always add your own columns to the library, just as you would for a list. Each SharePoint site ships with one or more libraries to enable you to store files within the site. Libraries can be of different types. A document library is the most used type of library. As the name suggests, it is used to store, manage, and share documents. The Site pages library is used to store and manage pages and news items. The Inbuilt list and library templates topic of the Creating a list using a built-in list template recipe in Chapter 4, Lists and Libraries in SharePoint Online, provides a list of all the inbuilt templates...

Uploading documents to a library

SharePoint lets you create new documents directly within a library through the New menu. It also lets you upload documents that have been authored offline.

In this recipe, we are going to learn how to upload an existing document to a document library and then associate metadata to it. Even though this recipe uses the Marketing Collateral library, which we previously created as an example, the steps here work for any SharePoint library.

Getting ready

You will need Contribute permissions or higher to the library where you would like to upload the document. You will usually have this permission if you are part of the Site owners or Site members groups for the site containing the library.

How to do it...

Here’s how to upload a document to your document library:

  1. Browse to the library where you’d like to upload the document.
  2. Click Upload and then choose the Files option to open the file selection dialog...

Deleting and restoring a file

In this recipe, you will learn how to delete a SharePoint document and then restore it from your site’s recycle bin.

Getting ready

You will need to be able to access a document library in a SharePoint site for which you have at least Contribute permission or higher. You will usually have this permission if you are part of the Site owners or Site members groups for the site containing the library.

How to do it...

To delete a file:

  1. Select the ellipsis () next to a file, then Delete.

Figure 2.40: Deleting a file from an item’s context menu

  1. Confirm the deletion on the pop-up dialog by selecting Delete. Watch for the status notification in the upper-right corner letting you know the file was successfully deleted:

    Figure 2.41: Deletion notification

    To restore a file:

  1. Select Recycle Bin from the left-hand navigation menu (team sites only) or follow the Viewing...

Sharing a document

Once you’ve uploaded your document to SharePoint Online, you can simply use Share or Copy link to easily share it with your colleagues. This recipe shows you how to share a link to a document using the Share feature.

Getting ready

You should have at least Read access to the document you’d like to share.

How to do it...

To share a document with a member of your team, follow these steps:

  1. Browse to the document you’d like to share.
  2. Click the Share (Share option on the top menu bar, as shown in the following screenshot:

Figure 2.49: Icon for sharing an item on the right of the item name

  1. On the pop-up box that appears, click the gear icon on the right of the filename to open Sharing settings:

Figure 2.50: Opening Sharing settings with the icon to the right of the filename

  1. This will open the Sharing settings dialog, which allows you to select one of the following options...

Searching content

Search is a core part of the SharePoint user experience. It enables users to find relevant business information and documents more quickly and easily than ever before.

For this recipe, I am going to act as a marketing manager who would like to search for our visual design guide, which I remember is called “Branding Elements.”

Getting ready

All you need is Read access to the site where you will be performing your search. The results that SharePoint returns are security trimmed, which means you will only see content that you have access to through direct or indirect permissions.

How to do it...

To perform a search within a site, follow these steps:

  1. Browse to any page on the site where you’d like to perform the search. In our example, I will browse to my Sales and Marketing site.
  2. Start typing your search keywords to see the relevant results. In this case, we will start typing Branding Elements. We’ll notice...
Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Enhance collaboration and productivity using SharePoint, Teams, OneDrive, Viva, Planner, and Microsoft Forms
  • Automate processes, build apps, bots, and dashboards with Power Automate (with RPA), Power Apps, Copilot Studio, and Power BI
  • Harness Copilot, the new AI virtual assistant, for seamless support in your everyday tasks

Description

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.

Who is this book for?

This cookbook caters to professionals stepping into the world of Microsoft 365 and SharePoint Online. It is tailored for a broad spectrum of skillsets including general business professionals, IT administrators, and enterprise architects who are newcomers to Microsoft 365, offering valuable insights for establishing a contemporary, digital workplace effectively.

What you will learn

  • Collaborate effectively with SharePoint, Teams, OneDrive, Delve, Search, and Viva
  • Boost creativity and productivity with Microsoft Copilot
  • Develop and deploy custom applications using Power Apps
  • Create custom bots using Power Virtual Agents (Copilot Studio)
  • Integrate with other apps, automate workflows and repetitive processes with Power Automate/Desktop (RPA)
  • Design reports and engaging dashboards with Power BI
  • Utilize Planner, To Do, and gather feedback with polls and surveys in Microsoft Forms
  • Experience seamless integration in the mobile platform

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Feb 29, 2024
Length: 640 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803243177
Vendor :
Microsoft
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Feb 29, 2024
Length: 640 pages
Edition : 2nd
Language : English
ISBN-13 : 9781803243177
Vendor :
Microsoft
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just NZ$7 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just NZ$7 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total NZ$ 152.97 190.97 38.00 saved
Microsoft 365 and SharePoint Online Cookbook
NZ$40.99 NZ$58.99
Mastering PowerShell Scripting
NZ$45.99 NZ$65.99
Learn Microsoft Power Apps
NZ$65.99
Total NZ$ 152.97 190.97 38.00 saved Stars icon

Table of Contents

14 Chapters
Overview of Microsoft 365 Chevron down icon Chevron up icon
Introduction to SharePoint Online Chevron down icon Chevron up icon
Modern Sites in SharePoint Online Chevron down icon Chevron up icon
Lists and Libraries in SharePoint Online Chevron down icon Chevron up icon
Document Management in SharePoint Online Chevron down icon Chevron up icon
OneDrive Chevron down icon Chevron up icon
Microsoft Teams Chevron down icon Chevron up icon
Power Automate (Microsoft Flow) Chevron down icon Chevron up icon
Creating Power Apps Chevron down icon Chevron up icon
Applying Power Apps Chevron down icon Chevron up icon
Power BI Chevron down icon Chevron up icon
Overview of Copilot in Microsoft 365 and Power Platform Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(22 Ratings)
5 star 100%
4 star 0%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




bradley wyatt Apr 18, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book does a great job going into the details surrounding Microsoft SharePoint, Microsoft Teams, Power Platform, and CoPilot in M365 and the Power Platform. The pacing of the book stands out as it begins with discussing the platform(s), interfaces, and key words and then dives into configuration, permissions, etc.
Amazon Verified review Amazon
Adam Clifford Apr 19, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book makes it easy to find and perform common tasks in SharePoint, OneDrive, and Teams with some Copilot and power automate content added in as well.The recipe concept is great with each entry broken down into “Getting Ready”, “How to do it”, and “How it works” it’s an excellent go to reference to get additional info on configurations and I really appreciate they that take the time to explain why why’s and just not the how’s as so often is the case.This will definitely.l stay on my reference shelf for all future SharePoint projects!!
Amazon Verified review Amazon
Ayon Roy May 30, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
As a dedicated user of the Microsoft 365 ecosystem for my day-to-day activities, I was on the lookout for a comprehensive resource that combines the power of AI with the full potential of Microsoft 365. That's when I discovered the “Microsoft 365 and SharePoint Online Cookbook” by Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, and Scott Brewster.Reading through this book was an eye-opener! 🌟 The level of functionality within the Microsoft 365 ecosystem is astounding, and I realized I've only been scratching the surface. Here are some key takeaways from the book that blew me away:Microsoft 365 Ecosystem Overview: The book begins with a thorough overview of the ecosystem, highlighting the incredible capabilities of SharePoint. From creating sites and managing documents with ease to adding applications, creating subsites, and organizing everything through lists and libraries, SharePoint truly allows you to build your own mini-universe.Advanced Use of OneDrive and Teams: I learned advanced techniques for leveraging OneDrive and Teams. For instance, I added a GitHub connector to my Teams chat, making it super easy to track activities directly from my workspace.Power Automate: The step-by-step guide on Power Automate was particularly enlightening. This workflow engine helps you create automated workflows with existing services, simplifying daily tasks significantly.Power Apps: The book delves into building custom applications using Power Apps. The setup process in Power Apps Studio is straightforward, allowing you to connect to your business data effortlessly.Power BI: I also refreshed my knowledge of Power BI, learning how to harness its functionalities and embed reports on SharePoint pages seamlessly.AI Integration with Copilot: As an AI enthusiast, I was thrilled to explore how Copilot can enhance the Power Platform. The book provides valuable resources on using Copilot to build apps through conversations and generate/edit DAX in Power BI.Overall, this book is a fantastic guide for anyone looking to maximize their use of the Microsoft 365 ecosystem, enriched with powerful integrations and AI functionalities that can transform your daily workflow. Highly recommended for both beginners and advanced users looking to unlock the full potential of Microsoft 365!
Amazon Verified review Amazon
Gerry O. Brien Aug 18, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I've read many "cookbook" style books in the past only to be left less than satisfied with lack of real content. Sure, you can put together step-by-step instructions as a "recipe", but they don't offer much beyond simply following instructions.This book differs because it tells you about the feature first, why it is used and why it is important. Then you work through an exercise to implement the feature. Finally, the all important summarization of what you did, how you did it, and why you did it, completes the actual learning process.Highly recommended.
Amazon Verified review Amazon
Thomas Rice Apr 09, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The second edition of the "Microsoft 365 and SharePoint Online Cookbook" is highly praised and recommended for individuals engaged with SharePoint and the Power Platform. It is recognized as a crucial resource in the vast landscape of technology learning materials, particularly valuable for its practical guidance on using various Microsoft Office 365 applications. The book focuses on SharePoint Online, Power Platform, and Copilot, offering a straightforward and user-friendly approach. It provides a structured learning path, with early chapters dedicated to SharePoint, followed by sections on OneDrive, Teams, Power Automate, Power Apps, Power BI, and concluding with Copilot and the Power Platform. With 610 pages of content, this book is seen as a go-to reference that readers will continually find useful and is a cherished addition to my personal library.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.