►
Description
Microsoft 365 & Power Platform Development community call on August 18th. Demos: Independent Publisher Connectors - RegEx Matching Demo, List Formatting Magic – Data and Time formatting options, and Create a list template from your pre-configured list with list formatting definitions. Delivered 2 new/updated Power Platform Independent Publisher Connectors along with 10 script, 2 Teams, and 4 Power Platform samples. Awesome work! Register for September Sharing is Caring trainings. Please see the blog post for this call for project updates, news and events details. The host of this call was David Warner II (Microsoft) | @DavidWarnerII. Q&A takes place in chat throughout the call.
Learn more
• See the full blog post for this call in the Microsoft 365 platform community blog - https://aka.ms/m365pnp/blog
• Download invite for the Microsoft 365 Developer community call: http://aka.ms/spdev-sig-call
• Microsoft 365 Unified Sample gallery - https://aka.ms/m365/samples
• Microsoft 365 Platform Community in YouTube - https://aka.ms/m365/videos
• Microsoft 365 Platform Community - http://aka.ms/m365/community
A
Live
with
the
community,
this
is
the
microsoft
365
and
power
platform.
Development
bi-weekly
call
today
is
august,
18th
where's
the
year
going.
I
am
your
host
david
warner
with
microsoft.
Let's
talk
about
what
our
fantastic
voyage
is
going
to
include.
Today
we
are
going
to
see
the
latest
updates
on
community
we're
going
to
see
pnp.net
library
updates,
pnp,
powershell,
independent
publisher,
connectors,
we're
going
to
talk
about
script,
samples,
microsoft,
team
samples,
power
platform,
samples
all
the
samples
and
then
what
time
will
it
be
picture
time
together
mode
with
the
community?
A
But
before
we
go
any
further,
we
do
want
to
call
our
fantastic
presenters.
Today,
we've
got
some
rock
stars:
mitten
shoe
is
going
to
cover
the
regex
matching
demo
today
on
the
independent
publisher,
connectors,
and
then
we've
got
chris
kent
back
to
talk
about
list
formatting
attack
of
the
hooves
you
can
see.
We
got
a
little
theme
going
on
here,
so
we're
excited
to
see
all
of
our
presenters
today.
Now
there
are
opportunities
for
every
single
one
of
you
to
participate
in
this
community.
We
absolutely
want
to
have
you
be
part
of
it?
A
You
can
demo
a
solution
or
a
technical
pattern
on
this
call
like
you
see
our
presenters
doing
today,
you're
more
than
welcome
to
do
that,
and
to
do
that,
you
would
simply
just
fill
out
that
little
form
we
made
it
easy
for
you
ak
dot.
Ms
four
slash,
m365
pnp,
slash,
request,
slash
demo
and
you
can
fill
out
a
little
form
tell
us
that
you
would
like
to
present
and
we'll
get
back
to
you
and
get
you
into
the
rotation.
So
we're
very
excited
about
that
and
don't
be
don't
be
overwhelmed
by
it.
A
If
you've
not
done
a
presentation
before,
don't
hesitate,
it's
a
really
easy
process
and
we
can
even
buddy
you
up
with
someone
if
you'd
like
within
the
team,
to
make
sure
that
it's
an
easy
process
for
you.
You
can
also
contribute
on
github
you're,
going
to
see
a
number
of
initiatives
today
and
programs
that
allow
you
to
do
that
and,
of
course
we
enjoy
getting
feedback.
We
want
to
hear
all
the
feedback
opportunities
that
you
have
to
provide.
We
just
ask
you
to
keep
a
positive,
even
if
it's
improvements
that
you'd
like
to
see
done.
A
No
problem
we
want
to
make
this
the
best
community
for
you,
so
don't
hesitate
to
provide
that
feedback
to
us
now.
There
are
a
number
of
initiatives
and
programs
and
resources
available
to
you.
As
you
can
see
here
we
have
videos
aplenty,
community
and
developer.
We
have
open
source
project,
sharepoint
office,
dev,
microsoft
graph.
We
have
got
a
plethora
of
sample
galleries
for
m365
team
samples,
spfx
samples,
spfx
extensions
list,
formatting,
oh
my
so
much
more,
do
you
need
to
remember
all
of
them?
Absolutely
not!
A
A
If
you
like
this
community
call-
and
you
want
to
join
in
more,
we
absolutely
have
lots
of
opportunity
for
you.
The
microsoft
365
platform
call
is
a
weekly
call.
It
starts
back
up
on
the
6th
of
september.
That
is
on
a
summer
break
right
now,
but
this
is
a
weekly
call.
That's
coming
straight
to
you
from
microsoft,
meaning
that
all
the
presenters
are
direct
from
microsoft.
A
Product
managers,
program
managers,
engineers
they're,
going
to
show
you
the
latest
and
greatest
on
a
variety
of
topics
and
features
and
products
so
definitely
want
to
get
that
on
your
calendar.
If
you
don't
already,
we've
also
got
adaptive
cards,
microsoft,
dining
platform,
office,
add-ins
power
platform,
which
just
happened
yesterday,
that's
once
a
month
and
then
the
call
you're
on
right
now,
microsoft,
365
empower
platform,
development
is
bi-weekly
and,
of
course
it's
sibling,
viva
connections
and
sharepoint
framework.
That
is
also
bi-weekly,
just
flip-flops
there
so
that'll
be
next
week.
A
You
can
access
all
of
them
at
ak.
Dot,
ms4
m365
calls
now
you're
going
to
see
a
number
of
opportunities
to
contribute.
Today,
a
number
of
programs
sample
galleries-
and
you
may
say
I
don't
really
love
to
do
I'd-
love
to
submit
to
those
I'd
love
to
be
a
part
of
that,
but
I'm
not
quite
sure
where
to
get
started
or
how
to
do
that.
Well,
sharing
is
caring
is
a
program
that
we
provide.
That
is
hands-on
guidance
now.
What
does
that
mean?
A
What's
a
fork.
What's
a
pull
request?
Well,
we'll
walk
you
through
it
and,
of
course
you
know
what
we
don't
even
record
it
it's
safe
space
for
you
to
ask
any
and
all
questions
that
you
would
like.
That
means
that
you
can
feel
confident
leading
there
because
we'll
walk
you
through
together
and
you'll
even
get
a
contribution
credit
for
it.
So
please
don't
hesitate.
We've
got
more
now.
The
summer's
ending
we've
got
more
dates
coming
up
and
spinning
up,
and
so
we
invite
everyone
to
go
check
that
out.
A
We'll
have
even
more
dates
as
the
week
ends
here
and
the
weekend
ensues,
so
don't
hesitate
to
take
advantage
of
that
now.
We
also
want
to
recognize
you
for
all
the
great
work
once
you've
done,
that
our
recognition
program
is
a
program
that
we've
set
up
to
officially
and
formally
evangelize
and
celebrate
and
recognize
the
amazing
work
that
you're
doing
this
is
powered
by
credly
yeah,
that
same
credly
that
you
get
badges
from.
When
you
pass
a
microsoft
certification
exam,
they
will
sit
right
alongside
it.
Why
does
it
matter?
A
Well,
it's
because
you're
being
recognized
for
the
work
you're
doing
in
the
community
and
that's
powerful
when
you're
able
to
go,
show
your
managers
or
your
clients
that
you're
making
a
difference
in
the
community,
and
it's
no
cost
to
you,
so
you
can
associate
it
to
your
linkedin
profile,
share
it
on
twitter,
throw
it
on
the
fridge.
I
know
I
do
the
family's
proud
of
me
and
I
get
all
kinds
of
hugs,
so
I
want
you
to
get
hugs
too
aka.ms
ford,
slash,
m365pmp,
dash
recognition.
A
You
only
need
to
register
once,
but
we
do
need
you
to
register
and
opt
in,
so
that
we
can
tie
your
github
contributions
to
that.
In
fact,
our
presenters
today
will
also
get
a
badge
for
being
a
presenter,
so
you
get
those
as
well,
so
don't
hesitate.
We
know
lots
are
really
enjoying
that
and
you'll
see
even
more
badges
coming
out
soon
this
weekend,
in
fact,
for
those
that
have
put
in
their
pull
requests
and
contributions,
all
right.
Let's
move
into
pnp.net
libraries,
and
for
that
we'll
hand
it
over
to
vesa.
B
Obviously,
bmp
powershell
and
many
of
the
other
things
are
using
this
particular
library,
because
it
is
that
library
which
is
being
used
behind
of
these
abstractions.
Now,
overall,
there's
more
than
220
000
tenants,
which
were
using
this
particular
automations
within
the
last
month,
which
is
mind-boggling
the
on
the
usage.
So
but
your
contributions
for
the
welcome,
please
check
them
out.
They
will
help
do
development
within
the
cloud
and,
let's
move
then
to
pmp
publisher
site
with
golden.
C
We
fixed
a
bug,
but
it
was
basically
kind
of
broke
some
stuff,
but
it
was
overall,
a
good
improvement
so
that
so
one
of
the
things
that
we
changed
was
related
to
like
connect
pnp
online.
So
that
was
one
of
the
major
changes
that
we
have.
So
the
thing
is:
if
you
want
to
use
connect
pnp
online
for
multiple
connections,
we
made
it
a
lot
more
simpler
and
that
kind
of
broke
some
minor
scripts
for
that,
but
yeah,
it's
overall,
a
very
good
improvement
and
is
a
good
change
that
we
had.
C
What
next
so
nightly
builds
are
continuing.
There
are
some
minor
bug
fixes
and
a
lot
of
documentation
updates
that
are
going
on
here.
By
the
way
did
you
know
that
pnp
powershell
supports
retrieving
of
the
sensitivity
label,
so
we
added
that
yeah.
We
added
that
command
to
retrieve
the
sensitivity,
labels
and
all
so
yeah.
C
C
A
Awesome,
thank
you
got
him
very
well
done
very
excited
for
those
updates.
Next
up
is
yo
teams,
so
v4
has
been
released.
This
is
the
generator
for
spf
x
and
teams
applications.
So
lots
of
features
in
v4
continuing
to
see
some
progress
here.
So
if
you
want
to
learn
more
about
using
your
spfx
skills
and
magic
for
creating
teams,
applications
definitely
check
out
aka
dot.
Ms
forward
slash
yo
teams
and
then
we'll
move
into
microsoft.
Graph
toolkit,
so
seb
is
out
with
his
lovely
baby
boy
spending
time
with
his
family.
A
What's
new
v2
2.6.0
is
the
latest
release.
It's
been
a
little
slow,
obviously,
with
him
being
out
we'll
see
some
more
updates
as
he
gets
back,
but
if
you're
unfamiliar
this
is
your
opportunity
to
use
fluent
ui
components
to
connect
to
the
graph
super
easy.
You
can
utilize
these
within
a
number
of
development
opportunities,
even
within
the
content
query
web
part.
In
fact,
that
makes
it
super
easy
to
connect
to
the
graph
without
feeling
like
you
have
to
be
overwhelmed.
A
D
Hello,
everyone
happy
thursday
and
so
independent
publisher
connectors
for
those
of
you
who
don't
know
what
they
are.
These
are
power
platform
connectors
that
are
submitted
by
anyone,
whether
you're,
an
mvp
or
a
non-mvp,
or
a
student
we've
had
so
of
a
wide
variety
of
people,
contribute
to
this
program
and
receive
the
badge
that
you
see
here
from
crudley,
but
also
get
an
opportunity
to
have
their
name
directly
in
the
product
right
next
to
their
connector.
So
we
have
53
awesome,
independent
publishers,
independent
publisher,
connectors,
so
working
our
way
to
200,
which
is
incredible.
D
Recently,
we've
just
had
two
updates
to
existing
connectors.
There's
two
square
connectors
that
troy
taylor
has
built
one
square
business,
one
square
payment,
so
we
had
some
additions
to
those
connectors,
definitely
check
them
out,
especially
once
those
changes
are
deployed
in
terms
of
how
you
can
participate,
you
can
become
an
independent
publisher
by
you
know
if
you
already
have
a
custom
connector
that
you've
built
that
you'd
love
to
share
or
have
as
an
official
connector
in
our
platform.
D
More
than
welcome
to
do
that,
if
you're
not
sure
where
to
start
and
which
connector
to
build.
We
do
have
a
link
in
our
github
repository
called
topconnector
asks
that
we
update
frequently
to
make
sure
that
where
it's
it's
all
up
to
date
or
you
can
also
extend
one
of
the
existing
independent
publisher
connectors,
maybe
there's
one
that
you
use
very
frequently,
and
you
realize
it's
missing
a
trigger
in
action
that
might
be
helpful
to
you
or
others,
definitely
a
great
way
to
participate
as
well
thanks.
Everyone.
A
Awesome
thanks,
natalie
and
well
done
troy.
I
guess
it's
hip
to
be
square
right.
I
guess
that's!
Okay!
Lame!
All
right!
I
see
todd,
give
me
the
thumbs
down
because
he
didn't
say
it.
That's
why
that's!
He
would
have
loved
it
if
he
had
said
it.
So
all
right.
Let's
move
on
to
script
samples
with
paul
bullock,.
E
Hey
everybody,
so
script
samples
is
a
tool
where
you
can
automate
tasks
within
365
and
upload
your
scripts
to
this
repository
and
share
them
with
the
community.
So
we
support
things
like
samples
from
the
cli
for
microsoft,
365,
pmp,
powershell,
sp
management,
shell
graph,
sdk,
a
whole
range
of
tools
that
can
be
supported
and
if
you
don't
feel
they're
supported,
I
can
always
add
that
capability
into
the
into
the
site
so
that
those
samples
can
be
articulated.
E
We've
had
a
great
set
of
new
samples
over
the
last
month,
so
I'll
just
call
those
out.
So
we've
got
some
new
ones
with
pmp
powershell,
specifically
like
exporting
checkout
files
associated
with
hub
sites
to
csv
by
arash
afghani.
We've
got
restore
large
number
of
items
for
sharepoint,
recycle
bin
in
bulk
by
paul
matthews,
our
request
we
index
or
sharepoint
user
profile
properties.
By
top
clint
we've
got
create
sharepoint
site,
sorry,
just
celebrate
there
create
sharepoint
site
and
using
configuration
by
another
site
by
layers.
E
Babette
we've
got
bulk
publishing,
syntax
models
to
libraries
by
leon,
armstrong,
update
user
profile,
product
properties
on
modern
pages
by
ramen,
and
we've
got
a
new
example
for
the
cli
from
microsoft.
365.
so
get
azure
ad
app
permissions
with
macro
elliott.
We've
also
got
some
updates
to
existing
pmp
powershell
scripts.
E
We've
got
two
from
todd
clint,
so
that's
add
a
document
library
web
part
to
a
page
and
a
tweet
to
that
re-index
user
profile
property
sample
previously
mentioned
and
also
copy
planner
plan
from
reshmere
accolade.
So
this
is
absolutely
awesome.
There's
also
been
a
few
conversations
on
twitter
and
the
community
around
scripts
relating
to
permissions
and
apps,
and
things
like
that.
So
what
I
have
done
is
add
a
security
filter
to
the
site
so
that
you
can
see
which
scripts
related
to
those
particular
that
particular
topic.
But
thank
you.
E
A
F
Hey
everybody:
how
are
you
we
have
two
new
samples
this
week,
which
I'm
really
excited
about
the
first
one?
Now
I'm
sure
that
a
lot
of
you
have
been
spending
late
nights
thinking
about
could
I
use
the
teams
toolkit
and
the
graph
toolkit
at
the
same
time
or
would
perhaps
this
might
destabilize
the
time
space
continuum
and
cause
all
kinds
of
of
crazy
things
to
have
the
two
toolkits
in
one
solution?
Well,
I
chabash.
My
colleague
has
actually
proven
that
you
can
do
both
together
with
this
new
sample,
which
is
the
one
productivity
hub.
F
F
This
one's
kind
of
bare
bones:
it's
just
what
you
need,
sometimes,
if
you're
building
a
meeting
app
and
you're
trying
to
figure
out
what
information
can
I
get
about
the
meeting
that
I'm
in
or
how
do
I
wire
up
a
bot
to
get
yes
in
order
to
get
some
of
this
information,
you
need
a
bot,
even
if
your
solution
is
a
tab,
so
marcus
has
really
demystified
this
in
the
second
sample.
So
please
go
check
out
both
samples
and
I'll
shoot
it
back
over
to
you,
david.
A
D
A
B
B
B
We
still
have
a
few
seats
on
the
room
so
before
we
start
recording
a
few
more
rows,
I
will
come
here
as
well.
I'm
all
the
way
on
the
left.
I
guess
that's
full
room.
So
let's
do
I
still
getting
few
beers.
I
will
start
recording
and
we
can
crap
a
nice
gif
animation
out
of
that.
So
thank
you.
Everybody
once
again
for
joining
us
on
the
community.
This
community
is
here
for
you
and
it
wouldn't
be
here
without
you.
A
David,
it's
gonna
be
a
dance
off.
Thank
you,
visa
dance
off
with
todd
all
right,
okay!
Well,
that
brings
us
to
our
fantastic
presenters
of
the
day.
Our
first
one
has
been
chew.
Garg
he's
gonna
show
off
an
independent
publisher,
connector,
specifically
for
regex
matching,
so
mint.
You
feel
free
to
take
it
over.
G
G
I
work
for
schlumberger
as
a
digital
sell
league
and
I've
worked
across
three
different
countries,
and
only
last
weekend
I
have
relocated
to
the
us.
We
have
a
like
equivalent
of
a
champions
program
called
special
agent
program
and
I'm
recognized
as
a
special
agent
zero
one
eight
within
schlumberger.
G
G
Now.
Why
do
we
need
this
regex
matching
in
power
automate?
So
I
had
a
use
case,
but
what
I
saw
was
out
of
the
box.
This
functionality
is
only
available
within
powerapps
and
apologies.
If
it
is
there
and
power
automatic
it's
just
that,
I
was
not
able
to
find
one.
So
there
was
like
I
couldn't
find
any
out
of
box
solution
in
power
automate,
so
I
came
across
independent
connector
and
that
came
to
my
rescue
in
that
particular
situation.
G
G
There
can
be
multiple
use
cases
where
you
want
to
validate
your
end
user
data
input
so,
for
instance,
if
you
want
legacy
data
in
a
spreadsheet
that
you
want
to
port
over
to
dataverse
or
to
sharepoint,
but
you
want
to
check
whether
user
input
is
good
or
you
are
having
you
know,
some
input
done
through
microsoft
form.
Where
again,
you
cannot
have
super
powerful,
client,
side,
validation,
so
you're
doing
it
through
power
automate
before
entering
it
into
into
your
database.
G
This
particular
connector.
It
returns
boolean,
true
or
false.
If
the
input
string
matches
the
regular
expression,
there
are
multiple
predefined
expressions
in
here.
However,
a
developer
can
provide
their
own
custom,
regular
expression,
so
you
don't
have
to
use
any
of
the
people.
You
get
a
generic
one
where
you
know
you
specify
your
own
regular
expression
and
go
with
it
so
demo
time.
G
G
So
I
choose
my
next
operation
under
regex,
and
so
the
first
one
we
wanted
to
check
was
whether
an
email
is
valid
or
not
so
check
for
valid
email
format.
Now,
this
again
regex
by
nature,
it
does
not
check
whether
an
email
id
exists
or
not.
It
is
just
going
to
tell
you
whether
it
looks
like
an
email
address,
whether
you
know
formatting
or
the
semantics
of
it
is
that
of
an
email
address
so
over
here
we
would
get
the
user
input
so
input
from
the
user.
G
G
G
G
Regex
pattern,
so
let's
say
we
want
a
to
z
up
to
three
digits,
and
that
was
that
is
our
pattern
and
the
request
that
we
are
checking
it
against
is
say
one
two,
three.
So
for
the
email
we
are
expecting
it
to
come
as
true
and
for
the
regex
pattern.
We
are
expecting
it
to
say
it
hasn't
found
the
match.
So
we
are
expecting
it
to
say
false
over
here.
G
So
if
I
went
to
the
summary,
so
it
was
telling
me
that
yes,
email
was
found,
but
the
custom
pattern
was
false,
because
one
two
three
did
not
match
the
a
to
z
up
to
three
digits,
so
that
is
it
right.
It's
a
pretty
straightforward,
very
simple,
connector
that
lets
you
provide
your
own
regular
expression
or
pick
up
one
of
the
inbuilt
ones
and
validate
your
end
user
input
before
you
use
that
data
into
any
of
your
subsequent
business
operations.
A
Right
awesome
menu
that
that
is
really
cool,
because
I
got
to
tell
you:
regex
is
like
kryptonite
to
some
of
the
best
developers
in
the
world
right
being
able
to
utilize
a
connector
like
this
to
make
it
so
so
simple
is
really
really
fantastic.
So
thank
you
for
sharing
that
very,
very
cool
links
to
the
independent
publisher,
connector
and
in
the
github,
the
docs
and
github
are
in
the
chat.
H
H
You
can
see
they
all
start
with
number
down
here
and,
if
you're
looking
for
that
particular
one,
it's
number
level
bar.
So,
if
you're
looking
for
this
one
right
there,
it
is,
we've
got
a
bunch
of
those.
So
that's
exciting
and
that's
what
I've
chosen
here
and
what
we're
going
to
look
at
now
is
we
want
to
take
this
a
little
further
right,
so
we
want
to
actually
start
tracking
some
progress
or
we've
got
a
status
and
and
that's
okay
right,
but
we
really
want
to
you
know
it's
been
three
months.
H
The
only
one
that's
actually
been
murdered
here
is
martha
washington
because
she's
already
dead,
so
that's
pretty
lame
right.
So
how
are
we
to
track
these
right?
Make
sure
that
our
assassinations
happen
on
schedule,
so
oftentimes
you're
going
to
add
a
you
know
a
date
column,
so
we're
going
to
have
a
date
and
time
column
here
and
we're
just
going
to
actually
we're
going
to
come
back
to
that.
First,
I
want
to
look
just
at
columns
in
general,
so
let's
show
hide
columns
and
I'm
just
going
to
show
the
modified
right.
H
So
I
want
to
talk
in
general
about
dates
and
times
how
we're
working
with
those
right.
So
we've
got
this
modified
date.
You
can
see
it's
got
this
friendly
display
where
it's
showing
you
know.
I
added
these
just
a
little
bit
ago,
the
other
ones
again
back
in
may
right
and
that's
okay.
But
what
if
we
want
to
do
a
little
more
with
that?
So
if
we
format
this
column
advanced
mode,
so
we
can
see
that
let's
go
over
a
little
bit
and
let's
hide
up
hide
that
stuff.
H
Okay,
let's
get
that
a
little
bigger,
that'll
be
fun
that
way,
and
just
for
funsies
that
sounds
good.
We're
gonna
type,
an
l
type
here
and
we're
gonna
say
it's
a
div
right,
and
that
way
we
can
just
get
to
our
text
content
right
and
if
we
were
to
say
you
know,
act
current
field,
that's
our
magic
placeholder
token
it'll,
take
whatever
the
value.
Is
there
we
preview
it
there.
H
H
It's
just
not
showing
it
right
because
that's
more
about
the
editing
and
the
view
experience,
so
you
will
have
to
account
for
those
when
you
start
doing
your
own
formatting,
and
so
what
I
want
to
look
at
is
how
do
I
determine
how
many
days
ago,
something
was
right.
Now,
that's
something
that
comes
up
a
lot
or
we
just
want
to
be
able
to
do
date,
calculations
based
on
days
or
something
else.
Now
we
don't
have
a
you
know
a
date.
You
know
ad
or
a
date.
H
One
of
those
types
of
functions
get
the
date
difference.
Unfortunately,
but
we
can
do
some
cool
things
with
that,
but
because
time
is
in
there
it
starts
to
mess
with
us
right.
So
one
of
the
things
we
can
do
is
we
can
say
equals
and
we
could
have
all
sorts
of
different
things.
So
I'm
going
to
say
locale
is
a
date
string.
Let's
try
that
string
right.
It
should
look
pretty
much
the
exact
same,
except
now.
It's
just
the
date
right
now.
We've
got
a
couple,
others
there's
a
date
time.
H
Let's
see
nope,
oh
it's
just
a
little
cal
string.
I
think.
Actually,
you
know,
because
that
makes
sense
there
we
go
okay,
so
that
idea
we
can
start
to
do
that
and
I'm
doing
that
for
a
reason,
so
we
can
make
sure
we're
always
seeing
the
same
format
here
now.
If
I
wanted
to
break
this
thing
down
right,
one
of
the
things
is,
I
can
get
certain
values
out
of
this.
I
can
say
you
know
I
can
get
the
month.
H
I
can
get
the
the
day
and
I
can
get
the
year
and
if
I
wanted
to
zero
this
out,
so
the
problem
is
that
time.
So,
if
I'm
starting
to
do
calculations
between
these,
the
only
real
way
to
do
that
is
within
converting
these
dates
to
numbers,
which
is
the
millisecond
since
1970,
which
you
know,
confuses
everyone,
and
we
want
to
make
that
a
little
easier
because
we
don't
want
to
account.
For
you
know
this
is
512
right,
but
it
also
has
this
extra
10
and
a
half
hours
on
top
of
it
right.
H
So
we
don't
want
to
mess
with
when
we're
doing
those
kind
of
calculations.
Since
we
want
to
compare
to
now-
and
we
want
that
date-
you
know
the
number
of
days
to
not
change,
as
our
clock
goes
up
throughout
the
day
right.
We
don't
want
this
now
that
we're
at
10
30
and
not
10
25.
Now
it
has
an
extra
day.
That's
not
what
we're
really
going
for.
H
Accurate,
but
it's
not
what
we're
looking
for
we're
looking
for
the
date
to
date.
Comparison
so
we're
gonna
talk
about
zeroing
out
these
dates,
so
we
can
do
that
by
using
a
lovely
little
thing
called
the
date
all
right.
So
when
we
use
the
date
function
and
we
put
in
a
date
here
right,
you
can
type
in
a
date,
so
we
type
in
12,
26,
1981
a
wonderful
day
right
and
we'll
preview.
That
and
now
you
can
see
it
has
just
the
date
right,
but
it
actually
pulled
out
a
time.
H
So
it's
actually
converting
that
to
a
date
time
from
a
string
now
this
is
locale
dependent.
Unfortunately,
so
you
all
have
to
take
that
into
account.
So
in
my
locale
here
in
the
us
right,
we
do
month
first,
because
you
know
that's
how
freedom
and
stuff
okay.
So
in
this
case,
if
we
wanted
to
build
our
own
right
based
off
of
the
current
value,
we
can
actually
build
this
as
a
little
string
inside
here.
H
Make
sure
we
had
a
plus
right
we're
building
a
little
string
inside
here,
we're
going
to
say
a
plus
and
we're
going
to
say
get
date
instead
of
day
match
the
javascript
nonsense
right.
So
current
field,
alright
so
get
date,
and
then
we're
gonna
plus
we're
gonna,
add
another
slash.
And
then,
if
we
add
the
year
right,
that's
gonna
get
our
four
digit
year.
H
So
there
we
go
now
we
run
that
we're
going
to
see
an
issue
here,
and
that
is
month
in
javascript's,
infinite
wisdom
is
zero
based
index
of
the
month
right,
so
january
is
zero,
and
so
because
this
is
going
to
string
we're
just
going
to
say
plus
one
to
it
and
there
we
go.
We
just
corrected
it.
So
now
you
can
see
we've
actually
zeroed
out
our
date
right.
So
now
it's
at
12
a.m.
For
all
of
these,
and
we
don't
care
about
time
anymore.
We
have
a
zeroed
out
date,
which
is
pretty
cool.
H
We
could
take
that
exact
same
thing.
Let's
get
rid
of
this
extra
thing
and
we
can
zero
out
our
current
time
right.
So,
let's
just
copy
that
for
simplicity
and
we're
gonna
say
you
know,
put
that
in
there
we'll
come
back
to
that.
We're
gonna
swap
out
at
current
field
with
at
now,
which
is
a
magic
placeholder
token
as
well,
and
that
is
the
time
at
render.
H
So
when
you
load
this
view
up-
and
it
applies
the
format
that
is
the
time
that
it
applied
the
format
so
there
he
goes
now-
we've
got
these
two
things
and
if
we
wanted
to
do
math
on
them
well,
we
need
to
convert
these
to
a
number.
So
we're
going
to
wrap
this
guy
in
a
number
I'm
going
to
come
down
here,
we're
going
to
wrap
this
guy
in
a
number.
So
we
can
subtract
this
guy
and
we're
going
to
say
right.
H
So
now
we've
got
a
number
subtracted
a
number,
and
if
we
look
at
that,
that's
going
to
be
really
pretty
right,
but
you'll
notice
that,
because
we've
zeroed
out
the
dates,
you
can
see
that
we
have
an
exact
zero,
because
this
is
the
number
of
milliseconds
in
terms
of
days
very
helpful
right.
But
we
can
make
it
more
helpful
and.
G
H
Way
we
do
that
is
we
wrap
this
whole
thing
and
another
set
of
parentheses
just
to
make
sure
I
don't
mess
up
our
order
of
operations
because
you
know
I
do
all
right.
We're
gonna
subtract
that
now
we
could
just
type
in
the
actual
value,
but
I
find
it's
a
lot
easier
to
read
if
you
can
call
any
of
this
easy
to
read
by
you
know
the
number
of
milliseconds
times
the
number
of
seconds
times
the
number
of
minutes
times
the
number
of
hours
in
a
day,
all
right.
H
If
we
divide
that,
then
we
get
hey
there's
the
number
of
days
ago
and
we
could
even
put
a
plus
space
days
ago
all
right,
ooh
fancy.
But
the
idea
here
is
before
I
did
the
calculations
on
the
dates
I
zeroed
them
out,
because
I
didn't
care
about
times.
So
I
know
that
that's
a
very
friendly
formula
there,
but
that's
why
we
tried
to
build
it
as
we
went
up
right.
So
that's
exciting,
so
we're
going
to
save
that
wow
all
right.
So
now,
let's
talk
a
little
more
right.
H
So
now
we
want
to
do
something
else
with
dates
right.
So
a
lot
of
times
we
want
to
actually
compare
dates.
So,
let's
add
a
new
date
time
column
right,
so
we
can
hack
track
when
this
is
done.
So
this
is
eliminate,
buy
right
and
we
don't
really
care
about
time.
We're
not
going
to
include
it.
Although
we
know
it's
going
to
be
midnight
inside
internally,
we're
just
going
to
say
save
we
got
eliminate
by
thank
you
for
covering
up
my
column,
go
away
all
right.
H
I
don't
care
about
the
status
anymore.
There
we
go
we'll
just
look
at
the
status
perfect.
You
know
we
edit
that
in
grid
view,
so
we
can
just
set
a
couple
dates
here,
all
right,
so
we
had
we'll
say
you
know,
eliminate
this
guy
by
next
month,
sometime
right
and
we're
gonna
eliminate
this
guy.
I
don't
know
the
next
month
after
that-
and
I
don't
know
I'm
picking
these
at
random
here
november
30th,
and
it
will
say
this
one.
You
know
martha
washington,
we
don't
care,
it
doesn't
matter
all
right
and
patrick
yeah.
H
We
gotta,
we
gotta
get
rid
of
him,
but
we
can
wait
till
january
on
him
all
right
I'll.
Let
him
get
a
little
more
get
another
release
of
pnpjs.
First
and
a
little
demny
will
just
say
you
were
overdue
right.
That
should
have
been
yesterday
all
right,
so
that's
exciting.
Now
we've
got
some
exciting
sample
dates
in
there
and
one
of
the
things
we
can
do.
If
we
go
to
column
settings
we're
going
to
format
this
column
and
I'm
going
to
scroll
over.
H
So
we
can
see
that
all
right,
we're
going
to
come
in
here-
and
I
just
want
to
change
this
slightly
all
right.
So
I'm
going
to
say
elm
type
is
a
div
and
I'm
going
to
say
the
text.
Content
is
at
current
field
and
if
I
want
to
look,
you
know
the
way
I've
configured
the
date
to
look,
I'm
going
to
say
display
value
at
the
end,
all
right
and
that's
not
going
to
change
much
of
anything
right
there.
But
that's
giving
us
that.
But
the
one
nice
thing
we
can
add
is
inline
edit
field.
H
So
I
don't
have
to
switch
to
quick
edit
all
the
time
right-
and
I
just
put
at
current
field
all
right
and
when
I
do
that
it
doesn't
change.
Much
visibly,
but
we
can
actually
when
we
cover
it
now
we
get
this
now
we
can
click
it,
and
now
we
have
a
date
picker
right
here
without
going
into
that
quicken
right.
So
that's
really
nice
right
now
to
go
to
the
grid
view
to
see
all
that
we
can
just
edit
those
dates
as
needed.
H
H
So
far
now
we
can
come
in
here
and
we
can
write
some
conditional,
formatting
rules
and
those
work
great,
but
I
don't
want
to
demo
those
so
we're
going
to
come
in
here
and
what
we're
going
to
demo
is
the
additional
row
class
all
right.
So
this
is
the
idea
that
the
entire
row
I
can
apply
some
class
on
it
right.
So
just
a
saving
say
msbg
color
red,
because
who
doesn't
love
red
right
now,
everything's
red
right
and
that's
okay,
but
we
can
do
this
all
conditionally,
as
we've
seen
a
few
different
types
right.
H
So
let's
do
that
by
figuring
out
where
my
other
stuff
is
okay,
perfect,
okay!
So
now
what
we're
going
to
do
is
we're
going
to
write
this?
You
know
a
lot
of
times.
We
just
did
that
crazy,
math
right
when
we
were
comparing
the
numeric
fields
and
it's
like.
Does
anyone
actually
want
to
do
that?
No,
you
have
to
sometimes,
but
in
our
case
we
want
to
make
this
a
little
simple
right.
H
So
what
we
want
to
do
is
we
want
to
turn
things
red
if
they're
within
30
days,
right
and
if
they're
in
60,
we
want
to
make
them
orange
if
they're
like
90
days,
we'll
make
them
yellow
right
and
otherwise
don't
worry
about
it.
We
don't
need
to
flag
them
yet
they're
not
really
coming
up.
So
that's
kind
of
our
plan
here.
So
how
do
we
start
doing
that
now?
H
H
So
I'm
just
going
to
show
you
a
quick
trick
that
I
use
for
this,
and
the
first
thing
I'm
going
to
do
is
I'm
going
to
say
equals
and
say:
if
right-
and
the
first
thing
I
want
to
check
is
the
status
because
I
don't
want
to
do
anything
if
they're
deceased
right
so
first
thing
I'm
going
to
check
is
status,
I'm
going
to
say:
if
it
equals
deceased
right,
then
don't
do
anything.
Otherwise
we're
going
to
do
something
right.
H
So
otherwise
we
would
say
you
know
msvg
color
or
something
right,
we'll
come
back
and
fix
that.
But
the
idea
here
is
we.
What
do
we
do?
Is
dou
equals
equals
all
right?
Let's
try
that
again,
boom
right,
so
we've
already
eliminated
we're
not
going
to
apply
anything
to
deceased.
So
now
we're
just
going
to
go
into
our
else
statement.
H
We'll
write
the
rest
of
these
things
right
so
now,
let's
compare
so
the
easiest
way
to
compare
instead
of
doing
something
like
crazy
math
right
is,
we
can
say,
if
add
day
so
add
days,
we'll
take
a
date
right
in
this
case,
we're
going
to
say
now
and
we'll
add
a
number
of
days
to
it.
So
we're
going
to
say
30
right
and
so
we're
going
to
say
if
30
days
from
now
is
greater
than
our
eliminate
by.
I
think
that's
what
we
call
that
column
all
right.
Let's
make
sure
we
pull
that
over.
H
So
we
can
actually
see
that
column
very
easy
to
read
with
that
green
right.
Then
we
want
to
say
that's
going
to
be
ms
bg
color.
What
do
we
say
red
right
and
then
otherwise
we're
not
going
to
find
anything
just
yet,
let's
preview,
that
there
we
go
so
now,
we've
got
our
30
day
ones
all
right,
and
then
we
can
just
keep
this
little
pattern
of
nested
if
statements.
H
So,
instead
of
our
else
here
we
can
come
in
and
say
you
know
now
we
can
say
if
days
you
want
to
do
this
in
ascending
order
right,
so
the
earlier
ones
get
caught
before
that.
So
now
it's
60
and
we're
going
to
say
is
greater
than
that
eliminate
by
all
right
and
I'm
going
to
say,
that's
also
an
msvg
color
of
orange
and
then
otherwise,
nothing
all
right.
So
now
we
start
to
see
now
we've
got
an
orange
and
we
said
we
would
do
one
for
90
days.
H
So,
let's
preview
that
oh
probably
didn't
have
any
within
that
time
frame
or
I
didn't
do
right-
let's
see,
I
probably
shouldn't
pick
something
within
that
time
frame:
okay,
but
that's
the
idea,
so
we
can
start
to
apply
these
types
of
things,
and
if
we
save
that
you
know,
let's,
let's
get
one
within
90
days.
How's
that
so
maybe
we
just
need
to
go
back
a
little
bit,
how's
that
yep
there
we
go
there's
one
within
90
days
again.
That's
why
we
added
that
nice
inline
edit
field.
Now
the
colors
are
not
great
right.
H
Maybe
we
change
it
slightly.
We
say
orange
light,
let's
preview,
that,
let's
see,
if
that
looks
a
little
better,
that's
slightly
better
and
then
we
can
add.
You
know
other
things
for
like
the
the
text
right.
So
we
could
say
ms
font
color
in
this
case,
which
won't
be
white
or
something
right.
So
I
can
read
that
you'll
notice,
because
I
have
one:
that's
already
got
a
few
things.
It
is
affecting
a
couple
things
there
and
the
title
field
doesn't
necessarily
have
the
font
colors
being
applied
because
it
has
one
applied
automatically.
H
So
you'll
want
to
mess
with
that
just
a
little
bit
if
you're,
looking
for
where
I'm
getting
these
classes.
If
we
go
back
to
our
samples,
repo
right
up
at
the
top
right,
we've
got
this
link
right
here
and
if
we
go
to
our
groupings,
that's
where
I'm
getting
all
these
class
listings
right.
So
we've
got
a
background.
We
have
these
msbg
colors,
those
are
all
the
the
ones
and
bg
cubs.
H
It
sounds
like
bg's,
that's
funny,
okay,
we
got
all
these
right,
so
there's
a
ton
of
them
and
you
can
look
through
all
those
if
you
want
to
do
the
more
traditional
ones
that
are
seen
with
a
lot
of
this
formatting
like
the
wizards
and
other
stuff.
That's
these
sp
css
background
color
ones
where
you're
gonna
see
like
the
bg,
coral
right
and
each
one
of
these
actually
has
like.
H
So
if
you
see
bg
dark
red
here
all
right,
if
we
wanted
to
to
take
that
instead,
let's
grab
that
set
of
our
red
and
we
can
mix
and
match
these
as
needed
all
right.
So,
instead
of
our
red
here,
we're
just
going
to
put
that
guy
in
there
all
right,
we'll
preview
that
so
now
it's
kind
of
an
interesting
red,
but
because
these
have
these,
also,
if
you
check
over
here,
we've
got
so
we've
got
dark
red.
H
We
can
come
all
the
way
down
and
we
should
have
a
dark
red
text
I'll
just
I
know
it's
in
there,
so
I'm
going
to
type
it
here.
So
each
one
of
those
has
a
matching
sp
css
background
color,
it's
a
dark
red
text
has
a
matching
text.
So
let's
see
there
you
go,
it
doesn't
look
great,
but
that's
what
they
have
set
up
here,
so
you
can
so
that
I
actually
may
not
type
that
one
right.
So
maybe
I
should
have
looked
it
up
here.
H
We'll
come
out
here
to
the
red,
dark
text:
red,
dark,
red
text.
Okay,
I
think
it's
red
text
red
background
red
text,
but
the
idea
is,
you
could
use
those
I'm
going
to
eliminate
the
text
portion
right
now,
because
I
don't
want
to
mess
with
that
because
I
typed
it
wrong
and
why
would
we
mess
with
it
right
so
we'll
just
type
that
ms
bg
color
red
and
we'll
put
that
ms
font
color
as
white?
But
again
all
of
those
classes
are
listed
for
you
there
and
that's
a
great
place
to
reference
those.
H
H
If
I
go
to
the
gallery
view,
which
is
not
actually
a
separate
view
right,
let's
switch
to
design
mode,
you
know
it's
it's
so
obnoxious,
let's
go
back
and
you
know
we
go
to
format
current
view,
and
now
we
can
see
we
can
edit
our
card
right,
move
things
around.
Let's
make
sure
eliminate
buy
is
in
there
and
that's
cool
like
we've
got
our
different
things
here.
The
first
thing
you'll
notice,
though,
is
it's
not
really
showing
the
same
way?
You
know
we
click
this.
H
We
don't
actually
get
edit
ability
right,
it'll,
show
it
here
and
there's
our
threat
level
and
so
on
and
that's
cool.
If
we
go
to
advanced
mode
once
we
get
these
kind
of
where
we
want
them
right.
We
go
to
our
advanced
mode,
any
one
of
those
we
could
come
down
here.
Let's
go
to
our
modified,
for
instance,
right
we're
showing
the
three
things
again.
We
could
hit
ctrl,
f
and
say
modified
there.
It
is
we
found
it
and
so
right
here
it,
these
cards
are
generated
with
there's
the
title
up
here.
H
If
you
selected
to
show
the
title
and
then
the
next
one
is
going
to
be
the
actual
value.
Now,
that's
nice
that
they
generated
all
that
for
us
thanks.
No
thanks
right
because
we're
just
going
to
say,
column,
formatter
reference
in
this
case
we're
going
to
put
the
modified
column
there
as
our
column
of
reference,
make
sure
you
put
that
in
quotes,
because
you
know,
apparently
it
likes
it
to
be
in
quotes
there.
We
go
let's
preview,
that
there
we
go
so
now.
H
H
Content
is
our
current
field
and
we
want
to
do
something.
We
say:
custom
pro
action,
action
and
then
we'll
say
our
action
we're
just
going
to
do
share
because
I
just
want
to
show
a
button
all
right
if
we
preview
that
we
get
that
beautiful
beautiful
button.
But
when
we
click
on
it,
we're
prompted
with
the
share
dialog
right
and
again,
we've
got
samples
on
all
that.
That's
not
really
what
I'm
trying
to
show
what
I'm
trying
to
show
here.
So
I
save
that-
and
I
go
back
over
to
that
gallery
view
all
right.
H
So
our
titles
view
in
some
cases
right
and
we
go
and
format
this
current
view,
and
we
do
the
same
thing
for
title
field
right.
So
we
come
down
to
our
title:
gotta
try
to
display
name,
that's
fine!
We
do
our
column
formatter
reference
here,
so
column,
formatter
reference
field
name
is
not
field
name,
it
is
title.
H
H
This
top
guy
is
a
button
that
ends
up
hovered
over
the
entire
thing.
That
is
doing
a
custom
reaction
of
default
click
right
and
now
our
inline
editing
we'll
work
through
that,
and
so
will
our
edit
fields
like
if
we
do
some
of
those
custom
actions,
that'll
work,
but
our
buttons
don't.
So
if
we
just
kill
that
thing,
maybe
that
we
lose
our
ability
to
open
this,
but
we
can
double
click
it
to
open
it.
H
Then
we
can
then
get
our
shared
link.
So
I
just
wanted
to
point
that
one
out
as
you're
messing
with
these
doing
some
of
that
you
can
now.
One
of
the
other
things
I
want
to
point
out
is
what,
if
I
want
that
same
kind
of
row
class
thing
I
did
before
right-
that's
where
we
don't
have
a
row
class
for
galleries,
but
we
could
take
what
we
did
before
I'm
going
to
leave
that
in
there
just
so,
we've
got
it.
I'm
going
to
take
that
same.
H
You
know
stuff
we
did
before
and
let's
take
this
guy,
because
we
definitely
need
the
sp
card
container,
all
right,
so
we're
going
to
say
equals
sp
card
container
with
a
space
and
we'll
say
plus
that
right
so
now
we
should
have
so
now.
We've
got
that
same
logic
here,
but
we
don't
have
a
column
for
a
reference
for
the
additional
row
class.
We
can
do
that
same
thing
here.
H
If
you're
doing
the
calendars
type
stuff,
you
could
do
an
additional
event
class.
It's
the
same
thing
you
can
write.
All
of
that.
The
only
thing
I
would
say
with
the
calendar
is
be
careful
with
the
selection
you
do
need
to
handle
if
it
is
selected.
We
covered
that
two
weeks
ago.
If
you
want
to
look
up
that
video.
Okay,
all
that
to
say,
we've
got
this
lovely
stuff
here:
wow
wow,
wow
wow.
H
So
if
we
come
back
here-
and
we
like
this
hit,
lists
are
great-
you
know
it's
going
great,
but
we've
got
you
know
we're
expanding.
The
warrior
horse
is
getting
bigger
and
bigger.
So
now
we've
got
this
idea
of
we've
got
multiple
hit
squads
right
and
they
each
have
their
own
team
site
and
they're
like
oh
man.
We
really
want
this
right,
so
I
could
go
and
I
could
copy
the
list
from
the
thing
to
thing.
H
But
if
I'm
spinning
up
these
hit
squads
all
the
time
lots
of
murdering
to
be
done
right,
I
want
to
make
this
as
a
list
template
well
good
news.
We
can
do
that,
so
everything
we
just
configured
in
the
ui.
That's
where
you
start
so
you
want
to
configure
a
list
template
make
it
in
the
ui,
apply
everything
you
want
add
all
your
views
get
them
all
kind
of
sorted
out
and
ready
to
go,
and
then
you
can
head
on
over
to
powershell
everyone's
friend
and
we
do
have
a
couple
requirements.
H
H
H
Hey
good,
I
got
my
password
right,
that's
always
a
good
sign
all
right.
So
now
we're
connected,
and
the
thing
you
can
do
is
we
could
say
we're
going
to
set
a
value
to
extracted
right.
That's
just
a
variable,
I'm
naming
I'm
going
to
say,
get
spo
site
script
from
list
and
all
we
need
there
is
the
list
url
now,
in
this
case
the
list
url
is
right
here.
H
It
was
originally
called
leads
we'll
copy
that
and
we're
just
going
to
come
up
here
and
we're
just
going
to
paste
that
in
all
right
we
don't
have
the
view
part
of
it
hit
enter
and
when
we
do
that
we
can
take
a
look
inside
extracted
and
you
can
see
it
has
everything
about
that
list
has
been
pulled
out,
including
our
formats
right.
So
our
formats
are
here
everything
we
just
wrote.
All
of
that
stuff
is
here
all
of
our
different
views.
The
gallery
stuff
is
all
here.
H
You
don't
have
to
look
in
that,
in
fact
maybe
avoid
it,
but
I
think
it's
very
interesting
to
see
that's
what
just
came
out
and
then
what
we'll
need
to
do
is
add
a
site
script,
so
we're
going
to
add
spo
site
script.
Now
this
is
the
site
script.
That's
going
to
run
from
the
template,
so
I'm
going
to
give
it
a
title,
and
it's
going
to
say
it's
the
hit
list
list
right,
because
this
is
how
we're
going
to
deploy
the
hit
list
list.
H
Let's
say
our
description
is
adds
a
hit
list
right
and
then
our
content
is
going
to
be
that
extracted.
This
will
register
as
a
site
script.
To
put
that
together
now
the
thing
we're
going
to
need
is
that
id
so
grab
that
guy
and
copy
it
and
then
we're
going
to
run.
One
more
thing
we'll
say:
add:
sbo
list
design
all
right,
I'm
going
to
say
our
title.
This
case
is
hit
list
and
our
description
is
track.
Those
that
lead
murdering
murder,
that's
good
murder,
we'll
say
our
site
scripts.
H
That's
where
we're
gonna
paste
that
id
we
just
got,
and
then
we
have
a
couple
of
things
that
is
like
list
color
right
and
we
can
see
there's
a
couple
options
here,
just
a
tab.
Until
I
find
one
green,
that's
beautiful
and
it
will
say
our
list
icon.
These
are
the
things
are
going
to
show
up
in
ms
list
right,
airplane
bug,
calendar,
I'm
going
to
say
robot.
I
just
have
no
robots
in
there
and
I
like
robot,
okay
and
then
the
last
thing
we
need
is
a
thumbnail
url
right.
H
So
where
do
we
get
that?
So
what
you're
going
to
want
to
do
is
you're
just
going
to
grab
a
random
picture
somewhere.
Now
you
could
take
a
screenshot
of
the
list
and
that's
okay
right,
but
a
lot
of
times-
that's
not
great.
So
let's
just
go
to
pixels.
Is
that
what
it's
called
yeah?
There's
some
free
stock
photos
and
we're
just
gonna
say:
horse
murder,
yeah!
You
know,
none
of
these
are
really
about
murder,
but
that's
fine!
We're
just
gonna
pick
this
tough,
looking
guy
gonna
download
that
guy
all
right.
H
So
now
we've
got
this
image
now.
Normally,
I
recommend
you
update
that
right,
so,
let's
just
open
that
guy
and
I'm
gonna
rename
him
over
in
my
other
window
to
list
template
I'll
hit
list
jpeg
and
all
I'm
going
to
do.
Is
I'm
going
to
go
to
a
site
where
everybody
has
access,
so
my
root
site
and
the
site
assets,
I'm
just
going
to
grab
that
file
and
I'm
going
to
drag
it
over
here
now.
Normally
you
want
to
resize
that
file.
I
think
I
just
picked
a
really
big
one.
H
The
size
is
about
200
pixels
wide
by
about
120
pixels
tall,
so
about
twice
as
big
and
tall
we'll
see
how
this
one
comes
out,
but
that's
the
idea,
so
I
just
want
the
address
for
a
file
that
everyone
can
access.
So
if
I
go
back
to
my
powershell
that
should
be
https
press
again,
dot
sharepoint.com
slide
asset
slash.
What
do
we
call
that
list
template
hitlist.jpg?
That
sounds
good
right,
so
now
we've
put
that
in
and
now
if
we
go
back
to
our
warrior
horses
site
now,
let's
calm
that
down.
H
In
fact
any
site
we
want
to.
We
should
be
able
to
go
new
and
we're
going
to
say
new
list
and
we
should
have
from
our
organization
hey
look
at
that.
We've
got
a
hit
list
you
can
see.
I
definitely
should
have
fixed
that
image.
The
good
news
is,
I
can
fix
this
after
the
fact
right,
because
it's
pulling
from
that
one
spot
I'll
just
go
fix
the
image
and
put
it
in
here
right.
But
now,
when
I
click
that
right,
I
get
my
green
icon
with
a
robot
on
it.
H
I
see
all
the
columns
there
I
can
say
use
template
and
hit
list
already
exists,
we're
going
to
call
this
headless2
right
or
if
we
were
put
on
a
different
site.
We
could
do
that
and
I'm
going
to
create
that
and
it
will
be
empty.
But
if
we
were
to
add
one
item
right,
we'll
say
all
right
now
this
matters
and
we'll
just
say
it's
neutral
threat
level
is
four
right
and
so
on
exit
our
thing
we
start
to
see.
H
I
didn't
fill
all
of
them
out
here,
but
you
see
all
of
our
formats,
including
our
additional
rope
classes,
all
came
across
if
we
were
to
switch
over
to
our
tile
view.
All
of
that
came
across
so
the
list
templates
are
really
really
powerful,
so
I
know
I
showed
a
ton
and
tons
of
stuff,
let's
go
and
do
a
quick
review
all
right,
so
the
first
thing
we
talked
about
was
how
to
zero
out
dates.
So
this
is
where
you're
going
to
take
advantage
of.
You
know
these
four
different
functions.
H
You
know
you're
going
to
take
date,
which
is
going
to
take
strings
again,
very
important.
It's
based
on
locale.
So
if
you're
expecting
this
to
work
across
multiple
regions,
you're
going
to
get
a
little
more
creative
with
that,
there
are
ways
to
do
it.
It's
it's
just
harder,
so
check
that
out
and
then
these
individual
pieces
will
pull
out
the
parts
of
the
date
you
need.
H
So
you
can
eliminate
the
time
and
then,
if
you
need
to
do
math
on
those
wrap
those
in
a
number
on
top
of
that,
do
the
math
and
do
some
exciting
division
all
right.
Lastly,
once
we've
wrapped
all
that
up
custom
lifts
templates
are
really
really
powerful.
You
know,
because
you
design
everything
in
the
ui
first
or
you
get
exactly
how
you
want
it
and
then
there's
just
a
very
handy.
You
know
three
powershell
commands
you
extract,
it
registers
a
site
script
and
then
you
can
put
it
up
there.
H
You
can
even
do
things
like
have
those
only
available
to
certain
groups
of
people
right,
so
you
can
keep
that
you're
from
your
organization
from
getting
too
crazy
right.
So
if
you're
in
I.t,
maybe
you've
got
lists
related
to
project
management
and
so
on,
but
if
you're
in
risk
maybe
you've
got,
you
know
risky
things,
I
don't
know
right,
but
the
idea
is,
you
can
go
a
little
crazy
with
that.
There's
also
commands
to
quickly
delete
these
and
recreate
them
as
needed
all
right.
H
A
A
If
you'd
like
lots
of
information
to
gather
from
so
I'm
sure
we're
all
going
to
want
to
go
back
and
see
exactly
how
chris
made
all
that
the
recording
will
be
available
in
24
hours
at
the
microsoft
365
community
youtube
channel,
you
can
subscribe,
aka.ms
m365
videos
you'll
be
alerted
as
soon
as
it's
available.
You
won't
be
able
to
download
it
in
the
teams
chat,
so
don't
try
to
download
it.
A
The
next
general
dev
call
that
you
are
on
right
now
will
be
in
two
weeks
september,
1st
at
7
a.m:
pacific
the
next
vv
connections,
the
sharepoint
framework-
call
will
be
august
25th
one
week
from
today
at
7
a.m.
Civic!
You
can
get
the
invites
to
these
and
all
the
other
calls
we
discussed
today.
Aka
aka.ms
m365
calls
thank
you
everyone
for
having
a
a
part
in
the
call
today,
fantastic
chat
and
conversation
and
collaboration.
We
really
appreciate
all
that
you
provide
and
contribute
to
this
community
so
great
work.