►
From YouTube: Microsoft 365 PnP – General Microsoft 365 Developer SIG community call – 13th of May, 2021
Description
Microsoft 365 PnP Community - General SIG call on May 13th. Demos: 1) Inspire, inform and prepare employees transition to the new hybrid Workplace transformation site, 2) Querying and Paging data with PnP Core SDK, and 3) Advanced tricks for form formatting and customization. Work is being done on all project fronts to be announced at Microsoft Build. Visit Microsoft Teams samples gallery, preview Microsoft 365 Extensibility look book gallery, and register for trainings on Sharing-is-caring. The host of this call was David Warner II (Catapult Systems) |@DavidWarnerII. Q&A takes place in chat throughout the call.
Learn more:
• See the full blog post for this call at: https://aka.ms/m365pnp/community/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
All
right,
thank
you
for
joining
us
today,
we'd
like
to
warmly
welcome
you
to
the
microsoft
365
development
bi-weekly
community
call
today
is
may
13th.
My
name
is
david
warner,
I'm
a
pnp
team
member
with
catapult
systems
and
I'll
be
your
host
today,
standing
in
for
vesa.
So
let's
begin
by
taking
a
quick
look
at
our
agenda
for
today
we're
gonna
review
and
begin
with
an
overview
of
all
the
latest
updates
on
all
the
initiatives,
we'll
remind
everybody
what
resources
are
available
to
them.
A
A
Of
course,
the
opportunity
to
participate
in
this
community
is
open
to
everyone.
You
can
demo
a
solution
or
technical
pattern.
You
can
contribute
on
github
and
you
can
provide
feedback.
We
always
love
to
see
everyone
contributing
by
way
of
a
demo.
I
know
it's
one
of
patrick's
favorites
as
he
says,
and
it
is
something
that
is
available,
so
please
don't
hesitate
to
reach
out
and
talk
to
anyone
on
the
patterns
practices
team.
If
you
have
a
demo
that
you
would
like
to
present,
there
is
no
restrictions.
A
As
we
saw
last
week,
we
had
a
14
year
old,
providing
a
demo.
So
we
invite
everyone
to
provide
a
glimpse
to
the
work
that
they're
doing,
and
we
certainly
do
appreciate
it.
If
we
look
at
our
collection
of
resources,
there
are
many
that
we
begin
with
the
365
developer,
videos
and
the
community
videos.
We've
got
a
number
of
open
source
initiatives,
available,
github.com
sharepoint,
pnp
office,
dev,
microsoft,
graph,
a
lot
of
sample
galleries
and
we're
working
on
a
unified
sample
gallery.
A
That
is
going
to
be
available
soon
that
everyone
can
take
advantage
of
to
see
everything
across
the
world.
So
it's
going
to
be
fantastic
and
all
of
these
are
open
source
and
have
an
opportunity
to
be
contributed
to,
and
of
course,
if
you're
looking
for
a
one-stop
shop
on
how
you
can
find
all
of
these
wonderful
things,
you
can
take
a
look
at
the
aka
dot.
Ms
forward
slash
m365
pnp.
A
That
is
the
primary
landing
page
for
open
source
initiatives
and
samples
within
the
patterson
practices
umbrella
extensibility
within
the
microsoft
365
ecosystem
is
fantastic
and
available.
So
if
you
go
to
aka
dot,
ms
forward
slash
m365
forward,
slash
extensibility,
it's
going
to
provide
you
a
glimpse
of
different
ways
in
which
you
can
extend
the
microsoft
365
landscape.
A
A
There
is
also
a
number
of
team
samples
that
are
available
if
you're
looking
to
get
started
with
team
samples.
Don't
miss
this
sample
gallery
we'll
talk
a
little
bit
more
about
it
in
a
few
minutes
with
bob
german,
but
it
is
available
to
and
by
the
community,
and
you
are
welcome
to
use
the
samples
reuse,
the
samples
improve
the
samples,
everyone
loves,
contributing
back
and
that's
an
opportunity
that
you
can
have
as
well.
So
aka
ms
forward
slash
team
samples.
A
Now
all
these
resources
may
be
overwhelming,
you
may
think.
How
am
I
going
to
get
started
with
them?
How
am
I
going
to
contribute
back
to
them?
Well,
we
have
an
opportunity,
for
you
call
now
and
you
can
get
access
to.
The
sharing
is
caring
initiative.
This
is
an
initiative
by
the
patterns
of
practices
team
that
provides
hands-on
guidance
on
using
a
lot
of
these
resources
and
contributing
back.
The
spectrum
is
pretty
wide,
as
you
can
see,
from
the
upcoming
sessions
from
first
time
contributor
to
creating
community
docs.
A
In
fact,
that
means
that
you
can
create
brand
new
guidance
documentation
that
you
can
see
living
at
microsoft.com.
If
you
are
more
of
a
developer
and
you
want
to
get
started
in
that
environment,
then
we've
got
sessions
that
will
cover
that
information
as
well.
If
you
want
a
demo
but
you're
a
little
nervous
about
presenting,
we
have
a
first
time
presenter
and,
of
course,
our
maturity
model
practitioner
session.
A
We've
also
started
up
the
amas,
those
are
vastly
popular
and
so
coming
up
in
june
we
have
a
graph
in
mgt
ama,
that's
exciting
and
a
teams
dev
ama,
so
be
on
the
lookout
for
those
all
these
sessions
are
live,
they're
hands-on,
they
provide
guidance,
they're,
not
recorded,
so
it's
a
safe
space
opportunity
for
you
to
ask
any
and
all
questions
without
feeling
a
little
overwhelmed
with
whether
or
not
it's
going
to
be
recorded
and
they're
all
free,
completely
free
of
charge.
So
please
don't
hesitate
to
register
aka.
Ms
ford,
slash
sharing
is
caring.
B
B
You
know
we
have
the
pmp
framework
and
the
pmp
core
sdk,
the
pmp
framework,
mainly
targets
developers
accustomed
to
play
with
the
season
side
of
the
world
and
the
pmp
core
sdk
is
the
new
sdk
that
we
introduced
to
have
a
completely
modern
and
new
development
model.
We
are
improving
both
of
them
constantly,
and
nowadays
we
are
in
version
1.5
for
pmp
framework.
B
We
are
preparing
the
version
1.5
of
pmp
framework
and
we
had
some
nice
improvement
by
christian
zuling,
giacomo
possoni
and
bear
jasmine
as
well
as
by
me
and
in
the
upcoming
weeks.
We
plan
to
introduce
full
support
for
the
latest
release
of
the
pmp
provisioning
schema,
which
is
the
2021-03,
so
the
one
of
march
2021.
B
from
a
pmp
core
sdk
point
of
view.
Again
we
are
working
on
version
1.2.0,
which
will
be
released
most
likely
by
the
end
of
may,
together
with
the
pmp
framework
1.5
and
still
there
we
have
improvements
made
by
again
christian
zuling.
So
thank
you
very
much.
Christian,
patrick
lambert
and
bert
again
and
stay
really
tuned,
because
we
really
plan
to
improve
pmp
core
sdk
and
provide
additional
capabilities.
We're
really
proud
because
we
reached
95
000
tenants.
B
Now
I
still
remember
when
we
reached
the
very
first
10
tenants-
and
I
think
this
is
a
huge
number
and
we're
really
proud
of
it.
Still
talking
about
the
developer
area.
We
also
have
the
pmp
powershell
command.
Let's
and
in
that
area
again,
we
are
proud
that
we
reached
already
290
000
downloads
and
on
average
we
make
up
to
75
million
common,
let's
executed
per
day,
which
is
a
huge
number
incredible
number.
We
reached
25
000
tenants
and
in
version
1.5,
which
is
already
released.
B
We
added
the
very
first
command
light
to
support
microsoft,
viva
connection
with
the
published
pmp
company
app,
as
well
as
some
other
small
fixes,
and
we
are
already
working
on
version
1.6.
Remember
that
the
pmp
powershell
now
is
cross-platform
and
it
is
targeting
the
powershell
core
engine
and
not
anymore,
just
the
windows.
Only
windows,
powershell
engine,
talking
about
your
teams.
There
are
some
upcoming
improvements
in
that
area
as
well.
B
B
When
you
develop
your
solution
and,
generally
speaking,
a
lot
of
improvements
like,
for
example,
support
for
importing
teams
up
studio,
manifest,
as
well
as
support
for
multiple
manifest
when
you
are
in
an
environment
where
you
want
to
develop
a
solution,
and
you
want
to
target
the
dev
staging
production,
environment
or
multiple
customers
with
multiple
manifest
files
that
you
need
to
manage
so
really
great
stuff
coming
out
and
very
soon.
We
will
release
all
of
these
capabilities
and
now,
mike
back
to
you
david.
Thank
you.
A
C
These
are
all
going
to
be
included.
So
I
guess
for
those
of
you
who
don't
know
what
microsoft
graph
toolkit
is.
It
is
a
reusable
component
library,
plus
authentication
libraries
that
help
you
connect
and
work
with
microsoft,
graph
and
accelerate
your
development,
and
we
need
people's
help
for
testing
out.
You
know
what
are
the
new
features
and
bugs
that
you
would
like
to
help
introduce
or
solve
for
the
ripple
and
then
try
out
the
new
things.
That's
coming
up.
D
Hey,
thank
you
very
much,
david
yeah.
I'm
really
excited
about
this
sample.
This
week.
We
have
a
new
one
from
seb
levere,
who
is
in
our
own
pnp
team
as
well,
and
I
like
this
one
because
a
lot
of
people
have
asked
me
over
time.
How
do
I
notify
a
user
if
I've
got
if
I've
written
a
teams
app,
I
want
to
get
the
user's
attention.
D
You
have
to
actually
have
an
app
installed
and
seb
leads
you
through
the
whole
process,
so
that
you
can
see
how
to
use
this
great
feature,
which
is
really
a
combination
of
graph
and
teams,
and
so
I
invite
you
to
check
that
out
as
well
as
the
fact
that
it
also
kind
of
the
scenario
is
a
kudos
app.
So
if
you
want
to
build
a
kudos
app,
here's
the
starting
point
for
that
as
well.
D
So
there's
a
url
there
also
tons
of
other
samples
available
at
aka.slash
teams
samples,
and
we
would
love
to
have
yours
if
you're
working
on
something
in
the
team's
development
space
and
are
willing
to
share
your
approach
or
your
actual,
obviously,
a
working
sample
that
exemplifies
that
would
absolutely
love
to
have
a
pull
request
and
make
this
totally
comprehensive
gallery
of
samples
for
everyone.
So
sharing
is
caring.
Thank
you.
So
much
back
to
you
dave.
A
Awesome
thanks
bob
yeah
and
if
you
are
a
little
uneasy
on
how
to
submit
that
pull
request.
Well,
don't
forget,
sharing.
Is
caring,
we're
up
we're
here
to
provide
that
opportunity
to
help
you
out
all
right.
Well,
it's
optional
picture
time.
So
everybody
loves
this.
So
if
you're
comfortable
turn
on
those
cameras
and
I'll
move
into
view,
our
together
mode
and
we'll
set
up
a
recording
for
camtasia
see
if
we
can
fill
a
few
more
in
got
everybody
turning
on
showing
up
excellent
todd
is
next
to
me
in
the
back
dancing
all
right,
excellent.
A
All
right
still
room
for
a
couple
more
people
want
to
get
in
all
right,
excellent!
Well,
let
let's
begin
the
recording
here
in
three
two
one,
all
right,
everybody
wave
say
hello.
It's
always
great
to
see
all
the
faces
of
the
community,
hopefully
soon
we'll
be
able
to
see
everyone
in
person
again.
That
still
exists.
I
think
all
right
fantastic!
A
Thank
you!
So
so
much
all
right!
Well,
it's
time
for
our
demos,
so
we're
going
to
turn
the
stage
over
to
holland
and
matt
feel
free
to
take
over
and
they
are
going
to
show
us
how
to
inspire
and
form
and
prepare
employees
for
a
transition
to
a
hybrid
workplace
with
the
new
workplace
transformation
site.
E
Thanks
david
hi
everyone,
my
name
is
matt
walidarski,
I'm
joined
by
my
colleague,
holland
and
together,
along
with
katie
larson
in
our
sharepoint
design
team
we've
created
some
assets
that
we
thought
might
be
interesting
to
this
community,
of
course,
including
a
hybrid
workplace,
sharepoint,
site
template
and
some
end
user
training.
So
that's
what
we're
going
to
be
sharing
with
you
today,
just
a
little
bit
of
setup
and
then
we'll
get
into
the
the
demo.
E
E
Over
80
percent
of
managers
surveyed
expect
to
have
more
flexible
work
from
home
post
pandemic,
and
then
more
than
70
percent
of
the
employees
and
managers
reported
the
desire
to
continue
working
from
home
at
least
part
time,
and
so
at
microsoft.
We
believe
the
future
of
work
is,
is
hybrid
and
really.
The
essence
of
hybrid
work
is
extreme
flexibility.
E
In
terms
of
where
and
when
people
work,
organizations
now
are
rethinking
how
work
is
going
to
happen
at
their
companies
they're
creating
new
policies,
whether
this
means
you
know,
portions
of
the
week,
people
will
spend
working
from
home
and
some
in
the
office.
You
know
that's
pretty
common
as
well
as
flexible
working
hours,
so
that's
kind
of
the
reality
of
what's
coming
post
pandemic
and
as
we
return
to
the
workplace.
E
Moving
to
the
hybrid
work
model
is
not
just
about
continuing
this
great
work
from
home
experiment
that
we've
all
been
participating
in,
there's
a
need
to
change
behavior,
and
that
means
developing
new
skills
so
that
we
can
work
in
this
new
hybrid
work,
environment,
there's
also
a
collective
effort
that
is
required
for
a
successful
transition
to
this
new
way
of
working.
We
kind
of
view
it
as
an
organizational
change
initiative
and
how
we
guide
people
through
that
journey
to
hybrid
work
is,
is
really
important.
There
are
risks.
E
If
it's
not
done
correctly,
people
won't
buy
in
people
won't
have
the
skills
necessary
to
work
in
a
hybrid
world,
so
that's
kind
of
how
we're
coming
at
it,
especially
with
this
first
asset
that
we're
going
to
be
talking
about
of
the
two,
and
that
is
a
new
workplace
transformation
site
template
that's
available
up
on
the
lookbook.
This
is
a
site
that
all
of
you
can
install
today
into
your
tenant
environment,
into
your
customers,
tenant
and,
basically,
like
other
site
templates.
It's
something
that
you
can
make
your
own.
E
E
E
If
you
go
into
the
solutions
section,
you'll
find
it
as
one
of
the
options,
along
with
all
the
other
sharepoint
site
templates
and
then,
of
course,
there's
a
direct
link
that
we'll
have
in
the
the
notes
that
you
can.
You
can
get
to
it
as
well.
So
yeah,
let
me
walk.
You
walk
you
through
this,
I'm
going
to
just
highlight
some
some
key
sections.
E
What
you're
looking
at
here
is
the
the
home
site,
we're
really
hoping
that
organizations
who
are
making
this
move
to
harvard
work
can
use
this
as
a
starting
point
for
their
change
site
related
to
the
hybrid
workplace.
So
you
know,
a
lot
of
thought
has
gone
into
what
hybrid
work
means,
because
it's
about
changing
people's
behavior.
We
of
course
have
to
outline
what's
in
it
for
them,
and
so
you'll
see
a
lot
of
that
throughout
the
site,
but
the
home
page.
Here
you
can
see
it's
broken
down
into
what's
happening.
So
what's
the
change?
E
What
to
expect
what
you'll
learn?
We've
got
some
new
training
playlists
that
holland's
going
to
share
more
about
in
just
a
moment
as
well
as
where
to
go
for
questions
and
support
and
lunch,
and
learns
all
sorts
of
good
community
type
resources
and
champion
programs
to
help
bring
employees
along
this
change
journey.
So,
let's
dive
in
a
little
bit
more
into
hybrid
work.
This
is
a
kind
of
a
deep
dive
into
what
this
means.
You'll
find
some
great
illustrations
and
powerpoint,
slides
or
pdfs
that
really
outline
what
a
hybrid
workplace
is.
E
E
That
shows
you
know
what
a
typical
week
is
for
somebody
who's
moved
into
this
new
hybrid
world
and
when
they
might
come
into
the
office,
what
sort
of
meetings
they
might
do
in
the
office
versus
at
home
so
very
useful.
I
think,
if
you're
trying
to
give
people
a
picture
of
what
to
expect,
we
have
this
getting
started.
E
As
I
mentioned,
we
view
this
very
much
as
a
change
journey,
so
we've
included
a
hybrid
work
checklist
that
organizations
can
again
use
as
a
starting
point
for
their
own
change
management
program
to
guide
their
new
employees.
So
there's
activities
here
in
terms
of
making
people
aware
giving
them
the
knowledge
getting
them
to
to
buy
in
and
kind
of
persisting
this.
This
change.
F
Thanks
matt,
hello,
everybody,
so
I'm
going
to
go
ahead
and
pop
up
a
couple
slides
and
just
walk
you
through
our
thinking
behind
the
content
that
we
did
create
and
how
it
may
apply
to
your
organization
and
some
different
methods.
You
can
use
to
actually
train
end
users
on
how
to
overcome
all
of
these
new
challenges
that
are
presenting
themselves
both
in
the
remote
work
situation
and
as
we
think
about
going
back
to
the
office.
F
So
what
you'll
see
here
on
the
slide
is,
on
the
left
hand,
side
we've
got
sort
of
a
landing
page
where
we've
created
all
this
awesome,
end
user
content
that
can
just
be
viewed
at
any
time.
This
is
on
support.microsoft.com,
as
you
all
are
probably
familiar
with,
and
so
content
is
available
there
and
then,
on
the
right
hand,
of
this
slide
we're
just
telling
you
that
it's
also
available
in
learning
pathways
playlists.
F
F
Your
organization
to
hybrid
work,
so
you'll
see
whispers
of
this.
This
training
in
the
site
itself,
and
then
we've
got
those
support.microsoft
articles
that
I
just
pointed
out,
as
well
as
learning
pathways
playlists
for
each
of
these
sections.
So
what
I'm
going
to
do
now
is
transition
to
the
demo
part
of
this.
F
So,
what's
great,
is
you
don't
have
to
come
up
with
the
content
and
you
don't
have
to
maintain
it.
However,
you
can
customize
playlists
to
include
microsoft,
content
and
your
own
content,
so
there's
a
ton
of
flexibility
with
this
solution,
but
kind
of
back
to
the
hybrid
work
itself,
so
we've
got
three
different
playlists.
F
F
Peek
of
how
this
all
comes
together
is
all
those
articles
that
I
mentioned
that
we
wrote
we've
sort
of
written
into
this
really
digestible
format
where
it's
just
these
really
quick
articles
and
you
can
sort
of
navigate
right
in
the
tool
without
having
to
leave
sharepoint
and
so
again
we
created
all
this
content
based
on
research,
findings
and
sort
of
like
talking
to
customers
and
learning
like
where
are
the
real
pain
points,
and
we
just
sort
of
like
reverse
engineered
ourselves
into
end
user
training.
So
this
is
all
available
today.
F
E
Okay,
so
we
showed
you
two
things
today,
one
of
them
being
the
workplace
transformation
site
template
the
sharepoint
site
template,
that's
something
that
would
really
encourage
you
to
install
in
your
tenant.
We've
got
the
link
at
the
bottom
aka.ms
workplace
transformation
site
so
get
that
into
your
environment.
E
It's
free
play
around
with
it
and
and
share
it
with
your
colleagues
and
and
your
customers
if
you're
looking
for
kind
of
a
summary
of
what
we
covered
today
in
general,
including
links
to
also
the
training
that
holden
walked
through
it's
that
first
bullet.
Sorry,
I'm
starting
from
the
bottom
up
here,
but
it
was
a
blog
post
that
I
did
when
we
launched
the
site
so
aka
dot,
ms
whack
workplace
site
blog
to
get
those
links
and
learn
a
little
bit
more
or
just
kind
of
recap
what
what
we
covered
today.
E
A
Awesome
thanks
matt
thanks
holland.
This
is
really
really
cool
because,
as
we
as
we
go
back
to
this
hybrid
environment,
it's
not
just
a
matter
of
flipping
the
switch
back
on
and
going
back
to
the
office.
There's
there's
going
to
be
some
newness
that
we
have
to
get
comfortable
with
and
get
used
to.
So
this
is
really
really
cool.
Stuff,
very
awesome,
real,
exciting
gonna
be
neat
to
share
and
actually
collaborate
on
and
share
the
information
with
with
everyone
in
the
community
so
nice
job.
A
There
was
a
question
in
the
chat
that
might
be
worth
calling
on
the
video.
Is
it
a
modern
or
classic
site?
And
that
is
a
modern
site.
So
just
everybody
knows
this
is
a
modern
site.
I
think
we're
all
starting
to
figure
what
classic
is
so
it's
a
modern
world,
so
awesome
excellent
stuff.
All
right.
Next
up
is
paulo
piolor,
see
querying
and
paging
data
with
pnp
core
sdk
paulo.
Take
it
away.
B
Thank
you
david,
and
here
I'm
back
again
today.
Yes,
we
talk
about
querying
and
paging
data
with
the
pmp
core
sdk.
First
of
all,
we
will
move
to
the
demo
environment
and
I
will
show
you
how
to
work
with
pmp
qr
sdk.
When
you
need
to
query
and
page
data,
and
then
we
will
come
back
to
the
slide
deck,
to
make
a
recap
of
the
ideas
that
I
share
with
you.
So
this
is
a
very
simple
console
application,
which
is
using
the
pmp
core
sdk.
B
First
of
all,
you
need
to
know
that
whenever
you
want
to
use
the
pmp
core
sdk,
it
is
available
for
dot
net
developers
in
dot
net
core
and
net
standard,
because
it
is
a.net
standard,
2.0
library,
and
in
order
to
use
it,
you
simply
need
to
go
to
new
get,
and
I
would
say
the
easiest
way
to
get.
It
is
to
download
the
pmp.cor
dot
auth
package,
which
includes
the
pmp
core
package,
which
is
the
main
one.
In
fact,
the
core
out
gives
you
the
capability
to
have
some
ready
to
go.
B
Authentication
providers
that
you
can
use
to
speed
up
the
process
of
using
pmp
core
and
of
authenticating
against
the
target
environment
once
you've
done
that
you
have
to
configure
a
upsetting
json
file
or
you
can
even
use
code
based
configuration
here
in
my
sample.
I
simply
configure
that
I
want
to
use
a
target
site
in
a
tenant
that
I
have
and
I
want
to
use
the
credential
manager
for
the
authentication
against
that
tenant.
B
B
I
configure
the
logging
services
to
show
you
what
will
happen
under
the
cover
while
using
core
sdk,
and
then
I
register
as
one
of
the
services,
the
pmp
core
library,
with
its
own
settings,
which
map
to
this
section
in
the
upsetting
json
file,
and
then
I
simply
configure
the
core
authentication,
pnp
core
authentication
services,
to
have
the
authentication
in
place.
Once
you
have
done
that,
you
can
run
your
hosting
environment
and
you
can
start
playing
with
the
pmp
core
sdk.
So,
let's
start
having
a
look
at
the
query
model.
B
Well,
whenever
you
want
to
use
bmp
core
sdk
to
query
data,
first
of
all,
you
will
need
to
get
a
reference
to
an
object
which
is
called
pmp
context,
and
in
order
to
do
that,
you
can
get
a
context
through
a
factory.
An
object
called
pnp
context.
Factory
will
give
you
back
an
instance
of
the
pnp
context,
as
you
can
see,
with
an
asynchronous
development
model,
and
by
doing
that,
you
can,
for
example,
reference
the
name
of
a
site
that
you
configured
in
your
configuration
section.
B
So
here,
test
site
means
go
to
this
site
using
this
authentication
model,
and
by
doing
that
I
will
get
back
my
instance
of
the
pmp
context.
Once
you
have
a
pmp
context.
Instance,
in
your
hand,
you
can
query
data
with
multiple
techniques,
depending
on
what
you
want
to
do
in
your
solution,
and
here
is
the
real
meat
of
the
of
the
demo.
So,
first
of
all,
one
option
is
to
load
data
in
memory
into
the
domain
model
objects
that
we
already
provide
you
through
the
pmp
context.
B
I
want
to
remember
you
that
the
main
purpose
of
bmp
core
sdk
is
to
help
developers
creating
solutions
for
sharepoint
online
and
microsoft
teams
using
a
library
which
is
which
has
been
created
with
a
graph
first
approach.
So
whenever
you
use
bmp
or
sdk
under
the
cover,
we
will
do
our
best
to
use
the
microsoft
graph
and
the
micrograph
endpoint
to
give
you
back
your
data
or
to
provide
you
the
services
you're.
Looking
for
and
in
case
there
is
a
lack
of
functionality
in
the
micrograph
and
we
need
to
still
use
the
sharepoint
rest
apis.
B
We
fall
back
for
you
to
the
sharepoint
rest
apis
but,
as
I
said,
it
is
a
graph
first
library,
so
we
always
try
to
use
micrograph
as
much
as
we
can.
So
when
I
say
load
here,
for
example,
I'm
targeting
the
web
object
in
the
current
context,
meaning
that
I'm
going
to
load
what
I'm
requesting
for
inside
the
in-memory
web
object
that
I
have.
This
will
be
a
very
simple
way
to
load
dynamically
load
properties
into
an
already
existing
domain
model
object.
B
When
you
do
that,
you
can
then
query
the
properties
that
you
loaded
and
you
can
use
them.
Of
course,
in
this
example,
as
you
see
I'm
using
a
couple
of
lambda
expressions,
so
I
say
for
this
object:
I
want
to
load
the
title
and
the
lists
property,
which
is
actually
a
collection
of
objects.
So
what
happens
under
the
cover
is
that
we
will
make
a
query
to
fill
the
collection,
the
memory
collection
and
as
such,
once
you
have
the
memory
collection.
B
If
you
want
to
use
it,
for
example,
because
you
want
to
browse
it,
you
want
to
enumerate
all
of
the
items
you
will
simply
to
say.
Okay,
given
the
web
in
the
current
context
and
given
the
collection
of
lists
in
that
web
collection
that
I
already
loaded
here,
give
me
the
requested
list,
meaning
the
one
that
I
already
have
in
memory
and
let
me
browse
through
all
of
the
items
and
that's
what
happens
in
this
code
excerpt.
B
Why
do
we
have
the
as
requested
the
method
extension
method?
Because
using
this
technique,
you
will
guarantee
that
you
will
have
access
to
the
already
in
memory
collection
of
items,
and
I
can
run
this
application
and
show
you
what
is
going
to
happen
here.
So
I
just
pressed
f5
and
now
you
will
be
able
to
see
my
console
application
running
here
and
let
me
put
the
visual
studio
code
just
on
the
other
side.
So
here
we
have
the
application.
B
B
So
when
I
will
press
enter,
let's
see
what
will
happen
we'll
see,
we
will
have
another
request
over
the
http
channel
and
we
will
download
a
fresh
new
list
of
lists
and
libraries
in
the
current
web
and
whenever
you
query
a
collection
in
the
core
sdk
library,
we
always
make
a
fresh
query
for
you
like
when
you
are,
for
example,
using
entity
framework
or
stuff
like
that.
So
this
is
important.
If
you
want
to
have
the
memory
one
as
requested,
if
not,
you
will
always
get
fresh
new
data.
B
Okay.
Moreover,
we
do
support
language,
integrated,
query
queries,
so
you
can,
for
example,
say:
okay
context.well.lists,
and
you
want
to
make
a
query
based
on
extension,
methods
to
get
the
lists
and
libraries
ordered
by
title
and
with
an
extension
method
that
we
introduced
in
core
sdk,
which
is
not
available
out
of
the
box
in
dotnet
framework.
The
query
properties
extension
method
will
instruct
our
query
engine
to
retrieve
the
id
and
the
title
of
every
single
list
in
the
collection
of
lists.
B
Right
now
we
do
not
support
the
projection
of
anonymous
types
and
as
such,
we
decided
to
use
this
technique.
This
approach
by
using
this
query,
you
will
simply
get
back
an
expression,
three
that
you
can
enumerate
whenever
you
want
to
get
access
to
the
result
of
this
query.
So
here
we
do
not
execute
the
query.
We
just
define
the
query.
We
will
execute
the
query
when
we
will
do
the
for
each
so
the
get
enumerator
against
the
expression,
three
describing
the
query.
B
So
again,
let
me
press
enter
and
you
will
see
that
now
we
have
another
query
and
we
get
still
the
list
of
libraries
and
lists
ordered
by
title
and
we
get
the
id
and
the
title
of
all
of
those
lists
and
libraries.
But
what,
if
you
want
to
use
the
language
integrated
query?
Syntax?
Well,
you
can
do
that
as
well.
B
So
you
can
say
from
l,
for
example,
in
context,
web
dot
lists
you
will
get
all
of
the
lists:
objects
in
the
collection
of
lists,
filtering
or
partitioning
the
result
by
template
type,
and
the
constraint
is
give
me
back
just
the
document
libraries.
So
you
see
we
can
have
intellisense.
We
can
have
fully
typed
approach.
We
order
the
result
by
title
and
we
get
the
list
items
resulting
from
this
query
and
again
we
want
to
specialize
the
query
just
requesting
the
id
and
the
title
of
all
of
the
lists
with
this
query
properties.
Extension
method.
B
So
let
me
press
enter
one
more
time,
and
here
you
can
see
we
get
the
four
document
lineup
that
I
have
in
the
whole
list
of
lists
and
libraries
of
my
site,
and
I
think
this
is
really
cool,
because
you
can
reuse
exactly
the
same
developer.
Experience
that
you
use
when
you
work,
for
example,
with
entity
framework
by
targeting
sharepoint
online
and
microsoft
teams
using
the
pmp
core
sdk
and
you
have
intellisense.
You
have
fully
tabbed
approach.
B
When
you
write
a
query,
you
can
get
help
from
the
ide
of
the
visual
studio
environment
to
see
what
you're
quitting,
for
one
more
option
is
not
only
to
do
the
load
or
the
link
query,
but
also
to
the
get
of
data.
When
you
use
the
get
approach,
the
result
will
be
slightly
different
when
you
use
get
get,
will
give
you
back
a
new
instance
of
a
domain
model
object
that
you
will
be
able
to
use,
so
you
will
not
load
the
result
into
the
in-memory.
B
Already
memory
object
that
you
have
in
the
context,
but
you
will
get
a
new
instance
like,
for
example,
if
you
want
to
create
a
specific
new
instance
of
the
web,
object
that
you
want
to
keep
and
reuse
multiple
times
with
some
specific
properties
loading
into
that
object.
Well,
you
do
a
get
notice
that
we
always
have
the
asynchronous
pattern,
so
get
a
sync,
but
we
do
support
synchronous
model
as
well.
If
you
like-
and
here
we
do,
get
a
sync,
we
get
the
title.
B
We
get
the
query
properties
of
the
lists,
the
collection
of
lists,
so
we
retrieve
the
id
and
the
title
of
all
of
the
lists
in
the
web
and
we
will
get
back
a
new
web
object
with
all
of
these
properties.
Inside
of
this
new
object
again,
let
me
execute
it
and
again
we
have
the
title
and
all
of
the
lists
we
can
also
do
batching.
Actually
we
do
batching
by
default
in
our
library,
so
you
don't
need
to
think
about
batching.
B
Whenever
you
make
a
request,
it
will
be
based
on
a
batch
request
to
be
fair.
But
let's
assume
that
you
want
to
have
full
control
on
the
batch.
Well,
you
can
make
a
get
batch
async,
for
example,
or
a
load
battery
sync.
Either
way
you
can
provide
a
batch
object
that
you
want
to
use
and
what
you
want
to
query.
B
You
can
add
multiple
requests
to
the
same
batch.
So
here,
for
example,
I'm
saying
okay
give
me
a
new
web
object
in
a
new
batch
and
also
make
a
link
query
still
as
a
batch
query,
and
when
you
will
do
the
executor
sync
on
the
context,
both
of
the
queries
or
all
of
the
queries
in
the
batch
will
be
executed
and
again
you
will
be
able
to
go
through
all
of
the
items.
B
So
let
me
execute
this
one
again
and,
as
you
see
when
we
do
a
batch,
we
can
also
see
in
the
batch
result
if
the
result
is
available
or
not
so
before
executing
the
batch.
The
is
available
property
that
you
have
in
the
batch
result
is
false,
but
right
after
executing
the
query,
the
batch
result
is
available
is
true
and
you
can
get
access
to
the
results
of
the
query.
So,
just
to
recap
this
part
of
the
story.
B
When
you
query
data,
you
can
load,
you
can
get
when
you
load,
you
load
data
into
the
already
in
memory
objects.
When
you
get
you
get
new
objects
and
you
have
four
different
flavors.
Four
of
them.
You
load
the
sync
deload
batch
async,
the
load
and
the
load
batch,
which
are
not
the
which
are
the
synchronous
ones.
This
one
loads
data
into
memory.
This
one
gives
you
a
new
object
with
data
and
memory,
you
have
the
link
option
and
you
can
do
nested
and
hierarchical
queries.
B
B
This
is
my
team
channel
with
about
50
messages
inside
of
it,
and
I
get
with
the
load
all
the
messages
in
a
channel
that
I
retrieve
using
a
first
or
default
query,
and
I
make
a
query
for
that
specific
channel.
Then
I
can
simply
go
through
all
of
the
messages
notice.
Then,
when
we
do
the
load
of
the
messages
property,
we
get
back
a
collection
and
we
can
inspect
the
length
of
the
collection.
So
if
I
will
do
that
right
now,
we
can
get
back.
B
B
But,
as
you
can
see
here,
I
have
a
wait
for
each.
Why?
Because
the
messages
as
like
as
any
other
collection,
the
core
sdk
library,
is
an
is
inc,
innumerable
collection,
and
if
you
will
do
that,
wait
for
each
on
a
collection,
we
will
do
for
you,
the
paging
under
the
cover.
So
you
will
simply
need
to
go
through
all
of
the
items
without
needing
to
think
about
what
will
happen
under
the
cover,
but
under
the
cover
we
will
do
pagic
for
you.
So
look
at
this
demo.
B
I
will
press
enter
and
you
will
see
that
I'm
getting
items
in
chunks.
I
get
the
very
first
20
items
after
the
first
request,
then
in
a
request
and
20
more
items,
and
so
on
so
forth
and
from
your
point
of
view,
from
a
developer
point
of
view,
you
simply
go
through
all
of
the
items
within
a
weight
for
each
so
in
a
synchronous
for
each
and
you
simply
get
back
all
of
the
items
page
by
page
we
take
care
of
paging
for
you.
B
Of
course
you
can
do
that
also
with
the
synchronous
approach,
without
the
await,
because
this
collection
implements
also,
I
enumerable,
but
if
you
will
do
that,
we
will
make
all
of
the
requests
for
all
of
the
pages
and
once
those
requests
will
be
done,
we'll
give
you
all
the
items
at
once.
Look
at
the
difference.
Now
we
make
still
all
of
the
requests
for
all
of
the
pages,
and
once
we
are
done,
you
get
all
of
the
items
at
once.
B
It
could
look
better,
but
it
is
not
because
right
now
you
will
have
to
wait
for
all
of
the
items
to
become
available.
While
with
the
previous
approach,
you
can
consume
them
on
the
go
while
we
make
paging
for
you
last
option
is
to
do
a
manual
paging
with
skip
and
take.
If
you
do
that,
you
can
target
a
collection,
you
can
use
the
skip
and
take
extension
methods
of
link
and
by
doing
that,
you
can
easily
create
your
own
paging
model
and
which
is
what
I
do
in
this
last
demo.
B
Just
as
a
recap,
so
you
have
the
implicit
asynchronous
paging,
which
is
the
best
one.
In
my
opinion,
we
just
do
paging
for
you,
you
asynchronously
enumerate
items
and
you
get
them
back
remember.
They
are
wait
for
each.
If
you
will
not
use
the
await
for
each
but
just
a
simple
for
each.
You
will
still
get
back
all
of
the
items
with
paging,
so
not
stressing
the
network,
but
you
will
have
to
wait
for
all
of
the
items
to
become
available
before
being
able
to
use
them
and
of
course
you
also
have
the
manual
paging.
B
A
Awesome
thanks
paolo,
very,
very
cool
stuff,
lots
of
love
in
the
comments
on
the
paging,
so
it's
your
favorite
and
turns
out.
It
tends
to
be
everybody's
favorite
as
well,
so
very
cool
stuff.
All
right,
chris
kent
is
up
he's
gonna
wow
us
with
some
list
formatting
and
form
formatting
magic
where
horsing
around
is
encouraged.
Chris,
you
want
to
take
over
the
screen
share.
G
All
right
here
we
go
all
right,
I'm
chris
good,
moving
on
all
right.
So
let's
take
a
look
here,
go
to
our
classic
warrior
horses
site
and
what
I
want
to
show
you
guys
is
you
know.
Even
the
horses
have
issues
they've
got
to
track
right
so
with
weapons
on
the
battlefield,
sometimes
they're
unreliable
right,
so
they've
got
a
whole
issue
tracking
system.
They've
got
a
variety
of
ways
doing
it.
They've
got
a
mobile
app
they've
got
a
form,
they've
got
all
sorts
of
things,
but
ultimately
everything
ends
up
in
this
list
right.
G
G
These
are
facsimiles,
so
we're
kind
of
imitating
that
inside
the
form,
so
we're
going
to
have
a
way
to
kind
of
show
that
that
way,
but
there's
always
going
to
be
things
like
the
grid
view
or
the
quick
edit
or
you
know,
the
api
or
powerapps
are
a
number
of
ways
to
edit
these
things
and
change
that
experience.
So
just
keep
that
in
mind,
but
these
are
really
helpful
tricks
when
you're
just
trying
to
get
something
done
quickly,
you
don't
have
access
to
some
of
those
other
tools
and
so
on.
Okay,
so
that's
my
caveat.
G
Now,
let's
get
going
all
right,
so
let's
say
I've
got
these
weapons
issues
and
those
weapon
issues.
I've
got
a
form
here,
all
right.
Little
things
like
a
title
here
we
got
the
weapon.
They've
got
to
select
that
that's
a
look
up
field
and
some
details
about
that,
and
then
we've
got
a
couple.
Other
fields
down
here,
right
resolution
comments
and
a
log
and
serial
number.
So
this
log
field,
for
instance,
isn't
something
we
really
want
anyone
to
enter.
This
is
something
that
might
come
in.
G
You
know
automatically
when
the
item
is
created
by
one
of
these
other
systems,
whether
that's
flow,
you
know
coming
off
a
form
or
who
knows
what
right,
so
we
don't
necessarily
want
to
show
that
log
or
definitely
don't
want
to
make
that
editable.
So
we'll
come
back
to
that,
but
the
first
thing
we
see
here
is
we
got
this
share
button
which,
on
here
we've
got
a
calculated
column.
We've
taken
one
of
our
samples
and
all
we've
done
is:
we've
made
it
very
easy
to
share
individual
issues.
G
Obviously
that
doesn't
make
a
lot
of
sense
in
context
of
the
form
right,
because
there's
other
ways
to
do
that,
and
it
also
doesn't
even
show
our
nice
button.
So,
let's
get
rid
of
this,
so
the
first
thing
we
can
do
is
we
can
edit
our
columns
and
mine
are
in
sections,
because
I've
kind
of
laid
that
out
here
with
the
body
layout
which
we'll
come
back
to
and
to
get
rid
of
that.
All
I
have
to
do
is
uncheck
share
right
and
now
it's
gone
and
that's
great.
G
G
Let's
refresh
I've
had
some
weird
things
with
the
column
customization
when
you're
using
a
body
layout
there
we
go.
It's
gone
okay,
so
we
come
in
here
and
we
want
to
edit
our
columns
and
we
want
to
conditionally
show
something
or
hide
something
right.
So
let's
do
that
first,
with
serial
number.
So
serial
number
only
makes
sense
if
the
weapon
is
say
knife
hose
right.
So
we
don't
need
to
show
that
if
they've
picked,
something
like
you
know
a
glue
gun
or
whatever
it
is
right.
G
So
if
they
pick
something
else
here
like
a
rocket
launcher,
serial
number
is
not
going
to
make
any
sense
right.
They're
not
going
to
be
filling
that
out.
So
we're
going
to
want
to
take
care
of
that.
We've
got
some
form
refresh
issues
here,
but
we'll
leave
it
on
knife
hose
for
now
and
let's
edit,
that
conditional
expression.
So
we
can
take
a
look
at
that
so
with
our
serial
number,
we
edit
this
conditional
formula
and
what
we
do
is
we
place
something
here
that
has
to
evaluate
to
true
or
false.
G
Now
we
want
to
look
at
the
weapon
field,
but
that's
a
lookup.
Now
we
talked
about
lookups
on
the
last
call,
but
there's
some
weird
stuff
with
those.
So
if
I
take
a
look
at
say
just
a
header,
I'm
going
to
paste
in
a
really
quick
format.
Just
so
we
can
look
at
what
that
might
look
like
all
right.
So
we'll
just
come
in
here
we're
going
to
go.
G
Okay,
so
now,
let's
take
a
look
at
something
else
here,
very
briefly.
What
about
context
right?
So
what
if
I
were
doing
things
like?
Let's
just
go
ahead
and
close
that,
like
this
knife,
this
title
field
right
so
let's
go
column,
segment,
format,
this
column
and
we're
just
going
to
apply
a
very
basic
format
here,
let's
make
it
a
little
bigger,
so
we
can
see
it
we're
just
going
to
come
down
here
and
we're
going
to
add
elm
type
of
div,
all
right,
we're
going
to
say
text
content.
G
G
I'll
add
this
guy
click
that
guy
we'll
put
class
in
this
case
we're
going
to
say
it
is
msbg
color
just
so
we
can
see
it
magenta
all
right,
so
we're
making
a
nice
magenta
color!
Oh
so
pretty
right,
that's
absolutely
what
everyone
should
use
for
their
title
column,
all
right
and
that's,
okay
right!
I
can
do
that
and
we'll
see.
If
I
save
that-
and
I
open
up
the
form-
you
know
we'll
see
that
same
thing
right.
G
G
So
in
this
case
we're
going
to
look
at
this
share
column,
which
we
know
we
don't
have
on
the
form
and
so
we're
going
to
conditionally
set
this
class,
we're
going
to
say
equals
and
if
all
right,
so
let's
make
sure
we
keep
that
magenta.
So
we
wanted
magenta
when
it's
you
know
on
the
form.
So
what
we're
going
to
do
is
we're
going
to
say
if
and
now
length
is
just
tells
us
on
a
string
value
like
share.
G
G
Otherwise,
why
don't
we
do
ms
bg
color,
something
obvious
yellow
that
sounds
beautiful
all
right,
we'll
close
that
out,
I'm
just
going
to
preview
that
all
right,
you
know
we're
going
to
skip
that,
because
I
have
no
time-
and
I
will
show
the
other
thing,
but
the
idea
here
is
there
is
a
way
to
detect
whether
you're,
here
or
not,
by
detecting
what
values
are
here
versus.
What's
in
the
form?
Okay.
So
let's
come
back,
there
is
a
sample
for
that
that
works
and
we'll
come
back
to
that.
Okay.
G
G
Okay,
so
we'll
come
up
here.
We've
got
these
kind
of
sections
here.
We've
got
a
problem
and
a
resolution
section
and
that
has
been
configured
through
our
body
here.
So
all
we've
done
is
laid
out
sections
a
display
name
right
and
display
name
here
hold
on,
I'm
sorry
to
say:
okay,
my
son
just
lost
his
tooth.
He's
very
excited.
To
tell
me
that,
okay,
I
know
everyone,
congratulations
all
right!
So
now,
let's
move
on
here.
So
what
are
we
talking
about
we're
talking
about
the
view
only
section
here?
G
So
what
if
I
want
to
take
that
log
right,
we
talked
about
that.
We
don't
want
that
to
show
up.
So
if
I
wanted
to
say
show
that
value
somewhere,
let's
do
our
quick
little
header
format,
so
we'll
say:
elm
type
is
div
and
we're
just
going
to
say,
text
content
here
is
the
value
of
that
which
is
log
like
that
preview.
On
that,
so
now
we
can
see,
we
see
log
up
there,
that's
great
right!
So
hey
I
can
put
it
up
there.
So
if
I
save
that
and
then
I
could
remove
it
right.
G
G
So
now
it's
no
longer
part
of
the
form.
It's
no
longer
editable
it's
right
here,
so
we
could
do
something
fancy
like
first,
let's
remove
from
the
header,
because
that
looks
a
little
silly
right.
Let's
preview,
that
now,
let's
come
to
our
save
that
and
let's
come
down
to
our
footer
and
instead
I'm
going
to
paste
a
part
of
a
sample.
We
have
called
the
fake
section
footer,
I'm
just
going
to
paste
this
here,
it's
a
giant
format,
but
what
it's
doing
is
it's
imitating
a
secondary
section,
because
I've
got
an
extra
line
here.
G
I
can
remove
that
here
in
a
second
that
extra
line
is
if
in
case,
you
have
attachments
enabled
on
this
list,
which
I
do
not
so
in
this
case
I
can
just
say
zero
here
and
I'll,
remove
that
border.
Let's
preview,
that
right
so
now
what
we
have
is.
It
looks
like
a
whole
nother
section
right.
We
even
have
it
looking
like
the
field,
but
I
cannot
edit
that
it's
not
clickable,
it's
not
anything
so
to
an
end
user.
G
It
just
appears
to
be
a
read-only
field
again,
not
really
read
only,
but
if
you've
got
fields
that
are
only
being
there,
you
know
when
you
create
the
item,
whether
it's
automatically
or
not.
This
is
a
really
really
helpful
tip
and
you
can
use
this
to
make
it
all
kind
of
blend
in
and
look
nice
right,
and
you
can
even
do
things
like
if
we
I'm
just
going
to
make
four
of
those
just
kind
of
show
how
this
is
all
working.
Let's
paste
this
in
we'll
keep
our
fake
line
in
there
anyway,
all
right.
G
So
now
we
got
just
four
versions
of
that
and
the
reason
we
did
that
is
just
to
show
that
when
we
refresh
this
guy,
when
we
look
at
this,
we
get
the
same
kind
of
stacking
right
as
everything
else,
so
as
things
kind
of
shrink
or
we
get
that
same
kind
of
wrapping
behavior.
So
it
behaves
exactly
like
any
other
sections,
but
again,
not
editable.
G
So
a
couple
of
things
with
that
you
can't
use
the
column
format
of
reference
we've
shown
off
before
inside
form,
formatting.
So
if
you
are
trying
to
show
a
value
that
has
a
format
associated
with
it,
you're
going
to
have
to
copy
that
in
and
adjust
it.
So
it's
a
little
bit
of
a
pain
in
that
regard,
but
it's
still
a
really
helpful
trick
for
some
of
your
more
advanced
scenarios,
all
right,
so
I
think
that'll
pretty
much
cover
it
and
I'll
turn
it
back
over
to
you,
david.
A
All
right,
thank
you.
Chris
share
out
the
screen
here
and
wrap
up.
The
recording
for
this
will
be
available
in
24
hours
want
to
thank
all
of
our
demo
presenters.
Today,
holland,
matt
paolo
and
chris
excellent
demos
recording
will
be
available
in
24
hours.
You
can
always
follow
us
on
m36,
microsoft,
365
dev
or
at
m365
pnp.
A
A
You
can
always
see
all
of
the
different
community
calls
that
are
available
to
our
community
adaptive
cards,
graph
identity
platform
teams,
add-ins
powerapps,
sharepoint,
dev,
sig,
sharepoint
framework
sieve.
Oh
my
lots
of
them
available.
You
can
get
them
all
at
aka
dot,
ms
forge
m365
pnp!
Thank
you.
Everybody
for
today,
we'll
see
you
next
week.