55302: Microsoft Lists for End Users Training

• What is Microsoft Lists?
• How can lists help me in my role?
• How does lists benefit other Office 365 services?
• Introducing Microsoft SharePoint
• How does Microsoft Lists fit into SharePoint?
• Types of lists
• An overview of columns and views
• An overview of list settings

Lab1: Setting up a new Team

• Download our training files
• Create a new Microsoft Team

After completing this module, students will be able to:

• Understand when and where to use a list
• Describe how columns and views make up a list
• Explain how lists can benefit other Office 365 services
• Set up a SharePoint site or Team for collaborative lists

• Navigating to Microsoft Lists
• Creating a new list
• My lists vs SharePoint lists
• Creating a new list
• Creating a new list from an Excel file
• Customising list settings
• Adding columns
• Managing and removing columns
• Creating views
• Managing and removing views
• Adding data to a list
• Editing single or multiple records
• Version history
• Delete and restore records
• Delete and restore lists
• Embed your lists into other Office 365 services

Lab1: Getting Started

• Create a new list from a template
• Add new columns
• Customise your default view
• Add a new view
• Add records to your list
• Recover from a mistake
• Delete and recover a record
• Embed a list in a Team

After completing this module, students will be able to:

• Build a useful list using templates in minutes
• Make simple changes to existing list
• Know how columns and views are used in Microsoft Lists
• Be able to add new records to a list
• Restore a previous version of a records
• Remove lists, columns and views

• Advanced column types
• Managed metadata
• Calculated columns
• Using lookup columns
• Geolocation columns
• Implementing formatting
• Using design mode for columns
• Using design mode for views
• How to use advanced mode

Lab1: Add advanced columns and apply formatting

• Create a new list from an Excel file
• Add advanced column types to the list
• Format your columns and views

After completing this module, students will be able to:

• Add a range of advanced column types to your list
• Understand the managed metadata service and its benefits
• Use formatting to customise list columns and views
• Understand where JSON code can be used to format a list

• Customising a list form
• Introducing Power Apps
• Editing a form in Power Apps
• Adding images
• Changing colours
• How to manage input visibility
• Using conditional formatting
• Adding screens
• Building a navigation
• Publishing your updates
• Reverting back to the default form
• Turning your list into a mobile app

Lab1: Customise your form

• Remove unwanted fields from your form
• Open your form using Power Apps
• Apply a business logo to the form
• Hide a control based on another control
• Highlight a field as red if empty
• Publish and test your form

After completing this module, students will be able to:

• Understand when to make changes to a form in Microsoft Lists and when to use Power Apps
• Be aware of what Power Apps can deliver to both your list form and to your list as a whole
• Be able to make customisations to a list form using Power Apps
• Turn a list into a custom mobile app in minutes

• What is Power Automate?
• How do flows start in a list
• How to add design-free workflows to a list
• How to add flow templates to a list
• Working with actions in a flow
• Save and test a flow
• Turn off or delete a flow

Lab1: Design an approval process

• Create a new flow based on an existing tempalte
• Customise the flow to combine Teams with an approval process
• Save and test your flow

After completing this module, students will be able to:

• Understand how to trigger processes from your list using Power Automate
• Feel comfortable adding, editing and removing actions in a flow
• Know how to manage a flow associated with a list