►
From YouTube: Microsoft 365 PnP – General Microsoft 365 Developer SIG community call – 29th of April, 2021
Description
Microsoft 365 PnP Community - General SIG call on April 29th. Demos: 1) Delegated and application permissions in the Microsoft Identity Platform, 2) Localization check inside SharePoint Framework projects – VS Code extension to increase your productivity, and 3) Using field lookups with list formatting. Released SharePoint Framework v1.12.1 and Microsoft 365 Extensibility look book gallery. Please complete the Microsoft 365 developer community survey and register now for May trainings on Sharing-is-caring. Prepping for May releases on PnP projects. One new Teams sample delivered. The host of this call was Vesa Juvonen (Microsoft) | @vesajuvonen. 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
Welcome
everybody:
this
is
microsoft,
365
development,
why
we
click
community
call,
it
is
april
29th
and
my
name
is
cesar
eugene
and
I'm
a
program
manager
in
the
microsoft
365
platform
side
of
the
house.
Now
in
this
call
we
have
a
typical,
let's
say,
flow
of
topics,
so
I'm
going
to
do
a
quick
recap
on
the
open
source
and
projects
where
community
is
contributing.
We're
going
to
kind
of
have
a
quick
recap
on.
A
So
thank
you
philip
on
that
one
advance
and
then
we'll
have
sergey
and
chris
kent
doing
the
additional
demos
after
that
now
quick
recap
on
what
are
the
opportunities
of
contributing
in
the
community.
Of
course,
we
do
welcome
community
demos
and
community
contributors
in
general,
so
we
would
love
to
have
you
to
do
a
live
demo
of
something
what
you
built,
something
what
you
learned,
something
what
you've
done,
not
really
a
product
marketing
demos
or
selling
your
product,
but
rather
explaining
something.
A
What
you
were
able
to
figure
out
or
a
technical
architecture
is
completely
fine,
whatever
you're
demonstrating
doesn't
have
to
be
open
source.
So,
but
we,
of
course,
also
look
for
samples
to
be
covered
in
here,
because
that's
the
easiest
way
to
learn
why
or
how
something
has
been
built
for
microsoft,
teams
or
microsoft,
385
or
sharepoint
or
whatever
is
your
target
and
the
most
important
thing?
Please,
please,
please
provide
feedback,
we
need
to
know
what
works
and
what
doesn't
work.
A
So
we
as
a
microsoft
can
make
your
life
easier
and
that's
super
important
in
keep
on
pushing
for
us
helping
you
for
the
microsoft
365
platform.
We
have
a
lot
of
assets
available,
so
we
have
two
different
youtube
channels.
We
are
kind
of
having
discussions
should
we
merge
them
and
all
of
that
stuff
it's
complicated
and
we
have
a
lot
of
open
source
stuff
available
in
multiple
key
top
locations.
A
We
have
sample
galleries
available
for
microsoft,
name,
sharepoint
framework
for
power
platform,
it's
the
latest
one
which
is
really
really
cool
and
if
you're
wondering
that
oh
there's
a
huge
amount
of
different
urls
in
this,
I
can't
remember
any
of
this
akms
m365
bmp,
the
last
one
in
the
list
is
the
one.
You
were
well
aware:
you'll
find
links
to
the
microsoft
traffic
sdks,
the
open
source
projects,
the
documentation,
the
forums,
samples
and
all
of
that
stuff.
A
Bi-Weekly
community
call
as
well
where
we
then
deep
dive
one
step
at
a
time,
of
course,
on
the
insides
of
what
can
be
built
and
how
stuff
can
be
built
and
there's
really
cool
reference
solutions
being
built
right
now
by
by
numerous
community
members,
but
as
part
of
one
twelve
one.
The
key
focus
areas
was
microsoft
teams,
so
making
teams
extensibility
easier
with
sharepoint
framework
and
why
it's
easy,
which
open
framework
is
that
you
don't
need
to
worry
about
hosting,
so
hosting
is
automatic
and
over
no
operational
costs
related
on
things.
A
You
have
single
sign-on,
automatically
happening
all
of
the
azure
id
authentication.
All
of
that
is
just
magically
working,
which
is
critical
advantage
for
a
simple
development.
Now
on
other
areas
on
microsoft,
365,
we
are
now
releasing
the
new
microsoft
365
extensibility
lookbook.
So
if
you're
wondering
on
one
of
the
different
ux
extensibility
options
for
microsoft
365,
you
can
easily
go
to
this
one
url,
which
is
into
adaption.microsoft.com
portal
and
from
there.
You
can
then
look
into
what
is
the
extensibility
options
in
sharepoint?
What
is
the
extensibility
options
and
teams?
What
about
office?
A
A
now
also
just
kind
of
a
recap,
typical
things,
but
akms
team
samples,
so
we're
getting
more
and
more
samples
available
in
this
sample
gallery
all
the
time.
So,
if
you're
looking
into
starting
to
build
extensibility
for
microsoft
teams,
don't
start
from
scratch,
there's
a
lot
of
existing
samples
and
guidance
available,
and
your
samples
are
more
than
welcoming
here
as
well.
We
do
have
for
sharepoint
framework.
I
think
we
have
more
than
300
or
400
or
500
samples.
A
Now,
on
other
news
and
other
updates,
we
are
going
to
close
the
microsoft
365
developer
community
survey
this
week.
We've
been
running
this
now
for
three
weeks,
so
collecting
feedback.
We
do
have
hundreds
of
responses
on
this
one
already,
but
please
help
us
to
help
you
by
answering
on
the
survey,
if
you
have
not
yet
done
that.
So
what
we're
basically
looking
for
is
what
kind
of
guidance
you
need.
What
kind
of
things
needs?
What
works
for
you?
A
B
Thank
you,
vetsa.
Well,
friends,
as
an
open
source
and
inclusive
community,
the
microsoft,
365
patents
and
practices
invites
you
to
take
advantage
of
all
the
resources
and
even
contribute
back
to
those
resources,
but
we
do
know
that
sometimes
there's
hurdles
that
prevent
you
from
contributing
back
or
even
using
them
so
sharing
is
caring.
B
Is
an
initiative
to
provide
hands-on,
safe
space
guidance
where
we
will
walk
you
through
how
to
take
advantage
of
all
these
tools,
as
well
as
contribute
back
to
the
tools,
a
wide
variety
and
spectrum
of
sessions
from
first
time
to
contributor,
to
first
time,
presenter.
Everything
in
between
is
available.
All
free,
like
we
said,
safe
space.
None
of
the
sessions
are
recorded
so
a
great
opportunity
to
collaborate
and
ask
any
questions
that
you
may
want
to
ask.
A
lot
of
upcoming
sessions
are
available
to
register.
B
For
today
we
also
have
the
amas
coming
up
early
next
month.
The
tech
community
with
luisa
freese,
will
be
our
guest
host,
as
well
as
a
special
edition
next
week
for
the
new
power
platform
samples
we're
going
to
celebrate
that.
So
if
you
have
questions
on
how
to
contribute
to
that
sample
repository,
we're
going
to
have
a
lot
of
experts
there
available
to
answer
any
and
all
questions
completely
free
to
join
aka.ms
forward.
Slash
sharing
is
caring,
we'd
love
to
see
you
vessel
back.
A
To
you,
thank
you
david.
Thank
you.
Thank
you
really
really
awesome
initiative
and
it's
great
to
see
that
there's
additional
coordinators
on
this
one
and
it's
growing
all
the
time.
So
the
interest
is
clearly
there
and-
and
this
is
a
good
example
of
an
area
which
we
got
feedback
from
the
community-
that
we
need
to
understand
how
to
get
started.
We
need
to
understand
how
to
get
started
on
contributing
in
open
source
and
in
our
project,
and
that's
how
sharing
is
caring
was
actually
created.
So
please
keep
on
providing
that
feedback.
D
C
For
pmp
framework,
we
mainly
focus
on
bug,
fixes
and
emerging
periods
from
the
community.
We
had
one
from
januk
rigmans,
where
we
kind
of
enabled
adding
document
sets
in
large
libraries
if
using
a
very
large
document
library,
depending
on
which
apis
you
use,
you
might
get
like
an
error
or
not
so
any
fix
that
for
document
sets.
So
that's
really
good
and
there's
a
set
of
all
smaller
fixes
improvements.
That
happened.
C
I
think
the
big
thing
there
to
call
out
is
the
new
provisioning
schema,
so
the
pnp
provisioning
engine
uses
a
schema
which
allows
you,
which
defines
what
you
can
add
in
a
template.
We
are
building
a
new
one,
the
march
21
schema.
You
should
probably
rename
it
to
may
before
we
ship
it
but
yeah.
So
the
schema
is
the
there
are
links
on
the
slide.
C
Looking
at
pin
picorazik
again
bug
fixes
er
annoying
one
was,
if
you
have
special
characters
in
inside
your
adults
like
german
or
french
characters,
then
things
could
go
wrong.
That's
fixed
now,
there's
additional
upside
data
methods
from
paul
bullock
struck.
His
did
some
fixes
and
multicom
there
yeah.
I
think
that
sums
it
up
for
both
the
libraries,
excellent
social
yep.
C
C
From
last
time
we
added
the
published
pdp
company
app
commandlets,
enable
enabling
you
to
build
the
microsoft
fifa
connections,
teams
app
and
deploy
that
it
was
commandless
for
syntax
support
and
bug
fixes
in
1.6,
again
bug
fixes
and
some
additions
to
set
pnp
tenant,
which
I
don't
exactly
know
what
they
are.
But
there
are
additions
to
set
pnp
tenants
all
right.
A
E
E
We're
sorting
out
a
few
issues
with
that,
mostly
about
sort
of
how
to
scaffold
these
et
cetera,
and
it's
also
raised
a
couple
of
requests
from
from
folks
out
there
to
being
able
to
scaffold
a
project
without
the
server-side
settings.
So
essentially,
if
you
just
want
to
click,
create
the
client-side
component
with
react.
E
So
that's
something
we're
looking
into
how
we
can
do
that
specifically
when
it
when
it
comes
to
viva
connections
right,
you
don't
need
a
listing
service
site.
You
just
need
to
generate
the
manifest,
so
we're
looking
into
more
modular
approaches
to
that.
So
that's
essentially
what
happened?
The
last
few
weeks,
a
few
prs
still
in
the
discussion
state
stage,
I
would
say
so.
That's
all
from
me
thanks.
A
Excellent.
Thank
you
victor
on
that
one
great
to
see
the
usage
of
this
one
growing
as
well.
So
things
are
working.
It's
good
community,
driven
tooling,
of
course,
supplementing
the
the
official
tooling
is
the
great
way
of
doing
these
things.
Now
on
the
on
microsoft
craft.
I
saw
beth
on
the
call
as
well
so
what's
happening
in
here.
Well,.
D
Thank
you
so
for
those
of
you
who
has
not
heard
microsoft
graph
toolkit,
it's
a
collection
of
reusable
components
and
authentication
providers
for
accessing
and
working
with
the
graph.
These
components
are
fully
functional
right
out
of
the
box
and
we've
built,
and
we
have
built-in
providers
that
will
authenticate
your
users
and
fetch
data
from
the
graph
super
easy
to
use
in
your
application.
D
We've
been
trying
really
hard
to
fix
all
the
bugs
that
we
have
opened
against
our
repo
in
order
to
prepare
for
a
2.2
release.
The
preview
package
now
includes
the
msl2
provider,
the
file
and
file
list,
new
components
and,
as
well
as
the
revamped
version
of
the
logging
component,
that
supports
multi-user
login
as
part
of
the
mso2
provider.
Release
so
feel
free
to
try
all
those
things
and
give
us
feedback
and
log
more
issues
and
help
us
push
out
the
2.2
release
faster.
A
Excellent
thanks
beth
and
please
use
microsoft,
craft
toolkit.
It's
definitely
the
easiest
way
to
use
microsoft
graph,
because
you
just
put
a
control
on
your
on
on
your
implementation
or
web
page
and
voila.
It
just
magically
works.
Well,
it's
not
magic.
There's
actually
engineering
behind
of
that,
but
it's
awesome
so,
but
thank
you
beth
for
being
one
of
the
persons
making
our
life
easier
with
the
with
the
microcraft
tool
game.
Thank
you.
Listen.
A
A
In
general,
we
are
looking
into
additional
samples,
so
we
can
get
you.
We
would
love
to
have
your
microsoft
team
samples
listed
in
this
same
one
location,
because
it
helps
everybody
else
on
finding
what's
available
now
before
we
go
then
to
the
actual
demo
section
of
today,
and
let's
actually
do
a
quick
crew
photo,
and
today
I'm
gonna
actually
start
my
camtasia
recorder
for
those
who
are
interested.
You
can
enable
your
video,
I'm
gonna,
put
you
in
that
screen
and
we
have
a
50
people
limits
still
in
the
microsoft
teams.
A
A
So
we'll
get
everybody
still
a
few
more
one,
more
few
more
seats,
I
think
we're
full
and
let's
do
some
waving.
Thank
you.
Everybody.
Thank
you
for
being
part
of
this
community
and
helping
others
to
succeed.
You
are
absolutely
awesome.
So
thank
you.
Thank
you.
Thank
you
and
keep
the
feedback
coming
thanks.
Everybody,
oh,
I
can
say
clippy
on
the
picture
as
well.
Thank
you
april.
A
Thanks
everybody.
It's
really
cool,
really
really
cool
good,
and
I
will
move
that
away
from
here
now
that
is
captured
excellent.
So,
let's
actually
then
move
into
the
demo
section,
and
we
are
right
on
time.
This
is
pretty
amazing.
I
think.
Finally,
after
five
or
six
years,
we're
learning
how
to
do
this.
So,
philip,
you
are
first
in
line
to
explain
us
how
the
delegate
and
app
permissions
work
in
azure
80
awesome.
Thank
you
I'll,
go
ahead
and
take
over.
F
The
screen
sharing
excellent,
so
my
name
is
felipe
signore,
I'm
a
program
manager
at
microsoft
in
the
ida
entity,
division
and
today
I'm
going
to
talk
a
bit
about
delegated
permissions
and
application
permissions
in
the
microsoft
identity
platform.
This
is
indeed
similar
to
a
talk
I
gave
for
the
mvp
summit.
I
changed
things
around
just
in
case
you'd
already
seen
the
mvp
summit
one
and
some
things
are
a
little
bit
different,
but
generally
it's
the
same.
F
So
the
when
we
talk
about
applications
forget
the
title
of
the
session
white
application
permissions
delegated
permissions.
Let's
just
talk
about
how
applications
and
services
actually
access
data.
There
are
two
ways
we're
going
to
talk
about
today
in
which
an
application
or
a
service
I'll
use,
those
interchangeably
can
access
data
at
a
service
and
when
I
say
access
data
generally
speaking,
we're
talking
about
an
api
request,
not
necessarily
rest,
but
usually
some
form
of
api
right.
The
one
simple
way
is
direct
access,
also
known
as
service
to
service.
F
We
sometimes
refer
to
it
in
our
documentation
or
on
stack
overflow
answers
as
app
only
access-
and
this
is
it's
very
simple-
there's
a
client
application
or
service,
which
is
the
one
on
the
left,
and
then
we
have
a
resource
application
or
service,
which
is
the
one
on
the
right
and
the
client
application
is
accessing
the
the
resource
service
directly
as
itself.
There's
no
user
involved.
It's
saying,
hi,
I'm
client
I'd
like
to
do
take
this
action
at
you.
F
If
the
resource
in
this
example
would
be
microsoft
graph,
the
client
could
be
trying
to
create
a
user
or
reset
a
password
or
download
a
file,
and
this
is
so
that's
one
form
of
access.
Direct
access,
pretty
straightforward.
The
other
form
of
access
is
access
on
behalf
of
a
user
right,
so
we
have
a
user
involved.
F
We
also
have
an
application
involved
and
the
access
that
the
application
is
taking
the
client
application
is
taking
on
the
resource
is
done
on
behalf
of
that
user,
and
so,
if
you
notice
the
little
pentagons
that
I
have
there,
that
represent
the
token
the
one
for
direct
access
is
identifying
the
application.
As
the
subject
of
the
token,
whereas
the
one
on
the
right,
it's
identifying
the
user
as
the
subject
of
the
token
and
that's
an
important
that
will
be
an
important
thing
in
the
next
few
slides.
F
When
we're
talking
about
access
on
behalf
of
a
user,
we
often
just
to
decode
some
of
the
terms
we
use.
We
sometimes
refer
to
this
as
delegated
access.
Sometimes
we
call
it
hapless
user
access
very.
In
some
cases,
I've
heard
in
constrained
impersonation
or
impersonation
access,
but
all
of
these
are
access
on
behalf
of
a
user.
F
One
important
thing
to
call
out
here
is
that
on
the
identity
platform,
this
is
always
on
behalf
of
a
signed
in
user,
so
a
user
that
at
some
point
in
time,
actually
signed
into
the
application
as
opposed
to
arbitrary
impersonation
of
any
user
who
didn't
actually
sign
it
right.
So
these
are
the
two
forms
of
access
that
we're
going
to
be
talking
about
the
the
what
I'm
talking
about
here
I
mentioned
often
the
resource
or
the
api.
F
You
can,
of
course,
always
imagine
think
of
microsoft,
graph
as
a
good
example
of
an
api,
but
there's
also
the
azure
management
apis
or
apis
that
you,
you
develop,
I'm
laughing
at
the
comments,
direct
access,
so
when
we
have
direct
access
again,
just
the
client
accessing
the
resource,
the
resource
needs
to
make
a
decision
and
for
in
terms
of
authorization.
It's
asking
a
very
simple
question:
is
the
app
authorized
to
do
this
a
little
bit?
More
generally
is
the
subject
of
the
token
authorized
to
take
this
action
right
and
on
the
identity
platform.
F
We
offer
a
permit
a
type
of
permission,
permissions
for
direct
access,
and
we
call
them
app
roles
and
when
it
turns
out
that
app
roles
are
granted
to
other
applications,
we
just
change
the
name
and
we
call
them
application
permissions,
but
app
roles
or
application.
Permissions
for
this
conversation
are
interchangeable
and
they're
just
a
way
of
expressing
authorization
that
is
used
for
direct
access
now.
One
very
important
thing
to
keep
in
mind
in
particular
for
direct
access
is
that
there
are
actually
many
ways
in
which
an
application
can
be
given.
F
Authorization
for
direct
access,
application,
permissions
and
app
roles
is
just
one
of
those
ways.
It's
a
very
common
way
for
reasons
we'll
see
in
a
bit,
but
many
other
ways
are
possible.
For
example,
if
you
think,
if
you're
familiar
with
how
azure
does
authorization
for
direct
access
for
applications,
there's
no
app
role,
there's
an
azure
rbac
role
assignment
and
it's
granted
to
the
service
principal
that
represents
the
application
in
that
tenant.
But
there's
no
consent
for
an
app-only
permission
like
there
is
from
microsoft
graph.
F
So
likewise,
you
can
assign
a
directory
role
to
an
application
or
you
can
make
a
service
principal
owner
of
a
group
or
of
another
service
principal,
and
that
is
giving
it
authorization
to
do
things
or
make
it
a
member
of
a
group,
etc.
So
always
keep
in
mind
that
there
are
many
different
ways
in
which
an
application
can
be
given
authorization
and
if
you're,
building
an
api
or
others
have
built
apis.
F
They
could
also
just
have
a
list
internally.
That
says:
hey
these
applications
are
allowed
to
take
these
actions,
and
that
would
be
another
form
of
authorization,
but
all
of
that
is
for
direct
access
when
it
comes
to
access
on
behalf
of
a
user.
Authorization
is
a
little
bit
different,
but
it's
when
you
look
at
it.
It's
actually
the
same
thing.
There's
just
one
extra
question
right.
The
first
question
is
very
similar
to
the
previous
one
is:
is
the
user
authorized
to
take
this
action
in
the
previous
case
for
direct
access?
It
was.
F
F
That
second
question
right:
is
the
app
authorized
to
do
this
on
behalf
of
the
user?
It's
delegated
permissions
have
no
say
whatsoever
in
whether
the
user
is
allowed
to
take
an
action.
Delegated
permissions
are
only
for
expressing
whether
an
app
is
allowed
to
do
something
on
behalf
of
the
user
right.
So
it's
always
important
to
keep
in
mind
that
the
user
needs
to
be
authorized
and
the
app
needs
to
be
allowed
to
do
what
it's
trying
to
do
on
behalf
of
the
user.
There
are
lots
of
ways
to
look
at
this.
F
One
way
to
explain
it
is
sort
of
how
I've
done
it
now.
Another
fairly
common
way
to
explain
it
is
to
say
you
can
imagine
everything
the
user
can
do.
You
can
email.
So
imagine
everything
the
app
has
been
allowed
to
do
on
behalf
of
the
user
and
what
the
app
can
actually
do
is
the
intersection
right.
It's
the
things
the
user
can
do
and
the
app
has
been
allowed
to
do
on
behalf
of
the
user,
so
just
to
walk
through
an
example.
Real
quick
of
this
here,
I'm
using
microsoft
graph
as
the
example
api.
F
But
again
you
can
imagine
this
being
a
different
api.
In
the
first
case,
we're
trying
to
list
users
we're
doing
a
get
for
users
and,
as
always,
the
first
question,
because
these
are
all
access
on
behalf
of
the
user
is.
Is
the
user
allowed
to
do
this?
And
if
the
case
of
a
guest
user,
which
is
this
row,
it
happens
to
be
a
user
signed
in
as
a
guest
user?
F
Well,
the
answer
is
no,
because
guest
users
by
default
are
not
allowed
to
list
all
users,
and
so
we
would
answer
no
immediately
and
the
resource
in
this
case,
microsoft
graph
would
would
just
stop
there.
It
wouldn't
even
ask
the
second
question
and
say:
no
user
is
not
allowed,
but
I
won't
even
check
if
the
app
now
in
this
case
it
turns
out
that
the
app
is
allowed
to
take
this
action
on
behalf
of
the
user,
but
that's
irrelevant
because
the
user
themselves
can't
do
it
right.
F
So
the
result
for
this
request
would
actually
be
an
authorization
failure.
The
second
example
the
app
the
user
is
a
global
administrator,
but
the
user,
the
and
the
app
is
trying
to
delete
a
user
right
now.
So
again,
the
answer
to
the
first
question:
is
the
user
allowed
to
do
this?
Well,
yep
global
admins
are
allowed
to
delete
users
unless
that
user
happened
to
be
the
global
admin
themselves.
But
let's
assume
that
wasn't
the
case.
F
The
second
question,
though,
is,
can
the
app
do
it
on
behalf
of
the
user
and
in
this
example,
because
the
app
had
only
been
granted
the
delegated
permission
directory
read
all
which
does
not
include
the
permission
to
delete
users.
The
answer
here
again
is
well:
no,
you
can't
do
it,
the
user
is
allowed,
but
the
app
is
not,
and
that
middle
row
is
the
reason
why
delegated
permissions
exist.
F
F
So
now
we
haven't
talked
so
far
about
like
okay,
great.
We
have
direct
access
access
on
behalf
of
a
user
for
direct
access.
We
have
application
permissions
for
access
on
behalf
of
the
user.
We
have
delegated
permissions.
How
does
an
application
request
them
and
how
does
it
get?
How
do
they
get
granted?
F
So
one
way
app
permissions
can
be
requested
by
an
application
or
by
a
developer,
who
wrote
the
code
so
that
the
application
would
do.
It
is
dream
sign-in
and
that's
a
very
common
approach.
So
if
there's
now
as
soon
as
we
say
during
sign-in,
that
means
there's
a
user
and
so
we're
usually
talking
about
delegated
access
and
delegated
permissions.
F
So
an
application
can
during
sign
in
can
dynamically
request
a
list
of
delegated
permissions
and
that's
just
part
of
the
protocol
open
eddy
connect.
In
this
case,
we
use
the
scope
parameter
where
you
can
identify
the
resource.
In
this
example,
the
resource
would
be
widgets.example.com
and
the
delegated
permission
at
that
resource
right.
So
every
resource
registration,
the
app
registration
for
an
api
or
a
resource
can
define
its
list
of
delegated
permissions
and
can
define
its
list
of
apples.
So
that's
true
for
microsoft,
graph.
F
There
is
an
app
registration
for
microsoft,
graph
that
has
a
list
of
all
the
graph
delegated
permissions
and
all
the
graph
app
roles
for
application
permissions,
and
it's
true
of
you-
can
do
that
for
your
own
apis.
In
this
example,
the
permission
is
read
if
permissions
that
were
requested
dynamically
are
granted
they
get
granted.
In
addition
to
anything
that
was
granted
previously,
we
call
this
incremental
consent.
This
is
useful
so
that
users
are
only
asked
for
what
they
need
at
the
point
in
time
in
which
the
application
needs
it
right.
F
So
basic
permissions
for
sign
in,
as
you
start
moving
forward.
Yes,
new
features
are
being
used.
Then,
at
that
point
in
time
the
application
requests
the
additional
permissions.
It
helps
for
least
privilege,
and
it
helps
ensure
some
level
of
interaction
with
the
user
before
they
have
to
go.
Find
the
person
to
to
grant
the
permissions
this
waiver
of
requesting
permission
only
works
for
delegated
permissions.
F
Then
we
have
the
statically
configured
permission
list
so
this
for
those
familiar
in
the
azure
portal.
Under
app
registrations,
api
permissions,
you
can
choose
a
list
of
application,
permissions
and
delegated
permissions,
and
these
are
the
permissions
that
will
be
asked
for
if
you,
if,
if
the
keyword
dot
default
is
used
instead
of
a
permission
name
right.
So
in
this
example
here
the
request
is
for
microsoft
graph.
So
the
the
app
is
probably
going
to
make
a
request,
an
access
on
behalf
of
the
signed
in
user
to
graph,
for
whatever
is
configured
now
granting
permissions.
F
F
Basic
permissions
for
signing
microsoft
will
step
in
and
block
user
consent,
even
if
it
would
otherwise
be
allowed
for
apps
that
we
consider
to
be
either
risky,
or
at
least
not
trustworthy
enough.
So
there
are
some
cases
depending
on
algorithms
working
behind
the
scenes
that
will
determine
hey
this.
This
situation
is
not
something
doesn't
look
right,
so
we're
not
going
to
lose
your
consent
when
a
user
is
not
allowed
to
consent
for
themselves.
It's
not
the
end
of
the
world.
F
They
can
always
go
request
for
admin,
review
and
approval,
and
there's
a
feature
for
that.
You
turn
it
on.
If
the
user
is
not
allowed
to
consent,
they
can
click,
request,
admin,
approval
and
provide
the
justification,
and
then
the
workflow
starts
there,
and
so
that
takes
us
to
admin
consent,
which
is
a
very
common
way
in
which
permissions
are
granted
to
applications
through
admin.
Consent
is,
as
the
name
implies,
something
that
a
privileged
operation
only
can
only
be
done
by
an
admin
or
a
sufficiently
privileged
user.
F
It
applies
tenant
wide
so
when
we're
consenting,
for
example,
for
delegated
permissions
they're
being
granted
on
behalf
of
all
users-
and
it
also
works
now
for
application
permissions
admin
consent
can
be
triggered
by
the
application
itself.
It
can
send
the
user
off
to
the
url.
It
can
be
done
from
the
azure
portal
or
sometimes
customers
themselves
will
construct
the
url
and
go
there
to
grant
admin
consent.
We
could
support
both
dynamic
and
incremental.
F
What
we
mentioned
dynamic
and
static
to
modes
I
mentioned
earlier,
and
one
thing
to
always
keep
in
mind
is
a
customer
can
always
also
manually
grant
access
you
can
you
can
write
a
powershell
script
or
call
graph
directly
to
create
service
principles,
create
app
registrations,
create
app
role,
assignments,
so
grant
application
permissions
or
create
delegated
permission
grants
so
grant
delegated
permissions
now?
Those
of
course
are
extremely
privileged
operations,
especially
if
the
application
doing
this,
the
automation
granting
permissions
is
not
constrained
in
what
permissions
it
can
grant.
F
D
A
So-
and
this
is
a
great
great
great
stuff
to
get
recorded
and
as
a
video
for
youtube
as
well.
So
thank
you.
Thank
you,
phillip.
On
that
one,
a
lot
of
people
clearly
happy
on
the
on
the
clarification
so
really
really
great
stuff.
I
think
it's.
It's
super
important
that
we
demystify
the
identity
model
because
people
are,
I
don't
think
people
are
educated
enough
or
maybe
it's
too
complicatedly
explained,
but
this
was
a
good
clarification.
How
things
are
actually
working
great
cool,
let's
actually
move
into
the
next
demo.
It
says
sergey!
A
G
Yeah,
thank
you.
Awesome,
hello,
everyone.
My
name
is
sergey
sergef,
I'm
from
belarus,
minsk,
I'm
sharepoint
and
microsoft,
365,
developer
and
consultant
love
development,
github
and
all
this
stuff
how
to
make
sure
that
all
of
your
localization
labels
across
sharepoint
framework
solution
are
consistent.
So
that's
something
we're
going
to
see
in
this
demo.
Let's
get
started
right
away
and.
D
G
I
have
a
very
simple
and
very
basic
as
perfect
web
part,
which
simply
outputs
a
localization
label.
So
if
you
go
and
see
the
code,
then
in
the
hello
world
component
I
have
a
strings
dot
greeting
which
shows
me
this
this
nice
label.
Here
now,
let's
say
that
we
need
to
change
something
in
our
localization
definition
file.
For
example.
G
G
Greeting
to
just
my
label,
then
again,
I
should
save:
let's
go
ahead
and
see
what
will
happen
next
and
palm.
We
don't
have
our
label
still
so
what's
the
problem,
the
problem
is
that
actually
I'm
running
on
decay,
local.
That
is
why
I
also
have
to
fix
it
here
so
in
two
files.
Finally,
if
you
wait
for
a
while,
then
our
label
is
available.
G
So
basically
you
see
the
problem.
I
changed
something
in
our:
let's
call
it
primary
resource
definition
file,
but
I
haven't
changed
individual
resource
files
and
from
from
build
standpoint,
everything
is
decay.
You
don't
have
any
build
errors,
you
don't
have
any
exceptions
or
problems,
but
actually
on
the
user
interface,
we
were
missing
a
label.
G
That
is
why,
every
time
you
modify
something
in
your
primary
resource
definition
file,
you
should
carefully
copy
all
changes
across
all
your
individual
resource
files
and
while
here
it's
not
a
big
deal
but
in
a
bigger
solution,
it
might
be
a
real
problem,
for
example,
check
out
here.
That's
pnp,
modern
search
solution,
and
here
we
have
a
lot
of
different
labels,
including
a
few
nested
levels.
G
G
G
Check
extension,
basically
I
have
it
here,
but
disabled,
let's
enable,
and
now
let's
see
what
will
happen.
If
I
do
the
same,
let's
say
if
I
want
to
rename
it
back
to
just
greeting
like
this
and
then
click
save
then
immediately
visual
studio
code
reports
me
two
errors
in
this
file.
So
if
I
open,
then
we
have
this
error
and,
if
you
hover
over,
then
it
says
that
this
object
should
have
only
known
properties,
and
this
my
label
does
not
exist
in
type
hello
world,
the
part
strings.
G
So
it
means
that
I
should
to
make
it
work.
I
should
rename
this
then
save
so
now
the
problem
disappeared,
and
I
should
do
the
same
here
and
now
finally,
and
also
I
think,
should
should
be
renamed
here
and
finally,
I
have
my
build
fixed
and
still
I
have
my
localization
label
here
and
it
works
for
all
solutions
if
we
change
anything
for
pnt,
modern
search,
if
you
rename
it
like
this,
for
example,
then
again
immediately,
we
have
a
clear
indication
that
there
are
some
problems
with
our
resource.
D
G
So
if
we
scroll
down
this,
then
you
see
that
this
again,
this
property
is,
does
not
exist
in
type,
and
it
also
suggests
you
the
right
even
right
name
for
this
property,
but
if
I
rename
it
back
and
then
and
then
save,
then
all
problems
disappeared.
So
this
is
how
this
extension
works.
It
helps
you
to
easily
identify
all
potential
problems
with
all
of
your
resource,
localization
files,
so
how
it
works
under
the
hood
under
the
hood.
It
goes
to
your
configuration
file
and
then
it
looks
through
all
of
the
localization
resource
folders.
G
Then
in
memory
it
creates
a
typescript
project
for
every
localization
resource
folder,
where
every
file
inside
those
folder
is
a
typescript
source
file.
So
actually
it
renames
again.
It
happens
in
memory.
It
renames
all
javascript
to
script
so
yeah
like
this,
then
it
goes
to
definition,
file
and
using
typescript
syntax
three.
It
extracts
the
interface
name
and
then
again
in
memory.
It
adds
a
type
definition
for
this
function.
So
now
now
our
now
our
resource
file
is
strongly
typed,
and
if
we
have
any
inconsistency,
then
the
error
will
be
reported
immediately.
G
So
it
happens
in
the
extension
in
memory
using
virtual
file
system
typescript
virtual
file
system,
so
it
compiles
typescript
project
for
every
localization
resource
file,
and
if
there
are
any
errors,
then
these
errors
will
be
mapped
to
your
visual
studio
code
instance
using
visual
studio
code
diagnostic
api.
So
this
is
how
this
stuff
works
under
the
hood.
So
now
I'm
going
to
revert
back
just
a
javascript
file.
G
No
please,
but
as
perfect
check.
Local
is
not
only
a
vs
code
extension,
but
that's
only
a
node.js
module
and
node.js
module
gives
you
an
option
to
to
implement
such
kind
of
checks
inside
your
build
pipeline,
for
example,
here
you
can
create
a
new
gulp
task
which
performs
validation
check
on
all
of
your
resource
files,
so
that
all
of
your
localization
files
are
consistent
with
your
primary
resource
definitions.
G
So
if
you
check
it
here,
then
that's
the
model
called
s
perfix
check
local.
Then
we
have
one
function
check
for
errors,
and
this
function
accepts
path,
root,
path
to
root.
Folder
of
your
s,
perfect
project
and
optionally.
You
can
say
whether
you
want
to
print
errors
or
not,
and
then,
as
a
result,
we
have
an
array
of
diagnostic
data.
This
array
contains
all
found
errors
and
metadata
about
errors.
G
If
this
array
is
empty,
then
everything
is
good,
so
we
are
done
without
error
message
and
if
not,
then
we
report
error
messages
back
like
this,
so,
for
example,
if
I
let's
say
let's
say
I
have
it-
I
have
it
renamed
here
to
something
like
this,
then
save,
and
if
I
try
try
to
try
to
run
production
build,
then
the
build
will
fail,
simply
because
I
have
now
having
consistency
between
my
localization
resource
files.
So
this
task
earth,
because
we
found
errors
in
localization
files
and
also
in
the
output.
G
G
So
you
can.
You
can
use
this
gulp
additional
gulp
task,
for
example,
in
your
continuous
integration
process,
to
have
additional
verification
that
all
your
localization
resource
files
are
in
sync,
with
your
master
or
primary
localization
resource
definition
file,
so
basically
yeah.
This
is
it
from
my
site.
Thank
you
very
much
for
this
opportunity.
A
Excellent.
Thank
you,
sir.
Okay.
Now
don't
don't
put
the
visa
studio
code
away
just
a
few
few
pointers
just
to
call
out
as
as
we're
chatting
a
few
questions,
because
we
have
a
few
minutes
so,
just
out
of
curiosity
you're,
probably
using
this
in
your
day-to-day
work
right,
so
you're,
building
and-
and
this
is
it
was
that
where
the
whole
need
came
from
so
just
our
curiosity.
What
was
the
original
reason
why
you
created
the
extension.
A
G
Actually,
it's
not
that
hard,
because
there's
just
a
few
node.js
modules
which
helps
which
help
to
create
this
in-memory
virtual
file
system,
typescript
project
and
then
the
typescript
api
provides
a
way
to
to
compile
a
project
to
add
files
and
then
to
to
see
the
problems
in
the
title
project:
cool.
Of
course,.
A
Yeah
it's
just
out
of
career,
so
they
have
it's
it's.
It's
always
interesting
to
know
the
how
hard
it
is
to
build
these
kind
of
things,
but
it's
super
useful
as
it
is
for
sure,
and
thank
you
sergey
for
sharing
this
one.
So
let's
then
jump
to,
is
it
fair
to
say
chris
no
code
or
a
low
code,
or
is
it
super
code
or
horse
code,
or
how
do
you
define
what
I
was
saying
soon?
H
All
right,
hey
everybody!
I'm
chris!
Let's
talk
about
some
formatting,
so
I
want
to
talk
about
something.
That's
always
been
a
little
bit
tricky
right.
It's
always
lived
in
kind
of
its
own
space
and
that's
lookups.
So
it's
a
field
type
right.
These
are
lookups
where
you
say:
hey,
go,
get
the
value
or
values
from
another
list
on
my
site
right
and
bring
that
value
in
and
whenever
I
look
at.
My
current
list
also
bring
those
values
in
and
there
we
go
right
and
you
can
have
one
you
can
have
many.
H
You
can
do
all
sorts
of
stuff.
Now
they
live
in
their
own
little
world
partially,
because
right,
there's
a
serious
lack
of
support
right
for
the
types
of
things
you
can
do
with
lookups
right,
so
really
you're.
Just
looking
at
you
know,
text
number
date
and
time,
and
although
it's
listed
as
unsupported,
I'm
telling
you
you
could
do
calculated
all
right
and
then,
of
course,
all
of
these
other
ones.
You
might
want
to
do
right.
H
Sorry,
that's
not
going
to
work
out,
but
that's
okay,
because
this
still
gives
us
a
lot
a
lot
of
power,
but
it
does
change
how
formatting
is
applied
so
just
like
it
lives
in
its
own
world
with
column
type
when
it
comes
to
formatting.
It
is
definitely
unique
and
present
some
unique
challenges
if
you're
not
familiar
with
it
or
if
you've
just
been
using
other
every
other
field
type
except
for
lookups.
H
H
In
case
you
didn't
want
to
just
type
in
dot
id
or
dot
value
type
in
the
full
lookup
id
all
right.
You
look
up
the
lookup
id
it's
going
to
give
you
that
list
item
id
in
the
referencing
list
and
then
your
lookup
value
is
just
going
to
be
whatever
the
actual
value
is.
So
if
it's
just
text,
it's
just
going
to
be
text.
But
if
it's
like
you
know
some
other
field,
you
can
get
the
subprops
okay,
all
right,
but
there
is
no
url
property.
H
So
the
moment
you
apply
format
you're
going
to
lose
that
link
back
we'll
address
that
in
just
a
minute
and
then
multi
lookups
to
process
those
you
can
use
a
for
each,
which
is
a
bit
of
advanced
topic.
But
again
we'll
take
a
look
at
that,
but
you
can't
do
the
same
for
additional
fields
or
sometimes
called
projected
fields,
because
microsoft
says
we're
super
helpful
and
join
them
for
you
with
a
semicolon
in
space.
So
let's
take
a
look:
how
do
we
handle
these
unique
situations?
H
H
You
know
where
we
added
this
whole
conditional
flow
and
we
added
a
nice
little
hover
screen
and
if
you're
interested
in
that,
there's
a
whole
video
that
I'll
link
to
that
at
the
end.
But
that's
not
we're
going
to
talk
about
today,
we're
going
to
talk
about
lookups,
so
I'm
going
to
create
a
look
up
to
my
agents
list.
All
right,
so
we've
got
battle
plans.
The
warrior
horses
are
always
plotting
out
their
battles.
H
H
I
gotta
go
traditional
classic
column
settings
here
right
in
this
case
we're
gonna
call
it
agent
and
we're
gonna
say
it
is
a
lookup,
so
give
it
a
chance
to
do
a
full
post
back,
miss
those
days
right
and
then
we're
going
to
choose
our
agents
list
here
and
in
this
case
we're
just
going
to
choose
the
title
column,
which
is
the
name
of
our
our
guide.
But
now
we
want
to
add
an
additional
field
as
well
like
whenever
we
select.
H
You
know
from
the
title:
let's
also
bring
over
say
that
phone
number
column
right,
because
that
phone
number's
got
a
nice
format
applied
to
it.
Let's
see
what
happens
so
we're
gonna
hit.
Okay,
we'll
take
a
look
now.
We've
got
two
new
columns
right,
nothing
in
them.
We
just
want
to
edit
that
in
grid
view
for
a
second,
so
we
can
add
a
couple
of
agents
all
right.
We'll
pick,
I
don't
know
our
finished
friend.
That
sounds
exciting
right
down
here.
H
H
Let's
come
back
to
this
in
just
a
moment,
but
let's
take
a
look
here
so
by
default,
the
kind
of
out-of-the-box
experience
is,
you
know,
gives
you
a
nice
link
when
you
click
that
it's
going
to
come
over
here
and
it's
going
to
open
up
and
it's
going
to
show
all
the
column
formats
on
your
nice
form.
You've
configured
right
with
your
header
and
your
footer
and
that's
great,
you
know-
and
that's
awesome,
but
if
you
open
this
item
first
thing,
you're
going
to
notice
is
hey.
I've
got
the
same
thing
here.
H
Sadly,
though,
if
you
click
this,
oh
no.
Why
microsoft?
Why
right
now
you've
got
a
classic
style
dialogue
right
with
a
ribbon,
and
now
you
cry
right:
none
of
your
formats
are
showing
up.
It
looks
very
strange.
You're
confused
your
users
are
confused
where's
my
x
button.
I
don't
know
what
to
do
right.
So,
let's
fix
that.
So
what
we're
going
to
do
is
we're
going
to
apply
a
format
here.
H
Column
settings
we're
going
to
format
this
column
in
this
case
we're
going
to
go
to
advanced
mode,
so
we
can
type
our
own
stuff
all
right.
Let's
make
this
slightly
bigger
and
we're
just
going
to
start
in
here
right,
so
we're
going
to
say
elm
type
in
this
case
we're
going
to
make
it
a
link,
because
we
want
to
recreate
that
link
or
say
our
text.
Content
is
just
going
to
be.
Our
current
field.
Right
sounds
great.
So,
let's
just
preview
that
we
haven't
provided
any
kind
of
url
anything
but
object
object!
H
That's
the
thing
I
mentioned
earlier
right.
So
here's
what
we
can
do.
Instead,
we
say
current
field
dot
that
little
period
there
look
up
value
with
a
capital
v
and
we
preview
that
ooh
there
it
is.
We
still
don't
have
our
link.
So
let's
add
that
in
right.
So
to
add
a
link
in
you
add
some
additional
attributes.
So
in
this
case
we're
going
to
say
attributes
I
want
to
say
bam
and
we're
going
to
say
thanks
for
being
helpful,
I'm
going
to
say
href
all
right
and
here
we're
going
to
build
it
right.
H
Unfortunately,
we
don't
have
any
information
about
that
list,
so
we're
just
going
to
type
it
ourselves
right,
we're
going
to
say,
slash
list,
slash
allies,
because
that's
the
actual
name
of
the
list
and
we're
going
to
say,
dis,
form,
dot,
aspx,
then
we're
going
to
rd
equals
right
and
there
we
go
and
then
we're
going
to
say,
plus-
and
in
this
case
my
at
current
field,
just
like
before
adobe
period,
lookup
id
with
a
capital-
I
lowercase
d,
all
right.
So,
let's
preview
that
now
we
get
this
nice
link
before.
H
B
H
All
right
just
so,
we
open
a
new
window.
Let's
save
that
so
now,
when
we
click
on
that
guy,
we
get
that
same
behavior.
We
had
before
here's
our
finished
friend
right,
but
if
we
open
up
the
form
and
click
it
there's
our
finished
friend
there
we
go
so
that's
pretty
exciting,
but
that's
kind
of
how
we
start
to
work
with
things
the
beginning.
Now,
what
if
I
wanted
to
take
my
phone
number
field
right
and
I
want
to
take
that
same
format.
I
had
before
well
good
news.
H
D
H
That
I'm
going
to
head
back
over
here
and
right
on
here,
oh
I'll,
right
click
and
left
click,
impressive,
I'm
going
to
format
this
column
advanced
mode
right,
we're
going
to
paste
it
in
there
and
preview
it
and
you'll
see
wow.
We.
It
just
works
right,
so
pretty
awesome,
so
you
can
copy
those
things
all
around.
H
But
what
if
we
want
to
do
some
other
things
right?
So
that's
cool.
We
fixed
one
little
thing,
but
let's
go
in
here
to
our
list
settings
and
let's
swap
things
around
a
little
bit,
so
we're
gonna
go
back
down
here.
We're
gonna
go
to
agent
and
in
this
case
what,
if
we
said,
you
know
what
I
want
from
I'll
actually
want
to
put
the
phone
number
in
the
main
title
right.
I
don't
know
why
you
do
that.
But
let's
say
you
don't
want
to
take
away
that
projected
call
right.
H
So
we're
going
to
hit
ok,
go
back
to
our
exciting
battle
plans
list,
and
now
we
get
this
we're
still
our
format
right,
it's
been
applied,
so
it's
got
that
link
and
everything.
But
what
if
we
said?
Okay
forget
the
link.
I
want
that
same
phone
number
format,
so
I've
still
got
it
on
my
clipboard,
so
I'm
gonna
paste
it
in
there
all
right-
let's
scroll
this
over,
so
we
can
see
it
now,
let's
preview,
that
it
broke
entirely
right
because
it's
assuming
current
field,
because
this
is
now
a
lookup
value.
H
We
have
to
have
all
that
now.
If
you
start
looking
through
here,
like
oh
gosh,
there's
all
these
calculations
for
all
this
junk.
Well,
good
news!
Now,
I'm
not
using
the
awesome,
sp
formatter
right
now
for
the
sample,
I'm
just
using
the
out
of
the
box
right,
but
because
this
is
also
a
monaco
editor,
I
can
hit
control
f
inside
this
box.
Ooh
hidden
secret
features
right
next
to
current
field,
and
if
I
hit
this
little
bit
of
care
right
here
now
I
get
a
replacement.
H
So
I
can
say
at
current
field,
dot
look
up
value
all
right.
If
I
hit
this
guy,
it's
going
to
place
all
of
those
and
when
I
preview
that
bam,
we
just
fixed
it
right.
So
that's
awesome
right
there.
So
now
we
do
a
lot
with
that.
Now,
let's
go
a
little
bit
crazier!
Even
right,
so
I'm
not
going
to
save
that
we'll
just
go
back
to
our
list
settings
now
what
if
we
decided
to
be
even
fancier
right,
we
take
our
agent's
column.
H
H
Now,
we've
got
this
and
again
I
didn't
save
that
of
the
format.
So
it's
got
the
link
and
that
seems
to
be
okay
right
because
we've
got
one.
But
what
if
I
decided
you
know,
our
finished
friend
needs
a
buddy
all
right,
so
we
come
in
here.
Finish
friend
also
needs
to
hang
out
with
his
russian
comrade
and
let's
say
his
dutch
roommate
all
right,
so
we're
just
gonna
click
off
to
save
that
and
that's
great.
But
oh,
we
got
problems
already
right.
H
So
now
it
looks
weird
and
if
you
actually
could
see
it's
going
to
concatenate
all
of
that
together,
it's
a
mess.
None
of
that
works
anymore
right.
So,
let's
go
to
column,
settings
and
format
this
column.
So,
instead
of
all
of
this,
we
actually
need
to
do
this
a
little
bit
differently
right.
So
we
need
to
do
what's
called
the
forage
field,
I'm
just
going
to
copy
this
and
then
we'll
take
a
look
at
it.
H
I'm
going
to
paste
it
in
here
all
this
is
available
as
a
sample
which
I
will
link
to
at
the
end.
So
the
idea
is,
we
have
kind
of
a
parent
element
and
then
we
in
in
a
child
element.
You
can't
do
it
at
the
root
element
within
a
child.
You
can
set
up
basically
template
element
right,
so
everything
in
this
sub
element,
this
child
is
going
to
be
repeated
for
every
item.
That
comes
back
and
we
do
that
by
saying
four
each.
When
we
put
this
on
here,
we
have
to
specify
an
eye
iterator.
H
We
can
name
this
whatever
you
want.
I
just
wanted
this
one.
It
item
iterator,
I'm
not
sure,
what's
happened
with
my
accent
there
that's
good
times,
though
all
right
so,
but
the
idea
here
is
now
I
can
access
like
it
was
another
column,
but
I
do
that
same
thing
to
get
that
lookup
value
right.
So
when
I
apply
this,
you
know
I've
not
done
a
link
or
anything,
but
I
get
this
nice.
You
know
list
here
and
that's
okay,
so
that
works
right.
H
H
This
column
go
to
advanced
mode,
let's
scroll
over,
so
we
can
see
it
and
I'm
going
to
paste
that
in
preview
that
it
totally
busts
here
because
again,
microsoft's
tried
to
help
us
out
and
if
we
take
this
away
right,
so
let's
cancel
so
we
can
see
it,
it's
actually
taking
every
value
and
it's
just
putting
a
semicolon
space,
not
particularly
helpful
to
us
right.
So
what
if
we
wanted
to
do
something
with
that?
H
H
So
this
sample
supports,
I
think,
up
to
five
particular
values,
because
you
have
to
have
one
for
each
of
these.
So
this
is
this
makes
you
cry
a
little
bit,
but
that's
okay!
What?
If
what?
If
we
want
to
do
something
a
little
bit
else
right?
We
could.
We
could
line
these
up
and
that
works
okay.
But
let's
go
one
step
forward
further
in
our
next
four
minutes.
All
right,
so
I'm
going
to
go
back
to
the
list
settings
just
to
change
this
up
now
I
mentioned
before
that.
H
Lookups
can
actually
do
calculated
columns
despite
the
official
documentation.
So
let's
see
that
in
action
all
right,
so
let's
just
take
that
away
and
we'll
just
say,
use
our
exciting
stats,
calculated
column
all
right.
So
I'm
just
going
to
go
and
clear
out
this
format.
So
we
can
see
us
looks
and
hit.
H
H
So
we're
going
to
expand
that,
so
it
looks
a
little
better.
All
right,
that's
fine!
Okay!
This
is
my
half
attempted
table,
but
the
idea
here
is
we're
going
to
split
those
values
ourselves
using
that
for
each
so
we
know
we
get
each
value
as
a
four
each
right.
So
we
get
that
item
iterator
and
again
we're
going
to
inspect
now.
The
first
thing
we're
going
to
do
is
we
want
to
do
something
different
at
the
top
right.
We
want
to
close
that
border
at
the
top.
H
You
can
get
what
position
you
are
in
that
for
forage
using
this
loop
index
operator
and
just
pass
in
whatever
iterator
you're
in
right
pass
that
in
it'll
tell
you,
and
so,
if
you're,
the
very
first
one
which
is
zero
and
then
we
add
a
you,
know
a
border.
Otherwise
we
don't
and
then
we
get
those
individual
values
using
a
substring
where
we
get
the
lookup.
We
look
inside
the
lookup
value
right.
H
We
start
there
and
we
say
the
first
index
of
you
know
the
pipe
and
so
on
we're
kind
of
doing
that
for
each
one
of
those
as
we
go.
So
that's
one
way
to
do
that
right,
so
you
can
take
all
that
and
kind
of
go
that
route
with
it.
So
if
you
want
to
go
a
little
crazy
with
the
table,
you
can
but
you've
got
other
problems
when
you
go
this
route
right.
So
if
I
come
in
here
and
I
want
to
filter-
oh
that
is
not
helpful
right.
H
So
again
you
kind
of
cut
away
the
pros
and
cons,
but
also
understand
that
you're
not
gonna,
be
able
to
bring
in
certain
values
from
those
other
columns
right.
So
there
are
lots
of
ways
to
solve
it
when
it
comes
to
formatting.
Those
are
the
kind
of
the
main
things
to
keep
in
mind,
so
the
lookup
values
themselves
have
to
come.
You
know,
as
sub
properties,
look
up
value
and
look
up
id.
H
If
you
do
any
kind
of
projected
field
or
additional
column
know
that
you
are
now
in
a
world
of
pain,
getting
those
coal
semicolons
and
spaces
and
split
all
those
apart.
But
again
the
sample
is
available
for
you
and
you
can
cut
and
paste
that
and
then
customize
as
needed.
So,
let's
switch
back
real
quick
for
some
resources
that
I
promised.
A
A
Do
a
beep
on
the
recording,
so,
okay,
so
it's
it's
a
family
show!
No!
Thank
you.
Thank
you,
philipp.
Thank
you
sergey
and
thank
you.
Chris
awesome
stuff
again
super
cool
demos,
we'll
get
the
recording
out
within
24
hours,
you
in
our
microsoft,
365
community
channel
and
we'll,
and
then
also
split
these
individual
demos
as
an
individual
videos
which
will
be
coming
out
gradually
within
the
upcoming
weeks.
The
next
entries
for
general
development
call
is
on
may
13th.
A
The
next
sharepoint
framework
call
is
on
same
time
as
week
from
now
as
today
from
week
from
now
so
kind
of
makes
sense,
maybe
in
english,
but
on
may
6th
and
see
all
of
the
community
calls
in
akms
m365
bmp,
there's
not
of
course
available
if
you're
looking
into
when
are
they
happening?
All
of
that
go
to
the
akms
m365
bmp
and
you
can
see
the
sequences
and
all
of
that
and
choose
those
goals
which
are
interested
in
joining.
A
But
that's
all
what
we're
going
to
do
today
have
a
great
rest
of
the
week.
Please
keep
on
the
feedback
coming.
It's
super
important
for
us
to
know
as
a
microsoft.
What
works
and
what
doesn't
work
and
if
you're
interested
on
doing
a
live
demos
and
any
of
the
future
calls
please,
please
please
reach
out
and
we'll
catch
your
schedule,
but
thank
you
chris.
Thank
you,
philip.
Thank
you.
Sergey
one.
More
time
have
a
great
rest
of
the
week.