1
00:00:00,040 --> 00:00:03,960
Welcome to the M365 FM podcast,
where we explore the people,

2
00:00:03,960 --> 00:00:06,639
ideas and technologies shaping
the future of work.

3
00:00:06,639 --> 00:00:09,480
The tracking spreadsheet
everyone is afraid to touch.

4
00:00:09,480 --> 00:00:10,679
Here's what happens when a messy

5
00:00:10,679 --> 00:00:11,919
tracking spreadsheet becomes a

6
00:00:11,919 --> 00:00:12,839
Microsoft list.

7
00:00:12,839 --> 00:00:15,839
The rows stay, but the chaos
goes because every column now

8
00:00:15,839 --> 00:00:18,839
knows whether it holds a name, a
date, a price, or a status.

9
00:00:18,839 --> 00:00:22,120
You don't need to be an admin or
write any code, since lists

10
00:00:22,120 --> 00:00:24,559
comes with the Microsoft three
hundred sixty five plans that

11
00:00:24,559 --> 00:00:27,879
include SharePoint, it shows up
in the lists app in SharePoint

12
00:00:27,879 --> 00:00:29,199
and right inside teams.

13
00:00:29,199 --> 00:00:31,679
So the data lives where your
team already works.

14
00:00:31,679 --> 00:00:32,799
By the end, you'll know what it

15
00:00:32,799 --> 00:00:34,640
is, how to start one, where it

16
00:00:34,640 --> 00:00:36,280
fits, and the limits that trip

17
00:00:36,280 --> 00:00:37,159
people up.

18
00:00:37,159 --> 00:00:40,920
Welcome to the M365 FM podcast
where we explore the people,

19
00:00:40,920 --> 00:00:43,679
ideas, and technologies shaping
the future of work.

20
00:00:43,679 --> 00:00:45,320
Most of us have met this
spreadsheet.

21
00:00:45,320 --> 00:00:47,479
Someone owns it, everyone edits
it.

22
00:00:47,479 --> 00:00:48,719
And by Friday there are four

23
00:00:48,719 --> 00:00:49,960
copies with slightly different

24
00:00:49,960 --> 00:00:50,399
numbers.

25
00:00:50,399 --> 00:00:51,240
The problem was never the

26
00:00:51,240 --> 00:00:52,679
people, because a spreadsheet

27
00:00:52,679 --> 00:00:53,899
was never built for a team to

28
00:00:53,899 --> 00:00:54,119
share.

29
00:00:54,119 --> 00:00:55,320
At the same time, that gap is

30
00:00:55,320 --> 00:00:56,479
exactly what this episode is

31
00:00:56,479 --> 00:00:58,719
about, what Microsoft lists

32
00:00:58,719 --> 00:00:59,710
actually is.

33
00:00:59,710 --> 00:01:01,109
So let's answer the question
plainly.

34
00:01:01,109 --> 00:01:01,990
Without the jargon.

35
00:01:01,990 --> 00:01:03,450
Microsoft Lists is a shared

36
00:01:03,450 --> 00:01:05,109
table for tracking information

37
00:01:05,109 --> 00:01:06,390
built right into Microsoft

38
00:01:06,390 --> 00:01:06,670
three.

39
00:01:06,670 --> 00:01:08,469
Sixty five Microsoft describes

40
00:01:08,469 --> 00:01:09,670
it as a way to organize,

41
00:01:09,670 --> 00:01:10,709
collaborate, and share the

42
00:01:10,709 --> 00:01:12,349
information you care about, and

43
00:01:12,349 --> 00:01:13,549
that's a fair summary of what it

44
00:01:13,549 --> 00:01:13,790
does.

45
00:01:13,790 --> 00:01:14,709
If you've used SharePoint

46
00:01:14,709 --> 00:01:15,829
before, you've already met the

47
00:01:15,829 --> 00:01:17,349
idea lists is the modern,

48
00:01:17,349 --> 00:01:18,390
friendlier way to build a

49
00:01:18,390 --> 00:01:19,950
SharePoint list, and it arrived

50
00:01:19,950 --> 00:01:21,269
as its own app back in August

51
00:01:21,269 --> 00:01:22,390
twenty twenty.

52
00:01:22,390 --> 00:01:25,349
Before that, the same feature
existed, but it lived inside

53
00:01:25,349 --> 00:01:28,109
SharePoint sites and was harder
for a beginner to find.

54
00:01:28,109 --> 00:01:30,109
The part that matters is where
the data lives.

55
00:01:30,109 --> 00:01:32,549
Every list is stored in
SharePoint, which is the same

56
00:01:32,549 --> 00:01:34,829
place your Microsoft three
hundred sixty five files and

57
00:01:34,829 --> 00:01:35,989
team sites already sit.

58
00:01:35,989 --> 00:01:37,269
That means your list inherits

59
00:01:37,269 --> 00:01:38,469
the sharing and permissions you

60
00:01:38,469 --> 00:01:39,430
already understand.

61
00:01:39,430 --> 00:01:40,590
Instead of creating a whole new

62
00:01:40,590 --> 00:01:41,870
system, you have to learn from

63
00:01:41,870 --> 00:01:42,829
scratch.

64
00:01:42,829 --> 00:01:45,109
A list is a collection of data
you share with your team and

65
00:01:45,109 --> 00:01:46,750
anyone else you give access to.

66
00:01:46,750 --> 00:01:49,930
You can open it from the lists
app, from a SharePoint site, or

67
00:01:49,930 --> 00:01:52,150
as a tab inside Microsoft Teams.

68
00:01:52,150 --> 00:01:55,069
It's the same list seen through
three doors, and nobody ends up

69
00:01:55,069 --> 00:01:56,549
working in a separate copy.

70
00:01:56,549 --> 00:01:57,939
What people actually track with.

71
00:01:57,939 --> 00:02:01,180
It covers a wide range support
teams, track issues.

72
00:02:01,180 --> 00:02:04,420
IT teams, track laptops and
monitors, marketing teams, track

73
00:02:04,420 --> 00:02:08,180
content ideas, HR teams, track
new hires and event planners,

74
00:02:08,180 --> 00:02:09,740
track sessions and speakers.

75
00:02:09,740 --> 00:02:11,219
The common thread never changes.

76
00:02:11,219 --> 00:02:14,139
It comes down to several people,
the same structured information

77
00:02:14,139 --> 00:02:16,139
and a need to see it live.

78
00:02:16,139 --> 00:02:18,979
Now, a list isn't a spreadsheet,
and it isn't a database either.

79
00:02:18,979 --> 00:02:21,620
It sits in the middle as a
shared tracker with structure,

80
00:02:21,620 --> 00:02:23,860
and that middle ground is where
it earns its keep.

81
00:02:23,860 --> 00:02:24,979
Picture a small support team

82
00:02:24,979 --> 00:02:25,960
that lives in a spreadsheet

83
00:02:25,960 --> 00:02:26,740
today.

84
00:02:26,740 --> 00:02:29,740
One person logs the ticket,
someone else updates the status,

85
00:02:29,740 --> 00:02:32,620
and the third person keeps
asking which version is current.

86
00:02:32,620 --> 00:02:34,139
Put that same work in a list and

87
00:02:34,139 --> 00:02:35,419
everyone opens the same live

88
00:02:35,419 --> 00:02:35,979
view.

89
00:02:35,979 --> 00:02:38,759
There's no emailing, no version
names, and no guessing which

90
00:02:38,759 --> 00:02:39,659
file is real.

91
00:02:39,659 --> 00:02:41,139
That's the promise of the tool,

92
00:02:41,139 --> 00:02:42,939
and it's a modest one, a single,

93
00:02:42,939 --> 00:02:44,139
shared, structured place for the

94
00:02:44,139 --> 00:02:44,620
information.

95
00:02:44,620 --> 00:02:46,539
Your team keeps passing around.

96
00:02:46,539 --> 00:02:48,699
Three easy ways to start your
first list.

97
00:02:48,699 --> 00:02:51,020
Getting started is easier than
you might expect, because you

98
00:02:51,020 --> 00:02:53,460
don't have to design anything
from a blank page unless you

99
00:02:53,460 --> 00:02:54,379
really want to.

100
00:02:54,379 --> 00:02:55,770
There are three ways to begin,

101
00:02:55,770 --> 00:02:56,969
and each one fits a different

102
00:02:56,969 --> 00:02:57,930
situation.

103
00:02:57,930 --> 00:02:59,409
The first is from scratch.

104
00:02:59,409 --> 00:03:00,810
You create an empty list, then

105
00:03:00,810 --> 00:03:02,169
add the columns you need one at

106
00:03:02,169 --> 00:03:02,729
a time.

107
00:03:02,729 --> 00:03:04,810
This is the right choice when
you already know exactly what

108
00:03:04,810 --> 00:03:07,409
you're tracking, and you'd
rather build it your own way.

109
00:03:07,409 --> 00:03:09,650
The second is from a ready made
template, and this is where a

110
00:03:09,650 --> 00:03:10,969
beginner should start.

111
00:03:10,969 --> 00:03:13,490
Microsoft ships a set of
templates with pre-built

112
00:03:13,490 --> 00:03:16,370
columns, formatting, and
structure already in place.

113
00:03:16,370 --> 00:03:17,569
There's an issue tracker, an

114
00:03:17,569 --> 00:03:18,849
employee onboarding checklist,

115
00:03:18,849 --> 00:03:20,530
an asset manager, a content

116
00:03:20,530 --> 00:03:22,449
scheduler, an event itinerary, a

117
00:03:22,449 --> 00:03:24,050
recruitment tracker, a travel

118
00:03:24,050 --> 00:03:25,430
requests list, and a work

119
00:03:25,430 --> 00:03:26,129
tracker.

120
00:03:26,129 --> 00:03:27,490
Pick the one closest to your job

121
00:03:27,490 --> 00:03:28,490
and you're already most of the

122
00:03:28,490 --> 00:03:29,370
way there.

123
00:03:29,370 --> 00:03:31,090
Take the issue tracker as an
example.

124
00:03:31,090 --> 00:03:33,770
It arrives with columns for
priority status and the person

125
00:03:33,770 --> 00:03:36,610
assigned plus two rules already
built in that email.

126
00:03:36,610 --> 00:03:39,050
The right person when an issue
lands on their plate.

127
00:03:39,050 --> 00:03:39,969
You didn't build that.

128
00:03:39,969 --> 00:03:42,210
It's just there waiting for your
first item.

129
00:03:42,210 --> 00:03:43,370
The third way is to turn an

130
00:03:43,370 --> 00:03:44,569
existing spreadsheet into a

131
00:03:44,569 --> 00:03:45,090
list.

132
00:03:45,090 --> 00:03:47,689
If your team already tracks
something in Excel, you can

133
00:03:47,689 --> 00:03:50,490
bring that data across and keep
the columns you've been using.

134
00:03:50,490 --> 00:03:53,330
You don't lose your history and
you don't start over.

135
00:03:53,330 --> 00:03:56,400
Bringing a spreadsheet across is
more forgiving than it sounds.

136
00:03:56,400 --> 00:03:59,479
Microsoft reads your columns,
guesses the types, and lets you

137
00:03:59,479 --> 00:04:01,280
fix anything it gets wrong
before you commit.

138
00:04:01,280 --> 00:04:03,719
If a column full of dates
arrives as plain text, you

139
00:04:03,719 --> 00:04:05,120
change it in a single click.

140
00:04:05,120 --> 00:04:07,879
Your data comes with you, and
the list takes over from there.

141
00:04:07,879 --> 00:04:10,759
So the honest advice for a first
list is simple start with a

142
00:04:10,759 --> 00:04:14,280
template, rename it to fit your
team and add or remove columns

143
00:04:14,280 --> 00:04:15,080
as you go.

144
00:04:15,080 --> 00:04:17,600
You can always change your mind
later because a list is never

145
00:04:17,600 --> 00:04:18,560
locked in place.

146
00:04:18,560 --> 00:04:20,759
Keep one number in the back of
your mind as we go.

147
00:04:20,759 --> 00:04:23,680
It's the one that catches almost
every new user off guard, and it

148
00:04:23,680 --> 00:04:25,000
decides how far a list can grow.

149
00:04:25,000 --> 00:04:27,560
Before you need a different
tool, we'll come back to it.

150
00:04:27,560 --> 00:04:29,519
Columns are where the real
difference shows up.

151
00:04:29,519 --> 00:04:30,639
What separates a list from a

152
00:04:30,639 --> 00:04:31,620
spreadsheet comes down to

153
00:04:31,620 --> 00:04:33,079
columns, and it's worth slowing

154
00:04:33,079 --> 00:04:33,720
down for.

155
00:04:33,720 --> 00:04:35,800
In a list, every row is an item

156
00:04:35,800 --> 00:04:37,319
and every column is a field with

157
00:04:37,319 --> 00:04:38,079
a type.

158
00:04:38,079 --> 00:04:40,279
A column isn't a blank cell
waiting for anything.

159
00:04:40,279 --> 00:04:41,199
You drop into it.

160
00:04:41,199 --> 00:04:43,199
You tell it what it holds when
you create it.

161
00:04:43,199 --> 00:04:45,319
The choices cover most of what a
team tracks.

162
00:04:45,319 --> 00:04:48,560
You get text a choice from a
short list, a person, a date and

163
00:04:48,560 --> 00:04:52,670
time, a currency amount, a
number, a yes or no, a link, an

164
00:04:52,670 --> 00:04:55,670
image, a location, and a lookup
to another list.

165
00:04:55,670 --> 00:04:58,069
Getting the type right early
saves real pain later.

166
00:04:58,069 --> 00:04:59,449
If a date column keeps the wrong

167
00:04:59,449 --> 00:05:01,269
type, you lose the calendar view

168
00:05:01,269 --> 00:05:02,509
and the sorting that comes with

169
00:05:02,509 --> 00:05:02,990
it.

170
00:05:02,990 --> 00:05:05,709
If you leave a status column as
free text, you get six spellings

171
00:05:05,709 --> 00:05:08,149
of the same word and a filter
that can't find anything.

172
00:05:08,149 --> 00:05:10,730
The column type is a small
decision that pays off every

173
00:05:10,730 --> 00:05:12,509
time someone opens the list.

174
00:05:12,509 --> 00:05:14,509
The type matters for a practical
reason.

175
00:05:14,509 --> 00:05:16,990
A choice column gives people a
drop down, so nobody types in

176
00:05:16,990 --> 00:05:18,430
progress five different ways.

177
00:05:18,430 --> 00:05:20,870
A person column knows it's
holding a real person, complete

178
00:05:20,870 --> 00:05:23,149
with a photo and a click through
to their profile.

179
00:05:23,149 --> 00:05:24,790
A currency column does math, and

180
00:05:24,790 --> 00:05:25,970
a date column can drive a

181
00:05:25,970 --> 00:05:26,750
calendar.

182
00:05:26,750 --> 00:05:29,790
The data stays clean because the
column itself protects it.

183
00:05:29,790 --> 00:05:32,310
The lookup type is the one that
surprises people.

184
00:05:32,310 --> 00:05:34,629
It creates a relationship
between two lists.

185
00:05:34,629 --> 00:05:35,750
Say you have a list of projects

186
00:05:35,750 --> 00:05:37,310
and a list of tasks, instead of

187
00:05:37,310 --> 00:05:38,470
retyping the project name on

188
00:05:38,470 --> 00:05:39,269
every task.

189
00:05:39,269 --> 00:05:42,509
The task uses a lookup column
that points back to the project.

190
00:05:42,509 --> 00:05:44,069
Change the project once and

191
00:05:44,069 --> 00:05:45,470
every related task follows

192
00:05:45,470 --> 00:05:46,029
along.

193
00:05:46,029 --> 00:05:47,750
This is the honest difference
from Excel.

194
00:05:47,750 --> 00:05:49,029
A spreadsheet cell holds

195
00:05:49,029 --> 00:05:50,540
anything you put in it, which is

196
00:05:50,540 --> 00:05:51,899
exactly why spreadsheets drift

197
00:05:51,899 --> 00:05:52,660
over time.

198
00:05:52,660 --> 00:05:53,899
A list column holds what you

199
00:05:53,899 --> 00:05:55,300
told it to hold, so the

200
00:05:55,300 --> 00:05:56,699
structure survives contact with

201
00:05:56,699 --> 00:05:57,540
real people.

202
00:05:57,540 --> 00:06:00,459
And because every item has a
type, you can filter, sort, and

203
00:06:00,459 --> 00:06:02,899
group on that structure later
without cleaning up a mess.

204
00:06:02,899 --> 00:06:05,220
First one list many ways to see
it.

205
00:06:05,220 --> 00:06:07,699
Once your data is clean, the
next question is how you want to

206
00:06:07,699 --> 00:06:08,019
look at it.

207
00:06:08,019 --> 00:06:09,500
And this is where views come in.

208
00:06:09,500 --> 00:06:11,379
A view is a saved way of seeing
the same list.

209
00:06:11,379 --> 00:06:14,579
It decides which columns show
how the items are sorted, how

210
00:06:14,579 --> 00:06:16,620
they're grouped, and which ones
are filtered out.

211
00:06:16,620 --> 00:06:19,379
You can make as many as you need
and switching between them takes

212
00:06:19,379 --> 00:06:20,379
a single click.

213
00:06:20,379 --> 00:06:22,100
There are a few shapes of you
can take.

214
00:06:22,100 --> 00:06:24,699
The grid is the familiar table
and it's the default.

215
00:06:24,699 --> 00:06:26,100
The calendar view takes anything

216
00:06:26,100 --> 00:06:27,540
with dates and lays it out

217
00:06:27,540 --> 00:06:28,939
across a month, which is perfect

218
00:06:28,939 --> 00:06:30,139
for the event itinerary

219
00:06:30,139 --> 00:06:30,980
template.

220
00:06:30,980 --> 00:06:34,259
The gallery view turns each item
into a card so it works well for

221
00:06:34,259 --> 00:06:35,980
photos or an asset directory.

222
00:06:35,980 --> 00:06:37,300
The board view gives you
columns.

223
00:06:37,300 --> 00:06:40,420
You drag items between, which is
great when status is the thing

224
00:06:40,420 --> 00:06:41,579
you care about most.

225
00:06:41,579 --> 00:06:44,500
Picture the same event list used
two ways during planning.

226
00:06:44,500 --> 00:06:45,519
You live in the grid view

227
00:06:45,519 --> 00:06:46,860
checking speakers, rooms, and

228
00:06:46,860 --> 00:06:47,779
capacity.

229
00:06:47,779 --> 00:06:49,089
On the day itself, you switch to

230
00:06:49,089 --> 00:06:50,129
the calendar and see the whole

231
00:06:50,129 --> 00:06:50,490
schedule.

232
00:06:50,490 --> 00:06:52,089
At a glance, it's the same data,

233
00:06:52,089 --> 00:06:53,290
but two completely different

234
00:06:53,290 --> 00:06:54,129
experiences.

235
00:06:54,129 --> 00:06:55,689
Filtering is the other half of
this.

236
00:06:55,689 --> 00:06:57,009
The filter pane lets you narrow

237
00:06:57,009 --> 00:06:58,209
a long list down to just what

238
00:06:58,209 --> 00:06:58,569
matters.

239
00:06:58,569 --> 00:07:01,430
Almost like shopping online,
filter to your own items, or to

240
00:07:01,430 --> 00:07:03,889
everything that's blocked, or to
everything due this week.

241
00:07:03,889 --> 00:07:06,490
Sorting and grouping work right
alongside filtering.

242
00:07:06,490 --> 00:07:08,050
You might sort by due date so

243
00:07:08,050 --> 00:07:09,310
the nearest deadlines float to

244
00:07:09,310 --> 00:07:10,810
the top or grouped by owner so

245
00:07:10,810 --> 00:07:11,889
each person sees their own

246
00:07:11,889 --> 00:07:12,490
section.

247
00:07:12,490 --> 00:07:14,089
Save that arrangement as a view,

248
00:07:14,089 --> 00:07:15,329
and the next person who opens

249
00:07:15,329 --> 00:07:16,529
the list gets the same clean

250
00:07:16,529 --> 00:07:17,730
picture without touching a

251
00:07:17,730 --> 00:07:18,610
single setting.

252
00:07:18,610 --> 00:07:20,529
Formatting is what brings the
list to life.

253
00:07:20,529 --> 00:07:23,250
You can color code a status
column, so blocked items glow

254
00:07:23,250 --> 00:07:25,889
red or flag a whole row when a
due date slips.

255
00:07:25,889 --> 00:07:27,930
None of this changes the
underlying data.

256
00:07:27,930 --> 00:07:30,490
It just makes the important
things impossible to miss.

257
00:07:30,490 --> 00:07:31,970
An HR team gets a lot out of
this.

258
00:07:31,970 --> 00:07:34,769
Their onboarding list can show
only this week's tasks in one

259
00:07:34,769 --> 00:07:38,050
view, only the tasks with no
owner in another and a color

260
00:07:38,050 --> 00:07:40,490
coded view where anything
overdue turns red.

261
00:07:40,490 --> 00:07:41,769
It's one list that answers three

262
00:07:41,769 --> 00:07:43,410
different questions at a glance

263
00:07:43,410 --> 00:07:44,889
when the list starts working

264
00:07:44,889 --> 00:07:45,689
without you.

265
00:07:45,689 --> 00:07:47,709
Now, for the moment, that makes
people lean in.

266
00:07:47,709 --> 00:07:48,709
A good list doesn't just sit

267
00:07:48,709 --> 00:07:49,870
there waiting for you to update

268
00:07:49,870 --> 00:07:50,189
it.

269
00:07:50,189 --> 00:07:51,550
It can start doing work on its
own.

270
00:07:51,550 --> 00:07:53,230
The simplest version is a rule.

271
00:07:53,230 --> 00:07:56,189
Rules are a no code feature that
sends an email when something

272
00:07:56,189 --> 00:07:57,870
specific happens on the list.

273
00:07:57,870 --> 00:08:00,949
Add a new issue and the assigned
person gets a notification.

274
00:08:00,949 --> 00:08:02,269
Change the status to blocked and

275
00:08:02,269 --> 00:08:03,389
the right person hears about it

276
00:08:03,389 --> 00:08:04,110
right away.

277
00:08:04,110 --> 00:08:06,829
You set it up once and it runs
without you.

278
00:08:06,829 --> 00:08:09,449
Rules replace the older alerts
feature and there are a lot

279
00:08:09,449 --> 00:08:10,550
friendlier to build.

280
00:08:10,550 --> 00:08:11,509
The next level is Power

281
00:08:11,509 --> 00:08:13,029
Automate, where a rule handles a

282
00:08:13,029 --> 00:08:14,310
single notification.

283
00:08:14,310 --> 00:08:17,310
Power automate connects your
list to a whole workflow across

284
00:08:17,310 --> 00:08:19,310
Microsoft three hundred sixty
five and beyond.

285
00:08:19,310 --> 00:08:20,470
A new item can trigger a

286
00:08:20,470 --> 00:08:21,670
sequence that updates another

287
00:08:21,670 --> 00:08:23,389
list, posts to a teams channel,

288
00:08:23,389 --> 00:08:24,829
sends an approval, and logs the

289
00:08:24,829 --> 00:08:25,350
result.

290
00:08:25,350 --> 00:08:27,430
If you've ever wished a
spreadsheet could just handle

291
00:08:27,430 --> 00:08:30,149
the boring part for you, this is
that wish answered.

292
00:08:30,149 --> 00:08:31,589
Then there's Power Apps, which

293
00:08:31,589 --> 00:08:32,909
lets you customize the form

294
00:08:32,909 --> 00:08:34,149
people fill in when they add an

295
00:08:34,149 --> 00:08:34,669
item.

296
00:08:34,669 --> 00:08:37,190
Instead of a plain form, you can
build something that looks and

297
00:08:37,190 --> 00:08:39,870
behaves like a real app without
leaving the list behind.

298
00:08:39,870 --> 00:08:41,710
Microsoft builds this right into
the list.

299
00:08:41,710 --> 00:08:44,190
You open the item form, choose
to edit it, and customize it

300
00:08:44,190 --> 00:08:45,259
with Power PowerApps.

301
00:08:45,259 --> 00:08:47,620
Approvals are the last piece,
and they're surprisingly useful.

302
00:08:47,620 --> 00:08:49,860
You can send an item for
approval and track the decision

303
00:08:49,860 --> 00:08:51,019
right inside the list.

304
00:08:51,019 --> 00:08:52,740
Think about a travel request
list.

305
00:08:52,740 --> 00:08:55,340
Someone submits a trip, the
manager gets asked to approve it

306
00:08:55,340 --> 00:08:56,299
and the status updates.

307
00:08:56,299 --> 00:08:59,019
Once they decide there's no
separate email thread, no lost

308
00:08:59,019 --> 00:09:01,419
request, and no wondering who
dropped the ball.

309
00:09:01,419 --> 00:09:02,440
Here's a small end to end

310
00:09:02,440 --> 00:09:03,940
example a new item lands in your

311
00:09:03,940 --> 00:09:04,740
issue tracker.

312
00:09:04,740 --> 00:09:05,860
A rule emails the assigned

313
00:09:05,860 --> 00:09:07,340
person, and power automate adds

314
00:09:07,340 --> 00:09:08,419
a card to the team's teams

315
00:09:08,419 --> 00:09:09,019
channel.

316
00:09:09,019 --> 00:09:10,299
When the issue is marked done, a

317
00:09:10,299 --> 00:09:11,659
second flow updates a summary

318
00:09:11,659 --> 00:09:12,899
list that the manager checks on

319
00:09:12,899 --> 00:09:13,460
Monday morning.

320
00:09:13,460 --> 00:09:14,980
You built none of that busywork.

321
00:09:14,980 --> 00:09:17,259
The list and its flows did it
for you.

322
00:09:17,259 --> 00:09:19,820
Where lists fits in Microsoft
three hundred sixty five.

323
00:09:19,820 --> 00:09:20,940
Before we get to the limits,

324
00:09:20,940 --> 00:09:22,080
let's zoom out and see where

325
00:09:22,080 --> 00:09:23,340
list sits because it doesn't

326
00:09:23,340 --> 00:09:24,100
live alone.

327
00:09:24,100 --> 00:09:26,340
Underneath everything, your list
lives in SharePoint.

328
00:09:26,340 --> 00:09:28,860
That's why sharing permissions
and version history behave the

329
00:09:28,860 --> 00:09:29,700
way they do.

330
00:09:29,700 --> 00:09:33,179
It's also why you can hand
someone access to a single list,

331
00:09:33,179 --> 00:09:36,299
or even a single item without
opening up everything else.

332
00:09:36,299 --> 00:09:39,179
The data is a SharePoint list
wearing a friendlier face.

333
00:09:39,179 --> 00:09:40,620
Inside Microsoft Teams, you can

334
00:09:40,620 --> 00:09:42,580
add a list as a tab so your

335
00:09:42,580 --> 00:09:43,690
teams team's conversation and

336
00:09:43,690 --> 00:09:45,049
the data it's about sit side by

337
00:09:45,049 --> 00:09:45,649
side.

338
00:09:45,649 --> 00:09:46,789
That one move is often what

339
00:09:46,789 --> 00:09:48,730
turns a list from a side project

340
00:09:48,730 --> 00:09:49,889
into the place your team

341
00:09:49,889 --> 00:09:50,809
actually works.

342
00:09:50,809 --> 00:09:52,090
There's a personal side too.

343
00:09:52,090 --> 00:09:53,330
You can keep lists of your own

344
00:09:53,330 --> 00:09:54,289
through OneDrive, so your

345
00:09:54,289 --> 00:09:55,450
private trackers don't sprawl

346
00:09:55,450 --> 00:09:56,529
across team sites where they

347
00:09:56,529 --> 00:09:57,330
don't belong.

348
00:09:57,330 --> 00:09:59,889
When you outgrow the list view,
you have somewhere to go.

349
00:09:59,889 --> 00:10:03,509
You can export the data to Excel
to CSV or straight into power BI

350
00:10:03,509 --> 00:10:04,809
for heavier analysis.

351
00:10:04,809 --> 00:10:07,970
And because lists is part of the
power platform, Family Power

352
00:10:07,970 --> 00:10:10,809
Automate and Power apps are
always within reach, there's one

353
00:10:10,809 --> 00:10:12,049
more connection worth naming.

354
00:10:12,049 --> 00:10:14,809
A list can act as the data
source for a power app, which

355
00:10:14,809 --> 00:10:17,649
means a team can work through a
friendly screen while the list

356
00:10:17,649 --> 00:10:19,090
holds the records underneath.

357
00:10:19,090 --> 00:10:21,450
That's how a simple tracker
grows into something that feels

358
00:10:21,450 --> 00:10:24,250
like a purpose built tool
without a developer in the room.

359
00:10:24,250 --> 00:10:27,370
Now, the Azure question answered
honestly lists as a Microsoft

360
00:10:27,370 --> 00:10:29,529
three hundred sixty five app,
not an Azure service.

361
00:10:29,529 --> 00:10:30,610
You go and set up.

362
00:10:30,610 --> 00:10:32,370
It runs on Microsoft's cloud and

363
00:10:32,370 --> 00:10:33,450
through the power platform, it

364
00:10:33,450 --> 00:10:35,049
can reach Azure Site tools, but

365
00:10:35,049 --> 00:10:36,350
you never have to touch Azure to

366
00:10:36,350 --> 00:10:36,809
use it.

367
00:10:36,809 --> 00:10:38,289
If you're a beginner, that's
good news.

368
00:10:38,289 --> 00:10:40,450
There's nothing to provision and
nothing to configure in the

369
00:10:40,450 --> 00:10:42,080
cloud before your first list.

370
00:10:42,080 --> 00:10:44,799
As for cost lists is already
included in the Microsoft three

371
00:10:44,799 --> 00:10:46,000
hundred sixty five subscription.

372
00:10:46,000 --> 00:10:48,639
That gives you SharePoint, and
there's a free personal preview.

373
00:10:48,639 --> 00:10:51,220
If you want to try it with a
Microsoft account, chances are

374
00:10:51,220 --> 00:10:54,240
it's already sitting in the
account you have open right now.

375
00:10:54,240 --> 00:10:56,200
The limits nobody wants you
about.

376
00:10:56,200 --> 00:10:58,940
This is the part that saves you
from a bad afternoon, so let's

377
00:10:58,940 --> 00:10:59,919
be straight about it.

378
00:10:59,919 --> 00:11:02,539
Microsoft says you can store up
to thirty million items in a

379
00:11:02,539 --> 00:11:03,559
list or library.

380
00:11:03,559 --> 00:11:06,559
That number sounds enormous, and
it is, but it's not the number

381
00:11:06,559 --> 00:11:07,919
that matters day to day.

382
00:11:07,919 --> 00:11:11,240
That number I asked you to hold
on to shows up right here and

383
00:11:11,240 --> 00:11:12,399
it's about five thousand.

384
00:11:12,399 --> 00:11:14,080
It's called the list view
threshold.

385
00:11:14,080 --> 00:11:16,360
And by default it sits around
five thousand items.

386
00:11:16,360 --> 00:11:17,440
When a view has to work with

387
00:11:17,440 --> 00:11:18,539
more than that at once, the view

388
00:11:18,539 --> 00:11:19,720
can fail to load and throw an

389
00:11:19,720 --> 00:11:20,000
error.

390
00:11:20,000 --> 00:11:22,320
Microsoft starts warning you on
the list settings page.

391
00:11:22,320 --> 00:11:24,720
Once you pass three thousand
items, which is your cue that

392
00:11:24,720 --> 00:11:25,960
the list is getting big.

393
00:11:25,960 --> 00:11:27,399
The limit exists for a reason.

394
00:11:27,399 --> 00:11:28,480
The list sits in a shared

395
00:11:28,480 --> 00:11:29,919
database, and locking too many

396
00:11:29,919 --> 00:11:31,240
rows at once slows the whole

397
00:11:31,240 --> 00:11:32,500
system down for everyone, so

398
00:11:32,500 --> 00:11:33,639
Microsoft throttles it on

399
00:11:33,639 --> 00:11:34,279
purpose.

400
00:11:34,279 --> 00:11:35,720
The exact number can shift with

401
00:11:35,720 --> 00:11:37,419
activity and configuration, so

402
00:11:37,419 --> 00:11:38,759
treat five thousand as a rough

403
00:11:38,759 --> 00:11:40,029
line rather than a law of

404
00:11:40,029 --> 00:11:40,750
physics.

405
00:11:40,750 --> 00:11:42,590
A few other ceilings are worth
knowing.

406
00:11:42,590 --> 00:11:45,710
An individual file or attachment
can be up to ten gigabytes,

407
00:11:45,710 --> 00:11:47,429
which is plenty for most teams.

408
00:11:47,429 --> 00:11:50,169
Unique permissions are capped at
fifty thousand per list, though

409
00:11:50,169 --> 00:11:53,110
Microsoft recommends staying
near a five thousand and lookups

410
00:11:53,110 --> 00:11:55,909
have a join limit of twelve, so
you can't chain unlimited

411
00:11:55,909 --> 00:11:57,470
relationships between lists.

412
00:11:57,470 --> 00:11:59,470
None of this should scare you
off your team list.

413
00:11:59,470 --> 00:12:00,649
Probably never comes close to

414
00:12:00,649 --> 00:12:02,070
these numbers, and the ones that

415
00:12:02,070 --> 00:12:03,629
do usually belong in a different

416
00:12:03,629 --> 00:12:04,470
tool anyway.

417
00:12:04,470 --> 00:12:05,950
So the practical rule is this.

418
00:12:05,950 --> 00:12:07,309
And it's the honest one.

419
00:12:07,309 --> 00:12:10,090
A list works best for tracking
hundreds or a few thousand

420
00:12:10,090 --> 00:12:12,509
shared rows, not for millions of
rows of analysis.

421
00:12:12,509 --> 00:12:14,950
When a list starts to strain,
you have moves.

422
00:12:14,950 --> 00:12:16,230
You can index the columns you

423
00:12:16,230 --> 00:12:17,710
filter on, build narrower

424
00:12:17,710 --> 00:12:19,350
filtered views, split the data

425
00:12:19,350 --> 00:12:20,789
across folders, or send the

426
00:12:20,789 --> 00:12:22,509
heavy analysis to Excel or Power

427
00:12:22,509 --> 00:12:23,190
BI.

428
00:12:23,190 --> 00:12:25,509
Knowing that ahead of time is
the difference between a tool

429
00:12:25,509 --> 00:12:29,470
that works and a tool you blame
the mistakes beginners make and

430
00:12:29,470 --> 00:12:30,590
what to do instead.

431
00:12:30,590 --> 00:12:31,809
With the limits in mind,

432
00:12:31,809 --> 00:12:33,309
beginner problems come down to a

433
00:12:33,309 --> 00:12:34,830
handful of predictable mistakes,

434
00:12:34,830 --> 00:12:36,110
and every one of them has a

435
00:12:36,110 --> 00:12:37,269
simple fix.

436
00:12:37,269 --> 00:12:39,419
The first is treating lists like
Excel.

437
00:12:39,419 --> 00:12:40,820
People import a giant analysis

438
00:12:40,820 --> 00:12:41,960
spreadsheet, hit the view

439
00:12:41,960 --> 00:12:43,259
threshold, and decide the tool

440
00:12:43,259 --> 00:12:44,059
is broken.

441
00:12:44,059 --> 00:12:44,980
It isn't broken.

442
00:12:44,980 --> 00:12:47,820
Lists is for shared tracking,
not for crunching numbers.

443
00:12:47,820 --> 00:12:51,220
And the moment you need real
analysis, you export to Excel

444
00:12:51,220 --> 00:12:52,419
and let it do that job.

445
00:12:52,419 --> 00:12:55,419
The second mistake is using
lists for personal to do lists

446
00:12:55,419 --> 00:12:56,460
for your own tasks.

447
00:12:56,460 --> 00:12:59,019
Microsoft to Do and planner are
the better fit.

448
00:12:59,019 --> 00:13:01,580
Save lists for the shared
structured information your team

449
00:13:01,580 --> 00:13:02,940
needs to see together.

450
00:13:02,940 --> 00:13:06,059
The third is building one giant
list for everything that feels

451
00:13:06,059 --> 00:13:09,100
efficient at first, but it turns
into a list with forty columns

452
00:13:09,100 --> 00:13:10,580
that nobody wants to open.

453
00:13:10,580 --> 00:13:12,980
Build a few focused lists
instead and connect them with

454
00:13:12,980 --> 00:13:14,500
lookup columns when they relate.

455
00:13:14,500 --> 00:13:15,620
The fourth is waiting until a

456
00:13:15,620 --> 00:13:17,299
list gets slow before doing

457
00:13:17,299 --> 00:13:18,580
anything about views and

458
00:13:18,580 --> 00:13:20,500
indexes, set up a filtered view

459
00:13:20,500 --> 00:13:21,139
early.

460
00:13:21,139 --> 00:13:24,019
Add indexes to the fields you
sort on, and the list stays

461
00:13:24,019 --> 00:13:24,940
quick as it grows.

462
00:13:24,940 --> 00:13:26,940
There's a fifth mistake that's
less obvious.

463
00:13:26,940 --> 00:13:30,059
People build a list and then
never tell anyone it exists.

464
00:13:30,059 --> 00:13:32,740
A tracker only earns its keep
when the team knows where it

465
00:13:32,740 --> 00:13:34,100
lives and how to use it.

466
00:13:34,100 --> 00:13:35,889
So share the link early and pin

467
00:13:35,889 --> 00:13:37,009
it somewhere people already

468
00:13:37,009 --> 00:13:37,889
work.

469
00:13:37,889 --> 00:13:40,490
If you want a simple rule to
carry with you, here it is.

470
00:13:40,490 --> 00:13:43,090
If several people need to update
the same structured information

471
00:13:43,090 --> 00:13:44,929
and see it live, a list fits.

472
00:13:44,929 --> 00:13:46,049
If one person needs to crunch

473
00:13:46,049 --> 00:13:47,210
numbers in private, reach for

474
00:13:47,210 --> 00:13:47,809
Excel.

475
00:13:47,809 --> 00:13:48,809
The pain almost always comes

476
00:13:48,809 --> 00:13:50,250
from mixing those two situations

477
00:13:50,250 --> 00:13:50,730
up.

478
00:13:50,730 --> 00:13:51,970
That one distinction explains

479
00:13:51,970 --> 00:13:53,370
almost every complaint about the

480
00:13:53,370 --> 00:13:53,929
tool.

481
00:13:53,929 --> 00:13:55,210
People who expect a spreadsheet

482
00:13:55,210 --> 00:13:56,809
from a list feel let down, and

483
00:13:56,809 --> 00:13:58,169
people who need shared structure

484
00:13:58,169 --> 00:13:59,330
wonder how they ever managed

485
00:13:59,330 --> 00:14:00,409
without it.

486
00:14:00,409 --> 00:14:02,690
The short version and one
question for you.

487
00:14:02,690 --> 00:14:03,970
So let's bring it together.

488
00:14:03,970 --> 00:14:05,610
Microsoft Lists gives your team

489
00:14:05,610 --> 00:14:07,190
one shared, structured place to

490
00:14:07,190 --> 00:14:08,370
track information inside

491
00:14:08,370 --> 00:14:09,470
Microsoft three hundred sixty

492
00:14:09,470 --> 00:14:09,970
five.

493
00:14:09,970 --> 00:14:10,970
It stores that data in

494
00:14:10,970 --> 00:14:12,210
SharePoint, keeps it clean with

495
00:14:12,210 --> 00:14:13,570
typed columns, shows it through

496
00:14:13,570 --> 00:14:15,009
flexible views, and can automate

497
00:14:15,009 --> 00:14:16,250
the busy work with rules in the

498
00:14:16,250 --> 00:14:17,129
power platform.

499
00:14:17,129 --> 00:14:19,529
It's not a spreadsheet and it's
not a database.

500
00:14:19,529 --> 00:14:20,809
It's the middle ground your team

501
00:14:20,809 --> 00:14:21,970
keeps trying to build out of a

502
00:14:21,970 --> 00:14:22,690
flat file.

503
00:14:22,690 --> 00:14:24,049
My question for you is this.

504
00:14:24,049 --> 00:14:27,049
What's still living in a messy
spreadsheet that a list might

505
00:14:27,049 --> 00:14:29,730
handle better if this made the
topic feel less intimidating?

506
00:14:29,730 --> 00:14:31,570
Subscribe to M365 FM.

507
00:14:31,570 --> 00:14:32,690
To master the tools and the

508
00:14:32,690 --> 00:14:34,409
mindset shaping the future of

509
00:14:34,409 --> 00:14:34,970
work.