►
Description
Microsoft 365 development community call on April 15th. Demos: 1) SharePoint Content Type APIs in Microsoft Graph, 2) Live London Underground Line Status Bot in Dataverse for Teams, and 3) Microsoft list formatting with header and footer settings. PnP project releases include - PnP Framework v1.4.0 and PnP Core SDK v1.1.0 and PnP PowerShell v1.5.0. The Microsoft 365 developer community survey is now open, 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 Vesa Juvonen (Microsoft) | @vesajuvonen. Q&A takes place in chat throughout the call.
Learn more:
• See the full blog post for this call at: http://aka.ms/m365pnp-blog
• Download invite for bi-weekly Microsoft 365 development community call: http://aka.ms/spdev-sig-call
• Learn more about the Microsoft 365 Patterns and Practices community at: http://aka.ms/m365pnp
• Visit the Microsoft 365 Patterns and Practices community YouTube channel: https://aka.ms/m365pnp-videos
A
Welcome
everybody:
this
is
general
microsoft,
365
development,
special
interest
group.
I
think
we
need
to
get
rid
of
the
sick
in
this
call,
because
it's
my
accessories,
it's
like
development
community
call-
and
this
is
the
the
bi-weekly
sync
happening
on
thursdays-
7
a.m.
Pacific
time,
bi-weekly
and
and
kind
of
a
sister
call
of
this
one
is
the
sharepoint
framework
call
as
well.
Today
we
kind
of
go
through
what's
happening
within
the
open
source
and
community
driven
initiatives
or
open
source
initiatives.
A
So
in
the
bmp
framework,
np
powershell,
your
teams
and
microsoft
craft
toolkit
every
one
of
these
projects
are
welcoming
contributions
and
they
there's
luckily
already
a
lot
of
people
involved
in
them.
So
thank
you.
Thank
you
for
that
one
as
well,
then
we're
going
to
do
a
quick
recap
on
what's
happening
with
the
microsoft
team
samples.
We
are
absolutely
welcoming
microsoft,
team
samples
as
well,
and
we
have
a
lot
of
them
already,
but
it's
a
good
cool
opportunity
to
get
some
visibility
for
your
samples
and
your
work
as
well.
A
A
Then
we
move
into
leon
armstrong
with
a
really
big
demo:
title
live
london,
underground
line
status,
bought
in
database
for
teams,
azure
management,
api,
azure
functions,
power,
virtual
8,
and
so
a
lot
of
a
lot
of
technologies
in
that
demo,
and
then
the
last
one
will
be
chris
kent.
I
have
no
idea
what
chris
is
presenting.
It
might
be
something
related
on
war
horses
and
if
you
do
not
know
that
joke
stick
around
for
the
last
demo,
you
will
probably
get
it.
A
So,
let's
see
what
chris
comes
up
with
today
now
a
quick
recap
also
on
the
opportunities
to
participate
in
the
community.
We
would
love
you
to
to
do
a
live
demo
in
this
community
course.
It
is
a
great
way
of
actually
getting
an
mvp
status
or
keeping
your
in
with
this
data.
So
all
of
this
is
is
obviously
absolutely
optional.
You
do
not
have
to
volunteer
for
a
demo,
but
it's
a
great
opportunity
for
those
who
would
love
to
do
so.
A
You
can
demo
a
existing
open
source
solution,
some
solution,
which
is
not
open,
source
completely
fine,
as
well,
not
for
product
selling
purposes,
but
more,
like
hey
here's.
The
solution
which
we
built
this
is
these
are
the
learnings.
These
are
technologies
that
you
use.
Those
kind
of
demos
are
super
useful
to
understand
what
kind
of
things
people
are
building,
because
learning
from
others
is
by
far
the
easiest
way
and
most
interesting
way
to
understand,
what's
possible
in
microsoft,
365
and
then,
of
course,
contributing
github
and
provide
in
general
feedback.
A
We
have
a
lot
of
assets
and
available
and
resources
available
for
you
to
take
advantage.
We
have
two
different
youtube
channels:
microsoft,
365
developer
videos
and
then
microsoft,
365
sharepoint
community,
video
channel
slightly
weird
that
we
have
two
of
them
do
historical
reasons
and
slightly
different
content
in
both
of
them,
but
check
them
out.
Super
super
cool
videos
coming
up
on
both
of
them
every
single
day.
We
have
a
lot
of
open
source
assets
available
in
multiple
different
organizations.
A
Many
of
them
are
actually
samples
and
because
people
are
always
complaining
that
kind
of
github
and
finding
the
right
sample
is
so
hard.
We've
actually
built
a
lot
of
sample
galleries,
which,
sooner
or
later,
within
this
quarter,
we
will
actually
release
a
new
unified,
microsoft,
365
sample
gallery.
So
you
can
go
to
one
url
and
then
you
can
easily
find
the
craft,
the
microsoft
teams
targeted
sample,
which
is
using
craft
for
power
platform
from
one
location.
A
So
that's
getting
built
right
now
and
if
you're
wondering
that's
so
many
urls,
I
can't
remember
any
of
this:
a
one
url
and
the
world
them
all
which
a
kms
m365
bmp
cool,
a
few
kind
of
general
updates.
Always
our
team
samples
are
available
in
acms
team
samples
gallery.
So
this
is
a
great
gallery.
It
has
multiple
filters
already,
so
you
can
easily
find
what's
relevant
for
you.
A
If
you're
looking
for
a
bot
or
a
messaging
extension
or
a
web
hook
or
spf
x,
target
for
teams,
you
can
target
your
query
based
on
your
preference.
So
please
take
advantage
of
the
existing
examples,
rather
than
always
start
from
scratch.
Samples
are
really
really
great,
and
this
is
samples
from
microsoft
and
from
community,
so
both
of
them
are
in
one
location.
A
Some
other
updates.
Please
do
answer
our
microsoft
resistive
developer
community
survey.
This
is
something
which
we
open
up
actually
a
few
days
ago.
So
we're
trying
to
understand
how
can
we
help
you
more
so
help
us
to
help
you?
It's
basically
the
the
statement
in
here.
We
want
to
make
your
life
easier
in
the
future,
so
let
us
know
how
we
can
help
your
life
easier.
A
What
are
the
things?
What
are
missing?
What
are
the
things
where
we
should
be
investing?
Are
you
looking
into
doing
certificates?
Are
you
looking
into
more
videos?
What
are
the
ways
you
are
learning,
so
let
us
know
so
we
can
help
you
on
that.
The
other
thing
which
we've
been
promoting
recently
within
this
course
is
the
microsoft
resist
five
extensibility
lookbook,
and
this
is
really
intended
to
answer
the
question
on
microsoft.
A
365
is
so
big,
there's
a
lot
of
options
to
extend
and
have
stuff
to
do,
but
what
are
all
of
those
options,
so
you
go
to
one
url.
You
can
actually
see
all
of
the
different
extensibility
options
in
teams
or
in
sharepoint
or
in
office
or
in
power
platform,
and
then,
when
you're
looking
into,
for
example,
info
additional
information
around
apps
in
teams
meeting
you
click
on
the
image.
A
You
get
videos
you
get
links
to
the
docs
you
get
within
links
to
the
samples
so
making
it
super
easy
for
you
to
find
the
relevant
information
and
we're
looking
into
feedback
on
this
one
as
well.
Is
it
working?
Are
people
finding
it
useful?
If
something
is
missing,
please
do
let
us
know
now,
then
we
have
the
sharing
scaling,
initiative
and
david.
I
think
you're
ready
to
go
to
do
a
quick
intro
on
this
one.
B
Absolutely
thank
you
vista
well
for
any
that
are
new
to
the
community.
It's
important
to
know
that
we
are
an
inclusive
and
open
source
community,
which
means
we
have
lots
of
tools
and
resources,
some
goodies
for
you
to
take
advantage
of,
and
you
can
even
contribute
back
and
update
some
of
those
items.
B
We've
got
more
coming
soon
with
power
platform,
they're,
safe
space,
inclusive
opportunities
for
you
to
collaborate,
they're
not
recorded,
so
you
don't
have
to
worry
about
any
of
that.
We
just
want
to
collaborate
with
you
and
give
you
an
opportunity
to
get
more
involved
so
aka
dot.
Ms
forward,
slash
sharing,
is
caring
and
be
on
the
lookout
for
the
next
ama
for
next
month
with
to
the
tech
community,
as
the
topic
with
luisa
freese
vessel
back
to
you,.
A
C
C
Over
in
a
month,
so
each
month,
there's
like
almost
100
000
antennas,
using
dot
net
libraries
or
the
libraries,
and
actually
we
did
some
calculation
that
boils
down
to
16
more
than
16
000
requests
each
second
of
the
month
march.
Just
saying
like
imagine
the
infrastructure
you
need
to
just
handle
16
000
requests
each
second
continuously
for
the
whole
month
of
march.
So
anyhow,
just
being
saying
that
this
is
being
used
and
usage
keeps
on
growing
massively.
Now.
C
What
did
we
do
over
the
last
month,
a
little
bit
less
than
previous
period,
because
it
was
easter
and
some
people
took
east
holiday,
but
on
the
pp
framework
site
we
are
preparing
for
1.5
some
highlights
there.
It's
the
patrick
helgen
created
an
sp
web
request
executor,
which
allows
you
to
replace
the
way
how
csom
makes
an
http
request.
C
So
csum
today
uses
hp
web
request,
glasson.net,
which
is
quite
old
and
has
some
limitations.
So
now,
with
this
web
request,
actuator,
you
can
just
plug
in
the
http
client,
which
gives
you
more
scalable
scenarios
in
clouds
when
you're
using
it
in
in
a
cloud
because
there
is
less
connections
being
created.
So
you
have
less
port
exhaustion
problems
and
so
on.
So
it's
a
better
scenario:
it's
not
a
default
yet,
but
we're
testing
that
and
might
even
become
a
default
solution
going
forward.
C
Marston
created
some
additional
test
marking
options
and
there
is
both
x's
from
christian
and
gotham
on
the
pmp
core
sdk
side.
So
the
new
library
we
have
some
page
api
updates
from
yannick
when
working
with
large
page
libraries,
so
we're
here
the
case
where
there's
like
a
page
type
we're
having
more
than
5000
pages.
So
we
have
some
issues
and
we
fix
those
viva
topic
pages
support
is
coming
now
we
have
like
limited
support
to
kind
of
read
an
existing
topic
page
and
update
it
and
save
it
back.
C
A
C
Yeah
I'll
do
it
real,
quick
again,
powershell
also
hit
like
a
all-time
record.
25
000
tenants
again
massive
growth
over
there
and
we
are
in
1.5
version
today.
I
think
the
main
new
thing
in
that
release
was
that
the
published
pnp
company
app.
So
if
you
have
a
desktop
connections
application
so
a
bit
similar
to
the
script
that
microsoft
shipped.
A
Because
I
have
to
say
that,
because
there's
an
active
discussion
related
also
index
internally,
we
can't
go
to
our
details,
but
there's
more
and
more
functionalities
and
and
stuff
happening
with
that,
one
as
well
from
a
sample
and
template,
and
all
of
that
perspective,
so
more
stuff
coming
really
cool
cool
stuff
as
a
teaser
just
to
mention.
So
thank
you
from
that
one.
Thank
you
on
that
one
and,
let's
jump
then
to
victor
villain
and
what's
happening
in
your
teams.
You
had
something
related
on
viva
connections
here
as
well.
Absolutely.
D
So
the
good
thing
with
these
bi-weekly
meetings
is
that
I
need
must
carve
out
some
time
to
do
some
updates.
So
I
did
that
this
morning
merged
some
couple
of
pull
requests
from
paulo
one
from
paul
or
a
couple
of
paul,
smaller
minor
enhancements,
and
we
published
a
new
3.1.0
preview
and
there's
also
now
a
new
option.
When
you
create
a
tab,
you
have
the
option
of
previously
at
the
option
of
a
configurable
tab
and
a
static
tab.
D
And
now
you
have
a
viva
connections
tab,
so
it
is
essentially
a
static
tab
that
is
just
pre-con
configured
with
all
the
valid
domains
and
everything
that
needs
to
be
in
the
manifest.
So
if
you
have
a
your
team's
application
with
the
bot,
for
instance
today,
you
can
just
run
your
teams
over
it
again,
assuming
you
should
using
version
three
and
then
add
the
viva
connections
tab
to
it.
D
So
that's
what
we've
done.
We
also
published
the
ability
was
1.1.0
this
morning
as
well.
It's
been
out
in
preview
for
quite
some
time,
which
has
support
for
multiple
manifests
and,
yes,
you
can
see
march
was
the
greatest
month
ever
for
your
team.
So
a
lot
of
good
stuff,
I
have
more
prs
to
walk
through
and
hopefully
we
have
some
great
updates
in
two
weeks
again.
A
Thank
you
victor.
This
there's
a
lot
of
excitement
on
the
yo
teams
as
well.
It
is
absolutely
a
great
tool
for
creating
stuff
for
the
microsoft
team,
so
check
it
out.
If
you
are
not
familiar
with
that,
but
thank
you
on
that
one
victor
and
then
let's
move
to
the
microsoft
graph
toolkit,
I
saw
that
we
have
beth
on
the
call
as
well
just
to
do
a
quick
recap
in
here.
Beth.
E
A
E
Thank
you
so
kind
of
similar
to
last
week
we
fixed
some
bugs
on
the
toolkit
and
for
those
of
you
who
doesn't
know
what
microsoft
graph
toolkit
is.
It's
a
web
component
library,
that's
components,
that's
fully
functional
powered
by
microsoft,
graph
that
can
help
you
build
microsoft,
graph
powered
apps.
We
also
have
a
list
of
authentication
providers
to
help
you
build
apps
on
different
platforms.
E
So
one
of
the
asks
that
we
have
from
the
team
this
week
is
please
try
out
the
microsoft
at
microsoft,
slash
mgt,
sharepoint
package.
This
solves
a
lot
of
the
bugs
at
people
using
sharepoint
and
building
apps
with
microsoft,
graph
toolkit,
and
then
we
also
have
two
new
things
coming
up.
One
is
the
msl2
provider,
the
other
one
is
the
mgt
file
and
file
list
components
so
feel
free
to
try
out
the
beta
version.
I
have
the
purple
mpm
install
on
there.
E
So
if
you
wanted
to
check
check
out
our
next
branch
for
msl2
provider
and
next
file
and
give
us
feedback
on,
you
know
if
there's
any
more
features
or
attributes
or
properties,
you
would
like
to
see
on
these
things.
Let
us
know,
as
far
as
how
you
can
help
just
try
out
these
things
and
give
us
feedback
on
the
ripple.
That's
all.
A
Thank
you.
Thank
you
beth.
I
I
just
need
to
again
repeat
what
I
always
say,
but
thank
you
for
waking
up
this
early.
It
is
7
a.m.
When
the
school
starts
in
pacific,
so
beth
is
really
showing
commitment
and
showing
up
on
this
course.
So
thank
you.
Thank
you
cool
and
then
bob
updates
on
the
team
samples,
not
that
many.
This
time.
F
I
know
it's
kind
of
it's
kind
of
disappointing,
but
every
now
and
then
I
have
to
make
the
slide
that
says
we
don't
have
any
new
samples.
So
you
know
lots
of
exciting
stuff
going
on
in
teams
development.
So
if
you've
built
something
cool,
consider
sharing
it
with
the
community,
we
would
really
love
to
have
it
glad
to
help
so
just
drop
a
pr.
A
pull
request
in
the
team's
dev
samples,
repo,
pnp,
slash
teams,
dev
samples
or
reach
out
to
me
jump
into
a
sharing
is
caring
session.
A
A
It's
all
good
yeah
and
you
can
filter
if,
by
the
way,
if
you're
wondering
that
hey
can
I
filter
on
the
samplers
coming
from
microsoft?
Yes,
you
can.
There
are
filtering
mechanisms
on
test
as
well.
Now.
Thank
you
bob
on
that.
Let's
jump
for
a
quick
group
photo.
Do
we
get
50
today?
Let's
see
I
will
flip
in
here
I
will
get
the
do
we
get.
Let's
see,
I
will
flip
the
scene
to
be.
Let's
pick,
let's
be
the
that
one
today,
so
we
haven't
used
that
for
a
while.
A
Yeah,
yes,
I
will
start
the
recording
and
that's
going
to
freeze
for
a
second
and
then
we
can
see
everybody.
I
think
we're
hitting
the
max
50.
Let's
do
some
waving.
Thank
you,
everybody
for
being
part
of
the
community.
This
is
super
super
cool,
hopefully
at
some
day
we'll
have
250
support
for
this
view
as
well.
So
thank
you.
Everybody
awesome.
We
kind
of
crap
a
screenshot
out
of
that
as
well
and
and
publish
that
into
social
media.
So
thank
you.
A
Thank
you
for
that,
and
I'm
gonna
steal
that
away
from
here
and
then
we're
gonna
go
to
the
demo
section.
So
we're
going
to
start
with
microsoft,
craft
apis
for
sharepoint
content
types,
it's
really
cool
to
see
more
and
more
sharepoint
apis,
classic
sharepoint
apis
being
available
in
the
microsoft
graph
like
it
should
be
so
we're
catching
up,
but
we
can
see
the
screen
so
take
it
away.
G
G
Just
a
quick
note
on
the
permissions
before
we
start
with
the
demo.
So
for
all
the
get
apis,
sites.read.all
permission
is
required
and
for
patch
and
patch
post
and
delete
apis,
sites.manage.all
permission
is
required
and
for
apis
that
are
specific
to
publishing
a
content
type
for
that
sites.
Dot
full
control
permission
is
required,
so
I'll
just
start
with
a
demo.
G
G
G
So
this
request
takes
in
in
the
content
type
url
the
graph
url
to
the
content
type
in
the
request
body
and
in
the
response
you
will
get
the
content
type
resource
that
has
been
added
to
the
list.
So
if
we
quickly
jump
to
the
document
library
settings,
you
should
be
able
to
see.
So
you
can
see
the
contract.
G
So
in
this
case
it
it
would
be
of
something
like
sites,
site
column.
So,
in
the
response
you
will
get
all
the
metadata
related
to
the
column
that
has
been
added
to
that
content
type
and
the
coming
to
the
next
api
is
basically
to
this
will
copy
the
an
existing
file
in
any
of
the
list
in
that
site
to
the
content
type
resource
folder,
so
that
file
then
can
be
used
to
use
as
a
template
or
in
case
of
document
set.
It
can
be
used
as
a
default
content
for
that
document
set.
G
So
basically,
I
already
have
a
item
that
is
stored
in
one
of
the
list,
so
in
the
request
body
I'll
just
need
to
provide
the
list
id
and
the
list
item
id
of
that
particular
item-
and
this
is
the
optional
parrot.
The
destination
file
name
is
an
optional
parameter,
which
will
basically
give
a
new
name
to
the
file
at
the
destination
if
it
is
present.
So
if
this
request
is
successful,
it
will
return
a
204,
no
content
response,
and
otherwise
it
will
return.
G
The
any
failure
code
then
coming
to
the
patch
api
I'll,
be
updating
the
document
set
content
type
that
we
have
created.
So
basically
I
am
adding
some
shared
columns
and
allowed
and
content
types
that
can
be
allowed
to
the
content
type.
So
once
I
make
this
request
yeah
it
will
return
the
allowed
content
types.
Basically,
you
can
see
the
content
type
that
I've
added
in
the
document
set
here
and
if
you
go
to
the
ui
in
the
site,
content
types
page,
you
can
see
that
in
the
document
set
settings.
G
We
can
go
back
to
the
content
types
page
and
if
you
go
to
the
manage
publishing,
you
will
see
that
it
is
now
published
and
once
the
the
sync
job
runs,
it
will
be
synced
to
all
the
sites
that
which
can
use
this
content
type
then
coming
to
the
next
api.
So
this
is
this.
Api
is
specific
to
the
tenants
that
have
a
sharepoint
syntax
license,
so
this
will
enforce
the
content
type
to
the
sites
that
are
associated
with
the
hub
site.
G
If
this
is
true,
then
it
will
also
add
the
content
type
to
the
existing
list
in
those
site,
and
if
this
is
false,
then
it
will.
The
content
type
will
be
added
by
default
to
only
the
new
new
list
that
the
user
will
create.
So
once
I
fire
this
request,
it
will
return
a
204,
no
content
response.
If
the
request
is
successful
and
the
change
will
actually
happen,
there
is
a
background
job
that
will
run
and
do
the
enforcement.
G
A
Yeah
visa
here
I
just
have
to
say
that
it's
great
to
see
a
lot
of
there's
a
lot
of
a
lot
of
a
lot
of
super
powerful
thinking
here.
Copy
the
default
content
locations
super
super
powerful
and
great
to
see
that
to
be
supported,
because
then
that
means
that
we
can
automate
the
template
for
the
content
types
as
well.
So
it's
not
just
about
creating
content
types,
but
also
getting
the
templates
here
and
I
love
to
propagate
to
existing
lists.
A
So
that
has
been
taken
into
a
consideration,
because
that's
quite
typical
enterprise
use
case
that
you
need
to
modify
existing
sites,
not
just
the
new
sites
and
new
operations
which
are
getting
created
so
really
really
cool
stuff.
There
was
a
question
I
don't
know.
If
we
can
answer
that
there
was
a
question
related
on
metadata
on
the
document
sets.
There
was
one
of
the
demos
which
showed
how
was
around
the
document
sets
and
what
is
the
metadata?
What
can
be
set
for
a
document.
G
A
A
H
Yep
welcome.
Let
me
just
share
my
screen
and
thanks
lesser
okay,
so
good
morning,
good
afternoon
or
evening,
wherever
you
are
in
the
world.
Welcome
to
my
presentation
today
on
creating
a
live
london,
underground
line
status,
bot
in
dataverse
versus
teams
using
power,
virtual
agents,
power
automate
as
your
management
api
and
as
your
functions
apologies
for
the
long
title
I
just
yeah
we're
struggling
to
get
the
technologies
in
and
a
little
about
me.
My
name
is
leon
anston
and
I'm
a
microsoft
365
solutions
consultant
at
intellij
in
london.
In
the
united
kingdom.
H
H
H
H
So
this
is
a
great
opportunity
to
use
this
exciting
new
technology
with
your
customers
or
organization
today.
So
I
wanted
to
use
power
virtual
agents
in
data
versus
teams
to
build
a
live
interactive
bot
as
its
database
for
teams.
The
bot
can
only
be
used
from
the
team's
application
or
teams
web
clients.
So
there
are
some
restrictions,
but
with
your
bot,
you
can
interact
with
any
live
api,
I.e,
transportation,
sports
results,
weather
recipes
or
even
those
chuck
norris
api
for
quotations.
H
H
H
I
will
now
use
this
diagram
to
explain
the
solution
so
watch
my
mouse.
It
consists
of
a
power
virtual
agent's,
bots
running
in
a
data
versus
teams
environment
for
a
specific
microsoft
team.
We
can
see
the
microsoft
the
data
versus
teams
environment
perimeter
highlighted
in
purple,
so
the
user
sends
a
message,
the
trigger
phrase
of
yeah.
Are
there
any
delays?
H
H
H
So
I'll
now
show
you
my
bots,
which
yeah
you
could
build
so
I'll
type,
the
trigger
phrase
of
line
status,
but
there's
many
other
trigger
phrases
that
it
responds
to.
So
it's
glad
to
report-
and
it
asked
me
which
line
I'm
interested
in
so
I'll
type
central,
so
that's
the
central
line
and
then
it
connects
to
the
tfl
api
via
power
automate
via
azure
and
yeah.
It
says
that
there's
no
delays
on
the
central
line,
I'll
type,
the
trigger
phrase
again.
H
But
this
time
I'll
type,
some
random
characters
and
obviously
there's
not
a
line-
that's
called
after
those
characters,
so
I
then
have
some
smarts
where
it's
yeah
then
gives
me
a
list
of
all
the
line
names
so
I'll,
select
the
waterloo
and
city
line,
and
it
will
return
that
there's
yeah
no
service
until
further
notice.
So
now
let
me
show
you
how
this
is
put
together.
H
So
in
your
teams,
client
under
database
teams,
you
can
access
power,
virtual
agents,
so
I'm
in
there
now
and
I
go
to
chat
bots
and
I
can,
when
it
loads.
I
can
see
my
power
virtual
agent's
bots
that
I've
previously
made
in
data
versus
team,
so
I
select
the
london
underground
dataverse
for
teams,
environment
and
I
can
see
my
bot
here
called
tubing.
H
I
select
tubing
and
then
this
will
load
my
chat
bots,
I'm
interested
in
the
topics.
So
these
are
the
rules
of
yeah.
The
responses
to
the
questions
asked
to
the
bot
so
I'll
go
to
line
status,
which
is
which
I
configured
and
we
can
see
all
the
trigger
trigger
phrases
for
this
bot.
So
when
these
trigger
phases
are
spoken,
this
topic
is
initiated
so
I'll
go
to
the
offering
canvas
now-
and
this
is
yeah
the
topic
in
logical
order
with
all
the
rules.
H
H
And
then
we'll
go
further
down
the
tree
and
to
the
response,
but
I
just
want
to
go
back
and
yeah
show
you
that
it
goes
to
power
automate
and
that's
where
it
connects
to
a
custom
connector
and
goes
and
gets
a
live
api
results.
We've
also
got
the
slots
here,
for
if
the
line
name
is
not
found,
then
we
have
the
option
to
select
from
a
button
all
of
the
15
london
underground
lines.
H
So
if
I
edit
the
flow,
I'm
not
going
to
go
into
great
detail,
because
this
is
quite
complex,
this
power
ultimate
flow,
but
the
first
trigger
initiation
is
it's
asking
for
the
line
name.
So
the
topic
provides
the
line,
name
that
we
typed
in
then.
If
we
go
to
here.
This
is
a
custom
connector
that
I
built.
H
H
Then
that
queries
the
api
and
if
there's
a
matching
line
name,
we
formulate
the
response.
If
there's
any
reported
delays
or
if
there's
delays
expected,
but
if
we
formulate
that
all
in
markdown
language,
so
we
make
thing
bold,
we
make
things
headers,
so
it's
nicely
formatted
for
the
users
and
then
we
return
all
that
back
to
the
user
in
the
topic.
H
So
I'm
now
going
to
go
to
azure,
to
yeah
show
all
the
components
for
this.
So
you
will
need
an
as
your
subscription
to
do
this,
but
the
custom
connector.
It
connects
directly
to
the
as
your
management
api
service
that
I've
got.
So
that's
a
web
layer
that
you
can
deploy
in
your
azure
environment
and
then
publish
your
own
apis
to
it.
So
you
could
publish
an
api
direct
from
a
logic,
app,
an
app
service
or
a
function
app
in
my
case,
I'm
going
to
well.
H
H
So
you
may
remember
in
the
custom
connector
in
power
automate,
we
had
two
text
boxes,
asking
first
for
the
subscription
key
and
secondly,
for
the
line
name,
so
that's
yeah
where
they
come
from
and
then,
if
we
go
to
the
back
end,
so
we
can
see
the
back
end
of
the
api
over
this
right
hand.
Side
is
the
is
it's
linked
to
an
azure
function
app
and
that
function
app
is
called
london
tubes.
H
And
with
this
will
now
load
up
the
power
shell
that
yeah
the
powers
this
script
so
I'll
just
go
through
this
we
have.
The
first
part
is
yeah,
where
it's
initiated
by
the
line
name.
So
if
a
line
name
is
supplied
to
it
that
then
populates
this
line
name
variable
over
here
and
yeah.
That's
coming
from
the
request
at
the
beginning.
H
So
what
happens
is
all
of
the
line?
Statuses
are
returned,
so
we
need
to
filter
it
by
the
line
name.
So
that's
what's
happening
here
and
then.
Finally,
we
convert
it
back
to
json
format,
ready
for
power
automate
to
to
use
the
next
part
of
the.
If
statement
we
don't
really
use,
but
that
yeah
returns
all
all
lines
without
filtering.
H
H
So
let
me
just
return
back
to
my
demo
and
do
a
quick
recap.
So
to
recap,
this
solution
uses
power,
virtual
agents
in
microsoft,
teams
in
data
versus
teams
to
provide
a
london
underground
line
status.
Spot
a
user
asks
a
question
to
the
bot
about
a
particular
line,
and
then
the
line
status
topic
is
triggered,
which
then
triggers
a
flow
in
power
automate.
H
H
Finally,
this
information
is
returned
to
the
user
by
bot,
and
that's
all
so.
Thank
you
for
your
time
today
and
for
watching
my
presentation
below
is
a
link
to
my
blog
and
a
direct
link
to
the
blog
post,
where
you
can
find
a
full
guide
for
implementing
this
solution.
There
is
also
a
qr
code,
so
you
can
scan
this
to
take.
You
direct
feel
free
to
connect
with
me
using
the
details
below
and
let
me
know
if
you
have
any
comments
or
questions
regarding
the
solution.
H
A
Thanks
leon
really
really
great
stuff
and
and
it's
a
absolutely
brilliant
set
of
technology
being
demoed
on
this
setup
and
and
it's
great
to
see
actually
how
your
tube
line
status
line
thing
is
evolving.
It's
been
a
dynamic,
spf
x
report.
It's
now
a
bot,
it's
it's
evolving,
all
the
time
across
the
different
technologies
in
microsoft,
365,
so
really
really
cool
stuff
and
april
is
reaching
out,
certainly
for
getting
you
to
demo
this
in
a
power
platform
community
course
as
well,
so
this
is
really
really
really
great
stuff.
Thank
you
for
that.
H
I
A
A
I
All
right-
everybody,
hello,
hello,
I'm
chris!
Let's
talk
about
some
cool
stuff
here,
so
I've
shown
something
like
this
before,
but
I
think
it's
important
to
kind
of
take
a
look
at
list
formatting,
so
there's
lots
of
different
options
in
list
formatting.
We
started
off
with
just
being
able
to
do
columns,
and
now
we
can
go
kind
of
crazy
with
all
sorts
of
stuff,
which
is
awesome,
but
it
can
be
a
little
confusing
if
you're,
just
starting
out.
So
let's
take
a
look
at
it
and
we're
going
to
dive
into
one
specific
section.
I
So
we
looked
at
this
before
right.
You've
got
this
idea
of
a
surface
so
where
your
list
is
going
to
render
whether
it's
the
list
view
microsoft
list
web
part.
You
know
mobile
app,
that
kind
of
thing
there's
going
to
be
standard,
ui
elements,
there's
going
to
be
the
headers,
the
unformatted
groups
and
aggregates
row,
and
all
those
kind
of
things
that's
just
standard
ui
and
all
this
extra
stuff
that's
going
to
come
along,
then
you're
going
to
have
your
data
right.
That's
just
where
you
know
your.
A
I
I
We
can
even
do
what's
called
a
view
format,
row
class,
which
is
just
a
simple.
We
can
put
an
expression
and
say
for
every
row
that
matches
this
expression.
You
know
slap
this
class
on
there
and
that
again
will
play
nicely
with
our
column
formats,
all
nice
and
stacks,
or
we
can
go
a
little
crazier.
We
can
use
what's
called
a
row
formatter
where
we
can
control
the
entire
render
of
the
surface
row
by
row
right.
So
we
control
this
whole
render.
I
Then
it
gets
applied
on
each
row
as
it
goes
with
our
view
formats
which
are
applied
at
the
view
level.
So
you
can
have
multiple
per
list
as
you
switch
between
views,
even
within
the
view
you
can
switch
to
what's
called
the
gallery
view,
and
we
can
control
that
separately
through
a
tile
props
format
where
we
can
apply
this,
and
these
can
live
simultaneously
together
right
and
then
we
have
this
idea
that
we
can
go
even
a
little
further
and
we
can
get
rid
of
the
column
header.
We
can
substitute
our
own
right.
I
I
We
can
control
the
body
layout
in
terms
of
sections
right.
So
we've
got
a
detail
section,
an
unnamed
section
up
here
and
we've
got
attachments
down
here
with
the
lines.
So
there's
quite
a
bit.
We
can
do
so.
All
of
that
to
say,
we've
got
samples
and
everything
else
and
guidance
and
multiple
videos
on
each
of
these
areas
and
a
couple
weeks
ago
we
look
take
a
look
specifically
at
group,
props
and
kind
of
that
for
footer
formatter.
I
What
I
want
to
do
so
that
was
done
by
microsoft,
and
there
was
a
great
presentation
check
that
out
on
youtube
right,
that
kind
of
introduced
the
concepts
and
kind
of
the
vanilla
view.
What
I
want
to
do
is
I
want
to
dive
a
little
bit
deeper
into
it
kind
of
look
through
our
options
and
kind
of
play
and
experiment
a
little
with
you,
okay.
So
let's
take
a
look
at
that:
let's
see
we
go
back
to
the
yeah,
all
right.
I
We
go
to
our
classic
war,
horse's
side
we
get
the
vest
out
get
out
of
here.
All
right,
you
know.
So
we
take
our
look
over
here
now.
We've
got
this
faqs
list
right,
pretty
common
scenario
and
in
fact,
we've
actually
shown
this
off
before
with
a
format.
So
we
applied
like
a
format
like
this
right,
which
is
cool,
and
this
format
is
a
sample
that
is
available
as
part
of
our
our
github
repo,
and
you
can
check
that
out.
I
But
what,
if
we
wanted
to
do
something
a
little
more
classic
like
one
of
the
things,
people
have
always
been
frustrated
with
with
this
kind
of
thing,
is
I
want
to
collapse
these
right?
For
you
know,
for
this
case,
I've
got
pretty
small
answers
here,
but
what
if
I've
got
really
long
ones?
I
want
to
collapse
that
I
want
to
group
these
by
various
things.
Well,
that's
what
we're
going
to
talk
about.
Imagine
that
so,
let's
take
a
look
at
the
easiest
way
to
accomplish
that.
So
I've
got
this
collapsed.
Simple.
I
I've
got
the
title
field
which
I've
just
renamed
a
question,
and
I've
got
a
multi-text
field
called
answer,
and
what
I
want
to
do
is
I
want
to
apply
some
grouping
and
some
formatting
to
that
now.
One
of
the
things
that
can
be
frustrating
is
there's
not
a
group
by
option
for
the
title
field,
so
we've
got
to
go
to
our
list
settings
and
go
old
school
view
settings.
I
So
if
we
scroll
all
the
way
down,
we
find
our
collapsed
simple
view.
Some
of
you
are
having
ptsd
just
seeing
this.
So
sorry,
so
sorry,
we've
come
down
to
group.
By
now
we
can
select
our
title
field
which
in
this
case
has
been
reading
to
question.
So
I'm
going
to
select
that
all
that
just
to
get
the
grouping
so
now
I've
got
it
grouped
and
that's
cool.
So
now
I've
got
this
kind
of
faq
look
right.
So
I've
got
a
question.
Expand
it
hey!
I
There's
the
answer:
it's
a
little
awkward
right,
so
we
can
do
a
few
things
like
we
could
take
this,
so
we
could
say
hide
this
column
right.
It
still
works
because
it's
part
of
the
grouping.
So
now
it's
not
as
awkward.
The
question
isn't
repeated
inside
there,
but
it's
still
a
little
weird
that
it
says
question
colon.
Can
I
have
a
hug-
and
it's
always
going
to
say
one
right,
because
we
always
have
a
one-to-one
answer?
What
if
we
want
to
customize
that
a
little
further?
I
Well,
it
wouldn't
be
a
demo
if
it
wasn't
possible,
so
we're
going
to
format
this
current
view,
in
this
case
we're
going
to
go
to
advanced
mode
and
for
this
demo
I'm
just
going
to
delete
the
schema
just
to
get
it
out
of
the
way
all
right
in
this
case.
You
know
this
is
a
view
format.
So
I
could
apply
all
the
things
I
would
normally
apply,
but
in
this
case
I'm
going
to
do
group
props.
When
I
say
group
props.
I
Now
I've
got
access
to
a
variety
of
things
I
can
set
the
header,
which
is
all
we're
showing
here.
We
don't
have
any
aggregates
or
anything
like
that.
So
I'm
going
to
say,
header
formatter.
I
always
write
header
formats,
header
formatter
right,
you
hit
that
and
then
this
is
just
same
rules
as
column
formatting
here.
So
I'm
saying
helm
type,
all
right
in
this
case
we're
going
to
say,
div
and
we're
just
going
to
say,
text
content,
all
right
and
just
for
our
personal
say,
wow
right
and
look
at
that
now
we
are
controlling
that.
I
You
notice
we
can't
control.
You
know
the
the
carrot
that
goes
up
or
down
here.
We
don't
have
any
access
to
that,
but
everything
from
the
carrot
over
we
can
control
that
experience
here,
we're
just
putting
text
what
if
we
want
to
put
that
value
like
we
had
before.
Well,
we
have
a
magic
stream
called
at
group
which
has
three
different
properties
on
it
right
we
have
the
column,
display,
name
all
right
and
notice.
I
That
n
is
capital,
unlike
in
the
body
sections,
and
if
we
preview
that
well,
we
have
to
type
it
correctly.
Apparently
I'm
going
to
see
my
I
don't
know
we'll
move
on
to
that
that
type
wrong
here.
Okay,
add
group
and
we'll
say
value
or
field
data,
we'll
come
back
to
the
column,
display
name
in
a
second
preview
that
there
we
go
so
group
dot
field
data
is
really
the
one
we're
after
in
this
case.
So
group
dot
field
data
is
going
to
be
just
whatever
that
field
is
right.
I
If
this
is
say
a
you
know,
a
currency
column
or
it's
a
yes,
no
and
you
don't
want
it
to
say
true
or
false,
when
it's
just
no,
you
could
say
display
value
in
this
case
with
with
text
is
gonna,
be
the
exact
same,
and
so
it
doesn't
change
anything
there,
but
so,
in
other
words,
field
data.
Consider
that
a
placeholder
for
whatever
your
value
is
so
you
can
do
a
lot
with
that
right.
What
if
I
want
some
of
those
other
things
right,
I
want
to
say
count.
I
I
want
to
know
the
number
of
items
displayed
there
right,
that's
that
one.
So
I
can
do
all
sorts
of
things
with
that
right.
If
I
want
to
highlight
colors
or
go
crazy
that
I
can
but
again
in
this
case
I
just
want
the
field
out,
I'm
just
trying
to
simplify
things.
So
it
doesn't
say,
question
with
that
number.
I
So
that
looks
cool
right.
Can
we
go
a
little
further
and
make
this
a
little
better?
Well,
of
course,
we
can
all
right
so
we're
going
to
go
up
here
and
we're
going
to
add,
add
hide
column
header
all
right.
We're
going
to
add
that
I'm
just
going
to
say
true
on
that,
because
we
don't
need
this
up
here
right.
So,
let's
preview
that
bam.
That's
now
gone
now.
We've
got
this
selection
going
on
here.
We
don't
need
that
either.
So,
let's
put
hide
selection.
I
I
I
will
tell
you
there
is
a
oh.
You
know
what
it
is.
It's
it's
showing
here,
there's
a
bug
and
that's
what
it
is
showing
so
you'll
notice
when
I
hide
the
selection,
which
is
correct,
you
see,
I
have
no
selection.
There
is
a
bug
right
now.
It's
submitted
on
the
issues
list,
we'll
see
where
it
goes,
whereas
as
soon
as
you
expand,
you
now
have
a
selector.
So
that's
a
little
weird,
but
it's
it's
still
workable
here
right.
So
this
is
pretty
good.
I'm
just
going
to
save
this
right
and
that's
cool.
Now.
I
I
You
know
here,
I'm
going
to
put
it
to
the
faqs
list,
all
right,
let's
edit
this
thing.
So
I
can
pick
my
view
and
the
view
is
collapse
simple
and
hit
apply
right
and
there
we
go,
and
I
can
you
know,
take
away
the
command
bar.
You
know
if
I
don't
want
this
display
fun
fact.
If
I,
if
I
just
put
a
space
there,
it's
no
longer
going
to
display
right.
I
So
now
we
hit
that
and
I'm
going
to
hit
publish,
I
can't
really
get
rid
of
the
c
all,
but
from
there
you
can
imagine
you
know,
especially
if
I
add
other
things
to
this
right.
This
is
a
we've
just
made
basically
a
little
web
part
or
a
little
application
where
you
can
display
this
stuff,
and
if
you
want
to
put
fancier
styles
on
there
right,
you
want
to
make
this
a
big
cool,
looking
bar
right
with
icons
or
anything
else.
I
All
that's
available
to
you
and
all
of
that
now
can
be
done
with
formatting,
and
you
get
really
that
interactive
piece.
This
collapsing
expand
which
we
didn't
have
before.
If
you
combine
that
with
something
like
the
hover
cards,
you
really
start
getting
into
a
little
miniature
application
here,
all
right,
so
that's
really
cool.
Let's
go
a
little
further.
Shall
we
yeah?
We
got
five
minutes.
Why
not?
So
if
we
take
a
look,
I've
got
a
couple
of
extra
columns
on
here,
so
this
is
just
a
standard
non-grouped
view
of
the
same
faq's
list
right.
I
I've
got
a
ratings
column
and
a
really
important.
This
one
just
has
a
simple
column
format,
just
to
show
that
that's
going
to
be
respected
with
our
grouping
all
right.
So
in
this
case
I'm
going
to
group
by
really
important
right.
So
now
you
have
the
node.
I
got
the
yes
and
in
this
case
I
want
to
add
some
of
those
total
columns.
So
I'm
going
to
add
a
total
of
let's
see
on
the
rating,
we'll
do
an
average
right
and
we'll
just
put
a
count
here
just
so
we
can
see
one
all
right.
I
So
not
on
that
totals
and
we'll
just
go
count
right
so
now
what
you'll
notice
here
is
every
group
right
has
its
own
footer
right,
which
shows
the
average
and
the
count
for
that
group.
This
count
isn't
very
accurate
because
it's
yeah,
it's
just
counting
the
yeses
right,
but
then
we've
got
here
the
same
thing.
We
have
an
aggregate
footer
on
the
very
bottom,
so
that's
cool
right,
but
what
about?
I
If
we
want
to
change
some
of
that
around
so
let's
format
this
view
now
in
this
case,
let's
target
this
list
forward
footer
at
the
bottom
right
now,
which
only
shows
up
their
aggregate
row
and
get
rid
of
all
that
again.
This
one
is
going
to
be
footer
formatter
and
everything
go
in
column.
Formatting
go
here
right,
so
I'm
going
to
say:
elm
type
is
div
and
I'm
going
to
say
text
content
is,
I
don't
know
donkey.
That's
some
kind
of
lesser
horse
sounds
right,
all
right,
so
preview
that
now
here's
what's
interesting.
I
You
notice
that
it
drew
it
in
both
spots
right,
so
the
footer
format
formatter,
because
it's
called
like
row
formatter
and
all
the
other
ones.
You
might
expect
I
can
now
control
this
entire
footer
row
and
that's
not
true,
it's
more
of
a
template
that
applies
and
it
will
be
drawn
in
the
same
spot
as
your
original
column.
I
That
sounds
great
okay,
so
the
idea
here
is,
even
though
I'm
controlling
the
entire
render
of
the
row
where
my
footer
formats
go
right
here
is
still
going
to
be
in
line
with
those
original
columns.
Even
if
I
hide
these
columns.
So
it's
just
something
to
keep
in
mind
it's
a
bit
of
a
limitation
in
some
ways.
In
other
ways,
it's
really
nice
not
to
have
to
draw
those
where
they
go
all
right.
So
let's
get
rid
of
that,
though,
because
that's
distracting
get
rid
of
that
guy.
I
So
that's
how
we
can
have
a
footer
format,
that's
beautiful!
We
can
also
do
something
like
maybe
we
just
like
this
is
the
aggregate
value
for
l
cross.
Everything
is
not
important
to
us
right,
so
we
want
to
say
hide
footer,
and
we
only
I'm
going
to
set
that
to
true
all
right.
I'm
going
to
preview
that
and
now
we
only
have
the
footer
for
the
group
right.
So
that's
deet!
Now
what?
If
I
want
to
apply
a
cool
format
to
do
some
other
stuff
with
it?
I
Well
good
news:
we
can
I'm
going
to
hurry
it
up
here
because
we're
running
out
of
time,
and
so,
if
I
grab
a
footer
formatter,
I've
already
got
over
here
on
my
magic
hidden
screen
all
right,
I'm
just
going
to
grab
this
and
just
paste
it
in
here.
So
I
got
a
footer
formatter
and
we
preview
that
now
the
only
thing
that's
really
doing
is
it's
taking
a
look
at
what
is
called
but
column
aggregate,
it's
a
magic
string
as
well.
That
can
only
be
used
inside.
I
You
know
the
groupings,
so
the
footers,
so
we've
got
at
column
aggregate
you
can
get
the
type.
So,
in
this
case,
I've
got
an
icon
based
on
the
type
right.
If
it's
count,
I'm
going
to
show
this,
you
know
oglethorpe
this
hashtag
or
if
it's
you
know
any
other
type.
I've
just
shown
a
calculator,
but
if
I
want
to
go
a
little
crazier,
we
can
do
that
right
and
I've
also
got
the
type
shown
up
as
a
tool
tip.
I
And
meanwhile
I
can
get
the
type
here,
but
I've
also
got
the
value.
So
I
get
the
value
and
of
course,
if
I
really
want
that
column
display
name,
I
can
get
that
as
well.
Now
you'll
notice
that
this
footer
was
applied,
but
this
footer
still
looks
like
the
standard.
Well,
that's!
Okay!
All
we've
got
to
do
is
get
our
group
props,
I'm
going
to
copy
this
whole
thing,
I'm
going
to
paste
it
again,
we'll
take
a
look
boom,
so
you'll
see
I've
still
got
that
same
thing.
I
We
just
did
with
the
footer
formatter
down
here,
but
up
here,
I've
just
taken
group
props
and
pasted
the
exact
same
footer
formatter
here,
except
that
I
changed
the
font
size
so
preview
that,
and
now
you
have
it.
So
we
can
specify
that
for
footer
format
separate
from
the
main
footer
format,
so
you
can
do
quite
a
bit
with
that
which
is
cool.
It's
pretty
fancy
right,
all
right,
one
last
so
we're
out
of
time,
so
I'm
just
gonna
we'll
have
to
skip
the
next
part.
I
There
is
some
complications
if
you're
doing
a
double
nesting
of
groups
and
when
you're
doing
something
along
those
lines,
you're
going
to
want
to
take
a
look
at
that
column,
display
name
and
maybe
set
your
display
to
none
on
multiple
elements.
So
there
is
a
sample
for
that,
but
I'm
going
to
skip
it
in
interest
of
time.
So
I
can
just
go
to
the
wrap
up.
So
vesa
doesn't
cry,
don't
cry!
That's
it
all
right!
I
So
last
little
thing
here
so
header,
formatter,
footer,
formatter
and
then
hide
footer.
That's
all
within
that
group
props
and
then
you've
got
the
group
here
where
you
can
get
these
various
values.
One
thing
to
note
is
it
is
the
display
name
when
you
pull
that
out.
It
is
not
the
internal
name.
You
don't
have
any
access
to
that
right
now.
That
is
something
I've
requested.
Hopefully
we
get
that
at
some
point
and
then
of
course,
the
list
footer
itself
again
you've
got
another
footer
formatter.
I
So
now
we've
got
three
different
spots
to
put
possible
footer
formatters,
but
they
are
a
little
different,
each
spot,
so
the
form
the
aggregate
bar
and
within
the
group-
and
of
course
you
can
hide
that
footer
and
then
you
get
all
the
column
aggregate
information
here
very
exciting
stuff
and
then,
of
course,
there
is
full
documentation
on
this.
In
the
view,
formatting
so
check
that
out
you'll
notice,
there
is
a
section
in
there
called
aggregates
where
they
suggest
using
the
for
each
don't
say
I
can't
figure
it
out.
I
So
if
anyone
else
wants
to
figure
that-
and
let
me
know
how
that
one
works-
that'd
be
great,
but
we've
got
a
ton
of
samples
on
this,
both
about
view
formatting
column
formatting,
but
also
illustrating
how
to
do
the
groups
from
the
very
simple
we
looked
out
to
some
pretty
elaborate
things
where
you're
doing
nested
groups
and
so
on.
So
that's
it.
That's
all.
I
got.
A
Excellent,
thank
you
chris.
I
will
quickly
close
up
for
today,
so
thank
you.
Great
demos
today
related
on
the
craft,
api
changes
and
then
leon,
armstrong
and
chris
on
the
last
section
quick
reminder:
next
tuesday,
we
have
the
microsoft
teams.
Monthly
community
calls.
So
this
is
the
the
typical
one
where
we
have
been
covering
engineering
things
this
time.
There's
no
engineering
topics
for
the
next
tuesday,
but
there's
three
cool
mvp
driven
demos
related
on
teams,
development.
A
So
just
a
teaser
for
next
tuesday's
microsoft
teams,
monthly
community
call
this
call
will
be
recorded
or
recording
will
be
available,
was
recorded,
recording
will
be
available
in
the
youtube
channel
in
24
hours,
we'll
push
it
out
in
the
social
media
as
well.
In
general,
there's
a
lot
of
lot
of
community
calls
available.
Please
select
those
which
are
suitable
for
you
and
then
check
the
recordings
from
the
rest,
if
you're
interested
in
following
up
what's
happening,
but
thank
you
everybody
for
joining.
Thank
you
for
the
demo
presenters
and
that's
it
for
today.
So
thank
you.