All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Microsoft 365 and SharePoint Online Cookbook - Second Edition

You're reading from Microsoft 365 and SharePoint Online Cookbook - Second Edition

Product type Book

Published in Feb 2024

Publisher Packt

ISBN-13 9781803243177

Pages 640 pages

Edition 2nd Edition

Languages

Concepts

Information Management

Authors (4):

Gaurav Mahajan

Sudeep Ghatak

Nate Chamberlain

Scott Brewster

View More author details

Table of Contents (15) Chapters

Preface

1. Overview of Microsoft 365

2. Introduction to SharePoint Online

3. Modern Sites in SharePoint Online

4. Lists and Libraries in SharePoint Online

5. Document Management in SharePoint Online

6. OneDrive

7. Microsoft Teams

8. Power Automate (Microsoft Flow)

9. Creating Power Apps

10. Applying Power Apps

11. Power BI

12. Overview of Copilot in Microsoft 365 and Power Platform

13. Other Books You May Enjoy

14. Index

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 https://m365book.page.link/github and save the file in your OneDrive for Business.

How to do it ...

To connect to a data source, do the following steps:

Open the Power Apps designer...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €14.99/month. Cancel anytime}

Authors (4)

Gaurav Mahajan

Gaurav Mahajan is a Microsoft Technology Solutions Professional who specializes in Microsoft 365, SharePoint, and AI, with over 19 years of technical consulting experience. Gaurav has a bachelor's in engineering, is Stanford certified in machine learning, and holds a PG Diploma in management from the Indian Institute of Management. He speaks at and organizes technical events, code camps, and conferences. He is a co-chair of the M365 & SharePoint Saturday, Pittsburgh (US) annual conference.

See other products by Gaurav Mahajan

Sudeep Ghatak

Sudeep Ghatak is a Microsoft MVP in Business Applications and a frequent contributor to the Power Automate Community forum. He works as a Principal Architect in Christchurch, New Zealand and loves designing solutions based on Office 365 and the Azure platform. He is a certified Solutions Developer (MCSD) and holds a postgraduate degree in instrumentation engineering. He is an active member of the Microsoft community and often seen speaking at user groups and conferences in New Zealand.

See other products by Sudeep Ghatak

Nate Chamberlain

Nate Chamberlain is a technical content creator, solution architect, and trainer, recognized as a 5-year Microsoft MVP. With a background in business analysis and systems administration, Nate has authored seven books and manages his blog. He holds an array of certifications, including M365 Enterprise Administrator Expert and Microsoft Power Platform App Maker Associate, and is a frequent speaker at user groups and conferences.

See other products by Nate Chamberlain

Scott Brewster

Scott Brewster is a Microsoft 365 Solutions Architect. He has supported numerous government clients focusing on SharePoint and Microsoft 365 since 2008. His focus is on security, administration, migration, governance, and training. Scott has been speaking at conferences and user groups since 2010 and runs the SharePoint User Group of DC.

See other products by Scott Brewster

Personalised recommendations for you

Based on your interests and search pattern

Engineering Manager's Handbook

Engineering Manager's Handbook

Engineering Manager's Handbook is a comprehensive guide for managers to excel in their role, foster customer-centric digital products, learn leadership, team building, and balancing technical work with management. You’ll also explore how to develop trust, authority, and collaboration to drive success and make a lasting impact.

Sep 2023 9 hours 16 minutes

C++ Game Animation Programming

C++ Game Animation Programming

Video game characters have a fascinating history, evolving from simple 2D sprites to high-polygon 3D models. Take a look behind the curtain and learn how to build a 3D renderer, load character models, play animations and blend between them, and create large crowds of animated people with this comprehensive C++ game animation programming guide.

Dec 2023 16 hours 0 minutes

Gamification for Product Excellence

Gamification for Product Excellence

This book helps you to take your product management strategy to the next level by standing out in crowded markets. Along with boosting user adoption rates by creating engaging products that incorporate playful elements, learn gamification theory and how to integrate it into your design, product development, and product management processes.

Sep 2023 11 hours 40 minutes

Supercharging Productivity with Trello

Supercharging Productivity with Trello

Supercharging Productivity with Trello is the ultimate guide for anyone looking to boost their productivity with digital tools. Whether you're new to Trello or a seasoned professional, this book covers everything from core features to advanced automation, and Power-Ups.

Aug 2023 11 hours 24 minutes

Automate It with Zapier and Generative AI

Automate It with Zapier and Generative AI

This comprehensive guide takes you through the concepts of business process automation, showing you how Zapier can facilitate it without having to write code and helping you to boost productivity. You’ll learn how to save time, reduce costs, and make your business recession-proof by using Zapier to automate tasks in your cloud-based business apps.

Aug 2023 23 hours 32 minutes

Scoring to Picture in Logic Pro

Scoring to Picture in Logic Pro

In this book, you’ll explore a variety of techniques to synchronize music to picture using Logic Pro. Though this is not a technical manual, it will teach you how to make the best use of Logic Pro and how to wield this technology to maximize your potential when scoring to picture.

Sep 2023 13 hours 44 minutes

Mastering Information Security Compliance Management

Mastering Information Security Compliance Management

This concise book equips you with the knowledge and practices needed to establish and maintain an effective information security management system. The chapters provide insights into ISO/IEC 27001/27002:2022, risk management, ISMS development, incident management, audit processes, and strategies for continuous improvement.

Aug 2023 7 hours 52 minutes

Implementing Atlassian Confluence

Implementing Atlassian Confluence

Implementing Atlassian Confluence provides both a high-level overview and an insightful path for remote collaboration with Atlassian Confluence. With this multi-layered yet practical guide, you’ll be able to set up Confluence-based collaboration with minimum external consultancy services to ensure smooth and close coordination between teams.

Sep 2023 13 hours 32 minutes

R Bioinformatics Cookbook

R Bioinformatics Cookbook

This book takes a unique problem–solution approach to handling complex tasks in the bioinformatics domain using different datasets present in the book. With the help of real-world examples, you’ll learn to put each independent recipe to use to tackle problems in the field of bioinformatics.

Oct 2023 13 hours 12 minutes

Build Your Own Metaverse with Unity

Build Your Own Metaverse with Unity

Build Your own Metaverse with Unity is a practical guide for developers to create their own metaverse - a virtual world with infinite possibilities. It empowers you to identify gaps in existing metaverses and improve upon them, enabling you to shape your virtual world.

Sep 2023 19 hours 32 minutes