Hands-On Microsoft Lists: Create custom data models and improve the way data is organized using Lists in Microsoft 365
Prepare to be a Microsoft Lists advocate and transform the way data is harnessed in your organization
- Get to grips with Microsoft Lists and organize your data efficiently
- Discover best practices and real-world scenarios to track information, events, and issues in your organization
- Take control of your data by creating custom data models using Microsoft Lists
Microsoft Lists is an extremely flexible and powerful platform for creating custom data models. Hands-On Microsoft Lists is an easy-to-read guide for those who want to get started with Lists, as well as those who are already familiar with the basic concepts and want to create custom and flexible Lists that are easily available through a web interface.
This comprehensive introduction to Lists will show you how to get up to speed in no time with the help of practical guidance and examples. Complete with hands-on tutorials and projects, you’ll understand how to use and implement Microsoft Lists effectively. You’ll start by covering all the basic concepts that will help you to build your Microsoft Lists and get the most out of the platform. As you progress, you’ll explore how to customize Microsoft Lists layouts and forms. Later chapters will guide you through integrating Microsoft Lists with the Power Platform. Throughout the book, you’ll work with practical scenarios that you can use daily to improve the collaboration in your organization.
By the end of this Microsoft book, you’ll have learned how to create custom data models to improve the way your data is put together, managed, and consumed in your workplace.
What you will learn
- Use the Lists platform effectively in the modern workplace
- Get to grips with data privacy
- Discover how to customize Microsoft Lists data and forms
- Automate processes using Microsoft Lists
- Extend the default features of Microsoft Lists using the SharePoint framework
- Create custom list templates using PnP PowerShell
- Extend Microsoft Lists using Power Platform
Who this book is for
This book is for business professionals and end users working with Microsoft 365 tools such as Microsoft SharePoint and Microsoft Teams who are looking to improve the way their data is structured, managed, and consumed inside an organization. Basic knowledge of SharePoint and Excel is assumed.
Table of Contents
- Getting Started with Microsoft Lists
- Creating Your First List
- Microsoft Lists Core Features
- Collaborating on Microsoft Lists
- Creating Microsoft Lists Views
- Customizing Microsoft Lists
- Customizing Microsoft Lists Views
- Customizing Microsoft Lists Forms
- Integrating Microsoft Lists with the Power Platform
- Microsoft Lists for Admins and Advanced Users
- Extending Microsoft Lists Using SPFx
Hands-On Microsoft Lists Contributors About the authors About the reviewer Preface Who this book is for What this book covers To get the most out of this book Download the example code files Download the color images Conventions used Get in touch Reviews Chapter 1: Getting Started with Microsoft Lists What is Microsoft Lists? How can I access Microsoft Lists? Microsoft Lists on the web Microsoft Lists on Microsoft Teams Microsoft Lists on mobile Lists on SharePoint Getting familiar with Microsoft Lists' user interface Microsoft Lists on the web Microsoft Lists on Microsoft Teams Microsoft Lists on mobile Lists on SharePoint What does a list look like? Summary Chapter 2: Creating Your First List Personal lists and team lists Creating a blank list Creating a new list from the Microsoft Lists app Creating a new list in a SharePoint site Creating a new list in Microsoft Teams Adding and maintaining columns on a list Adding columns to a list Editing and deleting columns from a list Creating a list from Excel Creating a list from an existing list Maintaining list data Adding items to a list Editing items in a list Deleting items from a list Summary Chapter 3: Microsoft Lists Core Features Modern and classic list features What are the out-of-the-box Microsoft Lists features? Column types Lists views List forms List item comments List item attachments List rules List sharing List templates Edit mode Where is Microsoft Lists data stored? Summary Chapter 4: Collaborating on Microsoft Lists Managing access to your list Sharing a list Sharing a list item Reviewing and modifying access Collaborating with others through comments Managing notifications through alerts and rules Using the Alert me functionality Using rules to get informed about changes Tracking item changes through list versioning Summary Chapter 5: Creating Microsoft Lists Views What are Microsoft Lists views? Default Microsoft Lists views Managing custom Microsoft Lists views Creating a view Editing and deleting a view Summary Chapter 6: Customizing Microsoft Lists Technical requirements Understanding Microsoft Lists formatting WYSIWYG formatting JSON formatting SharePoint Framework formatting Column formatting Supported column types How to format a list column WYSIWYG formatting options JSON formatting How to create and apply your own JSON column formatting Learning from examples Summary Chapter 7: Customizing Microsoft Lists Views Technical requirements Understanding Microsoft Lists view formatting How to format a list view WYSIWYG formatting options JSON formatting How to create and apply your own JSON view formatting Learning from examples Conditional view formatting Tile layout Formatting a view group header and footer Summary Chapter 8: Customizing Microsoft Lists Forms Technical Requirement What is a Microsoft Lists form? How to customize a Microsoft Lists form Showing or hiding columns in a form Showing or hiding form columns conditionally Learn by examples Formatting a list form's header and footer Formatting the form body How to create a Microsoft Lists custom form using Power Apps Publishing the Power Apps form to your list Modifying the form applied to the list Summary Chapter 9: Integrating Microsoft Lists with the Power Platform Exploring the Power Platform Learning Power Automate and Microsoft Lists Understanding Power Automate triggers Understanding Power Automate actions Implementing a sample notification flow Exploring Power BI and Microsoft Lists Creating dashboards using Microsoft Lists data and Power BI Learning about Power Virtual Agents and Microsoft Lists Summary Chapter 10: Microsoft Lists for Admins and Advanced Users Technical requirements How to manage Microsoft Lists as an administrator Managing Microsoft Lists via PowerShell Overview of PnP PowerShell cmdlets for Microsoft Lists Performing a mass-update of data via PowerShell Creating copies of a Microsoft list Summary Chapter 11: Extending Microsoft Lists Using SPFx Technical requirements What SPFx is and how to get started Creating a SharePoint Framework extension Building a field customizer extension Building a view command set extension Summary Why subscribe? Other Books You May Enjoy Packt is searching for authors like you Leave a review - let other readers know what you think
How to download source code?
1. Go to:
2. In the Find a repository… box, search the book title:
Hands-On Microsoft Lists: Create custom data models and improve the way data is organized using Lists in Microsoft 365, sometime you may not get the results, please search the main title.
3. Click the book title in the search results.
3. Click Code to download.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.