How to use Microsoft Lists - secure online data entry from multiple persons + live Excel reports
Channel: Efficiency 365 by Dr Nitin
Date: 2021-05-16

Using Microsoft Lists you can capture, manage and analyze data. Create columns, add validations, capture location or images, upload files and more. Share the link with multiple persons. Instant security - make sure that people can see and edit only the data they enter. Connect the data to Excel and create pivot tables or add calculated columns. Watch, try and learn. This session is entirely based upon a live demo. 
Use Power Automate to initiate actions automatically when new items are added or when data is changed. Use Lookup lists. Make sure that you give read permission on the lookup lists as well. 
Download PDF : 22 benefits of using Lists instead of Excel for data capture https://hi.switchy.io/lstxl
Contents
00:00 - Intro
02:00 - Problems with Excel based data entry
07:21 - How to start using Microsoft Lists
08:25 - Create a new List for lookup
16:10 - Version History
17:00 - Create new list for data capture
18:00 - Types of columns
19:53 - Lookup from another list
24:54 - Enter data into a list
28:40 - Using views in a list
30:25 - Sharing a list with others
34:40 - How to prevent people from editing other's data
38:00 - Multi-user data entry
41:00 - Adding column to know who added which row
49:16 - Export to Excel
54:30 - Refreshing data in Excel
56:33 - Auto-refresh while opening the file
58:30 - Create Pivot Table report from a list
01:02:35 - Adding Lists to Teams
01:06:37 - Automating actions after data is added to list
01:10:37 - Power Automate Demo
01:21:00 - Q&A - Detailed and interesting questions answered - with demos

Correction. At 36:30 there was an error.
This error occurred because the user Asst did not have Read access on the lookup list called Packaging. So remember, when you create a list which refers to another list as a lookup, users should have read rights on the lookup list. 

References

Customize SharePoint Permission Levels - allow people to add but not delete. 
https://docs.microsoft.com/en-us/sharepoint/how-to-create-and-edit-permission-levels/?WT.mc_id=M365-MVP-21100

A single list can have up to 30 million rows. 
https://docs.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits/?WT.mc_id=M365-MVP-21100

Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://hi.switchy.io/22B1
Excel to Power BI - https://swiy.io/pivotsh

Learn more from 1000+ blog articles by Dr Nitin Paranjape 
https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Created using Camtasia: https://www.techsmith.com/video-editor