►
Description
Microsoft 365 & Power Platform Development Community call on August 17th. Recap on news and updates from Microsoft and community projects, followed by demos by the community on the art of possible.
✨ Call included three awesome demos:
• Markus Möller (Avanade) - A Teams Tab enabling file conversions with Microsoft Graph
• John Aziz – Automate Business Email Management Using AI Builder and Power Apps
• Chris Kent (Takeda) – List Formatting Tips & Tricks – Formatting operators for adjusting your output
Q&A takes place as always in chat throughout the call.
Screenshot summary for this call | https://warner.digital/pnpsummary08172023/
Join the next one - https://aka.ms/community/calls
📃 Agenda
00:00 – Intro
06:25 – Latest updates
15:28 – Together mode picture
16:35 – Demo - Markus Möller (Avanade) - A Teams Tab enabling file conversions with Microsoft Graph
27:58 – Demo - John Aziz – Automate Business Email Management Using AI Builder and Power Apps
42:59 – Demo - Chris Kent (Takeda) – List Formatting Tips & Tricks – Formatting operators for adjusting your output
58:47 – Closing
📝 Learn more
• A Teams Tab enabling file conversions with Microsoft Graph blog post from Marcus - https://mmsharepoint.wordpress.com/2023/03/10/file-conversion-in-a-teams-tab-with-microsoft-graph-and-teams-toolkit-for-visual-studio-c/
• A Teams Tab enabling file conversions with Microsoft Graph solution in GitHub - https://github.com/pnp/teams-dev-samples/tree/main/samples/tab-sso-graph-file-conversion-csharp
• List formatting documentation - https://aka.ms/spdocs-column-formatting
• List formatting guidance & Tools - https://aka.ms/list-formatting
• SP Formatter extension - github.com/pnp/sp-formatter
💡 Learn more about the Microsoft 365 & Power Platform community
• Microsoft 365 & Power Platform Unified Sample gallery - https://aka.ms/community/samples
• Microsoft 365 & Power Platform Community in YouTube - https://aka.ms/community/videos
• Microsoft 365 & Power Platform - http://aka.ms/community/home
Sharing is caring! You are awesome! 🧡
A
B
Development
bi-weekly
call
we're
starting
a
little
8-bit
today.
How
do
you
like
that?
It's
August
17th
we're
in
the
back
slide
of
August
and
summer,
looking
forward
to
all
the
Fall
Foliage
that
is
going
to
be
coming
soon
and,
of
course,
all
the
exciting
updates
that
we
have
in
store
for
you
on
this
call
today.
So,
let's
take
a
look
at
our
agenda
latest
updates
on
the
community
we're
going
to
get
into
some
updates:
on.net
Powershell,
yo
teams,
Microsoft
teams,
toolkit
MGT
publisher,
connectors.
B
We're
also
going
to
see
some
samples
talk
about
some
team
samples,
Power
Platform
samples,
an
exciting
event,
that's
coming
up
in
the
Power
Platform
world
and
then,
of
course,
everybody's
favorite,
Time
picture
time.
So
get
those
fantastic
faces.
Ready
and
we've
got
three
amazing
All-Star
presenters
of
the
day,
Marcus
is
going
to
cover
a
teams.
Tab
enabling
file
conversions
with
Microsoft
graph
John
is
going
to
get
into
automate
business,
email
management
using
AI,
Builder
and
powerapps,
and,
of
course,
who
can
forget
Chris,
Camp,
Mr
list,
formatting
tips
and
tricks,
The,
Horse
Whisperer
himself
is
here.
B
So,
let's
first
talk
about
some
of
resources
that
are
available
to
all
of
you.
Absolutely
free
we've
got
videos
that
are
created
by
the
community
for
the
community
by
Microsoft
for
the
community.
It's
all
about
the
community,
everybody
and,
of
course,
we've
got
our
LinkedIn
group
for
discussions.
You
can
be
active
there
and
get
involved
collaborate
with
other
members
of
the
community.
We've
got
our
open
source
projects
like
pnpjs
and
CLI
for
Microsoft,
365
and
I
mentioned
samples.
We
got
just
a
couple,
maybe
a
couple
hundred
times
ten.
B
We
got
plenty
of
samples
for
you,
community
samples,
team
samples,
spfx
extensions,
Power,
Platform
list
formatting.
The
list
goes
on
and
on
and
on,
let's
see
what
I
did
there
list,
but
you
only
need
to
remember
one
URL
to
get
you
access
to
all
of
these
things
that
is
AK
dot,
Ms,
slash,
Community
home,
so
check
it
out,
make
sure
you
take
advantage
of
it
now
you're
here,
because
you
likely
like
Community
calls.
We
love
them
too,
and
we
got
plenty
for
you
so,
starting
out
with
a
Microsoft
365
Empower
platform.
B
Microsoft
only
speakers
call
it's
been
on
a
break
for
the
summer.
It's
been
getting
its
rest
and
relaxation
in,
but
it's
back
back
next
week.
Yes
back
again
tell
a
friend
right,
so
definitely
get
back
on
board
with
that
call.
It's
likely
already
on
your
calendar,
but
if
it's
not
then
check
out
the
AKA
dot,
Ms,
slash,
Community,
Ms
dash
speakers,
Dash
call
Dash
invite
rolls
off
the
tongue
and
you
can
get
the
in
ICS
added
to
your
calendar.
All
right,
then
we
got
our
monthly
Power
Platform
call
which
just
happened
yesterday.
B
So
if
you
weren't
able
to
see
it
check
out
the
video
already
available,
we
got
our
office
add-ins
and,
of
course,
our
sibling
calls.
These
are
both
bi-weekly
Microsoft
365
and
Power
Platform
Community,
which
you're
on
right
now
next
week,
Viva
connection
SharePoint
framework.
You
can
get
all
these
calls
at
AK,
dot,
Ms,
slash,
Community,
slash,
call
so
take
advantage
of
them
get.
Those
calendar
invites
out
of
your
calendar.
These
are
some
of
the
best
hours
you'll
spend
all
week.
I
promise
you.
B
It
will
be
worth
your
time
now,
you're
going
to
see
amazing
presenters
today
and
you
may
think
I
got
some
cool
stuff
to
share
I've
just
figured
out
how
to
create
time
travel
with
a
flux,
capacitor
I
want
to
share
it.
You
can,
and
we
welcome
you
to
so.
All
you
got
to
do
is
fill
out
AK
dot,
Ms,
slash,
Community,
slash,
request,
slash
demo
and
we'll
get
back
to.
C
B
B
Be
awesome,
so
definitely
don't
hesitate
to
take
advantage
of
it
now
I
mentioned
next
week
by
the
way
just
want
to
plug
that
next
week,
Microsoft
only
speakers
back
22nd
of
August
make
sure
you
get
that
on
your
calendar.
It
is
always
coming
directly
from
those
program.
Managers
and
product
managers,
you're
always
going
to
hear
it
first
there.
So
definitely
take
advantage
of
that.
You
can
do
that
by
using
the
URL
that
you
find
in
the
chat
as
well
as
you're,
seeing
on
the
screen
now.
B
A
Exactly
thank
you.
David
yeah,
like
David,
said,
you
might
say,
hey
Hugo
like
what
is
GitHub
you're
talking
about
using
GitHub
and
contributing
examples.
What
is
GitHub
and
I'll
say,
of
course,
how
did
you
get
in
my
house
and
how
do
you
know
where
I
live,
but
once
we've
done
that
I
will
also
say:
hey
we
have
sharing
is
caring.
Sharing
is
caring,
is
an
opportunity
for
you
to
actually
join
us
on
a
Hands-On
call.
A
Where
will
together
do
your
first
contribution,
we'll
show
you
how
to
use
GitHub
and
we'll
show
you
how
GitHub
is
not?
That's
scary,
we'll
show
you
how
to
build
your
first
Power
Platform
sample
and
how
to
contribute
to
the
Power
Platform
sample
gallery
and
we
have
a
whole
bunch
of
other
sessions.
Those
calls
are
never
recorded
so
that
you
don't
have
to
worry
about
asking
questions.
We
always
like
to
have
fun
and
once
you've
done
your
first
contribution
using
the
sharing
is
carrying
you.
Have
this
cool
thing
David.
B
I
would
love
to
thank
you
Hugo,
so
the
recognition
program,
if
you're
not
familiar
with
it,
is
a
formal
and
official
way
that
we
are
recognizing.
The
amazing
work
that
you're
doing
we're
powered
by
credly.
We're
partnering
with
credly
allows
you
to
add
these
badges
to
your
LinkedIn
account
to
your
Twitter
account
blog
account
print
them
out,
put
them
on
the
fridge,
send
them
to
Mom.
We
absolutely
want
to
recognize
you
in
a
more
formal
way.
We
are
coming
out
with
more.
B
You
may
have
seen
some
of
those
lately,
the
CLI
adaptive
card
Powershell.
This
formatting
just
got
word
that
we're
going
to
be
coming
out
with
some.net
and
other
related
ones,
and
you
know
what
we're
getting
to
the
end
of
summer
and
we
want
to
have
some
fun
everybody.
We
know
that
some
of
this
is
about
recognizing
the
work
that
you're
doing,
but
some
of
us
are
having
fun
so
who's
ready
for
PSL
season.
You
love
it
or
you
hate
it.
B
I
understand
it,
but
we're
gonna
bring
it
pumpkin
spice
a
lot
of
commits
right.
You
ready
for
it.
We're
gonna.
Have
that
plus
more
it's
gonna
be
a
fun
season,
everybody
as
we
head
into
fall
and
winter.
So
definitely,
if
you've
not
opted
in
check
out
AKA
dot,
Ms
slash,
Community
recognition,
opt-in
get
involved.
We
want
to
recognize
you
for
the
work
that
you're
doing
and
thank
you
so
so
much
all
right.
Let's
talk
about
some
Project
Specific
updates
and
we're
going
to
start
with.net
and
Bert.
D
Also,
thank
you
David.
In
it.net
space
there
was
a
lot
of
quiet
time,
and
that
is
because
you
know
well.
I
had
a
quiet
time
as
well,
so
meaning
not
much
happened.
I
have
a
backlog
of
things
to
to
process.
So
there
is
plenty
of
PRS
issues.
Discussions
so
I
saw
folks
helping
each
other
out,
which
is
great
but
I.
Rest
assured
I
will
start
looking
at
those
in
the
coming
weeks,
so
I
will
process
them
and
you
get
your
responses.
So
all
good
usage
wise.
D
D
It's
a
Powershell
side
bit
of
the
save
meaning.
There
is
a
number
of
proofings
that
the
team
did
several
commandlets,
that
they
improved
like
the
talent
they
said,
get
certain
commandlets
connecting
online
and
more
usage
wise,
also
pretty
stable.
Little
drop
in
actual
request
count
but
steady
on
the
number
of
talents
so
overall
running
really
well,
and
the
team
is
also
looking
at
the
future
for
example.net
8,
which
will
appear
in
November
yeah
November.
D
B
E
E
So
you
should
be
good
to
go
in
a
couple
of
days
with
your
teams
as
well,
and
on
top
of
that,
we're
still
working
on
some
cool
new
features
which
we
won't
share
with
you
today,
but
we
hopefully
will
see
the
light
of
the
previous
soon
and
as
usual.
If
you
have
anything
you'd
like
to
see
in
your
teams,
please
head
over
to
AK
dot,
Ms
forward,
slash
your
teams
and
tell
us
what
you
have
in
mind.
Thank
you.
F
Thanks
David
big
thing
to
share
this
week
is
the
17-7
release
of
the
vs
tools,
so
that
released
last
week,
I
think
so
you
could.
This
is
the
first
release
where
the
vs
teams,
toolkit
extension,
is
available.
We
kind
of
ran
through
previews
for
a
while
to
get
those
tools
up
to
par.
So
there
you
can
see
all
the
the
similar
features
that
we
released
in
the
vs
code,
which
is
a
lot
of
our
automation
tasks
and
if
you've
been
following
the
vs
code.
F
Stuff
we've
been
referring
to
that
as
kind
of
version
five
of
the
BS
code.
So
this
brings
a
lot
of
those
features
over
to
net
developers
so
check
that
out
and
we're
still
working
on
plug-in
extensibility
for
the
co-pilots
and
some
new
templates
for
conversational
Bots,
using
teams,
aistk
and
you'll
see
more
of
me
and
some
other
folks
talking
about
the
that
and
the.net
experience
in
the
coming
weeks.
So
looking
forward
to
that,
so
if
you
want
to
chat
about
it,
there's
a
link
there.
B
Awesome,
thank
you,
John
all
right,
MGT
or
otherwise,
known
as
Microsoft
graph
toolkit
just
shipped
3.1.0.
The
MGT
samples
repository
is
live
and
ready
for
you
to
submit
some
samples,
there's
10
new
samples
in
the
last
week.
The
public
roadmap
is
available,
so
definitely
check
that
out
for
those
that
don't
are
unfamiliar
with
MGT,
it
is
an
extensible
way
to
get
the
graph
in
included
in
your
Solutions.
The
easiest
way
possible
so
seb's
out
today,
but
definitely
take
advantage
of
all
of
that
information
that
you
can
see
there
all
right.
G
Hello,
everyone,
while
some
products
may
have
slowed
down
for
summer
break,
we
never
slowed
down
in
the
world
of
Power
Platform
connectors.
It
feels
like
just
yesterday
that
we
were
celebrating
our
1000
Milestone,
and
now
we
are
at
over
1100
already
1116
total
connectors,
with
just
as
many
made
by
community
members
and
independent
Publishers,
like
yourself,
that
was
made
by
Microsoft,
which
is
an
awesome
awesome
achievement
if
you
cannot
get
if
you
cannot
get
enough
of
connectors.
G
Just
like
myself,
please
join
me
on
our
once
a
month,
connector
specific
Labs
call
the
second
Wednesday
of
every
month.
Link
is
in
the
chat
for
that
and,
as
we
move
forward
into
conference
season,
I
just
want
to
call
out
there
will
be
a
ton
of
connector
Presence
at
mppc
this
year
in
Vegas.
So
please
check
out
these
two
key
sessions.
The
first
one
is
with
myself
laying
the
foundation
for
connectors,
and
the
second
one,
as
we've
been
teasing,
is
how
to
turn
connectors
into
plugins.
B
Awesome,
thank
you.
Josh
all
right
next
up
is
script.
Samples
Paul
Bullock,
is
also
out
on
some
well-deserved
vacation
got
some
new
scenarios.
New
samples,
updated
scenarios,
updated
updated
scenarios
using
PNP,
Powershell
and
updated
scenarios.
Generic
definitely
take
advantage
of
this
repo
friends.
This
is
one
of
the
easiest
ways
to
get
involved.
We've
all
got
those
utilities
and
utility
scripts,
whether
it's
CLI
or
PNP,
Powershell
or
anything
above
and
beyond.
H
Thank
you
David.
How
is
everybody
doing?
We
got
a
cool
new
sample
this
week
from
Lee
Ford.
This
is
a
message
extension
that
if
you've
ever
wanted
to
help
somebody
out,
maybe
a
little
remote
assistance,
maybe
an
app
like
this
is
just
what
you
want
right.
It
generates
a
team's
meeting
that
can
drop
right
into
the
conversation
you
and
the
user
can
join
there
or
you
can
send
the
meeting
information.
The
meeting
ID
to
your
user
and
use
an
a
public
website.
I
mean
it's
it.
H
The
website
is
part
of
the
sample,
so
you
have
to
stand
that
up
but
see
what's
going
on
right
now,
as
it
plays
through
the
animation,
it's
actually
using
an
ordinary
website
to
do
the
screen
sharing
so
that
you
could
help
somebody.
You
know.
Maybe
it's
a
family
member,
maybe
it's
a
friend,
maybe
it's
a
business
colleague,
maybe
they've
never
seen
teams
in
their
life.
Well,
now
you
can
get
on
a
meeting
with
them.
B
I
There
you
go:
that's
not
not
quite
in
October,
so
it
can't
be
October.
We
are
super
excited
to
announce
the
Power
Platform
AI
hacked
together
event,
September
14th
through
the
28th.
It's
all
online.
Anyone
is
welcome
to
participate.
Why
would
you
want
to
participate?
Well,
you
get
to
try
some
of
the
new
AI
powered
features
on
the
Power
Platform
and
all
of
the
co-pilots
you
get
to
have
together
with
yourself
or
hack,
together
with
friends,
to
make
it
even
more
fun.
I
We
allow
teams
up
to
three
people
and
of
course
we
have
prizes
who
wants
to
participate
in
something
without
surprises,
so
give
away
some
gift
cards,
Power,
Platform,
swag
and
someone
say
badges.
So
we
got
on
this
awesome.
Power,
Platform,
AI
hacked
together
badge
that
you
can
win
for
participating
for
winning.
We
have
four.
We
have
a
grand
prize
winner.
We
have
the
best
diversity,
equity
and
inclusion,
Focus
solution,
the
best
Better
Together
scenario
and
the
best
AI
high-powered
scenario.
I
So
we
have
several
opportunities
to
win
plus
just
have
fun
and
learn
more
about
the
tools.
Registration
is
opening
soon,
but
you
can
go
to
AKA
dot.
Ms
forward.
Slash
hack
together
forward,
slash
Power,
Platform
AI
to
find
out
more
information
and
watch
that
page
for
registration
when
it
opens
so
hope
to
see
you
there
and
participate
in
more
information
to
come
soon
all
right
and
then,
of
course,
we
have
some
Power
Platform
samples
as
well.
I
So
we
have
one
sample
to
Highlights
today
with
the
Power
Platform
teams
management,
app,
that's
a
canvas
app
built
by
sword.
Baxter!
This
application
helps
you
manage
your
dataverse
security
groups.
So
it's
a
canvas
application.
It
has
a
cloud
flow
in
the
back
end
as
well.
Just
makes
it
easier
for
you
to
do
that.
Dataverse
teams,
management,
there,
security
groups
and
all
that
so
really
cool
application
to
make
your
life
a
bit
easier
from
an
Administration
point
of
view.
So
thank
you,
sir,
for
that
sample.
B
E
C
E
B
J
J
There
we
are,
what
we
see
first,
is
a
small
toggle.
I
will
come
to
that
later.
Then
we
have
a
drop
file
Zone
and
we
have
an
option
how
we
can
convert
our
files
and,
depending
on
what
we
want
to
do,
is
we
have
some
supported
file
types
yeah
for
HTML?
That
are
not
that
much
so
we
will
skip
this
for
today
for
jpeg
there's
a
lot
of
yeah
and
you
might
wonder
even
for
some
of
them
how
to
do
that
or
how
it's
going
to
do.
It's
not
working
for
everyone.
J
J
J
As
file,
and
here
we
have
a
PDF
as
a
Target
and
what
what
is
better
to
convert
to
a
PDF-
that's
a
Word
document,
for
instance
yeah.
We
drag
this
on
the
Drop,
Zone
price,
uploading
and
converting,
and
there
we
have
a
link
to
the
Target.
One
I
also
prepared
this
here
in
my
root
side
in
the
document
file
press
the
file-
and
there
we
have
our
document.
2
PDF
yeah-
put
check
this,
but
let's
trust
this
is
to
really
want.
J
J
This
is
the
by
the
giveaway
you
can
see.
This
is
a
PNG
file.
It
was
more
than
five
megabyte
in
size,
no
problem
for
me
because
I'm,
of
course,
doing
a
resumable
upload
in
that
case,
because
you
might
know
that
this
graph,
you
cannot
upload
files
more
than
for
a
megabyte
in
one
step,
takes
a
while
and
there
we
are
with
our
Target
Recon,
also
open
it
here.
J
Finally,
have
our
bomb
VCR
and
that's
it
all.
This
works
yeah,
but
in
detail.
How
does
this
work
or
how's
the
functionality
ongoing?
Let's
first
have
a
look.
What
we
have
to
do
to
get
this
running,
because
the
problem
is,
we
are
starting
on
client
side
and
the
file
conversion
is
taking
place
on
the
download
of
a
file.
So
first
we
have
to
upload
something.
So
what
we
are
doing
is
we
are
uploading
the
source
file
like
the
document,
for
instance,
to
a
temporary
folder
in
our
OneDrive
in
our
personal
OneDrive,
and
then
immediately.
J
This
is
going
back
to
our
client,
but
not
really
to
our
client
not
to
our
browser
anymore,
but
only
to
our
web
app,
because
because
everything
from
up
to
here
takes
place
in
the
back
end,
of
course,
and
then
the
Azure
web
backend
uploads.
Finally,
the
downloaded
PDF
file
to
our
Target
location,
which
can
be
in
SharePoint
teams,
whatever
yeah
you've
seen
what
I
was
doing,
was
doing
uploading
it
in
my
root
site
collection
and
why
I
was
doing
that.
I
will
show
you
on
one
of
the
next
slides.
J
This
was
the
process
yeah
once
again,
the
converting
traumas-
and
here
you
might
detect
the
first
one,
which
is
a
glb
file,
never
heard
of
that
before
I
had
so
I
had
to
Google
that
in
date
yeah.
This
is
a
three-dimensional
file
option
mostly
used
by
paint
3D
yeah.
So
I
was
not
aware
of
that.
I
did
not
realize
this
in
code,
but
should
be
easily
extendable,
because
most
of
the
stuff
is
already
there.
If
you
have
a
need
for
that,
take
the
sample
update
it
to
your
needs.
J
What
I
was
already
mentioning
is
the
graph
endpoint,
the
graph
endpoint
for
a
fire
conversion
exactly
for
a
format
during
the
download
is
still
in
beta,
except
the
PDF
format.
So
I
was
using
in
my
sample
because
I
was
not
able
to
use
the
graphs
5
SDK,
which
makes
it
quite
easy
to
mix
better
and
version.
J
One
endpoints
I
was
using
a
HTTP
client
version,
so
I
was
directly
dealing
with
the
rest
endpoints
because
in
the
graph
SDK
version
5,
the
format
option
is
still
not
working
yeah
and
in
the
past
it
was
always
a
good
good.
Let
me
call
it
work
around
to
mix
better
and
version
one
endpoints
by
simply
using
the
HTTP
client
right.
J
This
is
about
the
graph
endpoint,
the
next
one,
about
the
higher
pick
options.
Yeah,
you
have
seen
the
drag
and
drop
zone,
which
is
realized
here
on
HTML,
with
a
lot
of
functions
in
there,
but
as
an
alternative.
So
if
the
fluent
switch
above
is
to
start
putting
the
show
upload
to
a
true,
then
we
have
a
simple
input
of
type
file.
This
is
what
you
have
seen
by
browding
for
a
fire
which
is
more
accessible,
of
course,
than
the
dragon
drop
zone
and
I.
J
J
Yeah
SSO
still
takes
place
in
JavaScript
here,
I'm
getting
my
client-side
bootstrap
token
on
the
client
side
and
when
I
hand
this
over.
Then
in
my
backend
services,
I
get
the
token
acquisition
and
with
that
I
directly
also
get
my
graph
client
or
one
line
or
two
lines
below
and
then
I
can
start
my
stuff
server
side,
which
is
yeah,
simple
web
API
controller,
consuming
dependency
injection
last,
not
least
already
announced
where
to
store
the
files.
J
Of
course,
you
can
configure
that
in
an
environment
variable
or
something
similar,
but
you
can
also
grab
it
from
the
context.
What
I'm
doing
here?
Because
you
have
seen
this-
was
a
personal
teams
app,
so
no
context
of
a
team
I'm
using
the
team
site
domain
variable
from
the
context,
which
is
always
my
SharePoint
root
domain
yeah.
So
in
my
case
it
was
MLA,
bmvp
sharepoint.com,
nothing.
J
If
I'm
running
a
configurable
tab
against
this
option,
I
could
also
use
directly
my
teamside
URL,
so
put
it
in
the
teams
site
collection
running
below
yeah.
This
is
another
option
where
I
can
get
directly.
Thanks
to
my
contacts,
I
have
a
SharePoint
URL,
where
I
can
upload
things
and,
of
course,
I
should
rely
on,
should
be
verify
or
rely
on
my
documents,
library
or
special
one,
depending
on
my
needs.
J
That's
all
for
my
explanation.
As
you
know,
always
some
resources
I
got
a
blog
post
on
that
sample.
Where
I
wrote
down
the
yeah,
the
major
things
as
well.
The
sample
is
available
in
that
in
the
teams
or
Dev
samples
see
projectory
from
PMP
and
last,
not
least,
the
documentation
on
the
mentioned
Microsoft
graph
endpoint
still
in
data,
but
you
can
also
switch
to
the
version
one.
Then
you
see
that
the
format
option
is
only
PDFs
there
to
yeah.
B
Awesome
Marcus.
Thank
you
very,
very
much
well
well
done
on
that
thorough
explanation
with
the
demo
really
good
job
love
the
extra
stuff
that
you've
added
there,
especially
with
the
supported
file
types
and
the
drag
drop
really
great
great
stuff.
Thank
you.
So
much
we'll
have
an
opportunity.
Everybody
to
chat
with
Marcus
in
a
in
the
community
called
conversations
afterwards
and
put
some
questions
in
the
chat
and
links
are
in
the
chat
all
right.
B
K
If
you
answer
yes,
so
what
we
are
going
to
do
today
is
gonna
solve
this
issue.
So
I
will
walk
you
through
a
low
code
to
no
code
solution.
We
are
going
to
leverage
the
AI
Builder
and
power
apps
to
streamline
our
email
handling
process
and
there
is
no
more
sifting
through
countless
messages
or
missing
crucial
communication,
whether
you
are
a
busy
professional
or
a
startup
entrepreneur
or
just
someone
seeking
better
email
organization.
K
I've
got
you
covered
today.
So
to
get
you
started,
the
first
service
from
our
platform
that
we
are
going
to
use,
is
power
apps
and
why
we
are
going
to
use,
perhaps
because
it's
an
easy
tool
that
we
can
build.
Applications
on
and
people
can
interact
with
easily,
and
then
we
need
the
emails
that
we
are
going
to
manage.
So
we
are
going
to
use
another
service,
which
is
a
conductor.
It's
Microsoft,
Office
365
Outlook
connector,
and
how
are
we
going
to
use
the
AI?
K
We
are
going
to
use
the
AI
Builder
tool
which
we
are
going
to
know
more
about
in
the
next
slides.
So
of
our
apps.
As
I
have
told
you,
you
can
build
emails
that
can
ease
your
business
processes.
It
can
help
you
do
a
low
code
to
no
code
solutions
for
your
business
and
you
can
learn
more
about
what
is
about
apps
in
this
link
again,
what
is
Office
365
our
connector?
It's
a
cloud-based
service
that
can
link
between
our
Outlook
or
our
Microsoft,
365
Outlook
and
more
apps.
K
K
The
sentiment
analysis
model
can
analyze
the
content
or
the
body
of
the
email
if
it's
positive
or
negative
and
based
on
that
it
can
put
or
group
the
emails
in
category
in
one
category.
So
that's
what
we
are
going
to
do.
It
only
gives
us
the
analysis
and
the
confidence
score
for
the
the
thing
or
the
content
of
the
email.
So
it's
just
with
some
very
simple
clicks.
We
are
going
to
be
able
to
do
this,
so
this
is
a
demo
of
the
app
that
we
are
going
to
build
together.
K
You
can
group
the
sentiments
here
by
choosing
from
this
filter
drop
down
menu.
You
can
open
an
email,
you
can
respond
to
an
email
and
just
write
the
message
and
click
on
reply,
and
if
we
go
to
our
Outlook
account,
we
can
see
that
this
actually
works,
and
this
is
like
small
GIF
of
the
solution
that
we
are
going
to
look
at.
Can
you
do
this
on
your
own?
You
can
do
this
really
simple
steps.
K
The
first
step
is
to
open,
perhaps
to
create
the
canvas
application,
the
three
pages
that
you
have
seen
before
again
or
sorry.
The
next
step
is
to
add
the
Microsoft
365
Outlook
connector,
and
we
are
going
to
see
how
we
are
going
to
do
this
and
to
add
the
AI
Builder
sentiment,
analysis
model
connect
and
the
rest
is
just
creating
some
screens
and
testing
publishing
the
app.
So
again,
I've
been
mentioning
that
there
is
a
step-by-step
guide
in
this
link.
K
Let's
do
this
together
now
so
to
get
you
started,
hey
I
have
to
open
my
outlook
here
yeah.
So
this
is
the
link.
This
is
the
Bitcoin
for
the
slash,
managed,
email
Dash
with
AI.
This
is
a
Blog
on
Microsoft,
Tech
Community.
You
can
see
the
steps
for
creating
everything
that
I
have
mentioned
today,
to
replicate
the
solution
step
by
step
and
the
options
for
each
element,
each
UI
element
that
is
being
created.
You
can
see
the
option
of
how
you
can
do
it
yourself
and
I've
only
included
one
screen.
K
As
you
can
see,
it's
a
lot
so
the
other
two
screens
you
can
either
try
to
take
what
you
have
learned
from
building
the
first
screen
and
apply
to
build
the
other
two
screens
or
you
can
get
the
solution
from
my
GitHub
repository.
The
link
is
also
included
here
and
I'm.
Just
I
can't
seem
to
find
it
now,
but
the
link
is
here
for
the
GitHub
repository
that
has
the
full
application
and
the
steps,
so
you
can
import
it
yourself
to
your
power.
K
K
I.
Have
it
already
built
a
young
building,
an
application
like
this
takes
some
time.
So
it
might
take
you
an
hour
two
hours,
three
hours
maximum
for
you
to
build
it
from
scratch,
and
then
that's
why
we
are
just
going
to
and
do
the
things
that
we
can
do
in
the
couple
of
minutes.
That
we
have
so
we
are
just
going
to
click
on
edit
and
then
we
have
the
application
open
here.
This
is
the
first
screen
the
browse
emails,
the
screen
you
can
search
for
emails.
K
You
can
group
the
emails
by
the
sentiment
and
you
can
get
emails
and
refresh
them.
Why
are
we
going?
Why
are
we
doing
this?
The
process
of
getting
emails
is
not
happening
simultaneously.
We
have
to
refresh
it.
So
if
I
get
the
emails
right
now,
I
have
a
version
of
the
emails
at
this
point
of
time.
So
it's
not
gonna
get
updated.
When
someone
sends
me
a
new
email,
what
can
I
do?
I
can
reset
the
gallery
and
get
emails
again.
This
is
a
very
simple
step.
K
K
We
can
go
to
the
connector
or
the
data,
the
data
and
then
I
can
add,
add
data
from
here
and
then
I
can
choose
the
connector
and
choose
the
Office
365
outline
connector
I
already
have
it
linked
when
you
try
to
do
this
step,
it's
going
to
ask
you
to
accept
and
sign
in
and
so
on.
So
once
this
loads
and
the
emails
are
gonna
show
up
in
front
of
us
while
it
loads.
Where
did
I
get
the
code
to
build
this
gallery?
K
It's
really
simple:
it
all
started
with
this
line
of
code
I'm,
just
calling
the
connector
I'm
calling
a
function
called
get
emails,
and
this
function
takes
the
folder
path.
If
you
check
your
email,
you
can
see
that
each
email
or
emails
are
grouped
inside
folders.
There
is
the
inbox
which
has
all
the
emails,
and
there
is
conversation,
feedback
and
I
have
created
a
folder
for
this
demo.
K
Specifically,
you
can
get
all
the
emails
from
your
inbox,
that's
totally
fine,
but
for
us
we
are
just
gonna,
get
the
feedback
because
I,
don't
wanna,
show
you
all
my
emails.
So,
let's
get
back
and
see
if
the
Outlook
has
worked
or
not.
So
why
is
it
not
showing
up
anything?
The
filter
function
is
blocking
the
AI
Builder
from.
K
If
we
just
do
this,
but
we
have
and
we
have
messed
up
the
search
you
can
see
all
the
emails
are
showing
up
here.
Okay,
so
again,
if
we
do
this
again
when
we
load,
this
is
the
first
email
we
can
enter
the
email
if
I
click
on
dismiss
it's
going
to
Mark
the
email
as
read
and
if
I
click
on
respond,
it's
gonna
go
to
another
page
to
enter
my
message
and
click
on
the
reply.
K
K
I
think
it's,
oh,
that
will
copy
everything.
So
again,
let's
copy
it
and
paste
it
here
so,
okay,
now
it
works
so
I
think,
okay,
so
again,
it's
not
gonna
work
and
unless
I
link
the
AI
Builder
mode,
so
AI
Builder,
as
you
may
have
seen
before
it-
has
lots
of
and
lots
of,
models
that
are
ready
for
you
to
use
and
the
documentation
is
also-
and
you
can
just
use
it
like
that.
So
I
click
on
AI
models
and
then
I
choose
the
model
that
I
want
and
we
want
the
sentiment
analysis
model.
K
Okay,
once
we
have
it
connected,
the
filter
is
gonna
work,
Why!
Didn't
it
work
because
we
we
were
calling
the
sentiment
analysis
model
here
and
it's
not
nothing
called
sentiment
analysis
in
our
application.
So
it
gave
us
an
error
now,
once
we
have
it,
it's
gonna
start
loading
I,
think
and
should
work
fine.
A
K
Box
for
the
sentiment
analysis
here,
it's
I
think
it's
the
combo
sentiment
yeah.
So
the
combos
sentiment
box,
okay,
combo,
okay,
Center,
element,
I,
think
now
it
should
works,
should
work
I,
think
I
don't
know.
Does
it
work
yeah,
it's
sending
the
request,
and
now
it
gives
us
the
email
and
the
sentiment
this
email.
It
says
it's
negative.
So
if
we
go
and
look
at
it,
we
can
see
this
is
the
worst
product.
So
it's
really
a
negative
email.
K
K
It's
and
if
you
go
to
the
Office
365
documentation,
scroll
down,
you
can
see
all
the
functions
that
I
have
shown
you
before
they
get
emails,
function,
version,
1
version,
2
and
version
three,
and
if
you
wanna
include
or
implement
the
search
and
the
filter,
this
is
a
cool
documentation
from
Microsoft
I
I
got
the
code
I
copied
it
I.
Just
understood
what
it
does,
what
it
needs
and
then
I
did
it.
It's
really
easy.
K
This
is
a
filter
example
and
you
can
see
how
you
can
do
it
your
own
again
using
the
AI
Builder
you.
If
you
go
to
the
documentation
you
can
see,
it
tells
you
to
include
it
and
just
type.
The
name
of
the
model
then
predict
and
give
it
the
input
and
see
what
you
want
to
get
back
from
this
model
and
I
hope
you
got,
you
got
it.
Let's
try
to
respond
to
an
email,
it's
dismissed
the
positive
one,
because
of
course
we
don't
want
it
now.
K
Okay,
now
I
can
go
in
and
I
can
respond.
Sorry,
sorry
for
that
and
when
I
click
on
reply
message
by
this
blank
I
think,
okay,
I,
think
when
we,
when
we
open
the
message
it
IT
pocket,
is
as
read
so
I
think
this
might
be
the
problem.
Let's
go
back
here
and
see
what
happens.
So.
This
is
a
message,
and
this
is
the
other
message
and
the
reply
hello
will
we
will
work
on
that
and
that's
it
and
that's
the
demo.
K
B
Awesome,
thank
you.
John
yeah
we'll
have
some
questions
in
the
chat.
If
anybody
has
any
and
then
of
course,
there's
that
conversations
opportunity
after
afterwards
that
everybody
can
engage
with
you
on,
but
really
great
stuff,
thanks
for
walking
us
through
step
by
step
love
the
sentiment
analysis
there
very,
very
useful,
really
in
our
day
and
age,
so
appreciate
you
bringing
that
to
the
community
to
share.
B
L
Sure
all
right,
you
guys
tell
when
you
can
see
this
is
your
screen.
It's
loading
there.
We
go,
take
it
away
all
right,
all
right,
everybody,
hello,
I'm,
Chris,
and
let's
talk
about
some
exciting
list,
formatting
stuff,
so
we'll
head
on
over
to
our
Warrior
versus
site,
until
I
figure
out
how
to
switch
dang,
it
video's.
Still
there
we're
still
here.
Okay,
sorry
teams
keeps
crashing
on
me
I'm
losing
everything
here
there
we
go
all
right,
we
figured
it
out.
L
Keyboards
are
hard
all
right,
so
we're
on
our
horses
site
and
we're
just
going
to
create
a
new
list.
You
know
the
the
horses
are
always
cooking
lots
of
delicious
things
and
thank
God
Microsoft
has
created
a
beautiful
template
for
tracking
that
and
SharePoint
all
right.
So
we've
got
our
recipe
tracker
here,
so
we're
gonna
create
a
recipe
tracker
at.
What's
that,
oh
all,.
A
E
L
L
That
sounds
exciting
and
then
we'll
just
add
a
couple
of
recipes
to
this
list
and
then
we're
going
to
take
a
look
at
what
we
can
do
with
that
right.
So
we'll
just
add:
let's
take
this
off,
we
don't
we
don't
care
about
this.
Let's
just
hide
that
column
right.
We
don't
need
a
link,
but
let's
add
another
column
like
a
description
here
or
text
here.
L
You
know
a
description
of
our
recipe,
we'll
call
it
description
very
exciting,
I'm,
going
to
call
it
a
multiple
lines
of
text
and
we'll
just
save
that
all
right.
So
now
we've
got
a
beautiful
list.
It
did
not
remove
the
link.
I,
don't
believe
it
matters
too
much
we'll
bring
that
over
here
and
now,
let's
add
just
a
couple
of
items,
so
we
could
get
this
going,
what
soggy,
oats
and
then
we'll
add.
L
What's
called
horse
lasagna,
that's
right
and
then
of
course,
I've
already
generated
a
couple
of
images
for
these
somewhere,
my
some
images
and
my
horses
somewhere
the
horses
and
then
we
got
the
recipes
here
we
go
and
we
got
some
horse
lasagna
there
we
go.
This
is
the
smooshy
oats,
perfect
sogio
smooshy
oats,
some
kind
of
Oats
all
right.
So
there's
some
of
the
AI
generated
images
that
apparently
don't
work
here.
So
that's
very
exciting.
L
Let's
try
this
again,
one
more
time
perfect,
we'll
upload
some
horses
lasagna
well,
whatever,
let's
just
exit
the
good
music
of
that
fixed
up
now,
somehow
my
images
are
broken.
It
doesn't
really
matter
we'll
skip
the
images
for
today.
For
now,
though,
let's
grab
some
descriptions,
though
so
maybe
we'll
ask
AI,
we'll
ask
Bing
to
help
us
out
right,
so
we'll
ask
it
to
generate
a
description
for
a
recipe
called
smooshy
oats
all
right.
L
There
we
go
and
so
I
bring
this
up,
because
this
is
a
great
way
to
make
demo
data
right.
So
if
you're
just
messing
with
list
formats-
and
you
want
some
some
data
to
generate
right-
you
can
use
the
old
ipsum
lips
and
bacon
whatever
it's
called
right
or
you
know
you
could
ask
Ai
and
one
of
those
cool
kids
right
to
make
sure
Jim
will
fancy
I'm
gonna
stop
responding.
L
We
don't
need
those
steps
right,
so
we'll
just
grab
whatever
this
is
perfect
and
let's
paste
that
in
there
beautiful
and
then
let's
get
one
more
for
the
horse
lasagna
as
well.
All
right,
we'll
just
ask
it
to
generate
one
for
us
on
horse,
lasagna,
womp,
perfect,
but
we'll
place
it
twice.
Apparently
all
right
there
we
go
just
do
it
sounds
great
all
right,
so
we'll
get
that
we'll
get
a
description
for
the
horses
lasagna
and
then
we're
gonna
take
a
look
at
some
format
it.
L
So
one
of
the
things
we've
been
doing
recently
is:
we've
been
showing
some
fairly
Advanced
scenarios
right.
A
couple
of
weeks
ago
we
took
a
look:
how
to
make
a
poll
application.
We've
looked
at
all
sorts
of
different
types
of
applications,
some
exams
formatting
things
with
for
each
and
the
loops
and
the
inline
editing.
All
those
videos
are
available
and
I
recommend
you
check
them
out,
but
for
our
purposes
we're
going
to
go
back
to
basics
just
a
little
bit
and
and
talk
about
how
we
even
understand
what
formatting
is
right.
L
So
we've
created
this
list:
we've
done
cool
AI
things,
so
we've
checked
off
our
list
of
being
a
cool,
a
or
cool
demo
in
2023,
by
having
AI
shown
so
boom
check
that
off
from
the
close
up,
Bing
guy,
all
right
and
now
so
we've
got
ourselves
a
list
right.
We've
got
some
sample
data
in
it
and
we
can
take
a
look
at
how
we
want
to
format
that
right.
L
So,
for
instance,
if
we
just
go
in
here
and
we're
going
to
go
column,
settings
and
we're
going
to
format
this
column
and
one
of
the
things
we
can
do
right
is,
we
can
get
these
nice
little
Wizards
and
and
that's
okay
for
us.
We're
gonna
go
to
advanced
mode
and
we're
going
to
take
a
look.
What
we
can
do
now
I
have
turned
on
SP
formatter.
That
is
a
extension
for
either
Chrome
and
for
Edge
I'll
have
a
link
and
everything
for
that
and
what
that
does,
and
what
that
does.
L
It
has
this
little
box
here.
It
makes
things
a
lot
easier.
It
makes
things
work
really
well,
but
one
of
the
things
we're
going
to
do
is
we're
going
to
take
a
look.
How
do
we
figure
out
what
we
can
do
right
so
you'll
notice
that
we
hit
this
kind
of
intellisense
right?
We
start
to
type
it's.
The
LM
type
is
suggested
here
all
right.
We
even
can
start
to
see.
You
know
we
could
type
div
and
we
can
type
our
text
content
now.
These
are
the
only
things
that
are
really
required.
L
We
can
say
wow
right,
we
can
put
in
literals
text
and
now
it'll
always
say
Wow
E
there.
So
that's
pretty
cool.
Let's
make
this
a
little
bigger
there
we
go
now.
How
do
we
know
what
can
go
in
there
if
anytime,
you're
interested?
This
is
actually
a
link
and
if
you
hold
down
control-
and
you
click
it-
it's
going
to
open
up
in
a
new
tab
here
and
if
you
wanted
to
read
how
to
describe
your
Json
with
Jason
Good
News,
you
can
right.
So
this
is
a
Json
schema
file.
L
Don't
expect
you
to
really
read
through
this
too
much,
but
if
you're
interested
in
exactly
what
you
could
do,
this
is
a
great
spot
to
check
that
one
of
the
things
I
want
to
point
out.
Is
that
not
only
does
it
show
you,
you
know
what
values
are
allowed
and
what
are
required
right.
You
can
see
if
you
go
all
the
way
down
to
the
bottom.
Here
we
talk
about.
The
only
thing
that's
required
is
either
element
type,
the
column,
format
of
reference,
so
that's
kind
of
cool.
L
You
can
see
these
kinds
of
things,
but
what
I
think
is
more
interesting
is
Expressions,
so
we
have
the
idea
of
a
property
or
a
value
right.
So
if
we
take
a
look
here,
this
is
the
property
Elm
type.
This
is
the
value
div
right
now,
for
the
most
part,
properties
are
going
to
be
fixed
right.
There's
a
specific
list
of
what
are
available
there,
there's
a
couple
of
dynamic
ones.
L
With
data
attributes
and
with
Aria
tags
you
can
check
out,
but
otherwise
they're
all
kind
of
fixed
they're
always
going
to
be
named
and
there
you
go,
but
the
values
can
vary.
Wildly
right,
for
instance,
LM
type,
is
you
know
one
of
a
few
right?
If
we
type
in
l
type
all
right,
we
can
see
that
it
only
takes
an
enumerator
value.
This
is
it.
This
is
all
you
can
put
in
there
and
more
interestingly,
you
cannot
do
an
expression
and
when
I
say
expression,
I
mean
that's.
H
L
These
different
things,
including
an
expression
itself
and
then
almost
everything,
is
either
a
string
or
an
expression.
Otherwise,
so
that
allows
us
to
say
you
know,
text
content
doesn't
have
to
be
wowee
right.
We
can
actually
put
a
curly
brace
and
now
we
get
an
operator
right.
So
now
we've
got
operator,
and
we
could
say
you
know
like
starts
with
that
sounds
like
an
exciting
operator
or,
let's
do
stealing
unsuccessful,
easy
understand
so
ceiling
just
rounds
down.
L
So
we
do
ceiling
the
idea
what
operators
always
has
operands
right
and
those
are
an
array
of
things
and
in
this
case
we're
going
to
say
you
know
45.5
and
if
we
preview
that
we
can
see
that
it
goes
up
to
46..
Let's
turn
this
enhanced
formatter
on,
so
we
don't
have
to
hit
preview
all
the
time
right.
So
if
we
have
ceiling
here,
we
can
also
type
instead
floor
and
I
can
see
it
goes
down
to
45.
L
But
you
get
the
idea
here,
it's
a
little
hard
to
read,
but
this
is
called
the
abstract,
syntax
tree
style
right,
so
AST
and
you'll
see
this
show
up.
This
is
the
only
thing
that's
supported
if
you're
doing
the
SharePoint
2019
or,
if
you're,
using
some
of
the
the
rules
that
generate
stuff
you're
going
to
see
this
kind
of
thing
now
this
can
be
Rewritten
pretty
easily
as
just
a
string
which
we'll
take
a
look
at
in
a
moment.
But
it's
important
to
see
this
and
not
be
too
scared
of
it.
L
Because
again
you
can
kind
of
go
crazy.
There
are
some
weird
things
and
I'm
going
to
turn
on
debug
mode,
so
we
can
see
some
of
that
weird
things
right.
So,
if
I
type
in
you
know
almost
anything
all
right,
so
if
I
type
a
number
like,
you
would
think,
would
work
right,
I'm
actually
told
it's
not
a
valid
operator,
and
that's
because
the
debug
mode
I
actually
can
see
all
of
the
list
of
operators.
I
can
use,
but
some
of
these
in
this
syntax
I
have
to
actually
include
the
parentheses.
Now.
L
Why
is
that?
For
some
of
them
and
not
for
others?
Why
are
some?
But
okay,
some
are
up
case
yeah,
yes,
Microsoft
right,
but
either
way
that's
kind
of
what's
happening
and
again
you
could
have
you
know
you
could
Nest
these
all
the
way
down
before
they
get
a
little
confusing.
Alternatively,
right,
you
could
just
write
an
equals
and
that
will
indicate
we're
starting
an
expression
in
line
right,
so
an
Excel
style
expression
where
we
could
say
you
know,
ceiling
of
45.5
all
right.
L
We
see
that
has
46
over
there
notice
again
that
SP
formatters
applying
this
automatically
right,
so
I
forgot
the
O
boom
there.
It
goes
and
you
can
see
this
is
a
lot
easier
to
read,
especially
when
you
start
nesting
a
lot
of
these
Expressions,
so
I
want
to
make
sure
I
called
that
out.
The
other
thing
to
note
is
how
you
reference
up
other
things
right,
so
this
value
can
also
be
fancy
things
right.
So
we
saw
before
we
were
just
like
dog
and
there's
dog.
L
Really
quite
a
bit
of
intellisense
here
so
I
can
see
the
at
current
field,
which
is
going
to
take
the
value
there,
but
I
could
also
reference
other
columns
right.
So
if
I
want
to
take
the
description
and
show
that
I
would
put
a
square
bracket
and
a
dollar
sign
and
again,
SP
formatter
is
doing
a
really
cool
thing
where
it's
actually
looking
at
what
columns
are
available
on
this
list
and
showing
them
to
me
here
right.
L
So
this
guy
didn't
refresh
after
that,
so
let's
just
go
ahead
and
type
in
descriptions,
but
we
type
in
the
internal
name
for
a
column
and
there's
the
description
right
and
that's
very
cool.
Now,
if
we
wanted
to
do
something
like
recipe
right
well,
that
doesn't
work
right
recipes
not
found
on
the
data
object.
That's
because
that's
actually
the
title
field
right.
So
these
are
the
internal
names
now
one
thing
you
can
do
is:
if
someone
does
that-
and
you
want
to
reference,
what
is
that
display?
L
Name
right,
like
maybe
you're
trying
to
write
in
you
know,
equals
and
you're
saying
title
right.
Is
this
thing
right,
I,
don't
know
why
you
would
do
that,
but
maybe
you're
doing
that
right,
but
you
don't
want
to
say
title
because
what,
if
they've
changed
that
right
so
now,
you
can
quickly
change
that
here
and
you
can
reference
column
metadata
instead
of
a
dollar
sign.
L
You
can
put
the
exclamation
point
and
say
display
name
right
and
then
we'll
say
another
plus
here
right
and
we'll
wonder
what
I
did
wrong
for
days
and
days
all
right,
I,
don't
know
what
I
did.
Is
it
lowercase
I,
don't
know
display
values
lowercase
either
way.
The
idea
is,
you
can
get
better
data
about
these
things?
You
can
do
the
placeholder
tokens
and
you
can
do
these
expressions.
L
It
gets
really
really
cool
when
you
start
to
combine
these
things
and
use
these
to
conditionally
turn,
things
on
and
off
to
apply,
Styles
and
so
on.
But
the
key
thing
with
Expressions
is
to
not
be
too
scary.
Is
that
operator
operand
stuff
and
to
be
aware
of
what's
available?
So
one
of
the
ways
I
like
to
see
what's
available
is,
of
course
you
can
always
check
out
the
actual
documentation
right.
So
this
formatting
syntax
references,
the
is
the
document
with
kind
of
the
bulk
of
that
stuff.
L
L
And
then,
if
you
come
down
here,
you
can
see
this
is
where
again
we
reference
that
kind
of
metadata
for
the
field,
not
sure
what
I
typed
wrong
there,
but
it
doesn't
really
matter
right
and
then
this
is
how
you
reference
internal
field
names
and
again,
if
you
use
that
debug
mode,
you
can
start
to
see
those
internal
field
names
and
use
SP
formatter
it's
going
to
get
even
easier
for
you
again
with
that
automatic
preview,
which
is
really
really
helpful.
Okay
and
then
the
last
thing
is,
you
can
see
the
operators.
L
If
you
come
here,
you
can
see
operators
right
and
you
can
see
all
of
them
listed
here
along
with
examples
of
how
do
you
call
each
I
said
it's
the
text
content,
but
it's
not
limited
to
text
content.
Almost
everything
except
except
element,
type
and
I-
think
custom
action
for
the
most
part
take
an
expression.
So
again
you
can
get
pretty
fancy
with
some
of
the
stuff
and
it's
very
cool.
L
So
now,
let's
take
a
look
at
our
slides,
real,
quick
and
we'll
wrap
it
up
so
again,
I
want
to
call
it
this
SP
formatted
by
Circle,
it's
free.
It's
part
of
PNP
check
it
out.
It
is
awesome,
it's
an
extension
for
both
Chrome
and
for
Edge,
so
new
chromium,
Edge,
and
it
makes
things
so
much
easier.
I,
don't
generally
demo
it
here
because
it
is
an
extra
install.
L
L
One
thing
to
note
here
is
a
little
weird
is
that
if
you're
in
that
operator,
operand
syntax,
you
use
either
a
question
mark
or
use
a
colon
don't
use
if,
but
you
don't
use
either
of
those
if
you're
in
the
Excel
expression,
I
know
that
sounds
a
little
weird,
but
just
think
I'm
just
reading
it
this
way
like.
If
this,
then
that
kind
of
thing
okay,
so
you
totally
got
that
here's
some
conversion
operators,
so
there's
a
way
to
take
in
you,
know
your
value.
L
L
So
it's
going
to
be
true
or
false,
or
it
could
be
a
date
which
would
mean
it's
actually
a
giant
number
of
the
milliseconds
since
1970s,
something
or
other
right,
and
so
you
can
use
these
here
to
convert
those
between
those
types
of
things,
including
some,
you
know,
Locale
type
items
and
then,
of
course,
there's
the
multi-value
and
loop
operator,
so
you
can
jump
through
so
you've
got
multi-choice
fields
or
multi-person
fields
or,
if
you're,
just
working
with
a
split
or
you're
doing
four
each.
You
could
do
all
sorts
of
cool
things
there.
L
So
these
are
a
little
more
advanced,
very
exciting
and
then,
of
course,
we
have
our
text
manipulation.
Operators
right.
So
this
is
how
you
can
change
some
of
that
strings
around
you
want
to
jump
in
there,
and
you
can
say
you
know,
make
a
shout
at
people
by
always
making
an
uppercase
or
sometimes
you
just
want
to
display
it
right,
and
you
just
want
to
add
a
padding
to
the
beginning
right.
So
the
pads
start,
a
very
common
use
case
right-
is
the
pad
numbers,
so
they
all
line
up
correctly.
L
The
fun
thing
is,
it
accepts
a
string
so
just
wrap
that
around
one
of
those
conversion,
two
strings
on
your
number
and
you're
good
to
go
and
then
finally,
here's
some
value
extraction
operators.
So
this
is
how
you
can
actually
grab
some
very
specific
details
out
of
a
value
right
again,
this
could
be
your
calculated
values
or
these
can
be
field
values
and
it
makes
it
very,
very
cool.
L
So
all
that
to
say
this
stuff
is
extremely
powerful
and
we've
been
showing
you
all
sorts
of
cool,
powerful
things
with
it,
but
I
wanted
to
take
it
back
a
little
bit.
Just
talk
about
these
Expressions
aren't
near
as
scary,
as
you
think,
I
think
they're
actually
easy
to
write
than
calculated
columns
everywhere,
just
because
some
of
those
are
a
lot
easier
right
there,
just
like
the
map,
kind
of
like
Excel
they're,
similar
Power,
FX,
and
so
on
so
check
those
out.
B
B
No,
it's
not
sharing.
Let's
try
again
thanks
teams,
all
right,
excellent,
okay!
Well,
another
big
big,
thank
you
to
all
of
our
presenters
today,
Marcus
John
and
Chris
excellent
job
always
appreciate
John,
welcome
to
the
community
and
presenting
great
job
on
your
first
one.
Everybody
did
excellent.
So
thank
you
for
putting
in
that
effort
and
bringing
it
to
the
community
today.
B
Now,
if
you
saw
some
awesome
things
today,
which
you
did,
then
you
want
to
converse
about
it
and
we
have
an
opportunity.
The
community
call
conversations
lives
on
the
powerapps
forums.
So
please
take
advantage
of
this
go.
Let
our
presenters
know
today
that
you
enjoyed
their
session.
If
you
had
questions,
ask
questions:
they
are
there
ready
to
collaborate
and
again
it's
okay
and
it's
acceptable
and
I
encourage
you
to
just
go.
Let
them
know
they
did.
A
great
job
time
is
taken
spent
to
put
these
presentations
together.
B
So
let
them
know
that
you
appreciated
them,
sharing
it
with
the
community
and
taking
time
to
do
that,
we'll
post
those
links
directly
into
the
chat
right
after
the
call,
but
you
could
use
those
QR
codes.
If
you
want
to
snap
and
get
get
a
head
start
on
it
now,
if
you'd
also
like
to
get
more
engaged
with
the
community,
we're
with
the
cool
kids,
now
we've
got
our
own
Discord
server,
so
absolutely
free
to
join.
B
You
can
access
that
via
the
web,
via
the
app
very,
very
cool
method,
to
be
able
to
talk
about
a
lot
of
topics
in
a
short
amount
of
time,
so
definitely
take
advantage
of
that
aka.ms,
Community
Discord
and
let
us
know
what
you
think
about
these
calls.
We
absolutely
want
to
continue
to
improve
them,
bring
new
and
exciting
collaborative
opportunities
to
work
together
with
you
all.
B
Let
us
know
what's
working,
what's
not
working
some
ideas
you
may
have
even
just
let
us
know
that
you
are
enjoying
it,
because
our
management
likes
to
know
and
see
that
you
are
benefiting
by
the
efforts
being
put
in
for
these
Community
calls.
So
please
please,
please
do
that
AK
dot,
Ms,
slash,
Community,
call
slash
feedback.
B
Well
again,
thank
you,
everybody
for
joining
us
today.
The
recording
will
be
available
in
24
hours
on
the
Microsoft
365
Empower
platform,
Community
YouTube
channel.
You
can
access
that
at
AK,
dot,
Ms,
slash,
Community
videos
better.
Yet
if
you
subscribe
and
set
your
alerts,
you'll
be
alerted
as
soon
as
it
drops.
If
you're,
not
in
Microsoft
you're,
not
going
to
be
able
to
download
it
you're
going
to
see
an
alert
saying
that
in
teams
the
video
is
ready.
It
is
not
it's
a
pretty
little
liar.
B
You
won't
be
able
to
access
it,
so
definitely
go
subscribe
to
the
YouTube
account
so
that
you
can
be
known
or
be.
Let
known
immediately
follow
us
on
Twitter
or
X,
the
artist
formerly
known
as
Twitter
for
updates
at
M365
PNP
and,
of
course,
our
LinkedIn
Community
as
well.
The
next
bi-weekly
M365
Power
Platform
call
the
one
you're
on
right
now
will
be
August
31st
in
two
weeks
and
our
next
Viva
connection
SharePoint
framework
next
week,
we're
here
for
you
every
Thursday,
every
Thursday,
no
matter
what
the
day
is
holidays,
we're
a
global
Community.