►
From YouTube: Microsoft 365 PnP – General Microsoft 365 Developer SIG community call – 17th of September, 2020
Description
Microsoft 365 PnP Community - General SIG call on September 17. Two demos and 1 Roadmap overview delivered: 1) List and column formatting magic, 2) Getting started on using Microsoft Graph subscriptions with Azure Functions and 3) Updates on PnP Sites Core / PnP PowerShell roadmap. Presently - September releases of PnP PowerShell, Modernization tooling, and yo teams 2.16.0-preview. Six new Microsoft Teams samples were released recently and from now on in this call, the latest Teams samples delivered in previous two weeks will be highlighted. The host of this call was Vesa Juvonen @vesajuvonen. Q&A takes place in chat throughout the call.
Demos:
• List and column formatting magic: Out-of-box UI design mode wizards – Chris Kent (DMI) | @theChrisKent
• Getting started on using Microsoft Graph subscriptions with Azure Functions – Yannick Plenevaux (PVX Solutions) | @yp_code
• Updates on PnP Sites Core / PnP PowerShell roadmap – Erwin van Hunen (Valo Intranet) | @erwinvanhunen & Bert Jansen (Microsoft) | @O365bert
Learn more: (YouTube)
• See the full blog post for this call at: http://aka.ms/m365pnp-blog
• Download invite for bi-weekly General M365 Dev SIG call: http://aka.ms/spdev-sig-call
• Learn more about the Microsoft 365 Patterns and Practices community at: http://aka.ms/m365pnp
• Visit the Microsoft 365 Patterns and Practices community YouTube channel: https://aka.ms/m365pnp-videos
A
Welcome
everybody:
this
is
general
microsoft,
365
development,
special
interest
group.
It
is
private
sync
september
17th
2020,
and
we
only
have
not
that
many
days
to
christmas
anymore,
so
we're
almost
the
end
of
this
quarter,
which
is
quite
horrifying
time
flies.
Now.
Let
me
actually
go
to
the
agenda
of
today,
so
we're
trying
to
do
we're
trying
to
slightly
adjust
the
timings
and
everything
else
so
we're
trying
to
get
the
mode
where,
in
this
community
course
we'll
always
have
15
minutes
of
random.
A
Let's
say:
updates
and
random
discussions
on
what's
happening
together
with
picture
time
with
computer
mode
and
then
45
minutes
of
demo.
So
if
you
basically
are
don't
like
to
talk
about
and
hear
what's
the
latest
and
what's
the
latest
samples
you
can
miss
the
first
15
minutes,
we
don't
encourage
you
to
do
that,
but
obviously
the
demos
will
try
to
start
to
demo
some
quarter
past
always
on
the
hour.
A
We
really
want
to
have
everybody
in
the
community
an
option
opportunity
to
do
a
live
demo
in
this
course,
and
you
can
absolutely
contribute
and
github
there's
a
lot
of
different
opportunities
projects
and
ways
of
engaging
in
the
github
as
well.
By
submitting
an
issue
submitting
pull
requests
on
and
the
most
important
part
is
always
to
provide
feedback
right.
We
track
provide
feedback,
provide
feedback.
A
So
if
there's
something
what
we
do
badly
or
well,
please
provide
us
feedback
and
also
the
positive
feedback
is
more
than
welcome,
so
in
open
source
world,
especially
and
the
positive
feedback
has
magnificent
impact
for
the
people
who
are
spending
their
time,
helping
other
people
moving
on
things.
Just
quick
recap
on
the
assets.
We
have
two
different
youtube
channels
do
historical
reasons,
so
we
have
the
official
developers
youtube
channels,
and
then
we
have
microsoft.
365,
sharepoint
community
videos
youtube
channel.
A
We
have
plenty
of
open
source
assets
available
in
multiple
different
organizations
and
sample
galleries,
and
more
and
of
those
sample
categories
are
coming
in
the
future.
Well,
actually,
a
unified
sample
gallery
is
in
the
works,
but
it's
not
yet
available.
So
we're
looking
into
building
a
one
sample
gallery
across
the
microsoft
365
samples,
so
you
can
actually
go
to
a
single
location
and
find
what's
relevant
for
you.
A
But
as
a
summary,
if
you
go
to
the
akms
team
samples,
you
will
actually
find
existing
samples,
which
are
the
app
template,
samples,
microsoft,
teams
and
and
content
which
has
been
contributed
also
by
the
community
so
making
it
super
easy
to
find,
what's
relevant
for
you
across
all
of
those
different
github
locations
and
we're
looking
into
improving
that
in
the
future.
Even
more
now,
a
quick
recap
on
the
air
sharing
is
caring
initiative
actually
david.
Do
you
want
to
do
a
quick
discussion
in
here
sure.
B
Thank
you,
yep
yeah,
absolutely
so
if
you
are
looking
to
contribute
to
the
community,
but
you
feel,
like
you've,
been
a
little
handcuffed
by
way
of
the
intimidation
factor
that
can
come
with
github
or
just
not
exactly
knowing
how
to
get
started.
The
sharing
is
caring.
Initiative
is
here
for
you.
We
have
multiple
sessions.
The
first
is
a
first
time
contributor
session.
B
So
these
sessions
are
like
a
pnp
call
but
they're
smaller,
a
little
more
intimate,
there's
safe
space
to
ask
questions
and
we'll
walk
you
through
from
beginning
to
end
how
to
perform
a
contribution
for
dev
docs
for
community
docs
and
then
also,
if
you're,
looking
to
consume,
we've
gotten
a
lot
of
feedback
that
new
ones
in
the
community
would
love
to
contribute,
but
honestly,
they're
a
little
bit
before
that
they
just
want
to
learn
how
to
start
consuming
some
of
the
samples.
So
one
of
our
newest
sessions
are
pnp.
B
Spfx
samples
using
node
version
manager
so
take
advantage
of
these
we're
having
even
more
sessions
coming
up
on
how
to,
for
example,
upgrade
samples
using
the
cli
so
completely
free
of
charge,
and
we
would
love
to
see
you
there
there's
multiple
slots
time
slots
available
for
both
north
american
and
apac
friendly
and
european
sessions,
so
aka
dot.
Ms
caring
love
to
see
you
there.
A
C
Yeah,
let's
keep
it
really
short,
because
we'll
kind
of
talk
about
it
later
on
as
well,
but
for
the
upcoming
october
release,
we
again
usually
think
we
merged.
We
asked
we
actually
merged
a
couple
of
older
prs,
which
were
waiting
for
quite
a
while,
but
which
was
still
very
valuable.
So
gotham
did
some
work
on
the
team's
provisioning
and
extraction
logic.
So
that's
really
good.
There's
a
little
bit
of
improvements.
We
moved
from
bed
to
v1
endpoints
because
it
was
still
using
beta,
which
was
something
that
had
to
change.
C
Paul
jefferson
did
some
updates
in
in
the
our
extraction
configuration,
so
we
you
can
kind
of
use
a
json
file
to
define
what
to
extract
in
a
pretty
granular
way
and
that's
using
a
schema.
There
are
some
issues
with
the
schema
those
were
fixed
now
and
this
just
these
are
just
two
fixes
to
small,
of
course
now
looking
forward,
what
happened
in
the
pmp
size,
core,
auto
10
standard
version?
How
will
that
go?
We'll
talk
about
that
in
a
second
and
the
pp
core
sdk?
C
That's
one
is
moving
forward
as
well
prepping
for
preview
three
by
end
of
the
month.
I
we
keep
on
adding
more
and
more
features
of
to
that
sdk,
and
it
also
will
be
discussed
in
the
end
of
the
session
vessel
when
we
talk
about
the
future,
because
things
are
related.
So
let's
kind
of
move
to
the
powershell,
I
would
say
just
be
on
time
absolutely.
D
Yeah
same
story:
I'll
keep
it
short
because
in
the
few
slides
later,
together
with
better
we'll
talk
about
the
future
of
pnp,
powershell
2
and
because
it's
directly
related
to
core,
we
meet
some
prs.
We
have
now
also
support
actually,
since
the
last
release
already
but
for
different
azure
environments.
So
you
can
specify
the
azure
environment
that
you're
connecting
to.
D
If
you
happen
to
be
connecting
to
the,
for
instance,
the
government
cloud
with
chinese
cloud
we're
prepping
a
lot
for
the
dot-net
standard,
build
so
for
powershell,
core
version,
six
and
seven
and
that's
still
ongoing,
and
we
have
some
updates
to
some
commands
here
and
there.
But
more
details
later
in
the
demo.
C
Well,
the
same:
this
is
last
time
two
weeks
ago,
so
nothing
major
plans
for
october
release
for
page
transformation,
so
transmission
is
having
a
steady
usage,
is
fairly
feature
complete.
So
it's
all
good
there
and
test
to
clarify
what
is
page
well.
This
space
transformation
is
a
good
point
because
don't.
C
That's
that's
what
it
is
just
kidding
if
you
have
classic
pages
classic
page,
is
a
wiki
page,
a
website
page
a
publishing
page,
a
blog
page
pages
that
you
created
like
years
ago,
and
if
you
want
to
transform
that
page
into
a
modern
page
which
nicely
works
for
the
modern
site,
then
this
is
the
tool
for
you.
You
can
use
the
firepowershell
over.net
and
it
will
kind
of
read
all
the
classic
pages
and
map
them
to
modern
pages
map
to
web
parts.
C
Kind
of
give
you
as
a
resulting
a
nice
modern
page,
so
that
so,
if
you
kind
of
take
that
in
the
monetization
look
at
the
story
of
how
to
modernize,
for
example,
a
team
site
at
that
point,
you
have
like
a
full
modern
team
site,
it's
the
same
site,
then
you
would
start
from
scratch.
So
you
don't
have
to
copy
off
and
do
and
everything
manual.
This
will
help
you
kind
of
just
in
place
upgrade
your
classic
team
sites
into
something
modern.
The
same
applies
to
publishing,
portfolios
and
block
size,
and
so
on.
C
Good
with
that
being
said,
the
monetization
scanner
is
the
second
in
our
tool.
In
our
monetization
toolkit,
I
would
say,
version
2.17
is
out
and
if
you
are
scanning
for
workflow,
which
we've
asked
you
most
of
you
to
do,
and
already
thousands
of
customers
did
that.
But
if
you
scan
for
workflow,
please
use
the
latest
version
2.17,
because
there's
some
improvements
there
rope
advice,
nothing
special,
planned
there,
let's
see
if
things
pop
up,
but
nothing
really
concrete.
At
this
point,
cool.
A
A
Actually,
it
looks
really
good
and
there's
more
than
22
000
downloads
in
this
year
and
on
the
yo
team,
so
widely
used
to
create
teams
extensibility,
which
is
then
implemented
using
node.js
and
typescript,
and
obviously,
if
you're
looking
into
doing
alternative
technologies,
those
are
definitely
an
option
as
well.
So
the
visual
studio
code
with
resource
studio
toolkit
is
an
option
and
in
there
you
it
generates
you
javascript,
based
on
extensibility
for
microsoft
teams,
so
it
doesn't
actually
do
typescript.
A
So
there's
a
use
case
for
all
of
these
things,
they're
not
really
competing
they're
different
tools
for
different
use
cases
as
well
and
and
victor
is
definitely
looking
into
growing
a
team
here
as
well.
So
if
you're
interested
on
engaging
and
building
further
versions
of
the
yo
teams,
that's
more
than
a
welcome.
E
So
yeah
a
bunch
of
new
samples
and-
and
we
want
to
keep
these
coming
so
I'm
really
excited
marcus.
Mohler
has
kind
of
outdone
himself.
He's
got
three
different
messaging
extensions.
All
of
them
call
the
graph.
One
of
them
actually
uses
a
sharepoint
framework
based
task
module,
which
is
the
secret
code
word
for
a
modal
dialogue
in
teams-
and
you
know
so-
that's
that's-
really
great
ramin
has
brought
in
a
third
party
api.
So
if
you're
in
a
sharepoint
framework
tab,
the
sharepoint
framework
makes
it
easy
to
call
the
first
party
apis.
E
But
what
if
you
wanted
to
call
a
third-party
api,
he
actually
has
a
whole
box
explorer
here
really
cool
stefan
has
brought
in
the
to
do
graph
api
in
a
messaging
extension
and
tomomi
amora
has
brought
in
her
famous
http
status
cats
into
a
messaging
extension.
If
you
like
cats,
or
even
if
you
don't,
you
might
want
to
check
that
out,
it's
definitely
a
lot
of
fun.
E
Sorry,
if
I
messed
up,
your
name
shows
how
to
install
a
teams
app
dynamically
when
a
messaging
extension
is
used
for
the
first
time
really
cool
stuff,
and
please
do
check
out
the
team
samples
before
you
start
coding,
see
if
there's
already
a
sample
that
does
what
you
want.
If
you
have
some
cool
code,
something
you've
done,
whether
it's
a
bare
bones
or
a
full
application.
We'd
love
to
have
your
contribution
into
the
sample
repository
thanks.
A
Excellent,
thank
you
both.
So,
let's
try
to
really
build
what
we're
trying
to
do
here
like
poco
sex
planning,
really
make
a
it's
hard
for
people
to
find
samples
because
they're
across
the
github
universe.
So
let's
try
to
create
a
location
where
we
can
actually
surface
all
of
the
samples,
even
though
they're
from
microsoft
or
community
and
multiple
different
locations
so
really
kind
of
making
it
easy
for
people
to
find,
what's
really
want
for
them
as
a
starting
point.
So
thank
you
for
that
one.
A
Now,
let's
actually
do
a
quick
photo
before
we
go
to
the
actual
demos,
and
this
is
the
goofy
photo
version,
few
weeks
back,
which
got
to
be
pretty
goofy
and
I
will
put
my
together
mode
on
and
we
can
actually
see.
Then
people
coming
in
and
so
I'll
share
my
screen.
So
you
can
actually
see
people
coming
into
the
call
as
well,
and
I
will
actually
enable
my
video
as
well.
So
it's
good
to
see
that
a
lot
of
people
again
on
the
call.
A
A
Yeah,
you
can
really
mess
up
the
camera
with
close-ups.
Should
we
do
a
crazy
one?
Everybody
crazy
go
crazy.
Oh,
I
can
see
a
sharepoint
monkey
there
as
well.
That's
really
cool
excellent.
I
think
that's
enough
for
now.
So
thank
you.
Everybody
just
good
to
see
the
faces
of
the
community
as
well,
because
we
can't
meet
physically
in
a
conference,
but
I
think
it's
time
to
go
to
the
magic
of
chris
kent.
So
let's,
let's
start
with
chris
with
the
list
magic.
F
Okay,
all
right
everybody.
What
up?
I'm
chris!
Let's
look
at
some
stuff,
I'm
good
all
right,
so
we're
on
our
classic
warrior
horses
site
and
we're
going
to
go
to
a
list
we've
seen
before
and
go
to
our
disasters
list
where
the
horses
track
potential
disasters
and
their
plan
to
avoid
them,
and
you
see,
we've
already
got
a
little
bit
of
formatting
with
our
classic
font.
Awesome,
pooh,
storm
icon,
we'll
be
covering
that
today.
Instead,
I
wanted
to
cover
some
of
the
stuff
you
could
do
out
of
the
box.
F
So
this
is
some
custom
formatting.
But
what
if
I
just
wanted
to
throw
something
on
there?
Pretty
quick?
So
let's
take
a
look.
We've
looked
at
the
design
mode
stuff
before,
but
there's
been
a
lot
of
improvements
and
I
think
it's
worth
taking
a
look
at
again.
So
one
of
the
first
things
to
do.
We
add
a
new
choice,
column
and
we'll
call
this
severity
and
right
away.
You'll
notice,
we've
already
got
some
formatting
you'll
see
that
from
now
on,
choice
fields
are
using
formatting
by
default.
F
F
What
another
one
here
we'll
call
this
one
has
issues:
let's
have
one
more
here,
we'll
call
blocked
okay,
so
you
can
see
I've
already
got
some
color
choices
here
I
can
go
ahead
and
do
my
formatting
before
I've
even
created
the
column,
all
right,
so
I
can
say,
no
fill
hit,
save
and
so,
let's
add
some
sample
data
here.
Let's
go
ahead
and
do
another
column
real
quick,
so
we
can
get
that
right
as
well.
Let's
add
a
date
and
time
we're
gonna
add
a
due
date.
F
Okay,
we'll
just
save
that.
So
if
we
edit
in
grid
view-
which
is
our
old,
quick
edit,
all
right,
much
better
name,
let's
go
in
here,
we'll
just
kind
of
set
these
quickly.
We'll
say
that
one's
done
right.
This
one
is
in
review
and
you'll
see.
Even
here,
we've
already
got
our
formatting
showing
up
right
here
inside
the
grid
view
as
we
set
these,
which
is
pretty
awesome.
F
F
F
F
Now,
if
we
come
in
here
and
go
to
column,
settings
and
format
this
column,
you
can
see
it's
chosen
by
default.
This
background
colors
design
mode,
which
is
nice
right.
It
really
just
adds
the
nice
rectangle
behind
it.
Instead,
I'm
going
to
switch
that
over
to
choice,
pills,
and
you
see
I
can
hit
this
edit
styles
now.
I've
got
some
options
here.
Let's
make
this
a
little
easier
to
see
we'll
make
that
more
focused
all
right.
So
if
we've
got
this,
that's
cool,
so
our
in
progress
is
blue.
Maybe
we
don't
want
that.
F
So
again,
we
can
change
those
colors
here,
but
you'll
notice.
We
have
this
other
piece
right
here
called
more
styles,
so
if
we
click
that
we
get
these
extended
styles,
so
we
can
do
things
like
add
these
icons
right.
So
for
whatever
reason,
microsoft
and
all
their
wisdom
has
decided
out
of
the
2000
icons,
you
can
choose
between
13,
but
we'll
see
a
way
to
change
that
here
in
just
a
little
bit,
but
either
way.
This
is
amazing
right.
I
can
change
all
sorts
of
stuff.
I
can
change
size
boldness,
the
font
colors.
F
F
Click
this
for
in
review
more
styles,
and
let's
put
that
there
all
right,
we'll
go
back
one
more
now.
We've
got
has
issues
and,
let's
add
an
icon
for
that.
One.
We'll
say
that
that
looks.
You
know
what
let's
do
this
one
for
has
issues
that
sounds
good
now
we
already
use
that.
Let's
use
that
okay,
so
we
come
back
here
and
we've
got
our
blocked.
F
Now,
let's
put
a
big
x
for
that.
Okay,
so
now
look
what
we
did
there
so
now
we
hit
save.
Never
once
do
we
have
to
see
any
json
or
any
other
fancy
formatting
stuff,
complete
ui
wizard.
To
do
that,
which
is
awesome
and
later,
if
I
come
in
here
and
let's
say
I
need
to
add
a
new
a
new
one
right,
so
I
go
to
column,
settings
and
edit
you'll
see
again
it's
all
integrated
right
here
and
I
want
to
add
another
choice.
F
F
Resolved
right
and
our
plan
for
this
one
is
go
on
a
fun,
loving
adventure
to
solve
the
mystery.
You
know
return
the
treasure
and
restore
the
declaration
of
independence.
Then
that
makes
me
laugh.
Okay,
all
right
now
we
can
choose
our
severity
canceled
and
we'll
put
a
due
date
of
I
don't
know
something
just
way
out
there
right.
So
this
way
off
in
the
future,
we'll
save
the
in
october.
So
we
save
that
you
see
immediately.
F
It's
got
this
new
thing,
it's
all
taken
care
of,
and
in
fact,
if
we
go
to
format
this
column,
you
can
see
we
have
a
new
option
here.
It's
automatically
picked
up
our
new
under
the
choice
here
we
can
come
in
here
and
we
can
change
that
as
as
needed
right
so
for
canceled.
Maybe
we
want
this
nice
gray
and
we'll
add
a
you
know.
Let's
add
an
icon
of
some
sort:
let's
go
thumbs
down.
That
sounds
great
right,
so
you
can
see
maintaining
these
and
adding.
These
is
super
easy
using
the
design
mode.
F
Wizards
right,
I
didn't
have
to
do
anything
crazy
and
I've
just
got
all
that
and
as
I
as
this
list
changes,
I
need
new
status
right
or
new
severity
fields
for
my
choice
fields.
All
of
that
just
kind
of
works.
It
works
very
nicely.
If
you've
got
a
fill
in
your
own
right,
you
can
have
a
style
defined
for
that
really
really
cool
stuff
right.
F
In
fact,
at
any
time,
if
I
want
to
jump
over,
you
can
so
if
I
want
to
go
a
little
more
hardcore
right,
I
want
to
use
one
of
the
samples
or
something
like
that.
I
can
format
this
column
and
you'll
see
down
here.
I've
got
this
advanced
mode.
Now
I
can
switch
to
that
and
you'll
see.
This
is
what's
making
all
that
magic
happen.
Now.
This
is
using
the
old
ast
format,
so
maybe
a
little
different
formulas
you
used
before.
F
But
if
you
want
to
run
in
here,
so
you
can
see
these
are
all
the
background
colors.
So
this
is
for
the
done
right.
Maybe
we
wanted
it
the
different
shade
of
green.
We
could
say,
ms,
you
know
bg
color,
we're
going
to
just
say,
green
light.
That
sounds
exciting
right.
So
if
we
preview
that
you
can
see,
there's
a
slightly
different
shade
of
green
or
if
we
come
down
here,
because
we
don't
like
you-
know
our
13
icon
choices
we
can
see.
So
this
is
our
in
progress
instead
of
trending
12.
F
Maybe
we
it's
in
progress,
we're
going
to
call
it
heart
fill
that
sounds
exciting
right.
So
there
we
go.
So
that's
where
we
can
use
that
as
a
starting
off
point
and
do
that
now.
One
thing
I'd
say:
one
big
caveat
here
is
the
moment.
You
save
that
and
you're
no
longer
using
the
wizard.
You
lose
a
lot
of
that
really
cool
stuff
right.
F
So
if
I
edit
this
column,
I
now
have
that
traditional
choice,
fields
right
because
I'm
doing
more
advanced
things
I
no
longer
have
the
ability
to
you
know,
see
that
thing
and
add
new
ones.
If
I
switch
back
to
design
mode,
it's
going
to
warn
me,
that's
all
gone
and
look.
It
is
all
gone
all
sad
for
now.
F
I'm
gonna
cancel
right,
but
the
idea
here,
though,
is
use
the
out-of-the-box
ones
to
do
amazing
stuff,
and
if
you
want
to
stick
with
that,
you're
going
to
have
some
options,
but
if
you
want
to
jump
into
more
advanced
stuff,
you
certainly
can.
So,
let's
look
at
another
one
here:
kind
of
a
classic
one,
so
column,
settings
and
format.
This
column
are
due
date
come
over
here
and
we
just
choose
format
dates.
You
can
see
that
it's
going
to
develop
some
rules
here.
F
So
by
default,
it's
going
to
say
if
it's
before
today
right
make
it
yellow.
If
it
is
today,
make
it
green
and
red
now
normally,
I
would
probably
make
this
one
yellow
right.
So,
let's
make
that
yellow
right,
because
you
got
last
minute
thing
right
now:
you're
good,
because
it
hasn't
come
up
yet
right,
so
easy
easy
to
do.
Right
and
again,
you
can
do
the
advanced
stuff.
We
go
to
the
more
styles
now.
What
if
I
want
to
reflect
a
little
more
right
like
who
cares?
F
F
So
if
we
go
back
here
instead
of
this,
every
column
type
has
this
kind
of
generic
rules
called
conditional
formatting,
and
so
let's
set
this
up
so
we're
going
to
show
all
the
values
as
right,
so
just
by
default,
we're
not
going
to
do
anything
right.
So
that's
kind
of
the
default
but,
let's
add
a
rule,
so
this
rule
we're
actually
going
to
look
at
another
column,
not
due
date.
F
Let's
look
at
severity
and
we'll
say
if
it's
equal
to
let's
say
done
right
or
if
severity
is
equal
to,
let's
say
blocked
all
right
or
you
see
I'm
just
building
these
rules
right
in
the
ui
I
can
see
my
severity
is
equal
to
and
I
can
say
canceled
right
so
any
of
these
three
that
I
would
consider
like
no
longer
does
the
due
date
matter.
I
come
down
here
and
now
I
can
specify
a
specific
value
for
that
right.
So
in
this
case
we're
gonna
come
in
here
and
we're
gonna.
F
F
Now,
if
we
come
back
here,
we
can
add
another
rule
right,
so
these
rules
will
be
applied
in
order.
So,
let's
add
a
rule.
So
if
that
didn't
apply,
let's
get
this
rule.
So
now
we're
going
to
say:
let's
look
at
the
actual
due
date.
I
want
to
say
if
it's
you
know
before
today,
we
can
use
a
specific
date.
This
time
we're
just
going
to
use
today,
all
right,
so
if
it's
before
today,
in
other
words,
we're
overdue.
F
You
know
let's
come
in
here
and
let's
go
more
styles
and
let's
actually
set
that
fill
color
to
whatever
this
pink
and
make
it
bold
all
right
we're
going
to
put
a
big.
You
are
bad
kind
of
icon
on
there
right
and
font
color.
Let's
make
that
you
know
this
nice
red
all
right
so
now,
we've
got
our
due
dates
that
are
overdue,
but
they
aren't
marked
as
complete
all
right.
So
that's
pretty
awesome.
F
Now
if
we
come
back
here,
let's
add
just
a
little
more
so
let's
add
another
rule
all
right
so
now,
let's
add
a
rule
for
if
the
due
date
is
today
right.
So
this
is
the
day
it's
due
all
right
so
equal
to
today,
I'm
going
to
show
this
item.
The
other
yellow
looks
good,
but,
let's
add
a
you
know:
let's
go
more
styles,
let's
make
it
bold.
Let's
add
just
a
calendar
icon
right
so
now
we
have
the
idea
that
oh,
these
are
the
ones.
F
I've
got
to
get
done
today
right
and
then,
let's
add
just
one
more
right.
So
we
add
one
more
rule
here
and
we're
going
to
say
if
the
due
date
is
after
today
right
so
now,
you've
still
got
time
to
do
this.
We're
just
going
to
come
in
here
and
we're
going
to
say
more
styles.
Let's
remove
the
fill
all
together
and
let's
make
it
that
nice
green
right
that'll
make
it
bold.
F
So
we
can
see
it
better
and
we're
going
to
put
a
thumbs
up
because
you're
on
track
there
we
go
and
just
like
that,
we've
created
some
pretty
complicated
rules
and
never
once
do
we
have
to
jump
into
the
json
unless
we
choose
to,
and
you
can
see-
that's
just
going
to
work.
If
I
add
new
values
in
here
tomorrow,
when
I
come
back
to
this
list,
all
these
will
be
reevaluated
right.
F
So
if
this
one
has
been
marked
as
done,
blocked
or
canceled,
the
sudden
they're
going
to
be
red
and
so
on,
so
this
acts
as
a
really
great
way.
You
can
just
use
these
design
mode
wizards
to
create
all
sorts
of.
You
know:
fancy
rules
without
having
to
really
really
jump
into
the
formatting
and
the
best
part
is
you
could
create
all
these
rules
and
then
jump
into
the
formatting.
G
F
All
the
you
know
the
switch
statements,
the
if
statements
are
already
built
for
you
and
you
can
just
change
those
values.
So
if
you
want
to
use
a
very
specific
shade
of
red
or
a
different
icon,
you
can
jump
right
in
there
and
do
that
all
right.
So
let's
review
real,
quick,
all
right
so
design
mode
all
right.
F
So
these
are
the
various
wizards
that
are
available
right
now,
there's
also
one
for
view
formatting,
which
does
the
alternating
rows,
which
is
a
nice
addition,
but
every
single
one
of
them,
including
the
view
format,
has
this
conditional,
formatting
type,
which
allows
you
to
define
those
rules
and
they're.
You
know,
building
those
is
pretty
straightforward.
You
can
do
the
ands
or
the
ors
and
kind
of
loop
them
all
together
again.
F
So
when
you
go
there
again,
you're
going
to
just
be
presented
with
that
by
by
default
on
several
of
these
column
types
you
set
edit
styles
and
you've
got
all
sorts
of
options.
You
know
these
are
pre-selected,
color
classes,
which
means
you
can
swap
them
out
later
with
your
own
classes.
They
are
not
your
theme
colors.
However,
there
is
options
to
choose
your
theme
colors
for
the
font
color,
but
not
for
the
background
color
inside
the
ui,
for
whatever
reason,
but
they
do
look
nice
in
dark
mode.
So
it's
hey.
F
You
know
it's
a
trade-off
and
then,
of
course,
these
extended
styles,
where
you
do
all
sorts
of
stuff,
which
is
what
I'm
really
excited
about.
We
didn't
even
take
a
look
at
some
of
the
border
options.
The
icon
alignment,
but
check
those
out
just
give
them
give
them
a
try
play
with
them.
One
thing
to
also
note
for
those
that
really
want
to
jump
in
there.
Every
single
one
of
those
represents
a
class.
F
So
it's
not
just
setting
bold
right.
There
is
a
class
to
make
that
bold.
So
if
you
wanted
to
use
those
same
classes
in
your
own
formats,
apply
them
here,
take
a
look
at
it
and
you
can
too
all
right
and
of
course,
you
can
always
switch
json.
If
you
want
to
take
a
look
at
some
of
the
samples
or
some
of
the
other
stuff,
all
right.
So
this
here
you
go.
Here's
the
documentation
check
out
our
samples
over
100
samples
out
there
on
how
to
do
all
this
stuff.
F
A
Excellent
thank
chris,
really
really
great
stuff
and
it's
good
to
always
recap
that
out
of
the
box
capabilities
are
evolving
all
the
time,
so
it's
good
to
actually
go
back
and
see
what's
always
possible
there,
so,
rather
than
ending
up
doing
extensibility
and
json
definitions-
oh
I
can
do
this
already
wow,
it's
a
good
example
of
a
evergreen
capabilities
for
sure.
So
thank
you
for
that
now.
A
F
G
G
I
am
an
office
development
mvp
and
you
can
reach
me
through
the
information,
as
you
can
see
here
so
today
we
are
going
to
talk
about
the
microsoft
graph
subscription
and
how
to
get
started
with
them
with
azure
functions.
So
as
an
introduction,
what
are
microsoft
graph
subscription
they
are.
They
are
also
known
as
web
books.
So
if
you
know
about
web
books
and
other
system
they're,
basically
the
same
in
microsoft
graph,
they
allow
the
subscribe
and
the
external
system
to
receive
notification.
G
G
You
want
to
be
notified
that
something
has
changed
in
one
of
the
servers,
so
we
will
use
graph
that
surface
microsoft,
365
and
then
microsoft
graph
will
notify
the
changes
that
has
appeared
that
have
occurred
in
one
of
these
services.
So,
basically,
here
on
the
right,
you
can
see
mostly
the
resources
that
are
supported
now
in
microsoft,
graph
with
v1,
so
it
could
be
changes
in
exchange
with
mailbox
with
users
and
groups
in
azure
the
chat
messages
that
are
currently
in
beta.
G
G
G
It
could
be
an
azure
function
that
could
be
also
an
app
service
in
azure
or
it
could
be
a
web
server
in
your
local
premises
and
then
we
will
say
we
want
to
subscribe
to
changes
that
occurs
to
that
resource
here,
and
we
have
to
specify
also
the
expiration
of
the
subscription,
we'll
see
that
in
a
minute,
so
with
this
subscription
that
we
want
to
create,
we
put
this
this
data
and
send
it
through
a
post
request,
a
post,
http
request
to
the
delegated
and
pointed
microsoft
graph.
So
basically
it
is
slash
sub
subscriptions.
G
G
We
will
still
we
have
still
microsoft,
365
and
microsoft
graph
and,
let's
say,
for
instance,
that
in
our
case
we
will
focus
on
when
an
email
arrives
in
the
user's
mailbox,
so
the
activity
occurs
in
exchange
online
exchange
will
relay
its
change
through
microsoft,
graph
and
microsoft.
Graph
will
send
a
notification
through
an
http
plus
request
to
our
web
book.
G
G
What
if
it
if
it
does
not
respond
within
30
seconds,
microsoft
graph
will
consider
the
notification
never
arrived
so
later
on.
It
will
try
resending
it
and
it
will
do
until
there
is
a
successful
call.
It
will
do
it
several
time
during
the
during
about
4
hours
after
4
hours,
the
notification
will
be
forever
lost.
G
So
I
will
use
really
basic
tools
here.
Just
for
the
experiment,
I
will
use
graph
explorer
to
create
a
subscription
and
I
will
use
the
in
portal
azure
function.
So,
first
of
all,
I
will
create
my
web
book.
I
already
have
one
here,
but
just
to
let
you
see
how
it
is
done.
I
create
in
my
function
app
here.
I
create
a
new
http
trigger
and
I
will
call
it
workbook
pnp
and
I
want
to
make
it
anonymous
because
the
the
url,
the
url,
must
be
accessible
by
anyone
without
any
authentication
scheme.
G
G
G
G
It
is.
It
should
be
running
okay.
I
do
that
because
if
I
don't
the
the
the
azure
function
in
consumption
plan
won't
be
warmed
up
yet,
and
so
remember
in
my
slide,
that
in
the
validation
step,
you
have
to
respond
within
10
seconds,
and
so
microsoft
graph
won't
accept
it
if
it's
not
already
running
so
it
is
saved
okay
and
then
now
I
have
to
go
to
graph
explorer
and
you
see
that
currently,
if
I
type
subscription
and
get
I
have
already
a
subscription,
which
I
think
I
cleaned
before.
G
Okay,
so
now
not
delete
yet
okay.
So
now
I
have
a
clean
set
of
subscription
and
I
will
create
a
new
one
so
to
create
a
new
one.
I
send
a
first
http
request
with
not
this
one,
this
one
here
and
so
it's
basically
the
same
json
except
that
that
you
saw
in
the
slide,
except
that
I
will
have
to
get
the
url
of
my
new
web
book.
G
G
G
G
Okay,
so
I
received
it-
and
you
see
here
that
I
have
received
a
notification-
okay-
and
I
will
just
paste
this
in
my
vs
code
to
make
it
more
clear
and
you
see
that
it
is
well
my
subscription
so
30
30
69
and
it
it
tells
me
that
I
have
a
something
that
changed
that
has
been
updated
on
that
resource
and
that
resource,
so
user.
Slash
id,
slash
message,
slash
the
id
of
the
message.
G
My
message
indeed
so,
basically
with
that
in
place,
I
can
then
query
graph
on
in
my
backend
system
and
do
whatever
I
I
need
to
do
with
the
data,
let's
change
in
microsoft,
365.,
and
it
is
basically
it
for
the
demo,
so
I
will
switch
back
for
a
next
couple
of
slides,
so
some
important
considerations
that
the
subscription
maximum
lifetime
is
quite
short
for
almost
every
resource
resources
types
in
v1.
It
is
a
bit
less
than
three
days
a
bit
less
than
72
hours.
G
Actually,
so
what
you
will
have
to
do
in
your
system
is
that
you
will
be
responsible
for
updating
the
lifetime
of
the
subscription
before
it
expires,
because
when
it
is,
it
is
expired.
It
is
simply
deleted
and
notification
won't
be
sent
anymore
after
30.
Second
time
also,
it
is
what
I
said
just
before
after
30.
G
The
notifications
are
not
immediate.
It's
important
to
consider
because
you
should
not
expect
them
to
er
to
arrive
immediately
because
really
depends
on
the
type
of
the
resources
you
are
subscribing
to
here
for
the
mails
and
the
events
in
outlook.
It
is
quite
immediate
for,
based
on
my
experience
for
notification
on
users
and
groups,
and
so
on,
it
might
take
a
few
minutes
according
to
documentation.
G
It
is.
It
should
be
maximum
15
minutes
for
receiving
the
notification,
so
you
should
not
use
web
books
expecting
real
time.
Notification
for
critical
stuff
web
must
have
https
public
reachable
url.
So
it
means
that
if
your
web
book
is
on
your
local
premises,
for
instance,
you
will
have
to
deal
with
the
firewall,
dns
and
so
on
and
so
forth.
G
G
If
someone
gets
to
know
your
secret,
it
can
stop
the
the
notification
as
well,
and
so
you
have
to
make
sure
that
you
won't
cause
any
risk
to
your
system
or
to
your
microsoft,
365
tenant.
By
directly
in
this.
In
the
code
of
this
web
book,
you
will
have
to
make
sure
that
you
put
everything
that
you
can
to
validate,
that
it
has
to
be
secure
enough
and
last
thing.
Notification
do
not
contain
that.
G
It
is
not
true
in
the
beta
version
of
microsoft
graph,
because
in
beta
version
you
have
some
endpoint
that
accept
what
is
called
rich
notification
that
contains
some
content,
but
it
has
to
be
sight
for
it
with
a
certificate
and
so
on.
It's
a
bit
more
tricky
in
my
opinion
to
to
to
set
up,
but
it
also
allows
more
complex
scenarios
so,
but
for
v1,
your
system
in
turn
needs
to
call
microsoft.
Graph
with
the
identifier
of
the
resources
have
changed.
A
A
So
obviously,
the
the
the
subscriptions
and
web
hooks
in
the
craft
are
super
super
powerful,
there's
a
massive
amount
of
different
options
related
on
that
I'll
add
a
list
of
different
resources
which
you
can
actually
subscribe
to,
just
as
an
example
for
all
of
the
incoming
messages
in
the
teams
or
events
which
are
getting
created
or
any
single
sharepoint
list
or
library
is
getting
created
in
a
tenant.
You
can
subscribe
to
that
event
and
then
modify
that
list
based
on
your
business
requirements.
So
super
super
super
powerful.
A
Also,
one
thing
that
I
wanted
to
call
out
because
vincent
is
in
the
call,
so
we
we
paul,
was
already
helpful
and
updated
to
think
that
you
don't
actually
have
to
be
necessarily
anonymous
with
the
end
point
so
vincent.
Can
you
actually
quickly
explain
that
winston
being
an
ex-mvp
nowadays
in
the
craft
team
implementing
some
of
their
stuff
so
sure.
H
Hi
everyone,
so
thank
you,
yannick
for
a
great
demo
to
begin
with.
I
don't
want
to
take
too
much
time
because
I
know
there
is
another
demonstration
right
after
that.
So
you
do
have
a
couple
of
ways
you
can
authenticate
and
authenticate
with
webhooks.
You
mentioned
the
client
secret
to
begin
with,
so
that's
a
shared
secret
between
graph
and
your
service
that
has
to
stay
secret
by
a
sense
right.
Another
way
is
to
make
sure
if
you're,
using
rich
notifications,
they
can
come
with
certificate,
authentication
and
certificate.
H
Signing
of
a
payload,
so
you're
sure
that
the
payload
comes
from
microsoft
graph
and
it's
secured,
and
it
cannot
be
decrypted
by
anybody
else
and
so
on
and
so
forth.
And
the
third
thing
that
we're
previewing
is
the
ability
to
receive
change
notifications
not
for
web
hooks,
so
not
through
an
http
post
but
through
azure
even
hubs
instead.
H
So
that's
really
great
for
cases
where
you
are
behind
a
firewall
or
you
are
already
using
some
azure
services
or
you
want
high
performance,
and
one
of
the
great
things
about
even
hubs
is
that
it
is
authenticated
by
default.
So
the
whole
string
of
notifications
will
be
secured
and
authenticated
by
default
and
feel
free
to
reach
out
to
me.
If
you
have
any
questions
and
with
that,
I
don't
want
to
take
more
time
from
birch,
because
I
know
bert
has
great
demonstrations
to
to
to
follow
with.
C
So
where
are
we
today?
What
do
we
have?
Today?
We
have
our
pp
size,
core
library,
massively
used
by
many
people,
and
we
have
our
new
pnp
core
sdk
bb
size
core
has
been
there
for
seven
years.
I
think
lesser
that
the
you
and
me
wrote
the
first
code
like
seven
years
ago,
and
we
still
thought
that
you
still
did
coding
and
dot
net.
The
times
have
changed,
but
it's
a
point
I
want
to
make.
Is
that
there's
a
ton
of
code
beside
score?
C
It's
not
always
the
cleanest
code,
not
always
the
nice
nicest
constructed
code,
because
that's
organically
grown
into
really
a
big
big
library,
which
has
a
lot
of
conditional
statements
around
the
on-premises
support
because
sharepoint
2013.
Does
it
like
this
sharepoint
2016?
Does
it
differently
ship
online?
Does
it
again
differently?
C
So
it's
a
fairly
complex
code,
the
other
end,
because
the
gate
is
brand
new,
it's
a
graph
first
library.
So
we
focus
on
the
graph
we
use
graph
wherever
possible,
but
you
fall
back
to
rest
or
see
some
when
needed.
That
library
is
using
modern.net
development
techniques.
Dependency
injection
is
as
80
plus
desk
coverage.
So
it's
more
like
how
it
should
be
done
now.
What
does
it
mean
for
going
for
our
future
going
forward?
C
C
The
v4
preview
will
be
the
one
that
will
support.net
standard
2.0,
and
our
current
plan
is
to
ship
that
as
part
of
the
october
release,
so
in
october
release
you
will
have
the
original
current
nuget
package
that
that
we
have
been
shipping
for
like
years
and
years
now,
but
you
also
have
a
new
nuget
package
containing
the
pnp
size,
core
version
4,
which
then
runs
onto
that
standard
3.0,
which
consumes
the
season.then
standard
3.0.
So
this
one
will
be
fully
platform
neutral
and
and
can
be
run
on
everywhere
going
forward.
C
We
will
once
we
feel
good
about
empty
status
quo
v4.
We
actually
will
stop
shipping
and
distributing
pbsco
v3,
which
also
implies
that
we'll
stop
shipping
new
versions
for
on-premises
for
pdp
sitescore,
we'll
only
continue
going
forward,
pnp
site
score,
v4
using
for
spo
and.standard
and
then
in
the
future,
with
no
timing.
Yet
it
mentions
q1,
but
let's
see
how
things
evolve
in
b,
core
sdk
will
be
consumed
as
well
by
being
besides
courses
so
that
we
don't
have
to
duplicate
code.
C
If
you
write
something
new,
we
will
do
it
and
peter
as
a
gay
and
then
just
live
widgets
from
pdp
style
score.
This
is
kind
of
our
way
to
a
step-by-step
transition
from
our
current
massive
monolithic,
bb,
cisco
library,
to
a
modern,
clean,
bmp,
core
sdk
library,
which
focuses
on
on
graph
and
modern
data
and
development.
C
C
C
A
D
So
the
next
release
there
will
be
a
v3
version
that
will
support
still
the
on-prem
releases,
but
there
will
also
be
a
preview
coming,
which
we
most
likely
will
mark
also
as
a
preview
release
in
the
powershell
gallery,
which
I
see
very
change.net
standard
from
2.1
to
2.
Yes,
actually
for
powershell,
that's
not
relevant,
we
can
actually
run
2.1
here,
I'm
just
I'm
because
I'm
consuming
doesn't
matter
technical
details,
it's
running.net
standard,
so
it
runs
with
powershell
7
and
then
later
we
will
stop
releasing
new
builds
of
the
v3
release.
D
D
C
Yep,
the
step-by-step
evolution
now
just
going
quickly
back
on
the
net
standard
2.0
versus
2.1.
We
actually
it
went
from
2.1
to
0.2.0,
because
2.0
still
runs
on
that
framework.
So
if
you,
if
you
use
our
opinion
besides
core
library
for
that
standard,
you
can
just
com
consume
it
in
your
regular.net
development
using.net
framework,
and
you
can
also
use
it
for
in
a
net
core
application,
for
example.
So
it
can
be
used
on
both
sides
if
you
would
use
2.1
at
that
point,
you're
limited
to
a
core:
that's
why?
C
But
this
will
unblock
lots
of
ask
from
people
that
want
to
use
this
in,
like
modern
azure
functions,
for
example,
or
cross-platform,
and
we
first
had
many
many
asks
for
doing
this
and
we
thought
this
is
the
clean,
proper
way
to
do
it,
and
so
we
can
ensure
quality.
We
can
clean
up
the
code
base.
We
can
actually
also
rationalize
things,
will
remove
legacy
stuff,
so
it
will
be
cleaner
and
better
going
forward.
D
There's
a
question
from
mike
here
about
if
this,
if
this
is,
if
there's
a
message
from
2019,
don't
read
into
this,
that
there
will
be
no,
we
don't
know,
that's
not
that's
we're
not
in
that
position
to
state
or
there
will
be
no
more
version
of
sharepoint
for
on-prem.
That's!
No!
No!
This
is
completely
disconnected
from
that
story.
It's
that's
just
us
deciding
to
not
doing
on-prem
releases.
A
A
D
Yes,
yes,
by
the
way,
a
little
last
thing
by
the
way
before
we
you'll
see
also
in
the
bottom
there's
this
green
line
there
we
say
the
repo
names,
so
we
are
putting
things
in
a
new
repository,
so
there
will
be
a
new
repository
from
code
and
on
the
powershell
level,
we're
changing
a
couple
of
things.
Also,
in
the
way
we
handle
documentation,
it
will
actually
be
easier
for
you.
That
is
not
a
coder
to
update
the
documentation
for
the
new
version
of
pnp
powershell
by
just
modifying
the
markdown.
A
Cool
and
we
are
on
the
hours,
sorry
for
the
time
management
we
are
trying
to
do
that
properly
and
learning
to
do
that
more
efficiently,
definitely
in
every
single
call,
but
we
don't
want
to
reduce
from
three
demos
to
two
because
yeah
that
wouldn't
feel
right
either.
No,
that
was
the
demos.
Today
we
are
heating
dower
and
I
will
actually
jump.
A
I
already
have
yannick's
slides
in
my
here
and
all
of
the
other
ones,
but
just
a
a
no
time
for
q,
a
it's
been
ongoing
in
the
chat
the
recording
will
be
available
in
24
hours
and
my
search
results,
sharepoint
community
youtube
channel
and
you
can
follow
up
on
the
announcements
in
microsoft.
Resist
five
deaf
m365bnp
next
m365
journal,
dev
call
isn't
in
october.
First
next
year
upon
the
framework
community
calls
on
september,
24th
and
and
if
next
sharepoint
monthly
community
call
is
in
october
13th.
A
There
is
also
plenty
of
other
calls
happening,
so
I
think
right
now
or
is
it
within
an
hour?
There
will
be
as
an
example:
microsoft,
identity
platform,
monthly
community
calls
so
depending
on
your
interest,
depending
on
your
focus
area,
choose
the
course
where
you
want
to
go.
All
of
this
is
getting
recorded
and
it
will
be
published
in
either
one
of
those
youtube
channels
which
you
saw
in
the
start
of
the
deck
or,
and
you
can
always
go
to
the
akms,
m365
dev
course
and
get
access
the
list
of
these
calls.
A
But
thank
you,
everybody
for
your
participation
again
today.
Super
active
chat.
That's
super
super
valuable.
We
didn't
have
a
chance
to
answer
in
all
of
those
questions.
I
do
apologize
on
that,
of
course
try
to
answer
as
many
as
possible.
Thank
you,
yannick!
Thank
you
chris
and
irvin
and
bert
for
the
great
demos.
Thank
you,
vincent
for
dropping
by
as
a
ad
hoc
at
her
visitor
as
well.
Do
a
cameo
role
on
the
on
the
course,
but
that's
it.
For
now.
Let's
have
a
great
rest
of
the.