►
Description
Recording of the SharePoint Dec community call from October 3rd 2019. The latest news around PnP CSOM Core, PnP PowerShell and the modernization tooling.
- Demo - Chris Kent (DMI) – @theChrisKent - New rounding and date capabilities in column formatting
- Demo - Erwin van Hunen (Rencore) – @erwinvanhunen - PnP Tenant template updates for Look Book v2 designs
- Demo - Paolo Pialorsi (PiaSys) – @PaoloPia - New WebHook support
Resources:
- SharePoint Look Book - https://sharepointlookbook.azurewebsites.net/
- SharePoint Provisioning Service - https://provisioning.sharepointpnp.com/
- Modernization Framework - http://aka.ms/sppnp-modernize
- Column and view formatting samples - https://github.com/SharePoint/sp-dev-list-formatting
Detailed agenda and covered topics are available from SharePoint Dev blog at http://aka.ms/spdev-blog.
Download recurrent invite from http://aka.ms/spdev-sig-call. More details on the SharePoint Dev community from http://aka.ms/sppnp.
A
Welcome
everybody:
this
is
the
SharePoint
financial
practices
and
general
development
special
interest
group,
and
this
is
the
bi-weekly
sync
and
today
is
October
3rd
2019
and
and-
and
this
is
decode,
where
we're
going
to
talk
about
everything
else,
except
SharePoint
framework
inquires,
our
development.
So
so
in
this
course
it
is
intended
to
actually
go
through
printing
capabilities,
provisioning,
automation,
PowerShell
assure
functionality,
is
solution,
architectures
and
all
information
architecture
and
all
of
these
kind
of
things.
A
And
then
we
do
have
two
separate
bi-weekly
SharePoint
framework
community
core,
which
is
happening
every
single,
well
bi-weekly,
on
the
same
time,
on
Thursday
morning,
Pacific
time
and
obviously,
depending
on
your
location,
is
the
morning
afternoon
or
evening.
Now
let's
actually
get
going
on
today's
agenda,
so
we'll
do
a
quick
recap
and
what's
happening
on
this
PNP
side
score
and
the
ancient
side
of
the
house,
the
empty
powershell
and
demonisation.
Tooling.
A
I
try
to
be
relatively
fast
again
on
this,
but
there's
actually
a
lot
of
a
lot
of
changes
and
improvements
on
that
side
of
the
house
related
on
actually
and
some
of
the
demos
which
you
kind
of
see
today
as
well.
So,
first
we'll
start
with
a
Chris
Kent.
It's
been
a
while
when
chris
has
actually
done
his
column
on
list
formatting
tips
so
he'll
be
showing
some
of
those
today
and
crossing
fingers
will
see
some
horses
on
his
demos
because
I
think
everybody's
waiting
for
Dan.
A
A
Well,
we
have
that
horses
Chris!
Oh,
you
know
we
will
okay,
excellent
excellent
cooks.
Sorry
for
that,
putting
on
a
spot
on
there,
it's
a
glorious
man,
okay
and
then
everyone
who
none
for
inquiries
can
I
show
you
some
really
cool
improvements
which
is
happening
on
the
tenant,
provisioning
engine
side
of
the
house.
So
how
can
you
really
provision
into
end
cool-lookin
portals,
and
these
are
actually
going
to
be
an
eventually
available
as
an
open
source
portals
for
you?
A
A
We
know
that
there's,
a
lot
of
is
V
is
important,
is
who
have
built
custom,
implementations
and
and
solutions
on
top
of
the
PNP
tenant
templates,
which
is
absolutely
by
design.
That's
that's
what
we
want
people
to
do,
and
so
these
are
great
improvements
for
them
as
well.
Now
a
quick
recap
on
the
opportunities
to
participate
with
the
community
and
we
always
have
these
sites
in
the
community
course
so
demo,
a
solution
or
technical
patterns.
So
please
volunteer,
if
you
are
interested
on,
gaining
or
demonstrating
your
functionality,
gaining
visibility.
A
Turning
into
an
MVP
well
or
just
show
a
cool
pattern
which
have
been
implementing
as
part
of
your
day-to-day
work,
so
showing
cool
solutions
for
everybody
else
will
help
everybody
to
understand.
What's
possible
around
office,
365
development
online
or
our
on-premises
development
as
well.
Well,
I
would
actually
prefer
why
not
on-premises
as
well,
but
and
not
farm
solutions
anymore.
At
this
time,
hopefully
now
contribute
on
key
Tampa,
definitely
an
option,
and
you
don't
have
to
contribute
towards
our
sample
calories.
You
can
just
that
kind
of
a
recap.
A
Why
do
we
actually
ask
people
to
submit
their
samples
to
our
towards
our
calorie
and
our
kids
are
proposes
that
then
we
can
control
those
samples
and
those
assets
and
and
that
it's
actually
quite
important
for
Microsoft,
because
they'll
say
if
we
would
just
promote
your
kids
application
behind
of
a
link.
We
do
not
know
what
will
happen
for
that
link
later
on.
So
is
it
pointing
somewhere
else?
If
the
information
still
valid,
is
it
still
working?
And
all
of
that?
A
So
that's
why
we're
asking
people
to
if
they
have
core
samples
and
solutions
to
actually
contribute
them
to
decentralized
github
repository
sample
calories,
so
we're
able
to
promote
them
as
part
of
the
work,
but
we
do
and
most
important,
if
nothing
else,
please
let
us
know
if
something
is
bothering
you
Microsoft
doesn't
get
it.
Please
let
us
know
well
we're
not
kidding
so
we're
able
to
fix
that
so
really
really
important
thing
and
provide
feedback.
Obviously,
positive
feedback
is
always
always
definitely
as
welcome
we
everybody.
A
We
tend
to
be
always
providing
more
negative
feedback,
because
that's
that
chorus
is
always
want
more
attention
in
ourselves
and
definitely
but
positive
feedback
is
absolutely
welcome
as
well
and
when
we
communicate
towards
to
other
people
in
the
community
and
and
well
in
this
case
in
our
communities
out
of
the
house,
I
think
we're
pretty
good
actually
on
that
one.
So
people
are
super
super
helpful
around
other
people's
who
are
contributing
as
well.
Good,
quick
recap
on
our
assets:
akms
SP,
div,
Docs,
developer
documentation.
A
You
can
find
everything
around
shape
on
favorite
teams,
integration
which,
upon
framers
building
teams,
tabs
graph
integration,
form
solution,
implementations
even
sample
solution,
implantation
from
that
one
centralized
location,
a
chemist,
SP
develops
videos
is
our
YouTube
video
channel
I.
Think
we
had
like
two
hundred
and
thirty
thousand
views
watch
time
minutes
within
the
September.
A
So
it's
good
to
say
that
people
are
finding
these
videos
and
these
assets
as
well,
because
there's
lot
of
valuable
insights
on
those
videos
and
recordings
and
then
ship
on
their
issues
are
the
issue
list
for
reporting
anything
what
you
see
around
developer
topics.
So
as
an
example,
suddenly
some
API
starts
behaving
badly.
Please
let
us
know
so
we're
able
to
jump
on
it
and
we're
able
to
go
on
reek.
Our
check
out
what's
actually
causing
that
possible
issue.
One
thing
maybe
to
know
this
ship
on
the
Vichy
list
is
not
for
out-of-the-box
functionalities.
A
So
if
our
books
wet
part
or
other
books,
the
list
behavior
is
changing.
We
can
unfortunately
tackle
those
things
using
this
channel.
It's
just
an
agreement
between
the
different
parts
of
Microsoft
now
and
obviously
feel
free
to
ask
questions
and
have
a
chat
on
the
chat
window
and
the
team
super
important
part
of
these
community
calls
as
well
now
one
thing
what
I
did
earlier
today:
I
shared
this
in
a
social
media
already
as
well.
A
I
just
collected
a
quick,
updated
set
of
metrics
from
September
on
on
how
people
how
the
community
is
behaving
and
how
much
people
and
what
people
are
actually
doing
in
the
community.
Now,
what's
really
interesting
on
September
side
of
the
house
to
SharePoint
framework
usage
actually
proves
more
than
15%
and
and
it's
already
in
a
massive
scale
level.
A
So
we're
still
growing
in
this
humongous
month
by
month,
section
or
month
by
month,
growth,
which
is
highly
surprising
for
everybody,
but
15
percent
is
insane
growth
and
considering
the
fact
that
it's
already
the
world
by
far
the
most
widely
adapted
extensibility
model
in
office,
resist
5.
We
had
43,000
more
than
43,000
of
using
SharePoint
dev
YouTube
channel
channel
right
in
238,000
watch,
10
minutes,
59
thousand
total
visitors
in
a
related
github
organizations.
That
means
SharePoint,
BMP
and
onedrive
organizations
in
the
kid
and
what's
really
interesting.
A
This
is
a
new
statistic
which
we
haven't
actually
shared
in
the
past.
The
BMP
components,
meaning
p.m.
be
jeaious
being
besides
core
do
not
get
buckets
and
BMP
PowerShell
are
actually
generating
6377
requests
per
second
worldwide
towards
sharepoint
online,
so
people
are
quite
Whiteley
adapting
and
using
this
tooling,
which
is
great,
so
27,
27
thousand
tenants
are
actually
using
this
open-source
components
across
the
world.
Six
thousand
three
hundred
and
seventy
seven
requests
worldwide.
A
Each
second
true,
PNP
components,
that's
quite
wild
to
be
fair
tenant
templates,
Herman's
can
talk
about
them,
was
used
in
a
three
thousand
and
two
hundred
eighty
nine
ten
months.
Last
month,
and
overall,
not
just
in
September
overall
in
our
repositories,
we've
been
already
having
more
than
one
thousand
contributors
which
which
shows
that
our
communities
is
learning
how
to
contribute
in
github,
and
we
have
a
lot
of
initiatives
like
what
David
Warner
is
doing
related
on
helping
people
to
understand
how
the
github
system
actually
works,
because
that's
quite
often
actually
the
number
one.
A
Let's
say
challenge
for
people
to
contribute
is
by
them
being
afraid
of
the
github.
So
we're
gonna
have
an
explicit
section
week
from
now
in
the
community
call
for
David
to
actually
talk
about
his
support
and
helping
people
to
get
that
adapted
or
using
github
in
their
day-to-day
work.
One
additional
guidance
also
which
went
live
today
or
a
recap,
just
a
reminder
on
these
things.
A
We
there
will
be
some
changes
on
the
throttling
models
and
and
if
there's
any
challenges
relator
on
that,
please
obviously
let
us
let
Microsoft
know,
but
we
also
have
updated
guidance
around
discovering
files
and
detecting
changes
in
scale
in
SharePoint
and
onedrive.
So
the
intention
is
not
that
you
are
scanning
across
all
of
their
sites
and
all
of
the
libraries
and
all
of
the
files
in
the
libraries
to
do
some
analysis
on
on
things
rather
use
the
gate,
changes
and
the
recommendations
which
are
behind
of
this
scan
guidance
documentation.
A
So
please
have
a
look
on
done
if
you're,
an
ISP
or
building
stuff
in
scale
to
analyze,
what's
happening
in
a
tenon.
Now,
moving
back
on
the
open
source
site
of
the
highest
PNP,
is
there
some
core
library,
I?
Think
Burt?
You
will
be
actually
talking
about
this
one.
So,
let's
get
to
the
right
slide
on
there.
Yes,.
B
B
What
will
be
new
will
have
a
new
release
Monday
next
week,
Monday
having
the
September
2019
scheme
is
the
default
scheme
for
provisioning
Network
tenant
templates.
There
will
be
several
improvements
around
client
side,
page
ex-post
I.
Guess
urban
will
touch
upon
some
of
these,
so
I'm
not
going
into
much
detail
there
same
about
bullet
number,
three
yeah
actual
office
items
are,
will
have
more
details,
we're
looking
for
as
well.
So
you
see
a
lot
of
things.
That's
actually
our
when
the
co
library
come
in.
B
Second
one
last
thing
there
is
this
skip
intermediate
page
version
server.
You
might
have
been
annoyed
by
the
fact
that
we
create
a
modern
page
using
a
provisioning
engine
or
just
modern
page
API
in
our
engine.
That
you'll
end
up
with,
like
a
ton
of
intermediate
versions,
that
there
should
be
gone
now.
B
A
Yeah,
it's
a
scalability
problem.
There's
a
high
pressure
for
the
team
to
deliver
certain
things
for
ignite.
They
say
other
things
which
are
causing
priority
and
delays
on
some
of
the
contributions,
but
it
is
definitely
a
positive
problem.
So
the
people
are
so
active
that
we
can't
keep
up
with
the
contributions,
and
that
means
that
sure
workaday
a
resource,
improvements
or
or
investments
then
more
in
the
future,
because
we
need
to
keep
and
the
community
happy
as
well.
Also.
B
C
Yeah,
it's
a
very
similar
story
to
birth,
so
all
the
goodies
from
core
they
automatically
drill
down
to
PowerShell,
especially
for
the
things
that
we
were
working
right
now.
What
I'm
working
on
right
now
those
talents
and
plays,
and
the
changes
in
there
and
also
the
work
I'm
doing
currently
to
prep
for
ignite
something's,
already
drilled
down
to
PowerShell.
For
instance,
now
we
are
able
you're
able
to
set
the
thumbnail
URL
on
a
modern
client
side.
C
B
C
B
Askew
so
I
think
first
point
is
usage,
so
we
kind
of
almost
doubled
or
not
only
doubled,
but
we
went
from
30k
to
a
plus
50
K
number
of
pages
being
transformed
of
in
September,
so
really
nice
growth
over
there.
Also
the
capabilities
that
we
introduced
of
the
last
months
to
start
modernizing
on
pram
pages
you
see
there,
the
yellow
and
the
black
bars
on
top
of
the
September
column,
so
the
most
right
column
there,
meaning
people
are
starting
to
use
new
transformation
for
1902
sharepoint
online
from
2060
2013
to
online.
B
We
also
saw
on
the
16
even
2010,
transformations
going
to
online,
so,
let's
starting
to
grow
majority
still,
this
wiki
pages
with
publishing
pages
is
kind
of
almost
at
the
same
level
as
wiki
pages
from
a
conservation
perspective.
Now,
looking
at
the
new
feature,
so
the
next
release
again
next
week,
Monday
will
have
the
first
first
time
we
can
start
doing
blog
page
transformation.
So
you
just
connect
to
your
blog
site
and
you
can
pick
up
the
block
blog
entries
and
just
create
a
modern
page
from
those
we
copy
the
metadata
as
well
for
you.
B
So
that
should
be
all
fine.
We
have
two
new
options:
one
to
keep
the
page
creation,
modification,
informations
and
just
kind
of
keep
the
author
editor
modify
date
and
and
create
a
date
from
the
original
source
page
and
put
it
on
stamp.
That,
on
the
target,
page
is
an
option
to
post
the
pages
news
so
really
handy.
If
you
want
to
have
it
as
news,
then
you
simply
provide
that
flag.
The
copy
metadata
now
also
works
in
cross
cross
site
preservation
scenarios.
B
So
previously,
when
you
had
a
wiki
page
and
you
kind
of
let's
say
you
read
a
wiki
page
in
SharePoint
on-prem
and
create
a
modern,
petty
shop
online.
At
that
point
we
didn't
copy
the
metadata
every
that
has
been
fixed
now,
so
we
have
metadata
copy
a
cross
site
if
that's
needed
for
you,
but
that's
an
option
to
populate
the
page
order.
So
we,
when
you
create
a
modern
page
you
you
have
an
option
to
put
the
author
in
there.
If
you
manually,
create
a
page
author
will
be
populated.
B
You
see
like
which
person
created
that
particular
modern
page
information.
We
didn't
do
that,
but
now
we
can
so
you
can
specify
a
flag
and
that
point
will
populate
the
page
order.
Then
I
saw
some
fixes
around
web
handling
from
Bram
and
intermediate
page
versions.
Thing
is
there
as
well
and
several
all
the
small
fixes.
So
actually
it
was
a
quite
active
month
in
page
transformation
and
I
would
say
so.
A
lot
of
things
happened.
B
So
much
better
and
so
cool
to
kind
of
great
latest
releases
say
once
they
come
available
just
once
a
month,
so
for
the
scanner
less
environment
to
prepare
for
your
modernization
work,
it's
kind
of
pretty
broad,
listen
to
IB
scoop,
connect
pages
portals
info
part
workflow.
So
we'll
have
some
I'm
working
on
some
work
for
it's
about
improvements.
There.
A
B
We'll
have
some
kind
of
workflow
mapping
to
flow
kind
of
data
and
actually
crack
open
the
workflows
and
then
compare
fractions
with
flow
equivalents
and
provide
like
a
mapping
scores
in
progress,
and
there
will
be
one
new
component.
There
will
be
a
block
in
so
we'll
have
a
scan
list.
You
all
the
classic
blocks
in
your
environments,
which
blocks
being
used
which
is
active
and
then
based
on
that
data,
you
can
decide
to
potentially
modernize
those
book
pages.
A
Elaborate
and
the
scanner
is
there
to
understand
what
do
you
have
on
your
tenants
and
because,
quite
often,
people
don't
know
what
kind
of
site
collections
and
capabilities
people
are
using.
So
it
is
a
super,
valuable
thing
and
then
the
transformation
framework
is
there
to
help
you
to
make
the
actual
transformation,
but
to
be
able
to
even
evaluate
the
amount
of
work.
What
you
need
to
do
to
transform
the
modern
experience
is
you
need
to
understand
what
you
have
and
that's,
where
the
scanner
really
is,
is
super
useful
as
well,
which
I
think
that's.
A
Suit
but
let's
actually
jump
on
Chris's
desktop
and
start
with
a
a
run
and
eight
and
capable
at
rounding
and
eight
capabilities
in
:
formatting
and
then
we'll
move
to
urban
and
then
to
Paulo
straight
from
there.
And
then
it
will
cut
back
on
the
presentation.
I
went
to
Thomas
right
Chris.
Take
it
away
all.
D
Right:
everybody:
it's
been
a
while
I'm
Christians
I'm,
a
officer
well
many
p.m.
on
the
core
team
for
a
PNP
I'm,
currently
out
of
Indianapolis
Indiana,
although
in
like
two
days,
I'll
be
at
Knoxville
Tennessee
from
then
on.
So
that's
pretty
exciting
stuff,
but
even
more
exciting
is
what
I
got
to
show
you
today.
D
So
if
we
go
over
here,
go
to
our
classic
warrior
horses
site
and
as
we
all
have
and
your
horses
have
decided
to
be-
we've
got
several
fallen
comrades
right,
so
they've
got
a
lot
of
people
that
have
died
in
the
course
of
their
work
by
people.
I
mean
horses.
You
know
in
what
better
way
to
remember
those
people
than
by
listing
them
in
a
SharePoint
list,
No
very
kind.
So
we
go
to
our
fallen
comrades
list
here,
and
this
is
the
knife
Wow.
D
But
all
these
people
come
to
meet
us
a
little
better.
Luckily,
with
a
couple
of
new
functions,
an
operator
we,
we
certainly
can
first
thing
I
want
to
show
you
is
what,
if
we
wanted
to
say
on
there
before
and
that's
when
they
died,
that's
great,
but
I
want
so
I'm.
Gonna
add
a
format
only
column
I
go
underneath
a
order.
More
and
I'm
gonna
create
our
calculated
column
in
a
minute.
D
Alright,
there
we
go
we'll
just
call
this
age,
alright,
make
this
calculated
column
and
again
the
reason
I
use
these
calculated
columns
with
a
formula
equals
double
quote:
double
quote,
so
they
don't
show
up
in
the
new
and
edit
forms,
but
I
can
apply
format
to
so
lid.
Okay.
Here
let
me
go
back
here.
Now,
get
this
nice
column,
I
can
format.
So,
let's
zoom
list
will
format.
This
column,
column,
settings
format,
this
column
and
we'll
just
type
it
in
directly
here.
D
So
what
does
dots
per
say,
yeah,
so
we'll
type
in
our
little
squigglies
all
right,
we'll
say
this
is
gonna,
be
an
element
type
of
div.
That
sounds
great
all
right,
but
the
thing
we
care
about
is
we
want
to
set
our
text
content
right.
So
in
this
case
we
can
actually
set
this
to
calculate
this
age
right
in
the
past.
This
has
been
fairly
difficult.
D
You
know
just
because
of
rounding
issues.
So
let's
take
a
look.
So
if
we
wanted
to
take
something
like
equals,
number
all
right
and
we'll
say
died
all
right.
So
this
is
our
died
column.
So
if
we
convert
that
to
a
number-
and
we
convert
it
to
the
other
date
born
to
a
number-
we
can
actually
get
the
number
of
milliseconds
since
1970
whatever
right.
So
obviously,
this
is
not
a
very
helpful
number
here.
So
we'll
talk
about
why
that
was
their
age
in
milliseconds,
since
1970
that's
raised
in
milliseconds
really
really
helpful.
D
But
if
we
take
that
and
say
we
divide
that
all
right,
so
we'll
throw
this
on
here
and
we'll
divide
this
by
say.
Oh
my
/,
you
know
a
thousand
for
the
milliseconds
times
60
for
the
seconds
times,
60
for
the
minutes
times,
24
all
right
and
we'll
preview.
That
I
did
not
do
this
just
copy
and
paste
what
I
got
over
here
and
the
other
screen
how's
that
that
will
paste
that
all
right,
so
that's
the
this-
will
be
their
age
in
years.
D
Right,
I,
trust
their
age
in
here,
because
we
take
away
the
365
right.
We've
got
their
agent
days
great,
but
that
is
not
helpful.
Nobody
cares
that
they
lived,
you
know.
0.18
I
mean
probably
their
family,
okay,
but
one
of
the
things
we
can
do
with
that
right.
So
we
can
add
these
nice
functions
here,
so
we
could
say
a
ceiling
right
because
we
live
part
of
a
day.
D
You
should
get
credit
for
the
whole
day,
all
right
so
we'll
say,
ceiling
now,
look
at
that
will
knock
it
off
we'll
just
round
it
up
to
the
very
next
integer
right
now,
if
we're
doing
that
by
year,
I
saw
the
times
365.
You
know
you
don't
get
credit
for
an
extra
year,
so
we're
gonna
do
something
different.
We're
gonna
be
four.
So
that's
gonna
round
it
down
on
to
the
nearest
integer
right.
So
that's
how
we
get
their
age,
but
you
again
it
can
be
really
really
helpful.
D
You
did
these
rounding
functions
for
and
see
if
it'd
be
awesome
for
things
like
our
pie,
chart
or
mats
or
some
of
the
other
data
bars
when
you've
been
showing
those
this
percents
we
haven't
been
able
to
get
rid
of
until
recently.
You
know,
like
the
nine
digits
of
precision
there,
so
this
will
way
you
get
rid
of
all
that
and
really
clean
up
your
formats
in
a
nice
way,
all
right.
So
that's
beautiful
to
save
that
exciting
this
and
that's
okay.
D
But
what
if
we
want
to
do
something
else
right
like
maybe
we
want
to
highlight
people
that
have
died,
just
there's
easier
right,
so
we
can
format
the
current
view.
I'm
gonna,
do
a
nice
thing
here,
we're
going
to
use
an
additional
row
class,
so
an
additional
row
class
provides
a
way
to
provide
you
know
a
class
across
your
entire
row
and
you
can
do
that
conditionally.
So,
if
I
type
an
additional
row
class
I
can
do
this
and
I
can
just
say
you
know.
D
If
there's
a
nice
new
function
here
or
I
could
say,
I
need
certain
parts
of
a
date,
so
I
can
get
the
year.
I
can
get
the
month.
I
can
get
the
day.
So
in
this
case,
if
I
wanted
to
say
yeah
yeah
year,
it
just
looks
like
this
at
now.
So
that's
the
current
date
and
time
equals
equals
year
of
the
safe
died.
D
And
I
want
to
apply
the
class
em
s.
E-G
color
will
say
theme
tertiary
is
that
so
popular
killing
current?
Otherwise
we
don't
really
wanna
highlight
anything.
Let's
try
that
out.
Bam
everybody
that
died
in
2019
is
now
highlighted.
So
how
kind
of
us
now
we
can
see
exactly
who
died,
say
me
want
to
take
this
even
further.
We
want
to
apply
something
even
further
to
that.
We
want
to
really
provide
a
way
to
to
honor
our
comrades.
Well,
we
can
use
something
with
our
new
tile
props,
this
and
fun
fact.
D
You
can
actually
combine
tile
props
with
an
additional
row
class,
just
like
I'm
doing
here
when
I
preview
that
I
got
a
type
in
the
formatted
correctly.
Let's
try
that
again,
let's
grab
all
that
pasted
in
and
we'll
just
leave
off.
You
could
provide
your
additional
real
class
inside
here
as
well
or
even
an
additional
format,
because
when
you
do
tile,
props
will
just
save
that.
Now
you
get
this
nice
tiles
feature
right,
so
I
switch
over
the
tiles
I
can
see.
We
have
a
nice
memoriam
right
to
our
fallen
course,
prints
right.
D
D
What
it's
doing
is
it's
looking
at
the
month
right
and
then
it's
substituting
that
month,
we're
actually
gave
it
a
custom
date
format.
This
way,
all
right,
we're
looking
at
one
at
0,
its
January.
You
know
when
first,
it's
February,
because
for
whatever
reason,
JavaScript
decided
that
month
sorry
0
based
index
by
the
way-
that's
true
here
in
format
as
well,
but
this
allows
us
to
provide
really
nice
date
for
writing
we're
in
the
past.
We
could
only
do
you
know,
time
or
date
strings
and
your
locale
right.
D
So
now
you
can
really
go
in
here
and
you
can
calculate
dates
between
things
right
say
how
long
it's
been
between
something
highlighted
based
on
the
current
date,
all
sorts
of
really
cool
stuff,
so
that
is
the
brand-new
functions.
So,
let's
just
review
real
quick.
We
jump
back
over
here.
One
I
didn't
cover
is
the
new
pal
function,
and
this
will
just
do.
D
Do
exponential
power
so
for
squared
you
type
in
pound
for
them
to
write,
there's
gonna
be
16,
but
here's
our
floor
again,
it's
gonna
collapse
and
then
Stephen
is
going
to
collapse
up
to
the
next
highest
integer,
all
right,
very
exciting.
These
are
very
helpful
over
here.
Those
are
date,
part
operators
right.
So
we
got
the
get
date
which
is
just
as
confusing
as
in
JavaScript
right
because
get
date
actually
for
a
reason
is
the
day
of
the
month
right.
D
So
that's
gonna
be
anywhere
from
1
to
31
depending
on
the
month
and
then
yet
month
is
gonna
start
with
0,
which
is
important.
Remember
that's
gonna,
guarantee!
That's
gonna
cause
your
problem
at
some
point.
So
just
add
a
1
right
if
you're
looking
for
the
number,
the
numeric
value
and
then
gate
here
is
the
full
4
digits
for
a
year.
All
right!
So
that's
gonna,
be
you
know,
2019,
not
just
them
all
right.
So
all
of
those
samples,
I
just
showed
you
are
available
or
they
will
be
as
soon
as
I
process.
D
A
A
Ok,
so
it's
actually
moved
to
this
computer
and
desktop,
and
the
government
has
really
really
cool
demo
waiting
as
well.
Awesome,
stuff,
Chris,
really
cool
stuff,
pretty
dark
demos,
this
time
but
take
it
is
life
and
as
well,
but
now,
let's
orbit,
we
can
see
what
you're,
sharing
and
I
think
those
yet
audio
is
absolutely
fine.
So
take.
C
C
We
figure
out
all
the
bad
parts
are
in
there
and
then
we
also
apply
them
and
to
give
you
an
idea
of
how
to
actually
build
up
your
your
client-side
pates
in
a
template
to
look
to
use
a
vertical
column.
I'm
gonna
open
this
specific
templates.
That's
the
site
that
you're
looking
at
here.
This
is
the
tenant
template.
C
Now,
if
you
use
the
provisioning
engine
before
you
might
be
familiar
with
the
concept
of
provisioning
templates
tenant
template
is
nothing
more
than
basically
a
wrapper
around
one
or
more
provisioning
templates,
and
we
allow
you
also
to
create
site
collections.
So
when
you
apply
this
template
to
your
tenant,
we
will
actually
first
create
the
size
collection
for
you
and
then
apply
the
templates
to
it.
So
in
this
case
we're
creating
a
communication
site
with
a
specific
URL
that
we
have
parameterised
here
and
then
we
apply
this
main
template
which
is
located
here.
C
So
if
I
scroll
me
down
and
we
go
to
the
client-side
pages
here,
you
see
the
trend
page
and
you
see,
is
a
new
type
here,
which
is
a
one
column
vertical
section.
There's
a
two
column
vertical
section:
there's
a
three
column
vertical
section,
allowing
you
to
specify
okay,
if
this
vertical
column
on
the
right,
it's
always
on
the
right
and
then
there's
an
X
number
of
columns
to
the
left
of
this
section.
C
We
also
now
allow
you
to
set
the
vertical
section
emphasis:
it's
a
separate
emphasis
from
the
section
emphases,
so
they
can
have
different
background
color.
So
if
we
go
back
to
the
page,
you
see
that
the
emphasis
is
a
bit
different
here.
This
is
neutral.
It
is
a
call,
that's
like
light
grey
in
this
theme,
then
you
basically
add
your
controls
to
your
controls.
Collection,
and
the
only
thing
you
have
to
keep
in
mind
is
to
get
your
control
in
that
vertical
section
you.
C
If
we
go
bit
to
the
right
here,
you
see
it
here
in
the
end,
put
it
in
column
the
last
column
effectively.
So
if
it's
a
two
column
vertical
section,
you
will
put
it
in
column
three,
because
that's
the
vertical
section,
that's
number
three.
You
have
first
two
columns
on
the
left
and
then
the
vertical
section
to
the
right
so
put
it
in
the
last
column
and
your
webparts
will
show
up
there.
So
we
did
a
lot
of
changes.
The
last
couple
of
weeks
to
the
engine.
C
C
Even
that
code
has
been
improved
and
we
discover,
for
instance,
all
the
image
images
in
your
client-side
page,
or
we
try
to
discover
them
as
much
as
possible
as
far
as
we
can
go,
and
we
will
add
them
to
your
file
selection,
a
false
collection
here
and
we've
refer
to
them
in
the
web
part
and
by
a
token,
so
we
we
dynamically
figure
out
where
that
file
is
located
in
your
site
and
then
at
application
time.
One
of
the
things
that
we
also
allow
you
allow
you
to
do
on
the
client-side
page.
C
Let's
see
if
I
have
actually
have
an
example
of
that
one
in
here
in
this
specific
template
is
to
set
the
thumbnail
URL
and
it
might
actually
not
have
an
example
here
now,
I'm
just
calling
down
from
client-side
page
to
client-side
page
here,
and
we
don't
I,
don't
think
we
have
an
example
here.
No,
but
you
can
set
the
thumbnail
URL
to
a
URL
in
your
site.
Direction
like
inside
s,
it's
not
whatever,
and
that's
that
that
URL
that
thumbnail,
you
might
be
familiar
with
it.
It
not.
C
But
if
I
open
a
page
here
that
thumbnail
is
actually
showing
up
there
and
this
thumbnail,
you
can
edit
separate
from,
for
instance,
the
background
image
in
your
header.
If
you
want
to
so,
you
can
set
a
separate
thumbnail.
That
thumbnail
will
then
be
say.
You
curated
client
side
page
without
a
header
background,
but
still
you
define
a
thumbnail
then
that
thumbnail
will
be
exposed
in
like
the
news
web
part,
for
instance
here.
So
that's
a
nice
way.
We
can.
C
We
started
to
implement
now,
and
that
is
the
ability
for
you
to
create
a
configuration
file
of
your
settings
that
you
want
to
use
while
extracting
currently
only
while
extracting,
but
this
will
also
come
during
application,
and
if
we
look
at
that
configuration
file,
it
is
it's
a
JSON
file.
So
we
know
that
provisioning
templates
is
XML,
but
the
configuration
file
is
Chasen
and
this
is
currently
what
we
allow
you
to
do,
so
you
can
specify
which
of
the
handlers
you
want
to
run.
C
So,
if
you're
only
interested,
for
instance
in
exporting
the
list,
you
just
specify
one
Handler,
there
is
a
schema
behind
it
right
now,
you'll
see.
The
schema
is
pointing
to
my
core
repo,
but
this
will
be
located
in
a
central
location
which
we
probably
will
do
before
Monday
and
so--but
the
schema.
We
have
these
completion
functionalities
in
vs
code,
for
instance.
So
you
can.
You
can
pick
from
the
handler
that
you
want
to
run
easily.
C
We
allow
you
now
when
we,
when
you
extract
a
template,
you
might
have
noticed
that
the
navigation
elements
in
the
template
always
have
the
remove
existing
notes
set
to
false,
which
is
annoying
a
lot
of
people,
including
myself,
but
we
basically
say
always.
We
do
not
delete
things
unless
you
explicitly
tell
us
to
and
that's
why
we
always
set
them
onto
false,
and
that
means
that
if
you
reapply
that
template
to
an
existing
site,
the
navigation
nodes
will
be
added
to
the
existing
navigation,
which
is
annoying.
C
Now,
with
this
configuration
file
and
notice
only
through
the
configuration
for
our
beam,
we
have
no
other
parameters
exposed
through
the
command
list.
For
that,
you
will
have
to
use
a
configuration
file
with
this
configuration
file.
You
can
say
you
know,
listen
set
those
properties
to
true
we
want.
C
If
you
want
to
export
all
the
client-side
pages,
not
just
a
home
page,
which
is
the
default
behavior,
you
just
say
includes
all
client-side
pages,
and
this
is
a
big
one.
I
think
if
you
want
to
export
a
specific
list,
instead
of
all
lists,
you
can
now
specify
this
list
section.
Then
you
have
a
list
collection
in
here
and
per
list.
C
You
can
say,
ok,
export
this
specific
list
and
include
all
the
items
in
that
list
and
give
me
only
these
fields,
so
we
basically
go
through
I'd
through
the
items
in
the
list
and
we'll
create
data
rows
for
this
specific
list,
and
we
will
include
the
fields
that
you
request.
If
you
don't
specify
a
query
rule
we'll
just
dump
everything
in
there,
including
the
internal
fields-
and
you
can
also
say-
listen
I
only
want
the
ones
that
match
this
query
now.
C
This
is
just
an
ordering
query,
but
this
is
a
full
camel
queries
you
can
do
where
sand
etc.
If
you
want
to-
and
we
will
filter
the
items
in
the
list
to
to
this
query
and
then
export
the
data
as
data
rows.
This
is
very
nice.
For
instance,
if
you
have
calendar
items
in
your
site
that
you
want
to
move
over.
For
instance,
you
see
that
specific
query
that
I
use
you
can
also
set
skip
empty
fields.
C
To
true
that
basically
means
if
the
category
is
not
set
for
the
specific
item,
we
will
not
include
it
as
a
data
row
or
a
field
in
that
data
row.
So
that's
that's
an
option
you
can
do.
You
can
also
just
say:
listen,
I,
don't
want
the
camel
query,
but
I
want
to
live
it
to
number
of
fields,
specific
fields,
and
you
just
leave
out
the
camel
query
and
what
will
come
is
also.
C
This
property
include
attachments,
I'm
still
coding
on
that,
and
there
is
the
option
of
setting
to
like
the
role
limits
to
like
I
only
want
the
first
ten
rows,
for
instance.
So
this
is
you
will
you
will
see
that
we
will
expand
this
configuration
file
more
and
more,
and
our
goal
is
just
to
not
introduce
new
functionality
in
the
old
way
of
configuring.
The
engine.
If
you
use
the
engine
with
c-sharp,
you
basically
use
a
creation
at
creation
information
object.
C
You
can
still
do
that.
So
all
the
older
code
is
still
backwards
and
backwards
compatible,
but
we
will
introduce
some
new
functionality
in
this
configuration
format
here,
which
makes
it
a
bit
easier
for
you
to
control
bulk
exports
etc
of
multiple
sites.
We're
pretty
excited
about
this.
It
makes
your
life
a
lot
easier.
As
I
said
it
I
lost
track
almost
of
all
the
changes
we've
done
in
the
engine.
It's
it's
an
it's
an
pretty
major
release,
we're
doing
on
Monday
a
lot
of
new
functionality
and
a
lot
of
new.
C
Performance
and
stability
improvements
because
we're
releasing
the
September
will
be
set
a
default.
It
does
not
mean
that
everything
in
that
schema
is
implemented,
yet
there's
still
gaps,
but
just
let
you
know
that
so
don't
expect
the
full
schema
to
be
100%
functional.
Yet
all
the
functionality
you
have
today
in
the
old
schema
is
100%
functional
in
the
new
schema.
The
new
things
in
the
schema
will
slowly
trickle
in
and
most
likely
the
majority
will
happen
basically
after
ignite,
when
we
release
will
do
a
renew
release
basically
next
month
and
that's
it
for
me.
C
C
And
they're
all
have
different
themes,
so
the
themes
are
now
provisioned
on
site
level,
not
on
tenant
level
anymore,
which
is
also
a
great
improvement
for
in
basically
not
affecting
you.
Your
attendance,
everything
is
contained
in
the
template
in
the
site.
Nothing
will
be
provision
to
your
tenets,
which.
A
Means
that
you
can
test
these
templates
in
an
existing
tenant
which
help
on
creating
for
example,
example,
content
and
structures
in
an
existing
current
and
hey.
Then,
if
you
realize
that,
though
this
is
actually
is
exactly
what
I
want
to
do,
I'll
just
treat
the
content,
and
then
you
can
do
a
swap
URLs
and
swap
route
may
be
that
the
new
created
experience
and
all
of
this,
this,
the
the
designs
are
really
cool.
They
and
templates
are
available.
We
are
working
now
on
the
provisioning
service
and
lookbook
site.
A
I
change
this
and
all
of
that
is
coming.
Obviously
an
eighth
night
timeframe,
really
cool
looking
stuff
and
if
you
are
already
like,
hey,
hey,
I
wanna
get
access
on
on
some
of
these
or
wanna
test
this
and
the
dog
topper
release
of
the
engine
and
PowerShell
is
coming
on
Monday
and
then
already
today,
these
templates
are
actually
available
in
a
key
table,
but
those
templates
are
using
capabilities
which
are
using
assuming
the
October
release
of
the
agent.
So
it's
good
better
of
them
now
from
a
timing
perspective.
Yes,
sorry,
sorry,
one.
C
C
Like
this,
so
you
say
whatever:
this
is
how
you
configure
the
PowerShell
command.
You
say
just
configuration
this
and
you
point
to
the
JSON
file
and
you
also
be
able
to
actually
send
in
an
object.
So
you
can
tweak
that
object
through.
If
you
want
to,
instead
of
actually
22
a
file,
you
can
send
in
an
object
containing
a
string
or
an
actually
JSON
object,
so
that
will
come.
C
A
E
You
so
let's
talk
a
little
bit
about
the
provisioning
Web
books
that
we
introduced
the
actually
that
we
introduced
in
April
2009
teen
with
schema
2000
1903,
but
that
we
improved
or
we
are
going
to
improve
with
the
release
that
will
come
out
next
week.
Next
Monday.
In
fact,
in
schema,
2000
1909.
We
improve
the
web
box
capability
and
let
me
try
to
explain
you
what
these
Web
books
are.
E
First
of
all,
in
April
we
introduced
a
set
of
web
books,
which
you
can
configure
in
a
provisioning
template
so
that
whenever
you
start
or
you
complete,
a
provisioning
template
application
or
whenever
every
single
object
handler
in
the
archaeologic
handlers
that
do
the
actual
provisioning
of
your
template
will
be
invoked.
You
will
be
able
to
get
a
book
notification
if
you
have,
for
example,
an
external
service,
an
external
application
that
want
to
do
monitoring
of
the
openings
under
the
cover
of
the
actual
provisioning
of
your
template
as
well.
As
you
never
know.
E
If
there
is
an
exception,
you
can
have
a
web
book
which
will
notify
you
that
an
exceptional
code
during
the
provisioning
of
a
template
and
this
set
of
web
books
were
released
in
April
this
year.
But
we
also
introduced
in
2010,
see
online
schema
and
we
are
going
to
release
them
in
the
engine
next
week,
three
more
web
books
for
being
notified
when
the
provisioning
of
a
tenant
level,
template
of
a
hierarchy
of
side
starts,
completes
or
eventually,
if
there
is
an
exception,
while
applying
a
tenant
level
template.
E
This
is,
as
you
can
imagine,
really
useful
from
our
perspective
thinking
about
the
provisioning
service,
but
if
you
are
an
ISV
and
you're
building
solutions
to
do
all
tamarick
provisioning
using
the
provisioning
engine,
it
would
be
really
useful
and
helpful
for
you,
as
well
from
a
technical
perspective,
and
to
give
you
some
implementation
details.
You
can
use
these
Web
books
either
providing
a
gate
or
a
post
capable
endpoint.
So
it
means
that,
from
an
engine
perspective
we
can
make
a
get
request
or
a
post.
E
If
you
want
to
configure
your
workbook
in
order
to
have
a
set
of
custom
settings
that
you
need
in
order
to
properly
identify,
for
example,
which
is
the
instance
of
the
provisioning
that
is
running,
and
it
is
notifying
your
workbook.
When
we
make
a
post
request,
we
can
call
your
way
book,
providing
edges
on
message
or
an
XML
message
or
making
just
a
forum
post
as
like,
as
it
would
be
an
HTML
page
in
a
web
browser.
E
The
web
books
can
be
invoked,
synchronously
or
asynchronously,
and,
let
me
say
a
nature
function
is,
in
my
opinion,
one
of
the
best
candidates
for
being
a
receiver
for
such
kind
of
web
books.
So
let
me
move
to
the
demo
environment
to
show
you
how
it
works
and,
first
of
all,
let's
have
a
look
to
the
new
schema
that
we
have
in
schema.
E
2000
1909,
as
I
told
you,
we
introduced
the
tenant
level
with
books
we
already
introduced
in
the
schema
2000
1903,
the
provisioning
template
were
books,
and
this
is
to
give
you
an
idea
of
how
a
web
book
looks
like
in
a
provisioning
template.
Well,
it's
just
an
XML
element.
Sorry
after
so
many
JSON
samples
we
needed
to
have
at
least
one
XML
sample,
so.
E
We
have
a
provisioning
template,
workbook
in
which
we
can
configure
the
URL
of
the
target
web.
You
can
point
and,
as
you
can
see,
the
URL
can
have
custom
parameters,
for
example
in
the
query
string,
which
can
be
a
book
parameters
which
means
items
defined
right
here.
So
you
can
configure
custom
parameters
here
and
you
can
even
use
the
tokens
in
the
value
of
your
parameters
to
make
them
dynamic,
or
you
can
read
any
other
information
like
a
parameter
that
you
already
have
in
the
template,
because
we
do
the
parsing
of
this
URL.
E
Moreover,
you
can
select
if
you
want
to
make
a
get
or
post
request,
and
you
can
configure
the
kind
of
proof
of
provisioning
a
book
that
you
wanna
fire,
so
it
could
be,
as
I
said,
provisioning
to
be
started
completed
or
whatever
else
is
supported
by
the
engine.
Almost
the
same
logic
can
be
applied
to
the
provisioning
web
books,
which
are
the
books
at
tenant
level.
So
we
have
exactly
the
same
idea.
E
We
configure
the
URL,
the
HTTP
method,
the
kind
and
the
body
format
if
it
is
a
pasta,
so
you
can
say
JSON,
XML
or
form,
and
you
can
configure
if
it
is
synchronous
or
a
single
and
as
like
as
before.
You
can
configure
parameters.
So
here
I
have
a
real
template
in
Visual
Studio
code,
which
I
created
starting
from
the
contoso
drawn
landing
lookbook
site
that
we
have
in
the
provisioning
service
and
in
this
template
we
have
some
books
configured
with
target
and
real
is
your
function,
which
is
listening
for
my
book
calls.
E
So
here
is
the
user
function,
which
is
really
trivial.
I
simply
get
all
of
the
query,
string,
input,
argument
and
I
get
the
body
and
I
show
it
in
the
log
window.
So
let
me
start
this
one
for
the
sake
of
testing
that
it
is
properly
working
and
it
is
working
and
now
I
can
simply
go
to
PowerShell,
connect
to
a
target
site
and
run
the
provisioning
template
that
we
just
saw
in
Visual
Studio
code.
E
By
doing
that,
my
provisioning
template
will
be
applied
onto
the
target
site
and,
at
the
same
time,
while
the
provisioning
will
happen,
we'll
be
able
to
see-
as
you
can
already
see
here
in
the
log
window,
that
I
have
the
provisioning
engine,
which
is
calling
out
my
book
to
notify
my
external
service,
my
external
application
of
what
is
happening
under
the
cover
of
my
provision.
So,
for
example,
here
I
can
see.
Well,
it's
pretty
fast.
So
it's
not
easy.
E
Let
me
pose
it,
but,
for
example,
I
have
a
message
for
the
provision
started
to
inform
me
that
the
the
whole
hierarchy
provisioning
has
started.
Then
I
can
see
that
I
have
the
provisioning
of
multiple
templates
that
is
running.
I
can
see
that
object
and
learn
has
been
started,
and
this
is
the
original
setting,
Swan
and
so
on
so
forth.
So
I
will
have
all
of
the
messages
useful
to
provide.
E
To
my
end
users,
what
is
the
status
of
the
provisioning
template
application
even
if
I'm
an
external
service,
an
external
application
just
using
the
provisioning
engine
in
the
backend
and
I?
Think-
and
we
think
that
this
is
really
powerful,
especially
for
us
vs
that
want
to
build
I
level,
provisioning
solutions
using
the
provisioning
engine
and
I
think
that's
it
on
my
site
as
well.
So
you
have
a
few
minutes
for
Q&A,
eventually
or
whatever
else.
Thank.
A
You
Paula,
for
that
one
super
super
cool
stuff
as
well.
We
do
absolutely
acknowledge
and
that
maybe
that's
not
a
let's
say
if
you're
a
smaller
I
am
partner.
You
might
not
be
super
interested
on
the
web
who
capability,
but
that's
actually,
something
which
we
it's
been
requested
by
many
ISPs
and
many
partners
who
are
building
this
kind
of
a
completely
custom
UX
as
an
example
based
on
the
provisioning
service
implementation,
which
we
have
because
that's
completely
open
source.
A
So
you
can
use
that
as
a
baseline
and
then
modify
that
based
on
the
customer
requirements
or
your
own
requirements,
so
pretty
cool
stuff.
We
do
have
a
few
minutes
here.
I
have
a
another
community
call
actually
starting
on
the
hour
as
well.
So
we
got
a
few
minutes.
If
there's
any
random
questions
in
here,
so
there's
a
question
from
Lou
::
can
you
create
side
and
apply
provisioning
template
using
BMP
web
cook?
A
That's
kind
of
I
would
say
slightly
confusing
things,
because
the
the
web
hook
is
for
indicating
the
progress
this
replica
is
registered
is
indicating
the
progress
of
what's
happening
when
you
are
applying
an
a
template.
Now,
yes,
there
is
the
native
web
hooks
in
SharePoint,
but
there's
no
native
web
hook
right
now,
at
least
for
when
we
create
a
site
collection,
which
is
one
of
the
limitations.
That's
why
there's
this
that
you
can
integrate
all
of
this
stuff
just
like
designs,
but
that's
a
slightly
different
discussion
as
well.
A
Now
any
any
ad
hoc
questions
which
we
can
answer
here
at
this
point,
or
we
can
close
few
minutes
early
as
that's
not
a
massive
deal
if
there's
no
burning
burning
questions
at
this
point
really
cool
stuff,
three
super
cool
demos.
Thank
you
Chris
for
that
stuff
for
the
for
the
coloman
list,
vomiting
demo
really
really
great
stuff
over
there,
slightly
darker
side
of
the
demo.
So
hopefully
we
didn't
actually
scare
anybody
with
that.
One
and
Chris
tends
to
step
on
the
line.
A
Thank
You
Irving
on
the
on
the
on
the
crate
demo
related
on
the
templating
capabilities,
and
it's
a
really
really
great
stuff
which
is
coming
I,
think
upon
release
Irving.
Is
it
13
new
templates
and
based
on
the
new
design?
I?
Think
it's
13?
Isn't
it
I
should
know
because
I'm
working
on
those
templates
as
well,
12
or
13,
something
like
that's
an.
A
You
have
example,
content
and,
and
all
of
that
so
really
cool
stuff,
and
thank
you
Barlow
also
for
the
webhook
side
of
the
house
and
that's
really
really
powerful
for
many
of
the
partners,
but
I
think
that's
it
for
now.
So
thank
you
very
much
for
everybody
who
joined
and
thank
you
for
questions.
There
was
a
good
discussion
again
on
on
the
chat
window
quickly.
Answering
may
be
on
Russell's
question
well
or
Bert
can
answer
that
on
the
chat
window,
but
thank
you
for
joining.
A
The
recording
will
be
out
within
24
hours
in
the
SharePoint
dev
YouTube
channel,
like
all
of
the
rest
of
the
recordings
and
demos
and
will
then
have
it
next
community
call.
Actually
we
have
next
monthly
community
called
next
Tuesday
and
then
shape
on
framework
America
on
Thursday
next
week.
So
2
calls
next
week.
Lots
to
cover
or
see
from
the
recording
side
have
a
great
weekend
until
Friday
and
Saturday
Sunday,
and
will
be
definitely
in
touch
bye.