►
From YouTube: Microsoft 365 PnP – General Microsoft 365 Developer SIG community call – 2nd of September, 2021
Description
Microsoft 365 PnP Community - General SIG call on September 2nd. Demos: SharePoint Approval Workflow Status Tracking with Column Formatting, Build your first conversational chatbot for Teams, and Updates on Independent Publisher Connectors for Power Platform. 2 Teams samples delivered. Submit a sample to the Microsoft 365 tenant – script, Power Platform or Teams samples galleries. Attend an event hosted by Sharing is Caring and register for the PnP Recognition Program. No project releases this week, you can surely expect releases soon. 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
Greetings
and
welcome
everyone
to
this
microsoft,
365
development,
bi-weekly
community
call
today
is
september,
2nd
we
are
already
into
september,
and
my
name
is
david
warner
with
catapult
systems
and
pnp
team
member,
and
we
warmly
welcome
you
all.
Let's
talk
about
our
agenda
for
today
we're
going
to
get
the
latest
on
a
number
of
pnp
initiatives,
the
pnp
framework
and
core
sdk
pnp
powershell,
yo
teams,
microsoft,
graph
toolkit,
we'll
talk
about
some
team
samples
and
power
platform
samples
and,
of
course,
we're
going
to
always
do
our
together
mode
opportunity.
A
Let's
dive
in
directly
to
the
opportunities
that
you
all
have
to
participate
in
this
community
first
is,
of
course,
providing
a
demo
or
solution
or
technical
pattern
on
all
these
community
calls.
We
welcome
everyone.
We
are
an
inclusive
and
open
source
community,
so
we
would
love
to
see
the
samples
you
have,
no
matter
how
simple
or
complex
we
want
you
to
share
with
the
community
what
it
is
that
you've
learned
that
you
have
found
valuable.
A
In
fact,
we've
even
opened
up
a
new
form
if
you'd
like
to
request
a
demo
spot
on
the
call,
you
can
go
to
aka
dot.
Ms
forward
slash,
m365
pnp
forward,
slash
request
forward,
slash
demo,
and
we
will
capture
your
information
and
get
back
to
you
and
get
us
something
scheduled
there
for
you,
and
if
you
would
like
to
contribute
on
github,
we
provide
an
open
source
opportunity
for
you.
It
is
completely
available
for
you
to
contribute
your
samples
and
demos
as
well
and,
of
course,
we
always
welcome
feedback.
A
We
want
to
hear
what
is
working
for
you,
what
is
not
working
for
you.
We
want
to
make
sure
that
this
is
the
best
and
most
inclusive
open
source
community
to
provide
you,
the
resources
and
tools
that
you
need
now.
Pager
links
as
patrick
calls
them
here
is
a
number
of
links
that
are
available
to
you
within
our
community.
A
We've
got
microsoft,
365,
developer,
videos,
ka.msm,
365,
dev,
youtube,
microsoft,
community
videos
by
all
of
the
community
members
here
that
you
see
on
these
calls,
as
well
as
others,
available
aka.msm365
pnp
videos,
a
number
of
open
source
initiatives.
Those
links
are
all
available
there
by
sharepoint
pnp
office,
dev,
microsoft
graph.
A
They
all
take
you
to
the
github
repositories,
where
you
can
not
only
use
the
resources
available
but
contribute
back
and,
of
course,
if
you
want
and
are
looking
for
samples,
we
have
got
samples
of
plenty
for
you
all
kinds
of
sample
galleries,
team
samples,
spfx
samples,
power
platform,
samples,
extensions
list,
formatting,
and
it
goes
on
now.
This
is
a
lot
of
links
to
take
in
all
at
once.
A
A
The
first
repository
that
we
want
to
talk
about
today
is
our
script
samples.
Now
this
is
a
newer
initiative
for
us,
but
it
has
over
80
scenarios
and
107
scripts
using
cli
for
microsoft,
365,
pnp,
powershell
or
sbo
management.
Shell,
tooling,
there
are
tons
of
contributions
so
far
you
can
contribute.
In
fact,
we
have
an
ama
coming
up
on
this
here
in
a
couple
of
weeks,
so
check
out
aka.ms4
script,
samples,
a
wide
variety
of
opportunity
and
a
wide
spectrum
of
script
opportunities
for
you
to
contribute
to
now.
A
We
also
understand
that
there
may
be
some
challenges
or
hurdles
for
you,
as
you
start
entertaining,
and
utilizing
the
resources
and
tools
available
to
you
in
the
community
and
in
fact,
if
you'd
like
to
contribute
back,
that
could
be
even
more
intimidating,
but
we
have
got
you
taken
care
of.
We
got
your
back.
We
want
to
provide
you
hands-on
guidance
sessions
by
way
of
the
sharing
is
caring
opportunity
that
is
going
to
provide
you
the
ability
to
collaborate
with
others
in
the
community
and
members
of
the
pnp
in
a
live
hands-on
session.
A
Now
the
spectrum
of
topics
is
wide.
It
goes
from
first-time
contributor
down
to
first-time
presenter.
So
if
you're
looking
to
provide
a
sample
or
you're
looking
to
demo
a
sample,
we
want
to
make
sure
you're
feeling
confident
and
well
equipped
to
be
able
to
accomplish
that
task.
They
are
scheduled
all
month
long,
they
are
free
and
they
are
not
recorded,
so
they
are
completely
safe
space
opportunities
for
you
to
take
advantage
of,
and
learn
more
about,
the
opportunities
that
you
can
contribute
to
within
this
community
and
get
more
involved.
A
We
also
have
the
ever
popular
amas
and,
as
you
can
see,
we've
got
a
number
of
them
coming
up,
ranging
from
the
recognition
program,
script,
samples
power
platform
and,
of
course,
the
newly
scheduled
list
formatting
with
chris
kent,
so
everybody's
going
to
enjoy
that
it's
going
to
be
a
lot
of
fun
register
for
any
and
all
of
these
at
aka
dot.
Ms
forward
slash
sharing,
is
caring.
A
A
We've
been
working
on
the
blog
authoring
opportunities,
spfx
samples
and
we've
got
a
lot
of
limited
edition,
badges
that
are
going
to
be
coming
soon
during
the
holidays
and
and
stuff
like
that
to
be
to
make
it
a
lot
of
fun.
So
we
need
you
to
opt
in,
though
so
check
out
aka
dot.
Ms
forward
slash,
m365
pnp
dash
recognition,
keep
keep
that
link
there
for
you,
because
we're
gonna
keep
looking
to
provide
again
those
additional
campaigns
and
look
for
ways
to
continue
to
celebrate
all
the
amazing
work.
You're
doing
now.
B
B
So
for
pnp
framework
we
are
at
1.6
and
we're
kind
of
getting
back
from
vacation.
At
least
I
am
some
other
folks
as
well.
I
know
so
catching
up
on
things.
There's
a
couple
pending
prs
that
we
have
to
merge
over
there
and
already
a
couple
of
fixes
from
irwin
lewis,
christian
miguel
and
quinn
that
have
been
merged
and
will
be
available
in
the
next
1.7
release.
B
Those
releases
1.7.
If
the
next
versions
of
the
libraries
will
be
around
let's,
let's
take
a
double
time
frame,
something
like
that
so
fairly
soon
on
the
bmp
core
as
the
gay
side,
the
new
library,
more
things
have
happened,
so
we
are
at
1.3.
We
were
a
bit
quiet
during
vacation,
but
now
we're
catching
up
on
things.
I
know
that
paolo
is
really
working
hard
to
to
build
a
new
version
of
the
pnp
transformation
framework.
B
B
On
the
powershell
site,
a
bit
of
a
similar
story,
meaning
everyone's
slowly
getting
back
from
vacation,
you
know
it
goes.
But
one
thing
to
highlight
here
is
just
the
usage
power
usage
just
skyrocketing
guys,
it's
like
more
than
700
000
downloads,
close
to
100
million
commandlets.
Well,
that's,
maybe
not
so
close,
but
we're
getting
to
100
million
commandments
soon.
I
hope
executed
per
day.
So
that's
just
massive
massive
usage
overall.
What
happened
in
1.7?
B
C
A
C
So
well
about
the
eu
teams
project
actually,
as
bert
already
said,
for
the
net
libraries
in
powershell,
we
have
been
on
vacation.
So
there
are
no
big
news,
but
for
sure
we
had
a
huge
increment
of
usage
of
the
yo
team's
toolkit.
So
we're
really
happy
about
that
and
we
plan
to
improve
it
in
the
upcoming
month
with
new
features
and
new
capabilities.
C
D
D
Our
team
personally
is
still
working
on
aligning
the
changes
with
all
the
topic
component.
Twofold
ui
web
components,
that's
released
in
the
last
build.
There
has
been
a
lot
of
architectural
discussions
so
that
we
wanted
to
keep
all
the
existing
features
because
there's
framework
differences
so
that
conversation
continues.
D
D
We
really
need
your
help
to
if
you
wanted
to
introduce
new
features
between
v2
and
v3,
for
bug,
fix
fixes
and
new
features,
so
come
check
out,
help
wanted
and
good
first
issues
in
our
repo
aka
ms
smash
mgt
and
then
give
us
feedback
on
the
new
components
that
we're
building
one
is
mgt
search.
This
is
this
is
going
to
enable
people
to
search
for
entities
such
as
people,
files,
chat
or
channels
all
included
in
the
same,
and
then
the
other
one
is
mgt
picker.
D
A
Thank
you
awesome
awesome,
thanks
beth
and
for
those
that
are
not
familiar
or
as
familiar
with
mgt.
Just
on
tuesday,
we
had
our
first
microsoft
365
platform
community
call
where
waldek
went
over
the
mgt
so
check
out
the
chat
for
a
link
to
that
video.
If
you've
not
already
seen
it
really
awesome
stuff.
Now
we'll
move
on
to
microsoft,
team
samples
with
bob
german,
hello.
E
Everyone,
you
know,
I
have
a
trivia
question
to
start
off
with
what
happens
if
you
take
yo
teams
and
the
microsoft
graph
toolkit
and
put
them
together.
The
answer
is
answered
by
marcus
muller's
excellent,
two
new
demos
that
he's
just
added
to
the
repository
and
the
link
is
right.
There
he's
actually
showing
how
to
use
yo
teams
with
mgt
authentication
and
components,
as
well
as
with
teams,
sso,
authentication
and
mgt
components.
So
you
can
leverage
all
those
really
great.
You
know
mgt
features
from
inside
of
the
yo
teams
projects.
E
So
thanks
so
much
for
that
marcus.
Also,
I
want
to
thank
dogen
for,
and
hopefully
I'm
saying,
everybody's
name
right
for
updates
to
the
node.js
sso
tab
example.
You
know
I
have
to
say
that
these
samples
are
only
as
good
as
we
can
keep
them
current
and
we
really
need
to
scale
through
the
community.
So
I
really
really
appreciate
that
kind
of
update
and
ongoing
maintenance
on
the
samples.
So
please,
your
contributions
are
welcome.
A.K.A.M.S
teams,
samples
sharing,
is
caring
and
back
to
you,
dave
thanks.
F
Unfortunately,
I
do
not
have
trivia
for
you
all,
but
I
will
talk
about
the
power
platform
samples.
We
don't
have
any
new
samples
this
week,
but
we
have
a
lot
of
great
samples
out
there
that
you
should
definitely
check
out
everything
ranging
from
fluent
ui
themes
for
your
powerapps
canvas
apps
to
your
responsive
templates
that
matthew
devaney
has
submitted
recently,
so
definitely
encourage
you.
This
is
open
source.
We
do
have
an
ama
coming
up
as
well
as
david
mentioned
earlier
for
power
platform,
so
make
sure
that
you
do
check
that
out.
F
If
you
have
any
questions
about
how
you
know
submitting
samples
here
using
any
of
the
samples
or
anything
like
that,
we
welcome
all
of
your
power
platform,
samples
from
power,
apps
templates
components,
connectors,
custom
functions,
power,
automate
flows,
power,
bi
power,
virtual
agents.
We
will
take
it
all,
so
I'm
looking
forward
to
more
contributions
and
seeing
what
we
can
share
with
you
next
month.
A
G
Yes,
indeed
I'll
be,
let
me
actually
share
my
screen.
Let's
start
from
there
and
I
will
get
everybody
visible
there
as
well,
so
there
we
go.
We
are
now
in
10.
I
think
we'll
get
get
the
full
house
again
today
we're
hitting
200
attendees
on
the
call
which
is
pretty
cool,
so
there's
50
seats
to
get
to
the
picture
and
then
we'll
do
some
recording
and
vaping
hands.
Hopefully
daniel
behave
on
the
back
row
and
bert
you
can
take
care
of
the
the
troublemakers
in
the
in
the
last
row,
I'm
getting
more
people.
G
Let
me
actually
enable
the
video
as
well
until
we
have
a
technical
challenge,
is
there's
me
anybody
else
who
wants
to
join
the
video
and
just
waving
our
hands.
I
can
see
only
presenters,
not
that
many
people
come
on.
Okay,
so,
oh
we
are
getting
more
people
in
that's
patrick,
I'm
just
checking.
Let's
wait
three
more
times,
there's
risa
a
lot
of
familiar
faces.
Paul
is
there
as
well.
G
A
H
And
share
my
screen:
okay,
so
the
topic
at
hand
today
is
sharepoint
approval,
workflow,
with
status
tracking
a
little
bit
about
me.
My
name
is
reza
durrani,
I'm
a
microsoft,
business
applications,
mvp
and
a
microsoft
certified
trainer.
I
work
at
catapult
systems,
along
with
my
friend,
david
warner.
I
work
as
a
power
platform
practice
technical
lead,
that's
the
link
to
my
youtube
channel
and
that's
my
twitter
handle,
so
the
topic
for
today
is
purely
approval,
workflows
in
sharepoint
and
how
we
can
track
the
output
and
the
status
of
those
workflows.
H
These
approvals
are
dynamic
in
nature.
They
are
serial
approvals
and
using
the
power
of
column
and
view
formatting.
I
was
able
to
track
the
entire
approval
process
from
start
to
finish
who
the
approvers
are
where
we
are
in
the
approval
status?
How
long
did
the
approvers
take
to
respond
and
so
and
so
forth?
H
H
H
H
I
have
my
types
defined
and,
more
importantly,
for
each
of
these
types
I
have
my
approvers
defined
of
this
definition
of
my
approvers.
Here
is
dynamic
in
nature,
so
if
the
user
adds
an
expense
request
related
to
training.
In
that
scenario,
my
approvers
would
be
james,
followed
by
reza
followed
by
sarah.
H
H
So
that's
the
setup
related
to
the
sharepoint
list.
Now,
on
top
of
this,
I
needed
an
approval
process,
so
I've
leveraged
power
automate-
and
this
is
my
power-
automate
approval
workflow
this
workflow
triggers
or
kicks
off
the
moment.
The
user
creates
an
item
in
my
expense
reports
list
try
and
zoom
in
here.
H
H
I'm
using
a
get
items,
query
against
the
expense
types
list,
and
here
I
have
an
odata
query
that
goes
and
grabs
the
approver
information
from
my
expense
types
list
based
on
the
expense
type
the
user
has
selected
for
the
request
that
they've
put
in
once.
I
get
those
details,
I
add
them
to
a
variable
of
type
array
and
that's
the
list
of
my
approvals.
H
That's
coming
based
upon
the
expense
type
selected
once
I
have
that
my
first
step
is
to
go
and
update
the
status
of
the
current
item
and
the
way
I
do
that
is,
I
just
change
the
choice
column
approval
status
to
pending
because
the
approval
process
will
be
starting
now
and
in
my
approval
history
column,
which
is
of
type
multi-line
of
text.
I
just
go
ahead
here
and
enter
simple
text
that
says
that
this
expense
request
approval
process
has
been
started
by
the
person
who
created
this
request,
and
they
started
this
at
today's
date
and
time.
H
Next
I
loop
through
the
array
of
the
approvers
that
is
obtained
dynamically
and
for
each
of
those
approvers
that
I
obtained,
I
started
the
approval
process
now
I
begin
the
approval
process
only
if
the
status
is
not
equal
to
rejected,
because
my
process
is
a
serial
approval,
a
multi-step
approval.
If
any
approver
rejects
it,
the
entire
process
stands
rejected
if
the
first
approver
approves
it,
it
moves
to
the
second
and
the
third
and
so
and
so
forth,
depending
upon
how
many
approvers
were
defined
for
that
specific
expense
type.
H
H
H
Their
decision
who
the
approver
was
at
what
date
and
time
did
they
respond?
How
long
did
they
take
to
respond
and
any
comments
that
they
plugged
in
while
they
were
responding
to
the
approval
process
once
this
is
done?
I
am
loading
it
into
my
array
variable
once
again
and
finally,
I
check
to
see
the
outcome
of
the
approval.
What's
the
final
decision,
if
the
decision
of
that
approver
is
approved.
H
In
that
case,
I
will
go
ahead
and
change
the
status
of
the
item
only
if
this
is
the
last
approver
in
the
thread
of
approvers
and
how
do
I
track
if
this
is
the
last
approver?
I
have
an
index
variable
that
I
maintain
inside
this
for
loop
right
here
that
I'm
incrementing
each
time
the
loop
runs.
So
I
have
the
counter
of
the
approver.
That's
currently
running
this
action
and
at
the
same
time
I
also
know
how
many
approvers
I
have,
because
I
can
check
the
length
of
my
array
variable.
H
So
I
check
to
see:
is
this
the
last
approver?
If,
yes,
then,
the
status
will
change
to
approved.
If
no,
that
means
there
are
more
approvers
who
need
to
approve
this.
I
keep
the
status
as
pending
in
case
the
approver
rejects
it.
I
straight
away,
go
and
set
the
status
as
rejected,
and
then
this
variable
that
I'm
maintaining
in
my
flow,
I
change
its
status
to
rejected
if
this
stands
as
rejected
the
next
time
the
loop
runs,
because
I
have
added
this
condition
that
checks
to
see
the
status
is
not
equal
to
rejected.
H
H
Let's
say
I
need
some
power,
automated
training,
or
maybe
I
took
some
power
automate
training
for
600
or
500
training
for
flows,
and
this
one
I
will
relate
it
to
training,
and
maybe
I
took
this
yesterday
for
a
day
I
can
even
attach
receipts
basically
attachments
to
prove
my
expense
details
and
once
I'm
done
with
this
I'll
click
save
now
the
moment
I
do
this.
The
first
step
here
is
that
the
information
gets
logged
in
sharepoint.
H
H
Once
the
process
begins,
we
will
have
the
status
change
from
new
to
pending
and
because
I
want
to
show
two
cases
I'll
go
and
create
another
item
right
here
once
again,
so
I'll
go
and
say
new,
and
this
time
I
will
say
I
need
some-
let's
try
a
different
expense
type
I'll
pick
marketing.
So
maybe
I
have
event
promotion.
Maybe
we
are
being
involved
in
an
event.
We
need
to
promote
something
so
a
thousand
dollars.
Let's
put
this
as
test
and
I'll
just
put
the
start,
end
date
and
click
save.
H
H
H
Now
all
of
this,
if
I
head
over
to
the
list
view,
this
is
my
column
formatting
sample
that
I
have
leveraged
right
here.
So
if
I
go
to
approval
history,
column,
settings
and
format
this
column,
this
is
the
json
code
that
I
will
just
go
and
plug
in
in
vs
code,
and
the
key
thing
here
is
one
I
am
no
json
expert.
So
how
did
I
get
this
sample?
H
Well,
I
looked
at
the
pnp
column,
formatting
samples
and
one
of
the
samples
that's
been
put
out
by
tetsuya
kuahara
and
I'm
a
big
fan
of
his
work.
He
has
had
put
out
this
nice
looking
timeline
sample
and
what
I
did
is
literally.
I
just
took
this
and
transformed
it
from
a
vertical
looking
timeline
to
a
horizontal,
looking
timeline,
and
when
you
select
this,
it
opens
this
custom
hover
card
in
there.
I
just
show
my
description
column,
my
history
column,
that's
all
I
did
and
the
way
I
did.
H
That
is
simply
when
the
user
selects
this
custom
hover
card
right
here
and
we
can
see
the
code
in
action
here.
I
all
I
do
is
just
go
ahead
and
plug
in
the
approval
history
and
regarding
the
position
of
the
and
regarding
the
position
of
this
shape,
if
you
notice
the
shape
moves
from
left
to
right,
depending
upon
the
current
status,
the
way
I
handle
that
is
by
using
the
justify
content
attribute.
H
If
I
zoom
in
here,
we
can
see
that
in
action
right
here
if
the
status
is
pending,
I
position
it
in
the
center.
If
it's
new,
I
position
it
on
the
left.
If
it's
approved
or
rejected,
I
just
move
that
shape
onto
the
right
hand,
side
and
the
color
of
the
shape
also
is
dependent
upon
the
status.
So
that's
why,
when
you
see
here,
depending
upon
the
status,
the
color
of
this
circular
shape
changes
as
well,
and
when
the
user
selects
this,
it
opens
up
the
entire
history.
H
So
now,
if
I
go
back
to
my
tiles
view
here
here,
I've
leveraged
view
formatting,
in
which
I
show
that
same
column,
formatting
experience
in
here
I'm
tracking
my
approval
process.
So
these
are
the
two
requests
I
put
in
for
the
training
request.
I
have
three
approvers
for
the
marketing
request.
I
have
two
and
these
are
being
dynamically
picked
from
this
specific
list.
H
H
If
I
sign
in
as
james
and
head
over
to
the
approval,
email
james
can
see
all
the
details
of
the
approval,
along
with
the
link
to
the
item
and
james,
can
approve
a
request
or
reject
the
request.
So
let's
say
james
approves
this
and
says:
okay,
so
james
has
taken
his
approval
decision
once
james's
approval
decision
is
logged.
H
The
flow
now
will
move
ahead
to
the
second
approver,
because
james
has
approved
it
and
while
the
flow
moves
ahead,
the
flow
is
smart
enough
to
know
that
the
status
is
still
pending,
because
reza
or
james
is
not
the
last
approver.
There
are
more
approvers
in
the
thread
and
if
you
observed
it,
it
moved
ahead.
Live
it
converted
the
james
james's
approval
to
green,
because
james
took
his
decision,
and
now
it's
jumped
ahead
to
reza,
and
if
I
click
on
this
approval
timeline,
I
can
see
the
entire
process
right
here.
H
Reza
started
the
approval
james
took
the
approval
decision.
James
took
three
minutes
to
respond.
That
was
pretty
quick,
and
this
is
the
comments
that
james
put
it
now.
The
task
is
assigned
to
reza.
So
now,
if
I
sign
in
as
reza
raza
should
get
the
approval
task
created,
and
in
this
case
let's
say
reza,
goes
ahead
and
says:
no,
I'm
not
going
to
approve
this
reza
rejects
this
outright.
H
Now,
since
reza
has
rejected
this,
the
status
now
changes
to
rejected
and
when
it
changes
to
rejected
no
other
approval
task
would
be
assigned.
That
means
the
process
will
stop
at
this
point
and
we
will
see
the
status
now
turn
red
goes
to
rejected
and
this
light
will
turn
red
and
no
task
will
be
created
for
sarah.
H
So
let
me
try
and
refresh
this
and
there
we
can
see
that
live
here
in
action
and
then
for
event.
Promotion.
It's
basically
the
same
experience.
I
have
two
more
minutes
or
three
more
minutes.
So
let
me
just
make
this
quick.
Let
me
show
you
the
formatting
experience
for
this.
The
key
to
show
the
status
here
was
two
things
one.
If
I
head
over
to
my
list
view
again,
I
have
a
column
called
approvers
where
and
I
track
who
my
approvers
are.
Of
course
I
also
have
something
known
as
approver
index.
H
This
tells
me
where
we
are
in
the
approval
process,
so
if
index
is
one
that
means
it's,
the
task
is
what
the
first
approval,
if
it's
two
it's
the
second
approver
and
so
and
so
forth.
So
the
index
lets
me
know
where
we
are
in
the
approval
process,
and
I
already
have
my
list
of
approvals
with
this
information.
H
H
So
I
thought
about
reusing
that
concept
and
what
I
did
is
I
actually
reapplied
to
that
concept,
but
the
only
thing
different
I
did
is
I
placed
certain
emojis,
which
basically
tell
me
the
status
of
the
approval.
So,
instead
of
putting
images
I
used
emojis
and
that
emoji
is
the
status
and
to
drive
the
status
here,
we
try
once
again
and
zoom
in
to
drive
the
status
here.
All
I
did
was
this:
if
my
status
is
approved,
that
means
every
approver
has
definitely
approved
it.
H
If
the
current
user's
index
is
less
than
that,
that
means
they've
definitely
approved
it.
So
it's
green
else.
It's
yellow
else.
It's
green
else.
It's
red,
that's
the
basic
logic
that
I
applied
right
here,
so
same
concept
as
what
chris
put
out,
but
I
just
changed
it
with
a
few
emojis
and
just
played
around
with
status,
and
this
is
what
I
ended
up
with.
H
So
you
can
build
these
experiences
for
your
users
inside
sharepoint
by
applying
column,
formatting
view
formatting,
and
then,
if
you
apply
on
top
of
that,
the
power
of
approvals
leveraging
power
automate,
you
can
create
such
amazing
experiences
I'll,
just
wrap
it
up
quickly
with
a
few
learning
resources.
So
you
can
get
started
with
what
I
demoed
today.
H
I
have
a
full
playlist
on
on
column,
formatting
approvals,
sharepoint,
of
course,
and
power
automate.
So
if
you
want
to
check
that
out,
that's
the
link
bit
dot
ly
slash
sp
formatting.
I
have
my
own
github
repo.
When
I
maintain
my
list.
Formatting
samples,
luis,
was
sweet
enough
to
reach
out
to
me,
and
let
me
know
that
I
can
apply
in
the
pmp
samples
as
well
so
I'll
plan
to
do
that
as
well.
H
Very
soon,
and
finally,
thank
you
for
for
listening
and
a
big
thank
you
to
vesa
for
giving
me
the
opportunity
to
be
on
this
call
today
I
have
been
a
fan
of
vesa
ever
since
the
pnp
initiative
started,
and
I've
always
been
on
the
other
side
of
the
call,
and
I'm
extremely
excited
to
be
here
today.
So
thank
you.
A
Awesome
thanks
excellent
stuff.
There
are
warrior
horses
celebrating
around
the
globe
with
all
that
list,
formatting
goodness
all
right,
we're
going
to
move
directly
over
to
stephen
we're
just
a
couple
minutes
behind.
So
we're
going
to
move
over
to
stephen
on
build
your
first
conversational
chat
bot
for
teams,
stephen,
you
want
to
take
over
sure.
J
Hi
everybody
and
welcome
to
my
demo
on
building
your
first
conversational
chat
for
microsoft
teams.
In
case
you
just
want
to
reach
me
after
the
call
use
my
at
least
twitter
handle.
So
you
can
reach
me
on
twitter.
If
you
have
any
questions
about
what
I'm
demoing
today,
as
you
might
know,
there
are
few,
let's
say:
options
when
building
chatbots
in
the
microsoft
world.
You
got
pva
coming
from
the
power
platform,
you
got
the
microsoft
butt
framework
and
azure
bot
service
and,
of
course,
some
other
options
as
well.
J
What
I'll
do
today
is
I'll
go
through
a
demo
which
I've
built
using
button
composer
so
but
from
a
composer,
is
the
more
or
less
graphical
user
interface
built
on
top
of
the
microsoft
bot
framework,
which
you
can
use
to
build
bots,
not
only
for
teams
but
in
general,
and
I've
prepared
a
little
bot,
which
I'm
gonna
walk
you
through
in
the
next
couple
of
minutes,
so
I
won't
build
anything
from
scratch.
I've
prepared
a
demo
already
and
I'll
walk
you
through
that.
So,
first
things.
J
First,
if
you
go
ahead
and
create
a
podcast
composer,
you've
got
a
lot
of
templates.
You
can
use
you
can
create
an
empty
bot.
You
can
create
a
more
or
less
conversational
bot.
You
can
leverage
the
templates
built
by
microsoft
or
build
your
own.
I've
gone
with
the
core
bot
template,
which
includes
at
least
language
understanding,
so
it
comes
with
some
basic
triggers
in
there.
It
comes
with
some
language
understanding
functionality
in
there.
J
If
you
go
ahead
and
create
a
bot,
you
need
to
at
least
assign
your
bot
your
language,
understanding
key.
So
you
got
to
go
to
the
azure
portal,
create
a
new
lewis
application
or
lewis
service,
get
the
offering
key
from
there
and
paste
it
into
your
composer
bot,
and
the
second
thing
I
have
done
already
is
I've
created
a
azure
bot
which,
which
was
then
called
in
the
past
bot,
channel
registration
service
and
I've
pasted
in
the
microsoft
app
id
and
my
microsoft
app
password.
J
So
switching
to
the
azure
portal,
I've
created
an
azure
bot
with
that
azure
bot
comes
a
new
enterprise
application
for
app
registration
for
you,
you
got
to
get.
You
got
to
get
the
microsoft
app
id
and
the
app
secrets
based
into
composer
and
what
I've
done
as
well,
because
as
we're
speaking
about
building
about
four
teams
and
building
a
bot
targeted
to
the
microsoft
365
ecosystem,
we
of
course
need
at
least
some
basic
functionality
coming
from
azure
id
or
from
the
graph.
So
what
I've
done
for
my
azure
bot
is.
J
I
have
added
a
new
ol
connection,
which
is
of
type
service
provider
azure
ad
and
in
there
you
need
to
at
least
provide
a
client
id
and
client
secret
and
of
course,
you
need
to
provide
the
resource,
url,
you're,
gonna,
you're,
gonna
use
within
your
bot
use
case
then,
which
is
in
my
case
the
microsoft
graph,
and
you
need
to
define
the
scopes
you
want
to
you
want
to
tackle,
which
is,
in
my
case
some
basic
ones.
Like
user
read,
profile
open
id
and
stuff.
J
What
I
have
done
right
now
is
within
my
root
dialog,
which
is
called
core
with
language
dialog.
I
have
added
some
basic
triggers
some
thing
coming
from
the
default
template
like
greeting,
cancel,
help
and
stuff
like
that,
and
what
I've
done
is
I've
added
another
trigger
called
get
reports
dialogue,
because
what
I
want
to
do
is
whenever
a
user
interacts
with
the
with
the
chatbot
in
microsoft
teams,
the
user
should
be
able
to
get
basic
information
about
his
direct
reports.
J
J
This
trigger
will
be
triggered
and
then
a
new
dialog
will
begin,
and
this
dialog
is
called
get
reports
dialog
and
in
here
you'll
see
the
first
connection
to
my
azure
id
app
with
the
oauth
blogging,
because
somehow
the
chatbot
needs
to
know
who
the
user
is
and
basically
get
the
credentials
of
that
user
and
get
the
user
contact.
So
I'm
using
a
an
action
called
oauth
login
and
in
there
I
just
need
to
provide
my
connection.
Name
remember.
This
is
the
connection
name.
J
J
For
the
sake
of
simplicity,
I
have
just
added
one
action:
usually
you
would
do
a
for
each
loop
and
loop
through
all
direct
reports,
you'll
get
back
and
then
get
for
each
report,
because
you
don't
you
just
get
the
id
of
that
report
or
that
user,
which
is
a
report
of
that
signing
user,
and
then
you
go
ahead
and
get
the
full
profile.
So
you
get
display
name
first
name
last
name:
email,
address,
user,
principal
name
and
stuff
like
that.
J
I've
just
done
it
for
one
user
turn
dot
report
and
the
first
occurrence
dot
id.
And
then
what
we'll
do
is
we'll
just
really
simple:
send
out
the
user's
display
name
and
the
user's
email
address,
and
that's
basically
it
so
if
I'm
gonna
run
that
bot
right
now,
just
right
from
composer
click
start
and
we'll
give
it
a
minute
or
so
to
start
I've
already
prepared
a
new
microsoft
teams
app
with
the
within
the
app
studio.
J
I
have
pasted
in
the
microsoft
f80
of
the
azure
bot
I've
shown
earlier
and
then
what
I
can
do
from
here
is
just
go
ahead
and
install
and
edit
and
I've
already
installed
it.
So
the
conversation
won't
be
playing,
but
we'll
see
if
we're
gonna
go
back.
The
bob
is
already
running,
so
I
can
go
ahead
now
and
say.
Show
me
my
direct
reports
and
what
the
bot
will
actually
do
now
is.
J
If
we
are
lucky,
we
should
get
the
the
login
prompt,
because
I've
restarted
the
plot
right
now,
but
you
see
it's,
the
user
account
is
already
logged
in
so
it
reaches
out
to
the
graph
gets
the
current
user's
profile
gets.
This
gets
the
reports
of
that
user
and
then
gets
the
profile
of
the
reports,
and
then
it
will
basically
respond
back
with
these
details.
J
What
I
have
done
as
well,
because
one-on-one
chat,
is
just
one
aspect
of
microsoft
themes,
but
you
want
to
include
your
bot
anywhere
in
teams.
You
can
also
go
ahead
and
include
your
bot
in
a
channel
and
there's
a
quite
a
cool
feature
within
composer,
which
is
a
trigger
called
on
channel
created.
So
whenever
there's
a
channel
created
in
a
specific
team
where
the
bot
is
already
a
member
of
the
bot
can
actually
react
to
that.
J
A
David
thanks,
awesome,
stuff
steven.
Thank
you
that
is
really
really
cool.
How
you
can
set
up
these
various
scenarios
for
the
the
the
bots
and
within
the
teams
and
the
triggers
really
cool
stuff.
Thank
you
for
sharing.
Next
up
is
natalie
from
microsoft.
She's
going
to
share
with
us
some
updates
on
the
independent
publishing
connectors
for
power
platform.
So
I
know
there's
a
lot
of
excitement
about
this
natalie.
Take
it
away.
K
Hello:
everyone
thanks
for
having
me
today
great!
So,
let's
go
through
updates.
There
are
a
lot
as
you
can
see,
on
the
screen
so
again,
just
to
recap:
independent
publisher,
connectors
or
connectors
that
are
submitted
by
anyone
so
built
by
anyone
submitted
by
anyone
and
that
run
through
our
certification
pipeline
right.
So
you
do
get
that
approval,
that
you
know
your
connector
works
and
and
that
it
is
of
a
certain
quality
and
that
it
is
directly
available
within
the
product.
K
K
What
three
words
etsy
hashify
and
secure
code
warrior.
So
it's
pretty
incredible
to
see
all
these
people
who
have
been
involved
ahmad,
daniel
who's
on
the
call
today,
troy
who's,
also
on
the
call
today
and
matt
have
been
adding
the
ones
that
came
out
this
month
in
terms
of
the
leaderboard
for
the
number,
the
most
number
of
active
connections
for
these
connectors.
We
have
air
table
and
number
one
hubspot
crm
as
number
two
and
jira
search
by
paul
come
c
as
number
three.
K
So
we're
really
excited
to
see
that
as
well,
and
we
have
15
connectors
still
in
the
pipeline
that
are
going
through
certification.
Three
of
those,
as
you
can
see,
are
actually
fun.
Connectors,
chuck,
norris,
dad,
jokes
and
place
dog
and
troy
will
be
giving
a
quick
demo
today,
right
after
I
finish
chatting
with
you
all
with
place
dog,
because
who
doesn't
love
dogs
and
just
in
general,
other
updates,
so
daniel,
as
well
as
a
couple
of
the
other
project
coordinators
have
been
managing
the
the
discussions.
K
The
new
discussion
section
within
our
github
repository.
You
know,
even
if
you're
not
looking
to
submit
a
connector
or
build
a
connector,
and
you
have
connector
ideas.
That
is
the
place
to
go
daniel
clipped
off
the
thread
very
recently,
so
you
know
just
go
in
there
put
in
the
connector
you're.
You
have
an
idea
for
or
functionality
for
so
this
is
the
place.
K
Definitely
to
go
that
and,
of
course,
a
special
shout
out
to
our
project
coordinators,
as
always
ahmad
april
daniel
fausto
paul,
rebecca
and
troy
for
all
their
brain
power
and
for
all
the
great
things
that
are
happening
in
this
community.
So
that's
all
on
my
end,
so
troy
I'll.
Kick
it
off
to
you
to
give
us
a
fun
demo
with
the
place
dog,
connector.
L
L
K
A
Awesome
well,
that
is
exciting
fantastic
demos.
Today,
let
me
share
back
out
the
screen
and
we
will
wrap
this
up
with
some
links
to
next
week's
calls
excellent
demos
today
again
by
reza
stefan
and
natalie
a
lot
of
exciting
opportunity.
Thank
you
for
everyone.
Who's
been
contributing
to
the
community,
keep
it
up.
We've
got
a
lot
of
initiatives
in
the
pipeline
and
a
lot
of
opportunities
to
help.
You
continue
to
contribute
so
keep
that
up.
A
A
The
next
general
development
call
will
be
september,
16th
same
bat
time
same
bat,
channel,
7
a.m,
pacific
daylight
time,
and
the
next
sharepoint
framework
call
will
be
a
week
from
today
september.
9Th
at
7
00
am
as
well.
You
can
get
links
to
all
these
community
calls
at
aka
dot.
Ms
forward
slash
m365
pnp,
as
well
as
a
calendar,
invite
for
the
new
tuesday
recurring
call
so
invite
you
to
join
that.
It's
going
to
become
very
amazing
with
a
lot
of
microsoft.
Presenters.