►
From YouTube: Microsoft Power Apps community call-October 2020
Description
October brought us a very special community call as we unveiled a new community offering from Canviz along with a walk through of a Power Apps Expense Application built with Oakdale (enabling full integrated with Microsoft Teams) by Reza Dorrani. The demos concluded with April Dunnam and Hugo Bernier walking us through an ENHANCED Power Apps SharePoint web part built by our very own community start and MVP Hugo Bernier!
Resources
Canviz Power Apps charting components https://aka.ms/AAa276m
Expense Tracking Application package https://bit.ly/expensereportingsolution
Power Apps web part https://aka.ms/AAa2fsf
Stay connected
Twitter https://twitter.com/microsoft365dev
YouTube https://aka.ms/M365DevYouTube
Blogs https://aka.ms/M365DevBlog
A
Hello
and
welcome
to
the
october
21st
2020
powerapps
community,
call
we're
glad
you
can
join
us
here
and
thanks
for
taking
time
out
of
your
day
to
be
part
of
this
with
us
today.
The
powerapps
community
call
is
something
that
we
do
on
the
third
wednesday
of
every
single
month,
so
our
next
call
will
be
on
november
18th
2020..
We
always
do
this
at
8
a.m.
Pacific
time
during
these
calls,
we
talk
about
the
latest
news
and
community
contributions
and
power
apps.
A
We
have
mvps
product
team
members,
community
champions,
just
basically
everybody
and
anybody
who
loves
and
is
awesome
at
powerapps,
comes
on
and
shares
their
knowledge
and
we
all
learn
together
and
really
grow
as
a
community.
As
a
result,
we
have
technical,
deep,
dives
and
q
a
is
always
going
on
throughout
our
session,
and
this
is
our
power
crew.
As
I
like
to
call
it.
This
is
all
of
us
who
bring
this
call
to
you.
That's
me
on
the
right
todd
baginski.
A
A
A
A
Then
april
and
hugo
are
going
to
show
us
an
awesome,
powerapps
web
part,
which
is
very
flexible
and
really
allows
you
to
drop
power
apps
into
office
365
sharepoint
pages.
I
have
a
feeling
that
may
hugo
may
show
hugo.
Is
it
even
going
to
go
somewhere
else
besides,
the
sharepoint
page?
Can
this
web
part
go.
A
All
right,
it's
cool
like
that
flexibility.
So
then
we'll
wrap
up
with
some
news
and
community
contributions
as
well
before
we
get
started
with
the
content.
We'd
always
like
to
give
a
shout
out
to
these
folks
right
here,
as
well
as
everybody
else
on
the
call.
There
are
so
many
people
who
join
this
call
every
single
month
and
spend
their
time
here,
answering
questions
and
mentoring,
people
on
the
chat
channel.
A
So
thank
you
to
all
these
folks
who
do
that
every
month
it
really
makes
this
call
special,
and
I
think
everyone
really
feels
connected
and
like
they
can
come
away
with
something
every
single
month.
So
that
brings
us
to
the
charting
components.
These
charting
components
are
something
that
matt
and
myself
are
going
to
show
you
today
and
before
we
get
into
the
demos,
I'm
going
to
demo
a
little
bit
in
that
map.
A
A
So
you
can
see.
There's
eight
different
types
of
charts,
plus
a
gantt
chart
that
you
can
make
now.
The
important
thing
that
you'll
notice
in
this
repository
is
that
this
ms
app
file-
this
is
actually
the
chart
component
that
you
will
import
into
your
power
app
to
use
them
to
get
started.
You
click
this
link
down
here.
That
says,
quick
start
right
above
the
picture
and
when
you
click
quick
start,
it's
going
to
open
up
this
documentation
that
you
see
right
here.
A
A
A
A
A
So,
as
you
come
back
now
to
your
chart,
import
upload
file-
and
then
here
is
where
you
will
then
go
and
pick
that
one
that
you
just
downloaded-
here's
the
one
I
just
downloaded
right
now.
You
only
have
one
copy
within
that
hit
open
when
you
hit
open
those
charts
get
added
right
here,
so
the
one
called
chart
can
make
eight
different
types
of
chart.
The
one
called
gant
only
makes
a
gantt
chart
to
add
it
to
your
screen.
Go
to
the
screen.
A
You
want
it
on
open
the
custom
section
and
drag
the
chart
on
now
that
you
drag
the
chart
onto
your
screen.
What
you
can
do
is
you
can
resize
that
chart
to?
However,
you,
like
the
type
of
the
chart
right
here,
gets
set
with
this
property,
so
this
could
be
pi
scatter
line
bar,
etc.
Everything,
but
the
gantt.
A
A
A
If
I
remove
the
first
five
colors
in
it,
you
can
see
how
easy
it
is
to
change
the
color
scheme
of
your
chart
to
something
else.
Perhaps
I'd
like
to
change
the
title
to
something
a
little
different,
I
can
make
a
really
great
title,
really
quick
like
that,
and
maybe
I
decide
I
don't
want
the
subtitle
on
my
chart
so
I'll
delete
it
as
well.
A
Perhaps
I'm
looking
at
the
legend
of
the
chart
and
saying
I
wish
I
would
have
that
in
a
different
spot
or
I
could
affect
how
that
looks.
Well,
you
can
do
that
with
the
legend
property
right
here.
I
can
turn
it
on
or
off
too.
Let's
say
I
want
to
move
it
to
the
top
I'll.
Just
go
like
that.
Now
it's
at
the
top
of
my
chart,
if
I
didn't
want
it
I'll,
just
set
this
true
to
false,
or
I
can
bring
it
back
now
when
I
come
to
the
bottom
there's
a
couple.
A
A
Finally,
my
data
section,
which
I
think
is
easier
to
look
at
in
the
top
up
here,
looks
like
this
data
is
bound
in
key
value
pairs
for
this
particular
type
of
chart.
Actually,
this
is
not
my
data
value
here.
It
is
there.
It
is
so
here's
the
different
data
that
I
have
in
the
chart.
Obviously,
I'm
showing
you
hard-coded
data
here,
which
may
or
may
not
probably
wouldn't
occur
in
a
real-life
chart,
but,
as
you
can
see,
as
I
change
it,
the
chart
reacts
immediately.
D
Thanks
todd,
hi
everybody,
so
first
things.
First,
let's
look
at
what
the
schema
is
for
a
gantt
chart.
Let's
go
ahead
and
click
on
the
chart
and
then
we'll
click
on
data,
and
here
we
can
see
what
it's
looking
for.
So
real
simple.
We
have
this
property,
which
right
now
is
just
set
to
a
static
group
of
values
as
well
as
the
label,
so
the
legend
down
here
on
the
bottom
right
now.
D
The
labels
on
the
left
hand,
row
side
and
then
the
meat
of
the
chart,
which
is
the
intervals
table
and
that's
just
looking
for
values
of
start
date
and
date,
color
index,
which
this
correlates
to
the
color
table
of
what
colors
can
be
used.
So
the
first
value
in
in
the
color
table
will
correlate
to
this
and
as
well
as
the
process
index
which
aligns
for
which
row
you
want
to
be
on
the
gantt
chart.
D
So
this
is
the
static
data,
but
first
so
we're
going
to
be
switching
it
over
to
dynamics.
So
let's
go
ahead
and
look
at
my
data
source
and
I
have
a
simple
sharepoint
list
here:
called
project
tasks.
I
have
a
title
row,
a
start
date
and
end
date
and
that's
the
core
of
what
you
need
now.
I
have
a
couple
other
columns
project
name
and
assigned
to
because
you
can
really
make
this
dynamic
and
and
add
a
lot
more.
You
know
a
lot
more
options.
D
You
have
the
sky's
the
limit
really
so
now
that
we've
seen
the
data
source,
let's
go
ahead
and
let's
look
at
I'm
going
to
switch
powerapps
screens,
and
so
here
we
see
a
gantt
chart
with
some
of
my
data.
So
we
see
the
labels
and
the
different
days,
and
so
let's
go
look
in
and
find
out
how
to
do
this.
So
let's
switch
over
or
let's
click
on
the
data
property
and
actually
might
not
be
what
you
expect.
D
So
we
have
this
set
to
a
global
variable
because
we
are
setting
this
data
on
on
the
on
visible
property,
so
we'll
go
to
the
invisible
property
of
the
screen,
and
here
we
are
so
first
step
is
to
create
a
collection
from
our
data.
So
I
simply
click
clear
collect
name
our
collection,
pull
it
from
our
project
task
list.
D
Let's
go
ahead
and
switch
back.
Okay,
so
that's
step
one,
and
actually
we
can
go
ahead
and
quickly
view
the
collection
project
tests
here.
So
here
you
can
see
the
collection's
been
built,
switching
back
okay,
so
next
step
is-
and
this
was
an
actually
an
optional
thing-
I'm
using
the
titles
for
these
tests
on
both
the
legend
and
the
rows.
So
I
just
set
a
variable
called
titles.
I
ran
a
for
all
function
and
just
collected
those,
and
by
doing
that
I
was
able
to
call
this
once
and
you
can
see
oops
my
bad.
D
D
So
I
have
this
wrapped
in
a
global
variable,
but
what
we
need
here
is
so
then
you
just
assign
the
legends
to
our
titles
variable
and
which
is
the
table
and
same
thing
for
this
c
labels,
property
and
then
the
intervals.
So
again,
I
do
a
for
all
function
for
all
items
in
our
project
task
collection
and
then
I
just
assign
the
start.
Property
with
my
start
date.
Column
end
date,
the
color
index
and
process
which
in
this
case
there's
multiple
ways
to
do
this.
D
So
I
set
a
variable
of
today
and
formatted
it
to
be
a
short
date
format,
because
that's
what
the
scheme
is
looking
for-
and
I
also
made
another
variable
called
var
three
months
and
basically
same
type
of
thing,
but
I
added
use
the
data,
add
function
and
that
in
90
days,
so
each
time
we're
looking
at
the
chart,
I'm
going
to
see
from
today
in
the
next
30
90
days.
Rather
so,
let's
go
back
to
the
chart
for
a
second
and
check
out
the
options
and
in
the
options
for
this
chart.
D
This
is
where
I
have
plugged
in
those
optional
dynamic
pieces.
So
for
gantt
start
date,
I
have
my
var
today
and
for
gain
end
date.
I
have
my
var
three
months
and
there's
lots
of
other
options
which
again
are
clearly
outlined
in
our
documentation
and
that's
how
this
chart
gets
built
all
right.
So
that's
how
easy
it
is
to
connect
to
a
sharepoint,
datasource.
D
Thanks,
I
think
we
have
another
example
here,
just
a
similar
example-
and
this
is
all
outlined
in
our
we-
we
take
you
through
this.
This
is
connecting
to
a
excel
sheet
and
over
here
in
the
data
we
can
see,
we
have
a
movies
excel
spreadsheet
in
our
onedrive
location,
and
so
we
go
ahead
and
just
get
our
data
from
excel
that
populates,
a
collection
of
movies
and
votes,
and
then
we
just
bind
that
data
to
the
table.
D
We
can
see
how
easy
easy
that
is
so
again
same
type
of
method
that
you've
seen
before
we're
setting
global
variable
again,
that
part
is
optional,
but
we
are
setting
the
labels
for
this
type
of
chart
running
through
and
grabbing
the
genres
of
our
collection.
And
then
this
is
a
key
value
pair.
So
we're
the
key
are
our
values
and
then
the
votes
is
the
values,
and
so
that
you
can
see
how
simple
it
is
to
make
this
dynamic
and
again.
This
is
our
outline
tutorial
in
our
documentation.
A
Quite
honestly,
it's
because
we
just
haven't
packaged
it
in
a
component
library
yet,
and
it's
in
our
component
and
we've
been
really
working
hard
on
the
documentation
recently
to
release
it.
So
people
can
understand
how
to
pick
it
up
and
use
it
easily.
They're
happy
to
see
it
done
if
you'd
like
to
help
out
with
it
like.
We
totally
encourage
contributions
on
all
this,
and
we
really
see
this
and
hope
that
this
is
like
the
foundation
of
an
awesome
set
of
charting
components
for
the
whole
community
wait.
A
A
Last
month,
I
think
he's
got
a
good
idea:
real
quick
shout
out
to
emmanuel
gallis
sancho,
harker,
raza
durani,
david
van
heerden
and
all
of
our
teammates
at
canvas
who
gave
us
feedback
on
this
and
helped
help
us
build
it
out.
So
we
could
get
it
to
the
point
where
everyone
can
use
it.
We
hope
you
all
enjoyed
a
lot.
A
A
Awesome
doing
good
so
you're
going
to
talk
to
us
about
the
project
oakdale
my
expenses
power
app
today
and
I'm
lucky.
I
got
to
see
this
before
so
I
can't
wait
to
see
what
new
things
you
may
have
added
to
it
since
the
first
time
I
saw
it
so
I'll.
Let
you
take
it
away
from
here
and
show
us
what
you
built
sure.
E
So
power
apps,
as
everyone
knows,
is
the
low
code
application
development
platform
can
come
here
and
build
a
wide
variety
of
apps
and
connect
to
n
number
of
data
sources
platform
in
itself.
The
power
platform
comes
with
a
data
layer
that
it
exposes,
which
is
called
the
common
data
service,
which
has
powerful
rich
data
types.
It's
a
relational
data
model
and
it's
built
for
scalability.
E
On
the
other
side
of
the
spectrum.
In
m365,
we
have
microsoft
teams,
which
is
our
hub
for
teamwork
and
in
teams
typically
for
building
applications.
You
need
to
probably
have
more
pro
dev
skills
in
order
to
build
apps
and
deploy
them
into
teams.
Now
powerapps
makes
that
really
easy
in
a
low
code,
no
code
experience.
E
So
would
it
not
be
great
if
we
could
merge
the
tool
together,
whereas
we
can
leverage
the
power
platform
along
with
the
data
layer
which
is
cds
and
have
all
of
that
experience
directly
in
microsoft
teams,
and
that
is
exactly
what
project
pokedale
is
project.
Local
is
the
code
name.
For
now
this
name
is
going
to
change
in
future.
Basically,
this
is
a
low
code
data
platform
that
has
been
built
for
your
microsoft
teams
and
the
way
you
get
started
with
this
is
in
microsoft.
E
Of
course,
we
just
have
15
minutes,
so
I'm
going
to
be
respectful
of
that
time.
I
have
already
gone
ahead
and
created
certain
artifacts
with
respect
to
my
microsoft
team,
so
I
have
a
team
here
called
play
zone
and,
if
I
head
over
to
see
all
this
will
list
out
all
the
artifacts
associated
with
my
microsoft
team.
E
Now
the
key
thing
to
understand
about
project
oakdale
is
you
can
build
apps,
you
can
build
flows.
You
can
also
build
chat,
bots
using
power,
virtual
agents
and
all
of
these
three
things
can
leverage
the
low
code
data
platform,
which
is
embedded
directly
for
your
team.
It's
like
a
light
version
of
cds
and
right
here.
E
If
I
head
over
to
tables
these
are
all
the
data
tables
that
I
can
create
within
the
context
of
my
microsoft
team
and
all
of
this
at
no
additional
licensing
cost
your
standard
office
licenses
will
give
you
access
to
all
of
this
so
for
building
bots,
no
premium
licensing
for
building
apps
and
flows
that
talk
to
your
data
tables,
embedded
in
your
microsoft
team,
no
premium
licensing
required
whatsoever.
So
that's
the
beauty
of
project
oakdale.
E
Now,
in
my
scenario,
I
would
like
to
demo
an
application
that
I
built
leveraging
project
oakdale
and
the
idea
for
this
actually
came
up
with
one
of
the
templates
in
powerapps.
So
if
I
head
over
to
powerapps-
and
if
I
go
to
home
there
is
this
small
little
link
that
is
extremely
difficult
to
look
at
it's
right
here.
It
is
called
all
templates
and
if
I
head
over
here,
this
will
list
out
a
lot
of
the
templates
that
were
created
by
microsoft
for
the
powerapps.
E
Now,
of
course,
most
of
these
templates
are
pretty
old
and
some
of
the
patterns
in
them
are
also
outdated.
So
let
me
warn
you
before
starting
to
use
them,
but
right
here
there
is
a
template,
called
expense
reporting.
It's
called
the
my
expenses
template
and,
of
course,
this
template,
although
it
says,
connects
to
sharepoint
and
reality
it
does
not.
It
just
connects
to
a
very
simple
excel
file.
I
believe,
and-
and
it's
just
a
good
starter,
boilerplate
template
to
get
started
with.
E
E
E
E
I
can
give
this
a
start
date
and
an
end
date
notice,
the
usage
of
the
controls
and
the
theming
that
matches
the
theming
of
microsoft
teams.
So
I
will
pick
today's
date.
End
date
is
today's
date.
I
can
go
ahead
and
pick
a
cost
center
associated
with
my
expense.
I
will
pick
contoso
and
I
will
go
ahead
and
plug
in
a
few
commands
and
I
will
click
create
now
the
moment
I
do
this.
This
has
gone
ahead
and
created
an
expense
for
me
in
my
oakdale
environment.
E
Now
this
what
you're,
looking
at
right
now
is
leveraging
the
data
platform
for
teams
and
I'm
using
a
lighter
version
of
the
data
platform,
which
is
cds,
which
enables
a
relational
data
model.
So
right
here
for
an
expense,
I
can
add
multiple
line
items.
So
let
me
go
ahead
and
add
a
line
item.
A
line
item
basically
is
a
receipt
that
I
can
upload
related
to
my
expense.
E
Now
right
here
in
the
context
of
teams.
Once
again,
I
can
go
ahead
and
upload
a
receipt.
This
is
using
the
image
data
type
in
oakdale,
so
I'll
go
ahead
and
say
upload
a
receipt
and
because
I
am
on
my
mobile
device,
I
have
the
option
of
opening
my
camera.
So
let
me
go
ahead
and
do
this
and
right
here
on
my
desk,
I
have
a
fake
receipt
that
I
stole
from
the
web.
E
So
this
is
not
me
and
I'll
go
ahead
and
take
a
picture
so
I've,
basically
right
now
using
my
camera,
just
taken
the
picture
of
a
receipt
and
the
moment
I
do
this,
I'm
actually
leveraging
azure
cognitive
services
now
which
calls
in
the
receipt
scanning
component
and
that
will
go
ahead
and
process
the
receipt
and
get
the
information.
So
I
was
just
talking
to
waste
time
if
you
notice
right
there
on
the
bottom.
It
gives
me
the
name
of
the
merchant.
E
It
gives
me
the
total
cost,
and
it
also
gives
me
the
transaction
date
all
of
this
leveraging
azure
cognitive
services.
Next,
I
can
go
and
pick
the
category
associated
with
my
expense.
This
is
food
and
beverage,
give
a
description
so
I'll
call
this
a
virtual
lunch,
and
then
I
will
click
on
save
and
just
like
that,
I
added
a
line
item
and
related
it
to
the
expense.
That's
the
relational
data
structure
right
here
in
action.
E
Is
this
data
gets
recorded
of
course,
however,
at
the
same
time,
I'm
leveraging
power
automate
to
start
an
approval
process.
So
let's
go
ahead
and
let's
go
back
to
my
schemes
now.
What
has
happened
is
I
went
ahead.
I
created
an
expense
and
I
submitted
my
expense
and
the
moment
I
submit
my
expense.
What
it
does
is
it
basically
records
it
in
the
system
and
based
on
the
cost
center.
I
have
dynamically
defined
my
approvals.
E
I
will
show
you
how
I
did
that
in
the
data
layer,
when
I
show
you
the
tables
so
right
now,
what's
happening
is
a
flow
is
getting
triggered
and
that
flow
is
going
to
send
out
an
adaptive
card.
Why?
Because
I
want
to
stay
in
the
context
of
teams
to
my
approver
dynamically,
so
my
approver
can
go
and
approve
or
decline
the
request
now
and
it
takes
typically
10
to
15
minutes.
So
I
went
and
pre-created
something
as
you
can
see
here
is
the
adaptive
card
in
action
right
here.
E
So
this
is
the
adaptive
card
that
my
approval
will
receive
and
in
this
adaptive
card
I
have
a
link
directly
to
my
receipt
and
if
I
select
this,
this
will
actually
open
up
that
same
app
in
the
context
of
teams.
Well,
it's
just
opening
a
new
tab
and
not
just
that.
It
will
also
deep
link
me
directly
into
that
expense
item,
for
which
I
am
performing
the
approval
action,
and
I
can
see
the
same
details
right
here.
I
can
look
at
the
the
user
has
uploaded.
E
I
can
see
all
the
details
right
here
and
once
I
want
to
take
a
decision,
I
can
go
ahead
and
either
approve
this
or
reject
this
right
here
within
the
context
of
teams,
and
once
I
click
on
submit
my
approval
decision
is
recorded.
All
of
this
information
goes
back
into
my
data
layer,
which
is
my
oakdale
platform.
That
information
is
recorded
there
and
the
user
who
created
the
expense,
is
notified
that
your
expense
is
currently
approved
in
the
system.
E
Now,
if
I
head
back
as
reza
once
again,
who
is
the
person
who
created
the
expense
and
if
I
head
back
to
the
expense
reporting
app
this
time
on
my
browser
in
teams?
This
is
the
community
call
prep
that
I
just
approved,
and
this
is
the
approval
task
right
here
of
82.98,
so
you
can
build
apps,
you
can
build
flows,
you
can
use
the
relational
data
model,
but
there's
more,
you
can
also
use
power.
E
Virtual
agents
to
build
chatbots
and
all
of
this
at
no
additional
cost,
so
I
went
ahead
and
built
a
chat
bot
as
well
that
talks
to
the
same
data
platform
and
this
bot
is
something
that
I
can
interact
with
directly
in
microsoft
teams.
So
once
again,
on
my
left
hand,
navigation,
rail,
I
have
my
expense
reporting
board.
So
let
me
go
ahead
right
here
and
say
hello,
I'm
going
to
try
and
zoom
in
as
well.
So
I
just
said
hello
and
the
bot
responded
with
hi
reza
I'm
a
virtual
agent.
E
I
can
help
you
with
details
regarding
your
expense
reports.
Now
the
bot
is
contextually
aware
of
the
logged
in
user.
So
it
knows
that
it's
me
presidenti
and
I'm
gonna
say
I
need
details
of
my
expense
expense
report.
So
I
need
details
about
my
expense
report.
It
goes
ahead
and
tells
me
okay.
So
what
is
the
status
of
the
expense
you're?
Looking
out?
For
maybe
I'm
gonna
say
I
am
not
bothered
about
the
status.
Just
show
me
everything
related
to
a
status,
and
the
next
question
is
enter
the
dollar
amount.
E
The
flow
will
query
my
data
source
get
that
information,
pick
the
data
and
post
that
information
back
right
here
to
my
bot
and
as
you
can
see,
it's
gone
ahead
and
showed
me
all
those
expenses
that
are
above
50
dollars
and,
at
the
same
time,
because
I
selected
status
as
all
it's
going
to
show
me
everything
whether
they
are
rejected
or
whether
they
are
approved
and
in
this
as
well.
This
is
doing
the
deep
linking
functionality.
So
if
I
pick
the
microsoft
ignite
related
expense
that
was
rejected.
E
E
Now,
if
I
head
back
to
my
microsoft
themes
and
if
I
head
over
to
powerapps
and
if
I
head
over
to
the
build
tab
once
again,
I
just
want
to
show
you
what
the
backend
looks
like.
So
this
is
my
team
and
in
this
theme,
if
I
head
over
to
apps,
you
can
build
multiple
apps
per
team,
so
you're
not
restricted
to
just
building
one
app.
So,
as
you
can
see
right
here,
I
have
an
expense
reporting
app.
I
have
a
help
desk
app
that
I've
built
for
this
specific
team.
E
E
The
key
here
is
in
the
tables
that
I'm
leveraging,
which
is
the
relational
data
model,
that's
baked
in
right
here
for
you
in
the
context
of
microsoft
teams.
Now,
in
my
scenario,
remember
I
created
expenses
with
line
items.
So
if
I
head
over
to
expenses-
and
if
I
go
to
quick
edit
they've
kind
of
given
a
sharepoint
like
experience
right
here,
which
is
very
cool,
as
you
can
see,
this
is
listing
out
all
the
expenses
that
are
being
logged
in
my
system
and
all
that
information
is
right
here
and
remember.
E
This
is
a
relational
data
model,
so
I
have
related
this
to
other
tables.
For
example,
I
have
a
table
called
line
items.
This
is
where
all
those
individual
line
items
are
mapped
and
they
are
related
to
an
expense,
and
here
is
that
lookup
column,
which
is
a
true
lookup,
because
it's
creating
the
relationship,
even
the
receipts
that
I
uploaded.
You
can
see
those
images
right
here
in
the
quick
edit
mode
and
finally,
I
have
my
third
table,
which
is
called
cost
center
and
when
the
user
picks
a
cost
center
when
they
are
creating
a
receipt.
E
This
is
where
I'm
dynamically,
defining
my
approvers.
So
in
my
scenario,
because
I
picked
the
cost
center
as
contoso
james
gets
the
approval
action.
If,
if
I
picked
it
as
microsoft,
then
reza
would
get
it.
So
I
can
dynamically
define
my
approvers
as
well,
and
leverage
flow
to
talk
to
the
same
back-end
data
source,
so
this
was
all
about
the
expense
reporting
solution.
I
think
this
is
something
that
is
pretty
cool
and
all
of
this.
What
I
built
by
the
way
is,
I
built
it
in
10
hours
flat.
Why?
E
Because
I
reused
a
lot
of
things.
I
I
reused
one
of
the
existing
templates.
I
use
project
oakdale
quickly,
build
these
tables
and
create
these
relationships.
Just
push
my
app
into
project
oakdale
copy
paste
stuff
in
there
and
connect
things,
build
a
flow,
build
approvals
and
the
chatbot
experience,
as
you
saw
it
in
action.
B
E
E
I
would
just
like
to
give
one
one
shout
out
please
from
my
side,
I
would
like
to
give
a
shout
out
shout
out
to
that
api
guy
vivek
bavishi,
the
there
is
no
ai
builder
today
in
project
oakdale.
I
really
hope
it
comes
in
future.
Currently,
it's
not
available.
So
if
you
noticed
when
I
added
my
receipt,
it
went
ahead
and
scanned
the
receipt
for
me
using
the
receipt
scanning
component.
E
A
A
F
Maybe
let
hugo
kind
of
speak
to
that
because
obviously
he's
the
one
that
built
this
awesome
web
part.
I
know
that
we
had
kind
of
been
talking
about
what
the
current
sharepoint
web
part
for
powerapps
can
do,
and
just
some
of
the
gaps
that
we're
looking
to
fill
and
so
kind
of
collaborating
with
hugo
on
that
give
some
ideas
of
some
things
that
would
be
cool
to
have
in
it,
and
he
just
kind
of
took
it
and
ran
with
it
to
you
know,
give
back
to
the
community.
A
F
F
F
Add
that
in
here
and
then
you
see,
the
two
settings
that
we
have
to
configure
are
obviously
the
link
to
the
powerapp.
So
I'm
going
to,
I
want
to
integrate
this
timesheet
application,
so
I'm
going
to
copy
that
url
and
I'm
going
to
paste
that
in
there
and
really
the
only
thing
other
than
that
that
we
can
configure
is
whether
or
not
to
show
a
border
and
you'll
notice
that
when
I
embed
this
in
with
that
web
part,
the
power
app
is
really
small
and
I
have
no
control.
F
You
know,
even
though,
that
this
is
optimized
for
the
tablet
you
know
in
the
desktop
it
takes
up
so
much
space
when
we're
using
it
in
the
powerapps
portal
itself,
but
when
we
use
it
here
in
embedded
sharepoint,
it's
just
not
really
optimized
right,
it's
just
pretty
small,
a
little
bit
hard
to
see
and
to
work
with.
So
that
was
one
of
the
first
things
that,
with
this
web
part,
you
go
helped
us
address.
F
So
if
we
go
and
add
his
new
enhanced,
powerapps
webpart,
you'll
kind
of
see
the
difference
right
off
the
bat
here,
so
we're
going
to
click,
add
an
app
it's
going
to
look
some
similar
and
I'm
going
to
add
in
that
same
link
to
the
app
and
you
see
when
we
do
that.
Now,
that's
actually
taking
up
the
the
width
of
the
column
that
we
have
here
within
the
sharepoint
page,
much
easier
and
more
user
friendly
to
work
with.
F
So
I
mean
this
alone
to
me:
is
a
big
improvement
just
seeing
visually
like
the
difference
between
this
small
one
and
this
nice
easy
to
use,
because
what
it's
doing
behind
the
scenes
is
it's
taking
the
scale
that
you
have
of
your
power
app.
So
if
I
go
edit
this
web
part
and
scroll
and
open
up
the
appearance
section,
we
see
that
we
can
control
and
customize
the
aspect
ratio.
So
we
can
either
dynamically
resize
it
based
off
of
that
aspect,
ratio
or
we
can
even
define
a
fixed
height.
F
So
we
can
come
in
here
and
manually
say
that
this
should
be.
You
know
like
800,
pixels
high
or
whatever
we
need
to
do
so.
We
have
a
lot
of
good
control
over
that
when
you're
trying
to
embed
these
power
apps
in
your
sharepoint
pages.
So
that's
the
first
thing.
The
next
big
one
though,
and
this
one
that
really
gets
me
excited-
is
the
dynamic
properties
capability.
F
F
So
if
you
wanted
to
do
something
like
we
have
over
here,
have
a
sharepoint
list
of
tickets
and
then
be
able
to
click
on
one
and
have
it
show
that
relevant
ticket
in
your
power
app.
We
can't
do
that
today
with
the
out-of-the-box
web
part,
but
we
can
with
hugo's
enhanced
web
part,
so
I've
actually
implemented
this
here.
So
if
I
click
on
one
of
these
tickets,
you
have
a
powerapp
on
the
right,
and
you
see
it
takes
me
directly
to
that
item,
and
this
is
again.
F
What
really
gets
me
excited
about
this
web
part
and
it's
as
simple
to
configure
as
we
edit
this
page.
I've
obviously
added
his
web
part
on
here
and
what
I
did
to
make
this
functionality
happen.
Is
I've
expanded
out
the
dynamic
properties
and
when
you
click
the
option
here
on
yes
to
and
turn
that
on,
to
pass
dynamic
properties?
We
have
these
drop
downs
where
we
can
select
the
content
that
we
want
to
pass
from.
So
it
knows,
and
it's
getting
the
context
of
every
web
part
that
I
have
on
the
sharepoint
page.
F
So
it's
going
to
ask
me:
okay,
do
you
want
to
pass
in
context
from
this
tickets
list?
So
I'm
going
to
select
that
and
then
you
can
define
what
what
are
you
wanting
to
pass?
So
you
wanted
to
pass
a
column
value,
for
example,
which
is
what
I
wanted,
because
I
want
to
pass
the
id
of
the
selected
item
into
my
powerapps.
F
So
I'm
going
to
select
that
column
containing
the
filter
value
and
then
it's
going
to
list
out
once
you
do
that
all
the
columns
that
you
have
in
there
that
you're
able
to
pass
in
so
I
just
went
in
and
selected
the
id
column
and
then
finally
you'll
define
the
parameter
name.
So
this
is
what
powerapps
is
going
to
see
to
be
able
to
read
with
the
param
function
and
know
to
get
the
value.
So
I'm
just
going
to
put
that
as
id.
F
F
I
want
them
to
be
able
to
use
the
application
embedded
and
submit
and
browse
and
submit
a
new
item
that
way.
But
then,
if
they
click
on
the
item
pass
the
value.
So
that's
what
I'm
doing
here
is
use
the
browse
gallery
selected.
If
that's
blank,
but
if
it's
not
look
up
to
our
tickets
list
and
find
and
get
the
id
with
the
matching
value
from
our
parameter,
so
you
can
use
this
concept,
for
you
know
anything
that
you
can
imagine
here
where
you
want
to.
F
You
know:
pass
data
from
one
web
part
to
another,
the
other
one.
So
one
of
the
things
you
know
going
back
to
teams,
apps,
okay,
we're
able
to
inherit
the
theme
of
your
team
again
within
sharepoint.
We
don't
actually
have
that
right
now,
but
thanks
to
hugo's
enhanced
web
part,
we
can
now
pass
in
theming
elements
from
your
sharepoint
site
to
your
powerapp.
F
So
if
we
go
back
into
the
edit
mode
of
his
and
expand
out
this
theme
property,
you
see
that
we're
able
to
with
this
drop
down
see
all
of
the
different
variants
of
your
sharepoint
theme.
So
if
I
wanted
to
use
any
one
of
these
like,
for
example,
I
have
body
text
selected
or
a
button
background.
I
just
select
those
from
the
option
here
and
now
I'm
able
to
pass
those
as
parameters
into
my
power
app
and
customize.
F
The
look
and
feel
so
all
you
have
to
do
is
keep
in
mind
of
which
one
you
want
to
set
the
color
for.
So
if
I
want
to
utilize
button
background,
I'm
just
going
to
type
that
in
as
my
parameter
value
to
look
for
in
the
powerapp-
and
it
is
case
sensitive,
so
make
sure
that
you're
aware
of
what
the
the
case
is
when
you're
doing
this
and
even
shows
like
here
so
just
use
the
color
value
param
and
then
the
parameter
from
the
theme
property
that
you're
wanting
to
use.
F
F
So
this
is
the
the
great
thing
about
his
web
part
and
just
lots
of
possibilities,
and
it
really
makes
you
know
integrating
your
power
apps
within
sharepoint,
just
that
much
more
powerful,
and
with
that
I
think
I'm
going
to
turn
over
to
hugo
now,
just
to
talk
a
little
bit
more
of
well.
How
do
you
actually
get
his
web
part
installed?
So
you
can
start
using
it
and
go
over
a
little
bit
more
details.
There.
C
C
But
if
you
don't
have
what
you
need
to
actually
build
the
web
part,
we've
actually
created
the
pre-built
version
of
the
web
part
for
you.
We've
included
the
url
in
the
presentation,
but
if
you
go
to
this
github
repo,
which
which
is
the
sharepoint,
the
the
microsoft
sharepoint
web
parts,
samples
repository
and
you
go
to
the
enhanced
web
powerapps
web
part,
you
can
just
download
the
sppkg,
which
is
what
a
sharepoint
package
is
once
you've
downloaded
it.
C
Now,
if
you
have
never
created
an
app
catalog
for
your
sharepoint
tenant.
Clicking
on
this
link
here
will
prompt
you
to
create
an
app
catalog,
but
if
you
have
an
app
catalog,
it'll
actually
just
take
you
there
and
when
you
get
to
the
error
at
catalog,
you
want
to
go
to
the
library
called
apps
for
sharepoint,
and
you
just
want
to
upload
the
file
that
we
just
downloaded
so
I'll
just
go
here.
C
The
first
thing
you'll
notice
is
it
asks
for
your
permission
now.
This
web
part
requires
absolutely
no
permissions
whatsoever
because
it's
running
in
the
context
of
the
user,
but
it's
always
important
when
you
add
custom
web
parts
or
custom
solutions
that
you
pay
attention
here
to
what
it
says.
This
is
only
saying
it
will
go
to
your
sharepoint
online.
It's
not
asking
for
special
permissions
or
anything
like
that.
C
C
Click
on
add
an
app,
and
if
the
demo
gods
are
with
me,
we
should
now
have
the
react.
Enhanced
powerapps,
client-side
web
part.
I
know
the
name
is
not
very
fun.
It's
just
the
default
name
that
it
gives
when
you,
when
you
add
a
web
part
or
when
you
create
a
new
web
part.
So
here
it
will,
it
will
take
a
few
seconds
to
add
it
and
I
don't
think
the
page
refreshes
itself
automatically.
But
if
you
just
kind
of
refresh
this
a
few
times
eventually,
it
will
show
up.
C
But
thankfully
this
is
like
a
cooking
show.
I
had
prepared
things
in
advance
just
to
make
sure
so
once
the
web
part
has
been
added
to
your
site,
you
can
just
add
it
now
to
a
page
and
just
to
show
you
how
I
would
have
done
that
I
would
just
go
here.
I
would
just
insert
webpart
and
then,
if
you
look
at
enhanced,
there's
an
enhanced
web
part
here-
and
this
is
the
part
that
you've
already
seen
april
demonstrate.
C
But
some
of
the
things
that
I
wanted
to
show
you
that
are
also
available
here
and
april
did
a
great
job
but
demonstrated
the
concept
of
the
dynamic
properties.
But
there
are
a
lot
of
dynamic
properties
that
are
available
to
you
and
it's
worthwhile
exploring
that
we
have
a
few
more
minutes.
So
let
me
just
show
you
so
the
first
thing
here
is
when
you
select
yes,
I
want
to
pass
dynamic
properties
as
a
parameter.
C
But
if
you
click
on
page
environment,
which
is
the
environment
or
the
information
about
the
the
page
in
which
this
web
part
is
running,
it
actually
extracts
other
things,
including
things
like
the
site
properties,
which
would
be
things
like
the
url
of
the
site,
the
name
of
the
site,
the
classification,
the
title
description
and
so
on
and
so
forth,
which
you
can
use.
So
you
can
actually
have
different
flavors
of
the
same
powerapp
app
depending
on
where
it's
attached
from
the
current
user
information
is
also
available.
C
So
you
can
leverage
that
to
take
advantage
of
things
like
username,
email
or
login
name,
and
one
of
the
cool
ones,
is
the
query
string.
So
the
query
string
allows
you
to
whatever
url
will
be
called
when
you
display
the
page.
Whatever
comes
after
the
question
mark
here
will
be
available
as
a
query
string
parameter.
So
if
you
click
on
query
parameters
now
here,
you
see
by
default,
the
the
page
just
says
mode
equals
edit.
So
the
only
property
that
should
be
available
here
is
mode.
C
But
if
I
change
the
mode
here
see
you'll
already
pass
the
edit
property.
So
if
you
wanted
to
add
more
things,
you
can
create
urls
here
and
add
more
parameters
in
here
again,
it's
a
great
way
to
do
this
and
then
the
search.
This
is
great.
If
you
actually
embed
a
search
web
part
into
the
page,
you
can
take
advantage
of
the
search
properties
to
actually
retrieve
the
information.
C
All
right,
so
just
one
last
thing
that
I
wanted
to
point
out
here
is
that
there
are
there's
always
this
one
parameter
that
we
pass
all
the
time,
which
is
the
locale
information,
so
you
can
actually
create
localized
versions
of
your
powerapp
apps.
So
if
you
want
to
have
a
different
power,
app
or
different
resources
that
load
based
on
whether
the
the
user
speaks
english
or
spanish
or
french,
you
can
absolutely
do
that.
That's
always
passed!
You
just
need
to
use
the
pram
locale.
C
Your
page
to
embed
it
in
a
teams
right,
so
this
is
the
same
page
and
there
you
go
so
I
used
the
same
page
here,
but
I
embedded
it
in
in
the
teams
environment.
So
the
great
thing
about
this
is
now
you
can
build
something
again,
a
master
detail
situation
that
is
using
the
context
of
the
page
but
embed
it
inside
of
a
teams.
I
could
remove
all
the
heading
and
all
the
stuff
and
make
it
really
look
like
it
belongs
inside
of
teams,
but
that's
pretty
much
it
for
me.
C
I
I'm
always
looking
for
suggestions
on
ways
to
improve.
As
I
was
telling
april,
I've
been
working
on
adding
the
ability
for
it
to
list
all
the
apps
that
you
have,
so
you
don't
have
to
copy
and
paste
a
url,
but
I'm
looking
for
more
suggestions.
So
if
there's
anything,
you've
always
wanted
the
out
of
box
web
part
to
do
just,
let
me
know-
and
yes,
if
you
order
now
in
the
next
30
seconds,
we'll
also
include
another
web
part
for
you.
A
So
how
about
we
take
we
make
an
oakdale
power
app
and
we
put
our
charting
components
in
it,
and
then
we
stick
it
on
the
sharepoint
page
with
your
web
part,
and
then
we
pass
in
the
color
scheme
of
the
sharepoint
site
when
you
click
on
a
list
item
it
gives
you
a
chart
that
shows
the
details
for
that
list
item
and
the
chart
matches
the
color
scheme
of
the
sharepoint
site.
So
basically
we
learned
how
we
could
do
that
exact
thing
today
with,
like
writing.
Hardly
any
code
at
all.
C
C
A
A
Yeah,
so
here
are
the
resources
associated
with
the
call.
So
if
you're
looking
for
hugo's
powerapps
web
part,
there's
the
link
where
you
can
go
get
that
and
this
deck
will
be
available
after
the
call
as
well,
and
there
is
where
you
can
also
get
the
expense
reporting
solution,
walk
through
and
download
from
reza,
and
he
also
has
a
playlist
in
youtube
to
get
started
with
building
apps
flows
and
bots
everything
you
saw
him
do
today
with
project
oakdale
as
well.
A
B
B
I
want
to
repeat
that
number
again,
998
videos
submitted
from
the
community
on
how
to
do
different
things
in
powerapps.
So
you
know,
if
you
actually
this
week,
you
could
be
the
lucky
number.
One
thousand,
I
think
april
will
almost
assuredly
get
that
just
from
the
number
of
videos
that
she's
been
submitting
great
jobs
for
april.
B
The
one
that
I
wanted
to
call
out.
That
was
really
really
good
is
three
ways
to
create
custom
connectors.
So
if
you're
looking
at
creating
custom,
connectors,
go
out
and
check
out
the
power
addict,
maverick
and
the
his
great
video
he
actually
tomorrow
at
the
vancouver
user
group,
he's
going
to
walk
through
that
video.
If
you
have
any
questions
for
it,
the
two
samples
that
we
called
out
todd
actually
called
out
the
powerapps
alert
notification
component.
That
is
so
cool
that
was
deepak.
B
I
believe
who
did
that
from
our
demo
extravaganza
a
huge
shout
out
to
dpac
and
definite
and
indefinite
looping
and
power
apps.
That
was
oh.
I
think
it's
actually
already
got
like
four
or
five
kudos,
so
those
are
both
samples
and
a
video
for
you
to
get
from
the
community
itself.
Great
from
my
team
tomorrow,
we've
got
the
power
platform
community
conference.
I
think
there's
a
couple
people
githas
on
there
reza
is
actually
presenting.
B
So
it's
you
know,
24
hours
of
power
platform,
goodness
also,
and
if
you
haven't
checked
out
the
usage
analytics
in
the
isv
studio,
that's
actually
a
blog
post
that
we
just
did
last
week,
zancar
actually
published
that
so,
if
you're,
an
isv
and
you're
actually
looking
to
go
out
and
figure
out,
where
are
people
coming
from?
What
are
they
doing?
How
are
they
using
your
application?
B
A
B
And
next
post
is
the
community
conference
itself,
so
this
is
actually
you
guys
presenting
in
a
24-hour
conference.
So
instead
of
like
ambassadors,
which
is
the
microsoft
people,
we
actually
john
levesque,
my
my
peer,
my
teammate,
my
friend,
my
colleague,
has
actually
gone
out
and
picked
out
the
very
best
of
the
community
and
actually
his
big
effort
was
going
out
and
constraining
it
down
to
the
number
of
people
because
he
actually
could
easily
go
to
a
five-day
conference
back-to-back.
B
B
If
you
haven't
registered,
it's
free
go
out
and
do
that
and
actually
it's
it's
now
watch
popcc.
You
can
still
do
this,
but
this
will
actually
force
you
to
do
a
registration
at
this
point
you
can
go
out
and
and
just
go
directly
to
the
youtube
link
because
that's
available
on
youtube.
Okay,
todd
back
to
you.
A
A
We
are
to
learn
more
about
that
several
of
the
folks
who
participate
in
this
caller
also
on
that
one
every
month,
and
in
addition
to
that,
one
back
to
donna
and
sarah,
they
have
the
less
code,
more
power,
video
series-
and
this
is
much
shorter
than
the
power
addicts
hangout,
or
this
call
you'll
find
these
to
be
10
to
15
minute
discussions
with
folks
from
around
the
world
who
are
great
at
power
platform.
So,
if
you're
looking
for
shorter
content
or
just
even
more
content
about
this
technology,
that's
another
great
place
to
go.
A
Look
finally,
we'd
both
like
to
say
everybody.
Thank
you
for
coming
on
the
show
today,
sharing
your
expertise.
Your
time,
thanks
for
everybody
in
chat,
it's
such
a
fun
community
to
be
a
part
of
the
recording
will
be
available
in
the
microsoft
365
youtube
channel.
Very
soon
you
can
follow
on
twitter,
microsoft,
365,
dev
and
you'll
get
an
announcement
on
when
that
happens.
A
B
And
next
month,
before
we
finish
next
month
is
going
to
be
really
exciting.
We
have
the
the
forum
super
users,
so
these
are
the
guys
that
answer
hundreds
and
hundreds
of
questions
every
single
month
are
going
out
and
doing
what
they're
actually
learning
from
looking
at
all
of
your
questions
in
the
forums
and
distilling
that
app
into
a
single
hour.
So
all
the
questions
all
to
support
all
the
troubleshooting
in
one
hour,
I
highly
recommend
you
actually
look
at
next
month's
community
call.
Thank
you
todd.
Thank
you
reza.
Thank
you.
Matt.
Thank
you
april.