►
Description
Microsoft 365 & Power Platform Development community call on August 4th. Demos: ProvisionGenie v.3.0 – focus on Localization and Accessability and List formatting for backgrounds and borders based on classes used. Delivered 8 new/updated Power Platform Independent Publisher Connectors along with 5 script, and 2 Power Platform samples. Register for Sharing is Caring trainings in August – Writing for the Web and Power Platform Samples Contributor. Please see the blog post for this call for project updates, news and events details. The host of this call was David Warner II (Microsoft) | @DavidWarnerII. Q&A takes place in chat throughout the call.
Learn more
• See the full blog post for this call in the Microsoft 365 platform community blog - https://aka.ms/m365pnp/blog
• Download invite for the Microsoft 365 Developer community call: http://aka.ms/spdev-sig-call
• Microsoft 365 Unified Sample gallery - https://aka.ms/m365/samples
• Microsoft 365 Platform Community in YouTube - https://aka.ms/m365/videos
• Microsoft 365 Platform Community - http://aka.ms/m365/community
A
Live
with
the
community,
this
is
the
microsoft
365
and
power
platform.
Development
bi-weekly
call
today
is
august,
4th
my
how
the
year
has
gone
by
my
name
is
david
warner,
community
program
manager
with
microsoft,
and
I
will
be
your
host
for
the
day.
Let's
talk
about
the
agenda,
we're
gonna
have
some
latest
updates.
We're
gonna
talk
about
independent
publisher,
connectors,
we're
gonna,
see
some
amazing
information
on
all
of
our
script.
A
Samples
as
well
as
team
samples,
power
platform,
samples
and
then
it'll,
come
to
the
time
for
picture
mode
together
mode
where
everyone
loves
to
turn
on
their
camera
and
wave
hello
to
the
community,
and
we
love
to
see
your
support.
So
we
look
forward
to
that
and
then
of
course,
we've
got
two
amazing
presenters
for
the
day,
luisa
freese
she's,
going
to
show
us
provision,
genie,
v,
3.0,
localization
and
accessibility,
and
then
chris
kent
is
back
warrior
horses
strike
back,
so
we
look
forward
to
all
there
is
for
list
formatting.
A
Let's
talk
a
little
bit
about
opportunities
to
participate
in
the
community.
There
are
many
and
we
would
love
to
see
you
do
that.
One
of
the
most
popular
is
exactly
what
you're
going
to
see
today.
You
can
demo
a
solution
or
a
technical
pattern
on
this
or
one
of
our
other
community
calls,
and
we
absolutely
would
love
to
see
you
do
that.
In
fact,
we've
made
a
little
form
for
you
to
fill
out
super
easy.
A
You
can
request
a
demo
spot
aka
dot,
ms
forward
slash,
m365
pnp,
slash,
request,
slash
demo,
it
just
rolls
off
the
tongue
so
definitely
submit
that
form.
If
you'd
like
to
provide
a
demo
on
these
calls
now
you
can
also
contribute
on
github,
maybe
a
little
scary.
We've
got
your
back.
We're
gonna
provide
some
coverage
on
how
you
can
take
advantage
of
doing
that
and,
of
course,
we'd
love
to
hear
feedback,
so
whether
it's
positive
or
improvement
feedback.
A
We
just
ask
you
to
keep
it
happy
and
and
positive
for
us,
so
we
can
ensure
that
we're
doing
the
best
possible
job
for
the
community.
Let's
take
a
look
at
all
of
those
resources
in
one
slido
links
as
patrick
calls.
It
we've
got
a
collection
of
videos
for
you,
developer
and
community
videos
in
which
you
can
consume
information
and
see
how
others
are
using
the
technology
that
you
as
well
are
using
every
day
aka
ms
forward
slash,
m365
dev
youtube
and
ak
dot,
ms4
m365
pnp,
slash
videos.
A
We
also
have
a
lot
of
open
source
tools
and
initiatives
and
programs
that
you
can
take
advantage
of.
You
can
see
them
at
a
variety
of
github
locations,
sharepoint
pnp
office,
dev,
microsoft,
graph
and,
of
course,
we're
going
to
see
a
lot
about
our
sample
repositories.
There
are
many
many
samples
and
these
samples
are
really
really
fantastic
for
you
to
start
learning
to
start
using
a
basis
for
maybe
a
production
worthy,
a
web
part
or
extension
or
solution
within
your
tenancy.
So
don't
hesitate.
Take
advantage.
A
You
need
to
remember
only
one
url,
aka,
ms4
m365
community
will
give
you
access
to
all
of
these
tools
and
resources
at
no
cost.
They
are
absolutely
free
and
open
source
available
to
you
today
and
if
you're
enjoying
these
community
calls
well
there's
more.
We
got
lots
of
community
calls
for
you
to
take
advantage
of.
The
top
community
call.
Is
the
microsoft
365
platform
now
this
is
a
weekly
call
that
occurs
on
tuesdays
and
all
of
our
presenters
in
this
call
is
microsoft,
employees,
so
you're
going
to
see
product
managers
and
program
managers.
A
A
We've
got
a
host
of
other
calls
as
well:
adaptive
cards,
microsoft,
identity
platform,
office,
add-ins
power
platform,
which
is
a
monthly
call
occurring
in
two
weeks,
and
then,
of
course,
the
bi-weekly
calls
that
you're
part
of
right
now,
microsoft,
365,
empower
platform,
development
which
you're
on
today
in
viva
connections
and
sharepoint
framework,
which
will
be
next
week
at
this
exact
same
time.
They
are
bi-weekly,
you
can
access.
All
of
these
calls
at
aka.ms4
m365.
A
Slash
calls
now
we're
going
to
provide
a
number
of
opportunities
in
which
you
can
engage
you've
seen
some
of
them
already
we're
going
to
provide
more
detail
on
some
of
them
soon,
but
you
may
be
a
little
unsure
of
how
to
do
that.
For
example,
I
want
to
submit
a
sample,
but
how
do
I
interact
with
github,
not
quite
sure,
what's
a
pull
request?
Well,
we
got
you
covered
sharing.
A
Is
caring
is
a
program
that's
here
to
provide
hands-on
guidance
for
you,
and
that
means
that
we're
going
to
walk
you
through,
together
in
a
live
safe
space
session,
how
to
accomplish
a
variety
of
these
things?
It's
not
recorded,
so
you
can
ask
any
and
all
questions
that
you
would
like
without
fear
of
feeling
like
well.
Should
I
be
asking
that
question?
I'm
really
not
sure.
Should
everyone
know
that
we
want
you
to
ask
any
and
all
questions,
so
we
don't
record
any
of
the
sessions
to
make.
A
We've
got
august
and
september
dates
coming
up
for
our
two
newest,
which
is
writing
for
the
web
and
power
platform
samples
contributors.
So
please
take
advantage
of
this
we're
starting
to
schedule
more.
It's
been
a
summer
break,
so
we
know
it's
been
a
little
slow,
but,
as
folks
come
back
from
summer,
you're
going
to
see
more
dates
opening
up
soon
and
of
course
we
want
to
recognize
you
for
all
the
amazing
work
that
you're
doing,
and
that
is
why
we've
started
the
recognition
program
now.
A
This
is
a
program
that
provides
official
and
formal
accredited
awareness
and
recognition
for
the
work
that
you're
doing
we're
powered
by
credly,
which
means
that
you
get
those
official
badges
that
you
also
get.
When
you
get
a
microsoft
certificate
or
certification,
they
can
be
associated
on
linkedin.
You
can
share
them
on
twitter,
put
them
on
the
fridge
share
them
with
mom
share
them.
With
your
friends
show
them
to
your
clients,
show
them
to
your
bosses.
A
It
is
a
way
that
you
can
show
that
you're
making
a
difference
in
a
formal
and
official
way
in
the
community.
We
do
need
you
to
opt
in,
but
there
is
no
cost.
We
cover
all
the
cost,
aka
dot.
Ms
four
m
three
six
five
p
and
p
dash
recognition,
and
you
only
need
to
do
that
once
so,
don't
feel
like
it
has
to
be
annual.
You
may
have
seen
some
of
those
badges
coming
out.
A
We
try
to
process
them
at
least
once
or
twice
a
month,
so
we've
got
even
more
showing
up
the
next
few
days
and
in
fact
I
know
I've
seen
some
some
new
ones
getting
badges
like
mr
todd
clint.
So
take
a
look
at
those
emails.
If
you
haven't
already
gotten
them,
they're
going
to
be
going
out
again
this
week
in
the
next
couple
of
days.
A
We
also
have
a
number
of
initiatives
we're
going
to
cover
now,
so
we
have
microsoft.
Graph
toolkit
seb
is
out
on
leave
right
now,
but
this
is
a
fantastic
initiative
and
program
that
you
should
be
learning
more
about
if
you're
interested
in
the
graph.
They
are
components
that
allow
you
to
integrate
the
graph
with
almost
no
coding,
absolutely
absolutely
priceless.
If
you've
not
worked
with
it,
you
can
learn
more
at
aka
dot.
Ms
forward
slash
mgt
next
up
is
independent
publisher,
connectors
I'll
hand
it
over
to
natalie.
B
Independent
publisher,
connectors
are
power
platform
connectors
that
anyone
can
contribute
to.
So
we
have
53
awesome,
independent
publishers,
158
independent
publisher,
connect
today
and
in
terms
of
new
connector
submissions.
We've
recently
in
the
past
two
weeks
received
one
for
the
microsoft
partner
center
and
for
snowflake,
which
I
know
a
lot
of
people
have
been
waiting
for.
B
So
renee
has
built
that
connector
and
troy
has
built
three
connectors
database
moose
end,
and
we
also
got
three
updates
to
existing
connectors
chandra,
who
originally
built
notion
has
extended
that
and
troy
has
extended
the
two
connectors
that
he's
built
in
the
past
quick
base
in
school
if
you've
never
built
an
year
in
the
past
and
you're
interested
in
learning.
How
to
do
that?
B
I
just
did
an
excellent
learning
module
that
we
have
feel
free
to
check
that
out,
try
it
out,
but
if
you've
unfortunated,
independent
publisher,
connector
and
submit
it
and
publish
it,
feel
free
to
do
so
in
our
github
repository
and
if
you're
for
connector
to
to
build
and
you're,
not
sure
which
one
to
choose
feel
free
to
go
into
the
top
connector
asks
in
our
github
repository
as
well.
Thanks.
So
much
everyone.
A
Awesome,
thank
you.
Natalie
really
appreciate
that.
Another
program
we
have
is
script
samples.
Now
this
is
one
of
the
more
popular
because
it's
so
broad
in
the
opportunity
to
contribute,
there's
now
158
scenarios
and
242
scripts,
and
this
covers
using
microsoft,
graph
cli
for
microsoft,
365,
pnp,
powershell,
sbl
management,
shell,
so
much
more
and
all
these
scripts
get
bubbled
up
into
the
unified
solution
gallery
at
adoption.microsoft.com.
A
So
don't
hesitate
to
not
only
look
at
these,
but
also,
if
you've
built
little
sample
scripts
that
have
been
useful
or
utility
scripts.
This
is
the
place
where
you
absolutely
can
share
them
and
earn
your
badge.
We
absolutely
would
love
to
see
them.
You
can
learn
more
at
aka
dot.
Ms
forward
slash
script
dash
samples
next
up
is
microsoft.
Team
samples
with
bob
german.
C
All
right
thanks
very
much
it's
good
to
be
here.
I
don't.
Unfortunately,
we
don't
have
any
new
samples
this
week,
but
we're
always
looking
for
one.
If
you
have
a
sample
you'd
like
to
contribute.
That
would
be
great
got
contacted
last
week
by
I
did
by
teams
engineering
asking
if
it
was
possible
to
get
the
samples
upgraded
to
the
new
version
of
the
javascript
sdk.
C
Now
the
new
version
it.
You
know,
the
old
version
still
works,
but
I
can
understand
that
the
new
version
is
a
lot
nicer
and
where
a
lot
of
people
build
things
on
top
of
our
samples,
it
would
be
great
if
they
use
the
new
sdk.
So
there's
some
links
here
if
you're
looking
for
a
way
to
contribute
and
I'm
planning
to
update
my
own
samples,
but
if
you're
looking
for
a
way
to
contribute-
and
you
don't
have
an
idea
for
a
new
sample-
consider
upgrading
one
of
the
existing
samples
to
the
new
sdk.
C
A
Awesome
thanks
bob
yeah
and
pasted
that
link
in
the
chat,
but
it
is
ak
dot.
Ms
slash
teams
dash
samples
for
those
that
would
like
to
access
that
repositories.
Thank
you.
Bob
great
work,
everybody
all
right.
Next
up
is
power
platform
samples.
We
have
our
very
own,
luisa
freeze,
who
is
going
to
be
demoing.
Today,
she's
created
a
progress
bar
component
for
powerapps,
very,
very
slick
component.
That
shows
really
really
cool
ways
to
utilize
those
progress
bars
and
then
a
power
automate
sample
from
raman
ahmadi
for
getting
terms
from
the
term
store.
A
A
All
right,
a
couple
more
seconds
for
everybody,
show
your
cameras
feel
free
to
share
those
cameras,
got
a
few
more
seats,
filling
in
all
right,
all
right,
good
good.
Let's
get
all
right,
we're
still
filling
in
everybody.
Still
a
few
more
seats,
all
right!
Okay,
let's
go
and
wave
to
the
community.
Tell
everybody!
Do
a
little
seb
right
got
some
more
showing
up
excellent!
You
all
look
fantastic
great
to
see
such
a
vibrant
and
active
todd's,
doing
the
dance
all
right,
excellent,
very,
very
good!
A
A
D
Perfect
looks
great,
looks
great,
that
is
cool,
okay,
so
hi.
I
would
like
to
talk
about
provision
genie
version,
3.0
focus
this
time
on
accessibility
and
localization.
Very
few
words
about
myself,
hi,
I'm
luisa,
I'm
an
m365
and
power
platform
consultant,
I'm
independent.
I
work
from
germany,
I'm
an
mvp
in
both
m365
development
and
business
applications.
D
A
couple
of
weeks
ago
we
launched
version
3.0,
and
that
was
a
major
progress,
because
now
we
do
support
three
themes:
for
teams
like
default,
dark
and
high
contrast
notes.
We
have
localization
in
12
languages,
you
can
add
onenote
notebook,
two
channel
and
you
can
pin
lists
and
libraries
to
our
channels
as
a
tab.
D
So,
as
today
is
all
about
accessibility
and
localization,
you
can
find
the
full
release
notes
at
provisiong.com.
I
will
add
the
link
later
to
the
chat
as
well,
but
you
will
find
this,
but
speaking
about
localization,
so
it
is
really.
We
already
have
12
languages,
just
like
from
danish,
finnish,
portuguese,
even
japanese,
so,
and
that
really
looks
cool
so
for
european.
This
really
looks
cool
if
you're
not
used
to
that
so
hello
to
everyone
who
speaks
japanese
and
thanks
to
our
translators.
D
But
how
does
that
work?
So
how
can
you
make
that
happen
that
you
have
12
languages
and
a
powerapp
so
as
our
data
already
sits
in
dataverse,
because
that
is
just
like
really
the
preferred
way
of
doing
this?
In
a
powerapp,
we
have
a
special
table
called
localization
and
in
this
table,
admins
can
decide
which
languages
they
want
users
to
choose
from.
So
if
spanish
and
english
make
sense
in
your
market,
then
you
can
just
like
limit
the
choice
to
those
two
languages.
D
If
you
want
to
have
just
like
a
full-blown
application
and
have
all
languages
available,
that's
up
to
you
as
an
admin
genie
will
then
pick
up
the
local
just
like
the
language
from
the
team's
context
and
provide
this
in
the
language
that
teams
is
running
in
with
a
fallback
language.
That
is
english.
If
the
language
that
teams
runs
in
is
not
supported
yet,
but
users
can
also
override
that
choice.
So
if
they're-
I
don't
know,
teams
runs
in
english,
but
they
want
to
display
genie
in
finnish.
D
They
can
absolutely
do
that
because
it
is
their
choice
to
do
so
and
how
we
did.
That
is
pretty
flexible
and
it
also
ensures
the
performance
of
the
app,
because
you
can
imagine
if
we
always
needed
to
call
just
like
a
lot
of
values
from
an
external
database
which
database
still
is
so
it's
not
locally
available
in
the
app.
Then
they
would
just
like,
add
massive
delays.
D
So
we
use
a
collection
to
display
only
the
language
that
is
currently
selected,
and
then
we
use
a
lookup
function
so
that
we
do
not
have
just
like
a
lot
of
nested.
If
statements
to
determine
in
which
language
we
are
now
in,
that
makes
sure
that
if
we
later
add
new
languages
that
we
do
not
need
to
change
our
canvas
application
at
all
anymore,
so
a
little
call
to
action.
D
If
you
speak
a
language
fluently
that
is
not
listed
on
the
left
hand,
side
of
the
slides
and
you're
willing
to
help
translate
provision
genie,
then
please
do
reach
out
to
me.
Okay.
So
how
do
we
make
this
magic
happen?
First,
catalog
guys
all
like
really
all
texts
of
the
application.
This
includes
text
that
are
printed
to
the
screen,
but
also
just
like
error
messages,
warning
messages
and
so
on.
D
Then
have
them
all
translated.
We
used
just
like
a
just
like
super
simple,
excel
sheet
for
that
and
then
upload
this
axle
sheets
data
to
dataverse.
So
first
I
tried
to
import
this
later.
I
got
the
just
that
this
would
better
work
with
the
data
flow,
because
once
data
is
updated
in
an
excel
sheet,
because
I
don't
know
some
values
change,
because
someone
found
a
more
elegant
translation,
then
of
course
that
should
be
updated
as
well.
D
D
So
what
you
can
see
is
power
app
studio
and
I
already
opened
provision
genie
and
I
want
to
show
you
what
happens
so
we
have
here
a
simple
text
label
and
this
text
label
of
course,
has
a
text
property
and,
as
you
can
see,
it
uses
a
lookup
to
a
collection
and
then
it
asks
for
a
key
which
says:
label
welcome
and
it
returns
a
value.
So
let's
see
what
happens
and
where
this
collection
is
is
being
collected
and
what
is
that
value
about?
D
D
D
It
sets
the
display
language
to
a
variable,
and
then
I
say
I
want
to
clear:
collect
into
a
collection
called
call
language,
and
I
want
to
filter
my
localizations
table
and
the
language
should
be
the
same
than
the
selected
language
from
my
drop
down
menu.
Okay.
So
for
that
we
would
need
to
know
yeah.
But
what
is
the
localizations
table?
The
localizations
table
is
something
that
I
prepared
for
you
here.
So
that
is
a
view
of
the
localizations
table.
It
sits
in
dataverse,
as
you
can
see,
and
we
have
a
key.
D
We
have
a
value
and
we
have
the
language.
So
if
I
want
to
search
for
something
just
like
look
up
something
that
is
lbl
welcome,
so
that
I
would
need
to
scroll
down
or
set
a
certain
filter
to
that.
But
then
it
already
knows
the
language,
because
I
searched
my
localization
table
into
this
collection,
so
only
the
so
that
I
only
get
the
data
that
I
really
need,
which
makes
the
app
faster
as
well,
and
then
I
would
return
this
a
value
here.
D
Okay,
so-
and
that
means
that
every
single
text
that
is
displayed
in
the
application
works
like
that.
So
there
are
no
hard
coded
texts
inside
of
this
app,
not
even
error
messages
or
warning
messages,
but
every
every
single
text
sits
in
the
localization
table
in
data
version
is
then
being
collected
into
a
local
collection
with
this
drop
down
menu.
So
I'm
switching
to
another
language
and,
as
you
can
see,
the
entire
app
already
changes
again.
D
D
But
in
this
demo
I
chose
to
show
off
all
the
languages,
because
we're
very
happy
to
have
them
in
here
and,
as
my
netherlands
is
not
as
good
as
it
should
be,
I
will
switch
to
english
again
and
include
this
pop-up
again.
So,
as
you
can
see,
everything
is
localized
and
works
like
a
charm,
and
it's
even
fast,
because
we
only
collect
this
locally
when
we
choose
or
select
the
language
and
by
default
it
checks
which
language
is
in
teams
and
gets
of
this
context
and
defaults
to
english
if
the
language
is
not
available.
D
Okay
next
thing
next
thing
would
be
accessibility
in
our
in
our
application.
So
we
feel,
like
accessibility,
is
not
a
luxury
thing
that
you
should
add
on
top
to
an
existing
app,
but
it
should
really
be
one
of
your
major
design
goals,
and
this
is
why
we
really
invested
very,
very
massively
into
accessibility,
and
I
would
like
to
show
you
what
that
means
to
us.
So
first,
is
you
already
I
I
hinted
this
already.
D
Second
thing
is:
we
have
a
screen
reader
and
keyboard
only
supports,
and
we
do
this
in
a
way
that
we
have
always
the
accessible
label
property
for
all
controls
fields
and
in
these
as
well.
We
use
the
lookup
function
to
do
this
in
our
12
languages.
So
it's
not
that
the
accessible
label
is
only
available
in
english,
but
we
want
to
make
provision
genie
available
to
more
and
more
and
more
people,
and
that
is
why
all
the
comms
is
then
available
in
our
languages.
We
made
use
of
the
role
property
of
all
text.
D
So
it
ties
into
the
localization
thing
as
well,
which
is
why
we
chose
to
present
this
at
the
same
time:
okay,
a
quick
demo
of
accessibility.
So
I
opened
I
open
provision
genie
already
in
teams,
so
provision
genie
can
work
as
a
standalone
app,
but
you
can
also
run
it
as
a
personal
app
in
teams.
So
this
is
what
I
did
right
here.
You
can
see.
I
run
teams
in
the
web
client
right
now
in
the
dark
mode.
So
but
not
everyone
runs
teams
in
dark
modes.
D
D
And
yes,
thank
you
thank
you
for
that,
then
you
can
see
this
runs
in
high
contrast
mode
as
well
and
for
everyone
who
does
not
work
on
a
regular
basis
with
high
contrast
theme.
This
could
look
a
little
bit
ugly
to
you.
So
maybe
it's
just
like
uncommon
for
you,
but
trust
me
for
everyone
who
needs
a
higher
contrast.
This
is
just
like
really
the
way
of
consuming
and
interacting
with
apps,
and
also
it
makes
sure
that,
additionally,
to
that
to
that
theme
we
have
a
screen.
D
D
So
this
is
mostly
for
debugging
and
development
purposes,
because
mostly
people
will
not
overwrite
this,
but
they
can
do
so,
and
then
I
defined
all
my
app
colors
and
I
refer
to
all
those
app
colors
in
something
that
I
call
the
global
app
styles.
So
you
can
see
for
each
and
every
single
control
that
I
have.
D
I
always
have
three
values:
one
for
dark,
one
for
default
and
one
for
high
contrast,
notes
and
then
a
simple
text
label
like
that,
so
we
already
determined
it
has
a
text
property,
but
that
has
of
course
also
a
color
property
and
you
can
see
it's
globalab
styles.label.color
and
in
this
preview
it's
shown
that
here
in
default
node.
This
is
black-ish,
I
would
say
so
what
happens?
D
D
A
Very,
very
cool,
luis.
Thank
you
for
sharing
that
I
love
how
inclusive
that
is
a
dozen
languages.
That's
impressive
accessibility
is
an
important
thing.
Thank
you.
Provision
genie
is
granting
wishes
just
like
that
right,
so
we
we
want
to
appreciate-
and
thank
you
for
that.
Okay
next
up
is
chris
kent
with
list
formatting
and
a
bunch
of
horses,
we're
waiting
chris.
E
Wow
that's
my
face.
None
of
this
is
me,
but
that's
my
face
all
right.
So
hey
everybody,
I'm
chris
yeah,
I'm
gonna
talk
to
you
about
some
list,
formatting
stuff
today
very
exciting.
So,
let's
head
on
over
to
our
classic
warrior
horses
site
that
we
all
have,
of
course
good.
So
we're
on
our
war,
horse's
side
and
the
warrior
horses
have
put
together
a
very
short
list
of
elite
warriors
all.
B
E
So
we
have
this
elite
warriors
list.
What
they're
actually
doing
is
not
that
important
right,
but
the
idea
is
they're,
just
tracking
some
things
here
and
what
they've
run
into
is
they've
got
a
manager,
that's
decided
they
don't
like
how
this
looks.
I'm
like.
Oh
there's,
the
weird
gray.
We
use
brown
everywhere
else,
there's
a
weird
gray.
I
don't
like
that.
I
want
it
to
be
all
these
other
colors
right.
So
now
we
can
do
some
things
like
that.
E
Now,
we've
seen
this
before
we
go
into
format
our
current
view,
and
if
we
go
to
advanced
mode,
we
can
do
what's
called
an
additional
row
class
and
what
I
want
to
show
you
with
that.
Well,
first
off
we
don't
want
an
object.
We
want
a
expression
here,
all
right,
so
we
could
easily
say
you
know
in
this.
What
is
it
bg
color
and
we
could
say
red,
just
cuz,
we're
like
here
you're
like
pretty
there's
pretty
right.
There's
the
prettiest
thing
possible
right
and,
and
that's
not
so
pretty
right.
E
We
want
to
do
this
a
little
more
carefully.
Now
we
can
pad
expressions
here
right.
So
we
could
add
an
expression
to
determine
you
know
what
those
should
be
and
so
on,
but
I
want
to
look
at
a
fairly
new
placeholder
that
can
help
us
with
this
right.
So
in
this
case
we
want
to
say
you
know
the
the
background
color
is
going
to
be.
E
I
don't
know,
let's
pick
one
out
we'll
say
theme
lighter
so
msbg
color,
we'll
just
go
neutral
lighter.
That
sounds
good
all
right.
So,
instead
of
that
white
bracket,
we
went
to
this
slight
gray
background
and
that's
okay
right,
but
now
we've
matched
our
hover
color
like
dang
it
right
now
we
don't
have
the
hover
and
that's
kind
of
annoying.
So
now
we
could
add
our
own
color
right
here.
For
that
we
can
say.
E
Ms
eg
color,
you
know
we'll
say
theme
lighter
dash,
dash
hover
right
and
we
do
something
like
that.
Now
we
get
now,
we've
got
our
home
cover
some
public
color.
I
got
our
own
custom
background
color
and
that's
nice
right
and
then
we
run
into
this.
You
know
I
select
an
item
and
well
now
we
don't
run
into
an
issue.
Apparently
it
was
supposed
to
be
the
wrong
color.
Oh
there
it
is
okay.
So
now
we
get
the
wrong
color
right.
E
So
if
I
were
to
take
the
same
kind
of
thing
here
and
I'm
just
going
to
cut
that,
so
I'm
just
typing
again
and
I
can
say,
equals
I'm
going
to
write
an
expression
and
say:
if-
and
I
can
look
at
at-
is
selected
keep
in
mind.
The
is
is
all
lowercase
and
selected
as
capital
s,
but
this
is
going
to
return
a
true
or
false
value,
based
on
whether
it's
selected
or
not,
and
so
now
I
can,
you
know,
type
in
some
things
here.
E
So
if
it's
selected
I'm
going
to
do
something,
but
if
it's
not
we'll
keep
what
I
had
before
right.
So
now,
when
it's
selected
we're
not
doing
that.
But
let's
add
some
other
things
here.
So
I'm
going
to
say
msbg
color,
we'll
go
theme
light
makes
it
selected
is
our
case
sensitive
all
right
theme
light
and
let's
just
see
what
that
looks
like
for
a
second
right.
E
So
now
we
can
see
now
we're
selecting
setting
a
selected
color
remember
if
we
want
to
override
so
it
doesn't
hover
anymore,
because
it's
not
selected,
you
know
we
could
come
in
here.
We
could
say
msbg
color
theme,
light
dash
cover
all
right,
then,
when
we
do
that
now
we
shouldn't
get
that
anymore.
So
that's
kind
of
cool.
So
now
we're
controlling
a
little
more
of
the
experience
right.
If
we
want
to
go
a
little
further,
we
could,
where
am
I
getting
these
classes
from?
E
So
if
you
head
over
to
our
list
formatting
repo
and
you
click
on
this
link
over
to
the
right
now,
we've
got
this
site
with
some
documentation,
some
other
groupings
and
things
and
the
way
I
use
this
all
the
time
is.
I
use
the
groupings
and
I
go
down
by
class
and
I
literally
use
this
to
find
out.
What
can
I
say?
Oh
I
want
to
find
out
backgrounds.
Well,
here's
some
msbg
colors,
like
we
just
looked
at,
I
can
see
there's
a
bunch
of
name.
E
Colors,
there's
also
theme
colors,
all
right,
there's
the
neutral
colors
all
of
these
are
in
here
and
I
can
use
these
to
help
me
determine
what's
available.
Alright,
you
can
see
I've
got
other
things
like
what,
if
I
want
to
slap
a
border
on
there
right.
So
we
come
down
here
and
we
got
these
like
sp
field
border
right.
So,
let's,
let's,
let's
take
one
of
those,
so
sp
field
border
all
dotted
sounds
exciting
all
right,
so
maybe
we
ought
to
add
it
when
you're
selected.
E
Actually,
let's
try
a
different.
Let's
try,
there's
a
couple
of
these
sb
field
order
all
dotted
and
that
one
was
on
here.
It's
just
in
the
sp
field,
border
yeah!
That's
what
it
is
all
dotted.
That's
we
got
that
let's
pry
it
so
preview
that
so
now
now
you
notice
there's
some
weird
things
where
they're
actually
doing
a
thing
where
they're?
E
Actually,
they
didn't
quite
do
the
border
sizing
right,
but
you
know
the
idea
is
we
can
start
applying
classes,
we
can
do
so
based
on
selection
or
not,
and
that's
pretty
cool
right,
so
we'll
save
that
and
we
can
do
the
same
thing
in
our
column
format.
So
if
we
come
over
here,
I've
got
a
column
format
here
on
the
horse.
E
E
We
wanted
to
do
something
a
little
more
elaborate
here
in
this
case,
and
now
we've
got
that,
but
we
could
come
in
here
and
we
could
even
use
that
the
same
kind
of
pattern
so
app
if
at
is
selected
right
then
we
can
say
add
to
the
url
sitting
right.
Otherwise,
just
leave
it
alone
all
right.
If
we
preview
that
and
we'll
save
it,
oh
well,
we
have
to
put
a
plus
symbol
here,
real
card
formula.
E
Let's
preview
that
see,
if
that's
right,
I'm
going
to
refresh
I've
had
a
couple
of
issues
today
with
my
stuff
there
we
go
perfect
so
now
we
can
see
that
now
the
horses
will
sit
down
whenever
we
selected
them,
because
they're
ready
to
be
doing
something
with
them
and
that's
very
exciting.
But
the
idea
here
is
you
know:
is
that
particularly
practical
right
now?
E
No,
but
you
could
find
probably
lots
of
use
cases
where
this
would
be
very,
very
practical
right,
the
idea
of
being
able
to
indicate
when
something
is
selected,
whether
it's
in
your
view,
format
and
so
on.
A
couple
things
to
know
with
this
is
this
only
works
if
selection
is
enabled.
So
if
you
hide
that
selection,
you
have
no
way
to
select,
and
there
was
nothing
to
be
selected.
I've
also
seen
some
weird
stuff
like
you'll
see
here.
E
Like
you
see
this,
where,
if
I'm
not
selecting
the
select
button,
I
don't
get
my
same
quite
the
styles,
the
columns
I'll
get
it
it's
that
additional
row
class.
It
doesn't
seem
to
be
evaluated
quite
right,
but
if
I
hit
edit
it
does
get
re-evaluated.
So
there's
a
couple
of
the
weird
things
with
the
additional
row
class
and
the
is
selected
and
how
that's
been
evaluated,
but
otherwise
you
selected,
you
know,
evaluates
immediately
and
the
idea
here
is.
You
could
use
this
to
indicate
when
you're
customizing
say
the
ribbon
up
here,
not
ribbon.
E
Sorry
oops,
oops
command
bar
when
you're
customizing
the
command
bar
right,
you're
doing
certain
things
with
selection.
You
may
want
to
indicate
you
know
various
things
that
could
happen
here
to
say
like
oh,
this
one
is
going
to.
If
you
hit
delete
on
this
one
right,
it's
going
to
be
doing
something
here.
You
could
even
change
the
button
text
based
on
what
has
been
selected
and
so
on.
So
you
can
see
that
now
we've
got
an
extra
tool
in
our
tool
belt.
All
right!
So
that's
for
is
selected.
So
that's
really
exciting.
E
Okay.
Now
let
me
make
sure
that
that
went
very,
very
fast,
so
good
news
is
I've
got
something
else.
We'll
show
you
too
just
for
funsies
here
all
right,
so
that
was
the
the
primary
demo.
But
let's,
let's
look
at
one.
That
is
we're.
Gonna
do
on
the
fly.
Just
for
fun
here,
okay,
so
what
we're
gonna
do
on
the
fly
here
is:
there's
a
new
custom
action
here
and
we're
gonna
take
a
look
at
it.
So
what
if
you
were
saying
like
the
title
class
like
this
is
cool.
E
I've
got
these
extra
things,
but
you
know
what
I
really
want
to
do.
Something
where
I
want
to.
I
want
to
change
this
slightly
based
on
the
formula
right,
so
we're
going
to
invent
an
arbitrary
formula
here,
we're
going
to
format
this
column.
Let's
go
advanced
and,
let's
just
say,
let's
put
a
div
in
there.
E
That
sounds
exciting,
all
right,
div
and
then
we'll
say
our
attributes
just
to
make
this
look
the
way
we
want
we're
gonna,
add
a
class
on
there
and
we're
going
to
say
this
is
the
ms
font
color
neutral
primary
and
then
usually
I
start.
I
very
rarely
have
things
in
the
primary
thing.
I
usually
create
children
just
because
it
saves
you
steps
later
right.
E
So
if
you
just
kind
of
have
a
wrapper
div
up
at
the
top
and
then
anything
you
actually
want
to
put
in
there,
you
put
in
the
children
that
gives
you
a
lot
more
flexibility
and
so
on.
But
in
this
case
we're
going
to
say
this
will
also
be
a
div
and
we'll
just
say
our
text
is
our
text
content,
oops
text
content,
we're
going
to
say
is
the
current
field
right,
so
that'll,
take
whatever
the
title
value
is
review
that
okay,
so
you
see
we've
just
done
that.
E
That's
interesting
right,
we've
lost
some
things
and
if
we
wanted
to
like
the
whole
reason
we
wanted
to
do,
this
right
was
to
have
something
happen.
So
let's
go
to
our
attributes
again
and
we're
going
to
throw
a
class
on
here
we're
going
to
do
an
expression
for
a
class
right.
So
we're
going
to
say
if
we'll
go,
what
starts
with
the
current
field?
Give
this
a
little
arbitrary,
but
if
it
starts
with
a
c,
let's
do
an
ms
font,
color
of
green
and
an
ms
font
weight
of
bulb
all
right,
we'll
make.
E
Just
leave
it
alone
all
right,
but
the
idea
here
is
now
we're
there.
We
go
so
we're
trying
to
do
something
where
we're
trying
to
reuse
this
title
field
right
we're
trying
to
do
some
kind
of
expression,
but
you'll
notice.
We
just
lost.
You
know
some
of
those
things
we
had
where's
our
dot
menu
with
the
context
menu
right.
We
know
we
can
right
click
and
get
a
context
menu,
but
that's
it's
a
hassle
doesn't
show
things
right,
where's
our
share
button,
a
couple
other
things
that
we
had
before.
E
E
And
we'll
go
here,
we're
going
to
go
icon
name
and
we
need
an
icon.
So
actually
I've
got
flanking
up.
Let's
see,
I
don't
remember
what
that
thing's
called
say:
dots
there
we
go
dots,
so
it's
called
more
vertical
okay-
and
I
will
tell
you
more
about
this,
but
let's
come
back
here,
so
we're
just
going
to
paste
that
in
here
more
vertical
all
right
and
what
does
it
not
like?
What
did
I
do
tributes
additional
attributes
to
be
added
to
home
type?
E
Let's
see,
I
got
a
name,
I
don't
know,
let's
just
grab
all
this
and
find
out
what
do
you
not
like
it
likes
all
that?
So,
let's
just
paste
that
in
oh
cause,
I
didn't
do
it
as
the
right
spot.
There
we
go
we'll
face
it.
There
all
right
turns
out.
You
have
to
format
your
stuff
correctly.
There
we
go
so
now,
let's
preview,
let's
format
that
so
we
can
see
it
look
a
little
prettier
all
right,
but
now
you
can
see,
we've
got
these
three
little
dots.
E
I
don't
know
if
you
can
see
them
they're
real
tiny.
There
see
three
dots.
Okay.
So
now
we
got
three
dots.
Let's
make
that
just
look
a
little
better
because
that's
going
to
drive
me
nuts,
otherwise
so,
let's
add
a
style
here
and
we're
going
to
add
this
as
a
display
we'll
make
this
a
flexbox,
so
I'll,
say
flex
and
we'll
say,
justify
content
and
we'll
call
this
space
queen.
That
should
help
us
yeah
moves
that
little
menu
over
to
the
right.
So
that's
exciting!
E
E
I
just
happen
to
know
some
of
them.
So
now
I've
made
the
button
bigger
and
now
you
can
see
it
changes
color
slightly
to
red
when
we
hover
over
it.
So
that's
exciting
right.
In
fact,
we
want
to
do
something
a
little
further,
we're
going
to
say
our
style
in
this
case,
we're
going
to
say
a
cursor
and
let's
put
that
to
a
pointer,
so
it
because
obviously
we
should
be
able
to
do
something.
With
that
there
we
go
now.
We've
got
a
little
bit.
E
We
still
can't
do
anything
so
we're
still
confusing
people,
but
here's
now
what
we
can
do
now
we
can
actually
say
custom
row
action.
Oh
yeah
yeah,
this
action
and
the
action
here
in
this
case
is
going
to
be
open
context,
menu
all
right.
So,
let's
preview
that
and
so
now
there
we
go-
we've
restored
the
three
dots
menu
and
we've
got
our.
You
know
our
our
expression.
Here
we
could
add.
We
could
add
one
more
button
here
to
add
that
share
button
back.
We
could
even
add
one
for
the
comments
right.
E
We've
even
got
some
samples
on
how
to
get
comment
counts
if
you
wanted
to
change
that.
So,
instead
of
add,
comment
actually
show
the
comment
count
and
so
on.
So
you
can
start
to
recreate
that
title
field
or
whatever
the
field
you're.
Looking
for
and
put
that
in
there
you
know-
or
if
you
wanted
to
put
this
say,
you
know
with
a
centralized
spot
with
all
your
other
buttons,
there's
a
lot
of
options
there
if
you're
using
this
open
context
menu.
So
all
right,
that's
exciting!
E
E
So
this
is
a
another
new
piece
here.
So
let's,
let's
just
we're
just
going
to
leave
that
for
fun,
we'll
move
over
to
our
primary
weapon
category.
Let's
zoom
this
a
little
bit
there
we
go
now,
let's
go
in
column,
settings
we're
going
to
change
it
here.
So
what
I'm
going
to
show
you
now
is
I'm
going
to
just
ignore
this
primary
weapon
thing.
E
I
just
need
to
call
them
to
format
on
all
right,
so
we're
going
to
say
elm
type
in
this
case
we'll
say
another
div,
because
you
know
me:
I
love
the
divs
all
right
and
then
we'll
say
our
children.
As
I
mentioned,
I
like
to
put
everything
in
the
child
because
it
comes
up
and
then
we'll
say
another
div
in
here
and
we're
just
going
to
say
our
text
content
right
is,
I
don't
know
dog
cat
lizard
right.
So
the
idea
is
that
we
can
start
to
control
stuff.
E
But
what
if
we
wanted
to
do
something
so
say
we
had
values
that
were
separated
by
something
right.
We
have
the
idea
of
a
join,
so
if
you've
got
a
multi-select
field
or
you
can
join
those
together,
so
you've
got
multiple
people
selected.
You
can
join
those
with
commas
or
you've
got
choices.
You
can
join
those.
We
have
a
new
expression
called
split,
which
is
kind
of
the
opposite
of
that,
and
that
gets
pretty
exciting
all
right,
so
we
can
say
equals
split.
This
is
again
arbitrary.
E
E
Oh,
it
doesn't
really
change
anything
okay.
So
let's
try
this.
Let's
do
a
for
each
instead
that'll
be
more
fun.
So
if
you're
not
familiar
with
four
eaches
four
each
allow
you
to
do
like
an
iterator
right,
so
you
can
see
just
like
that
iterator
and
field
name.
So
normally
you
would
do
that
with
a
multi-select
field
right.
So
we
would
give
this
we'll
just
leave
it
iterator
name.
You
can
name
that
whatever
you
want
and
then
you
would
apply
this
what's
interesting.
E
E
Now
we
go
text
content
will
equal
the
iterator
name
that
we
used
up
above
and
let's
see
if
that
works
yeah.
So
now
what's
happened
here
is
they're
all
just
being
concatenated
all
together
right.
But
if
we
were
to
change
this
to
you
know,
I
have
style,
for
instance,
so
let's
do
a
style.
Let's
do
it
this
way,
we'll
skip
the
classes.
For
now
we'll
say
border
say.
One
pixel,
solid,
yeah
paint
sounds
pretty
preview.
E
That
you
start
to
see
that
we've
actually
taken
these
and
we're
really
generating
a
separate
div
for
each
one
of
these.
So
you
start
to
see
this
becomes
really
really
powerful
pattern.
Then,
hopefully,
we'll
have
a
better
sample
of
this
soon.
You
know
that
shows
us
a
little
more
advanced
detail.
The
idea
is,
if
you
had
a
column
that
had
you
know
a
lot
of
different
types
of
things.
E
E
But
the
idea
here
is:
I'm
not
splitting
an
arbitrary
value,
but
this
could
be
coming
from
a
field
or
whatever
else,
and
then
I'm
creating
individual
elements
based
on
that
and
then
I
can
apply
conditional
formats.
I
can
do
all
sorts
of
stuff
right.
I
could
instead
of
these
are
all
being
because
by
by
default
in
these
columns
you
get
when
you
have
a
selection
on
you
get
flex
with
a
column
layout,
so
they
go
all
side
by
side.
E
So
those
behave
just
slightly
different
when
you
have
the
selection
on,
but
the
idea
here
is.
I
could
use
that
right
to
create
a
whole
list
of
items
right.
I
could
have
these
all
listed
out
separately
and
I
could
pull
that
out
and
we've
had
all
sorts
of
samples
that
have
tried
to
work
around
this
right
by
using
their
index
of
and
replacement
statements.
So
having
a
split
finally
is
really
awesome
and
the
fact
that
split
can
work
with
inside
of
four
each
really
opens
up
a
ton
of
possibilities.
E
You
know
with
a
lot
of
power
again
that's
much
more
of
an
advanced
topic
when
you
start
doing
the
for
each,
but
as
you
get
to
that,
I
think
you're
going
to
find
that
you
can
actually
simplify
your
formats
using
this
same
technique
where
I've
I'm
using
a
hard-coded
kind
of
sort
of
pseudo
array
here,
and
you
could
do
that
the
same
way
right.
If
you
want
to
create
a
collection
of
icons
or
something
you
could
split
those
all
up
and
create
those
all
here
and
then
create
that
way.
E
You
don't
have
to
write
these
massive
formats.
That
are,
you
know
five
six
hundred
lines
long.
You
could
kind
of
handle
that
altogether,
because
the
four
each
makes
this
element
into
basically
a
template
which
is
pretty
cool
and
you
could
even
wrap
in
those
is
selected
and
so
on
and
open
the
context
menu
just
to
to
pull
it
all
together,
which
is
awesome.
So
we
have
some
additional
things
coming
as
well.
E
So
there
is
an
additional
row
action
coming
to
open
the
approval
dialog,
which
should
also
help,
and
then
we
even
have
another
function
which
I'm
not
gonna.
I
won't
demo
here
because
we're
just
running
out
of
time
here
called
replace
all
so.
We've
had
replace
and
it's
been
very
irritating
because
it
just
replaced
the
first
instance
of
something.
E
So
if
you
wanted
to
replace
multiple
instances
of
something
you
had
to
just
basically
nest
or
place
and
just
hope
that
you
got
it
enough
times,
capture
that
with
the
replace
all
like,
you
would
expect
it's
a
one-liner
and
you
can
just
replace
all
occurrences
of
something
in
a
string
which
can
be
really
really
helpful
as
well,
and
we
use
that
with
split.
That's
awesome
and
there's
a
couple.
Other
array
type
functions
like
split,
so
split
can
work
across
an
array.
E
This
is
creating
an
array
of
these
values,
but
you
can
use
append
to
and
remove
from
on
those
as
well.
So
if
you're
not
familiar
with
this,
please
check
out
our
documentation,
which
you
can
imagine
david's,
probably
dumping
a
link
in
the
chat
already,
but
it's
akms,
sp,
docs
column
formatting,
is
what
that
would
be
so
aka
dot.
E
Ms
sp
docs
column,
formatting
and
if
you
haven't
checked
that
out
right,
if
you
go
to
the
advance
or
the
formatting
syntax
reference
or
you
can
find
out
all
about
those
operators
and
so
on
that
I've
just
mentioned
down
here
in
the
expressions
section
right
so
there's
a
ton
of
operators
you
can
use
those
are
those
removed
from
append2.
I
talked
about
if
you
wanted
to
start
working
with
array
type
objects,
whether
you're
saving
them
or
not,
or
you're,
just
iterating
through
them.
E
E
E
You
know
true,
or
anything
like
that-
you
just
say,
is
selected,
but
you
could
use
that
within
you
know
the
ands
or
the
ors
to
wrap
that
up
in
kind
of
an
elaborate
expression,
and
the
main
thing
is
obviously
when
you
hide
selection,
it's
it's
a
no
go
all
right.
Finally,
a
couple
of
resources
for
you
right.
So
apparently
you
go
sp,
docs
or
sp
dev,
so
that's
fun
for
the
full
documentation
and
then,
of
course,
the
icon
side
I
showed
off.
E
E
A
Awesome
chris
thanks
and
thanks
for
adding
a
little
extra
sugar
on
top
there
for
the
demos
today,
some
extra
stuff
really
appreciate
that
everybody
loves
to
see
sneak
previews
of
upcoming
and
new
functionality,
all
right,
let's
wrap
it
up.
Everybody
thank
you
again
to
luisa
and
chris
for
your
amazing
demos.
Today
we
have
more
available
to
you.
The
recording
of
this
will
be
available
in
24
hours
on
the
microsoft
365
community,
youtube
channel.
You
can
access
that
at
aka.ms
forward,
slash
m365
videos.
You
will
not
be
able
to
download
the
video.
A
If
you
see
it
in
the
chat,
don't
worry,
it
will
be
posted
on
the
youtube
channel.
You
can
subscribe
and
you'll
automatically
get
the
alerts
when
they
are
available
or
check
out
the
blogs
as
well
you're,
going
to
see
a
blog
post
on
it.
Follow
us
on
twitter,
at
microsoft,
365
dev
and
at
m365
pnp.
The
next
general
dev
call
is
two
weeks
from
today
august
18th
at
7
a.m.
Pacific
and
the
next
vv
connections
and
spfx
call
is
on
august
11th.
One
week
from
today,
7
am
same
bat
channel
same
bad
time.