| Tip |
|---|
No matter how easy it is to build lists and use lists, you still have to actually add data to them regularly for them to be useful. The getting everyone in the team to use them bit is the hardest bit of using lists. |
What is Microsoft Lists
A fancy view on SharePoint lists… making SharePoint lists actually useable.
Can view the Lists inside your Teams site.
It will have a mobile app.
May be nicer than everyone working on the one Excel spreadsheet - and the Quick Edit option is quite nice.
What Lists can’t do
Have related data (apart from lookup to User)
Very First Impressions
The icon is fugly
It’s just SharePoint
It will be a bit better (less like just using SharePoint) when the mobile app comes out, I hope.
Alerts seem good
Like anything, it could get unwieldy when you have too many lists.
...
By default lists are in your personal site on SharePoint but you can store them in a SharePoint site.
List can have a Colour, Icon, Name, Description.
You can customise the default form by hiding fields.
Start with a template and customise from there.
...
Create a List, stick it in a Team’s SharePoint site then add that List to your Team site.
The ability to style columns looks amazing, but the advanced options may difficult for newbies (but there are simple options also).
Conditional visibility of fields!
Views or filters are just like you would expect from SharePoint
Grouping is great. Including totals if neededThe Lists app shows your very very old SharePoint lists and they look ugly.
Creating Lists
From Template (easiest)
Blank List
From an existing List
Eg to copy the template into another site… but with no data.
Import from Excel
Needs to be from a Table
Then you can choose the type of field
But it will NOT automatically create the values in choice types
List Formatting
Basic Options
...
You have full SharePoint style columns, including Managed Metadata
I can’t see how to edit column formulas after you create them
Views
Views or filters are just like you would expect from SharePoint
Grouping is great. Including totals if needed.
Sharing Lists
By default Lists are created in My Lists and only visible to you.
But you can share it to anyone else in your team
Individual List Items can be shared
Then it looks like a form record, not a list, if it’s sent to Outlook. If sent to Gmail the link goes to the list with a single line visible.
This could be really handy dandy
You can also set an expiration date and password on individual list items.
And you can share them via a link to anyone.
However, you can’t set the expiration date and password and share it with a named user, which is a bit limiting.
Even though you can email it to a person outside the team the edits are by Guest Contributor only.
Note that the people who get the share can see the View names and can edit the columns. So be careful when setting up your view names.
I can’t see that people can add comments to a list item, this is very limiting.