►
From YouTube: Microsoft Power Apps community call-August 2020
Description
This month's call hosted by Todd Baginski and Charles Sterling included Power Apps best practices through a Power Apps Cookbook, Practical AI Builder in Power Apps and integrating data sources with Flows. Plus recent Power Apps news and community contributions.
Speakers: Belinda Allen, Brian Knight, Paul Stork
Blog summary https://aka.ms/AA9d8ho
Stay connected
Twitter https://twitter.com/microsoft365dev
Blogs https://aka.ms/M365DevBlog
A
A
We
have
our
call
every
third
wednesday
of
every
single
month.
Our
next
call
will
be
on
september
16th.
In
this
call
we
do
the
latest
news
and
community
contributions.
We
meet
products,
teams
behind
power,
apps,
we
do
technical,
deep
dives
and
we
explore
neat
things
that
are
happening
in
the
land
of
power
apps.
A
That's
me
on
the
left,
I'm
todd
baginski.
I
work
at
canvas
from
a
partner
and
cto
and
I
lead
our
teams,
all
things
technical.
You
can
find
me
on
twitter,
on
my
blog
or
on
youtube,
where
I
like
to
share
what
I
learn
about
powerapps
as
well
and
as
usual
I
have
charles
sterling
with
me
chuck.
How
are
you
doing
today?
I'm.
A
Pretty
good,
pretty
good
glad
to
be
back
in
the
swing
of
things
after
a
tough
last
week,
breaking
my
arm
so
chuck
good
to
have
you
here
and
you're
you're
joining
us
from
vacation
today.
Actually,
aren't
you.
A
That's
awesome
so
a
little
bit
about
what
we're
going
to
do
on
our
call
today,
we'll
quickly
introduce
the
rest
of
today's
team
for
the
call,
and
then
we
have
belinda
here
and
belinda
is
going
to
share
all
about
her
powerapps
cookbook.
A
So
it's
definitely
a
real
world
thing
as
well.
We'll
also
talk
about
news
and
community
contributions
across
the
land
of
powerapps
and
throughout
the
entire
call.
You
can
use
the
chat
for
q
a
which
brings
us
to
all
these
awesome
folks,
every
time
we
house
this
call
these
folks,
as
well
as
many
others
and
if
you're
one
of
the
folks
who's
always
on
this
call
and
helping
out
in
chat.
A
Let
me
know
I'd
love
to
get
your
picture
up
here
too,
but
these
folks
are
community
champions,
powerapp,
mvps
power
addicts,
all
those
things
mean
they
love
powerapps,
and
do
it
all
day,
long
and
they're
here
in
chat
to
help
you
out.
So
if
you're
stuck
on
something
or
wondering
how
to
do
something,
you
can
come
to
this
call
every
month
and
get
unblocked
and
learn
more
about
powerapps,
real
time
right
in
the
chat.
So
thanks
everybody
for
being
a
part
of
that
with
us.
A
C
I
do
that
is
pretty
much
all
I
do
anymore.
I've
been
working
with
the
microsoft
family
of
products
for
24
years,
so
now
I
just
do
what
I
enjoy,
which
is
training,
so
I
work
mostly
with
partners,
and
so
as
I
I'm
gonna
go
ahead
and
share
my
screen
and,
as
I
share
my
screen,
it'll
make
more
sense
as
to
why
I
share
work
with
partners.
C
So
I
had
an
app
in
my
ipad,
which
I
had
for
many
many
years
and
at
the
beginning
of
this
year
they
started
telling
me
we're
going
to
start
charging
you
2.99
a
month,
and
I
only
used
it
for
a
few
recipes.
So
I
said,
I'm
not
going
to
do
it
and
the
recipes
I
used
it
for
were
mostly
when
I
traveled
and
like
when
I
go
to
my
parents
house.
C
More
often
than
not,
I
make
my
dad
cashew
brittle,
and
so
I
thought
I
just
need
a
place
to
store
that,
and
I
thought
I
know
I'll
build
an
app
right.
We've
got
a
hammer
everything's
now,
so
I
started
building
this
app
and
I
kept
starting
over
because
I
kept
having
more
and
more
ideas
and
then
all
of
a
sudden
one
day
it
dawned
on
me
that
in
this
app
there's
a
lot
of
comparisons
to
businesses,
and
so
I
started
looking.
C
If
you
look,
I
have
the
cookbook
area
in
the
middle
there's,
you
have
a
recipe,
you
have
ingredients
and
you
have
directions
and
it's
very
much
the
same
as
so
many
projects
in
a
business
itself
right
in
the
business
industry.
So
if
we
look
on
the
left,
we
think
about
projects.
There
are
projects
you
can
have
budgets
or
estimates,
which
is.
These
are
all
the
things
I
need
to
do
on
my
project
and
then
the
big
things,
and
then
you
have
individual
tasks
or
even
more
advanced.
C
C
The
cookbook
is
thinking
about
that
particular
scenario.
So
I'm
here
as
the
proverbial
drum
banger
for
the
citizen
developer
people.
If
you
can't
see
on
my
camera,
I've
got
a
little
citizen
developer
tag
that
this
is
where
so
many
people
can
pay
for
their
licenses
for
power
apps,
and
then
you
can
get
into
the
bigger
things.
So
some
of
the
people
you
had
on
that
call
like
reza
durrani
and
daniel
christian
and
and
my
very
close
personal
friend,
mariano
gomez,
as
well.
C
They're,
amazing
people
but
they're
pro
developers
and
they
think,
like
pro
developers
and
although
they've
done
some
amazing
citizen,
developer
type
stuff.
The
fact
that
these
are
the
things
that
drive
those
return
on
investments
so
that
you
could
do
the
more
amazing
things
we
need
to
remember
to
to
take
advantage
of
some
of
these
smaller
things.
One
app
that
I
built
for
one
customer
that
had
a
return
on
investment
of
less
than
a
month
was
a
simple
list.
C
That's
all
it
was
just
a
gallery
with
a
list
and
when
they
selected
on
what
they
would
select
one
and
then
press
a
button,
and
that
was
inside
of
a
power
bi
report
and
that
paid
for
the
whole
power
apps
and
power
bi
in
the
first
month.
So
we
need
to
remember
that
sometimes
the
little
things
can
really
make
a
big
difference.
So
when
we're
looking
at
a
cookbook
here-
and
you
notice
that
my
slide
deck
chuck,
this
is
a
nod
to
you.
My
slide
deck
is
actually
a
power
app.
D
C
So
this
is
the
traditional
recipe
card
right,
so
you
have
the
whole
recipe
and
then
you
have
the
ingredients
and
you
have
the
indirect
directions.
So
that
kind
of
leads
me
to
I'm
just
going
to
show
you
click
on
the
ingredients
and
right
now,
looking
at
cake
there's
only
a
few
ingredients
in
here
I
do
have
a
cup
one
of
my
favorites
in
here.
Let
me
do
a
search
on
that
one.
This
is
one
I
got
from
my
mother,
a
four
layer,
surprise.
C
This
is
one
of
my
favorites,
but
a
simple
recipe
list
and
notice.
This
is
nothing
fancy.
This
is
the
standard
gallery
and
then,
if
you
just
add
to
it,
I'm
just
here
to
remind
you
that
some
of
these
simple
things
can
make
a
big
difference
so
like
when
you
press
this
button,
it
sends
an
email
to
me
telling
me
what
the
shopping
list
is
and
if
I
have
recipe
notes,
I
can
see
them
here.
I
could
see
a
description
of
the
product,
a
bigger
picture
and
I
could
even
go
in
and
look
at
the
ingredients.
C
C
One
of
the
the
act
that
just
resonates
the
most
with
me,
where
I
did
actually
work
with
a
customer,
was
just
a
little
gallery
list.
It
was
nothing
special,
so
if
I
were
to
go
back
to
the
gallery
list,
this
is
all
it
was
right.
Just
a
simple
list:
only
the
title:
they'd
click
it
they'd
select
a
button.
It
would
go
into
sql,
it
would
approve
a
batch
and
problem
solved
and
that
saved
them
about
eight
hours
a
week.
C
That's
a
lot
of
time
and
we're
talking
about
the
controller.
So
that's
a
high-paying
position
in
new
york
city
eight
hours
a
week
do
the
math.
That
is
my
whole
presentation,
because
I
don't
want
to
show
anything
super
fancy.
I
want
to
remind
you
about
the
basics
and
the
problem
solving.
Once
you
get
someone
to
pay
for
powerapps
itself
to
pay
for
the
license,
then
you
could
go
and
build
some
pretty
fantastic
things
not
much
there.
I
see
you're
looking
todd.
A
I
was
looking
for
the
you
know
how
they
changed,
where
the
buttons
are
in
teams,
since
it
pops
out
now
looking
at
the
bottom
where's,
my
unmute,
that's
really
nice.
Do
you
use
this
as
your
way
to
go
into
or
to
to
actually
attack
real
use
cases
in
the
real
world
too?
To
start
people
with
this
and
try
to
find
analogies
between
the
two,
like
you
outline
in
your
your
three
columns
slide.
B
C
Or
don't
have
a
deep
or
in-depth
knowledge
of
it,
and
so
I
do
at
that
point,
and
so
I
think
that
I
mean
there's
so
many
things
you
can
do
with
it.
There's
so
many
things
that
I
still
want
to
take
it
deeper
and
deeper,
and
those
are
things
like
add
in
if
you
have
the
number
of
servings,
how
many?
How
many
servings
do
you
want
to
make?
C
So
if
it
makes
eight
servings
and
you
want
to
make
16,
you
tell
it-
I
want
to
make
16
servings,
so
it
doubles
the
ingredients
for
you
or
it
doubles
the
nutritional
value
for
you,
so
that
you
could
use
some
of
those
things.
But
yes,
I
do
I
talk
about
it
because
it's
so
it's
it's
exactly
the
same
thing,
especially
with
light
manufacturing.
It's
exactly
the
same
thing.
The
only
difference
in
light
manufacturing
is
when
you
get
to
the
ingredients.
C
A
I
think
that's
really
helpful
to
talk
about
too,
because
so
many
times
like
you
mentioned
on
this
call,
we
get
really
technical
right.
We
dive
into
like
hey.
This
is
really
how
you
need
to
do
this
if
you
want
it
to
perform
right
or
things
like
that,
but
but
this
is
before
you
even
talk
about
how
you're
going
to
build
it.
You
have
these
conversations
right.
How
do
I
shake
out
my
use
cases?
Who
are
my
scenarios
that
I'm
working
with
here?
A
C
No,
I
do
not
yet
this
is
something
that
I've
been
like.
I
said
I've
been
playing
around
with
it
for
a
while
I've
demoed
it
there
was
a
a
couple
of
times:
we've
had
presentations,
daniel
christian
and
mariano,
and
I
kind
of
a
app
off
if
you
will
and
at
one
of
them.
I
showed
a
previous
version
of
this.
Of
course,
daniel
crushed
me
like
a
little
amp,
but
in
showing
his
lego
app.
But
that
being
said,
I
I
I
showed
it
there,
but
it's
something
that
I
I
keep
thinking
about.
C
My
problem
is-
and
this
is
one
thing
a
lot
of
developers
have
I
keep
changing
my
mind
and
things
I
want
to
add.
I
need
to
stop
and
I
really
need
to
get
at
the
basics,
but
it's
something
that
I
am
about
to
start
vlogging
on,
because
it's
sticking
to
the
basics
to
solve
some
basic
fundamental
problems
is
quite
the
big
deal,
and
often
it
unearths
bigger
problems
that
list
that
I
told
you
about
they
didn't
ask
for
that.
They
asked
for
something
entirely
different
to
save
time,
but
I
kept
digging
in
well
like.
C
Why
do
you
want
this
and
then
what
I
uncovered
was?
It
was
just
taking
a
long
time
for
them
to
do
batch
approval,
and
so
I'm
like,
let
me
solve
that
problem
and
then
all
the
other
problems
will
just
disappear
and
not
only
will
they
disappear,
but
I'll
save
more
time
for
you,
and
so
I
mentioned
the
time
the
controller
saved.
I
didn't
mention
the
time
that
the
accounting
person
saved.
So
that's
why
I
said
I
mean
it
was
less
than
a
month
roi.
A
A
C
A
A
That's
great
thanks
again,
we
hope
to
see
you
again
and
that
you
can
come
back
and
share
the
next
souped-up
version
of
it
once
you've
got
it
ready
to
roll.
I
see
a
couple.
People
in
chat
think
they
already
have
a
good
use
for
it
too.
A
Awesome
all
right-
we
are
doing
good
here
on
time
today,
let's
move
over
next
to
welcome
brian
knight,
brian
thanks
for
coming
and
you're,
going
to
chat
with
us
about
ai
builder.
I
so
you
live
in
florida.
I
live
in
jacksonville
yeah
go
right
on!
I
didn't
know
that
I
thought
you
were
down
in
texas
for
some
reason.
A
So
you've
been
working
with
with
ai
builder
for
a
long
time
now,.
E
Since
the
early
preview
days
yeah
and
there's
some
and
before
that
it
was
all
azure
at
the
azure
ml
side
and
a
little
bit
cv
as
well
computer
vision
site
as
well.
So.
E
All
right
cool
so
get
money
with
brian
knight,
my
email
address.
E
I
have
one
slide
today
and
this
is
it
just
to
kind
of
have
my
contact
information
on
I'm
a
I'm
also
here,
as
todd
mentioned
in
jacksonville
florida,
and
then
I'm
a
founder
of
a
company
called
pragmatic
works
where
we
do
things
in
analytics
and
azure
as
well
as
power
apps,
and
then
I've
authored
a
number
of
books.
We
have
a
book
coming
up
in
about
two
weeks
here
on
power
platform,
and
then
I
blog
at
pragmaticworks.com.
E
E
Call
you
know
todd
you're,
the
only
one
that
actually
notices
that
I
I
I
forever.
My
brother
played
a
prank
on
me
that
she
messed
up
my
bio
slide
a
long
time
ago,
and
I
kept
it
because
I
loved
it
so
much,
but
nobody
even
even
chuckles
at
it
anymore.
I
I
don't
get
it
all
that,
so
you
don't
really
have
one.
No,
no.
A
E
So,
as
I
mentioned
before,
I've
been
doing
since,
like
belinda
since
the
twenty
some
years,
but
doing
data,
data,
processing
and
database
work,
power,
bi
work
and
one
of
the
most
fun
projects
you'll
ever
have
and
one
of
the
biggest
impacts.
You'll
ever
do
are
machine
learning
and
ai
projects,
and
traditionally
they've
been
one
of
those
things
that
have
required
a
lot
of
work.
You'd
have
to
install
analysis
services
or
do
something
like
and
train
the
model
and
do
all
that.
E
So
I'm
going
to
kind
of
take
belinda's
idea
and
go
a
little
further
with
it
on
focusing
on
the
citizen,
developer
and
less
about
the
heart,
the
hardcore
dev
stuff,
as
well.
Now,
when
you
open
up
powerapps
and
you
go
to
make.powerapps
you're,
going
to
see
really
cool
stuff
in
the
ai
builder
already
under
build,
and
you
can
sign
up
for
a
trial
and
it's
and
it's
very,
very
easy
to
do
now.
There's
a
whole
slew
of
pre-built
models,
but
there's
also
some
some
good
ones
that
you
can
use
as
well.
E
Some
of
the
ones
I've
used
are
this
object?
Detection,
one
that
we've
used,
that
for
inventory
systems,
where
I
can't
find
this
this
one
customer
didn't
have
a
barcode
system.
For
example,
they
they
just
had
they
had
pictures
of
products.
So
we
trained
the
model
to
to
recognize
those
pictures.
They
would
hold
their
phone
up,
take
a
picture
of
it
and
then
say
I'm
adding
two
of
these
to
my
to
my
system.
E
E
This
is
for
scanning
and
they're
improving
us
every
single
release,
but
there
is
taking
a
a
1099
tax
form,
for
example,
or
an
invoice
form,
for
example,
scanning
it
and
pulling
the
data
out,
so
you
can
use
it
and
power
automate
or
empower
apps,
so
you
can
train
it
just
to
scan
over
a
list
of
documents,
for
example
on
a
sharepoint
list.
You
know
loop
over
there
pull
all
the
key
information
out
load
it
into
a
sql
server
and
then
areas
where
it's
not
100,
confident
on
you
can
kind
of.
E
You
know,
check
this
somewhere
else
for
manual
intervention.
Potentially,
so
I'm
going
to
focus
on
a
variant
of
that
and
it's
with
a
brand
new
feature
they've
added
very
recently,
and
it's
for
doing
receipt
processing.
So
what
I'm
going
to
do
is
I'm
going
to
go
ahead
and
open
up
a
brand
new
app
and
we'll
just
go
ahead
and
pick
one
here
from
from
scratch
here,
we'll
call
this
just
a
community
call.
E
Haven't
had
my
caffeine
this
morning
and
then
what
we're
going
to
do
is
we'll
build
a
really
simple
app
to
do
some
really
complex
things
now
this
would
have
taken
me.
You
know,
potentially
months
and
months
and
months,
like
computer
vision,
building
models
around
that
to
pull
the
key
data
out
now
we're
going
to
build
this
in
less
than
10
minutes.
So
it's
kind
of
a
it's
very,
very
much
geared
at
citizen
developers
and
ultimately
it's
it's
really
lowering
the
curve
that
would
normally
take
a
a
pretty
hardcore
development
effort
to
do
so.
E
This
is
going
to
be
we're
going
to
go
ahead
and
under
the
insert
ribbon
you'll
find
there's
a
little
ai
builder
and
we'll
select
this
new
receipt
processor.
It
is
a
preview
feature,
and
so
some
of
the
things
might
be
improved
and
changed
as
time
goes
on,
but
the
core
functionality
is
not
likely
going
to
change.
E
So
this
is
a
little
bit
of
a
variant
of
the
form
processor
and
it's
not
really
geared
at
looking
at
invoices
per
se,
it's
more
geared
at
and
it's
been
trained
already
and
and
tested
around
these
ad
hoc
receipts.
Now
it's
not
only
going
to
do
you
know
a
nice
form
printed
receipt,
but
it
will
also
do
things
like
handwritten
objects
as
well
looking
for
tips,
for
example,
so
I
then
dropped
in
this
this
receipt,
and
this
was
an
example
we
used
for
a
basic
expense
report.
E
Now
this
I
got
a
lot
of
pretty
stuff
on
it,
we're
going
to
keep
it
very
simple
for
this
demo,
but
I
want
to
go
ahead
and
scan
for
receipt
and,
let's
see
here,
I
got
a
camera
right
from
my
screen
here
and
we'll
just
do
a
good
old-fashioned
target
proceed
here
and
let
me
zoom
in
closer,
so
you
can
see
what's
happening.
Okay,
once
this
comes
in
comes
in
it's
sending
it
up
to
the
the
model
and
there
we
go
so
you'll
notice
in
blue
whoa,
too
close
and
blue.
E
There
you'll
notice
in
blue
here
the
areas
that
it
found
in
the
receipt.
So
things
like
hey,
I
recognize
you
know
who
is
this
receipt
for?
What's
the
merchant's
number
and
there
they
address
the
transaction,
the
time,
the
transaction
and
the
address.
Now
all
these
elements
that
it
found
you
actually
get
a
list
in
the
gallery.
You
can
say:
well
what
did
you
find?
So
it
was
there
a
tip
even
in
this
transaction
and
if
there's
our
tip,
is
it
in
the
normal
boundaries
of
what
we
expect
on
a
per
vm
basis.
E
Perhaps
so
all
these
kind
of
really
nice
rules.
We
can
build
to
automate
this
this
human
interaction.
You
can
also
see,
of
course,
it
found
all
the
products
right
there
and
it
found
things
like
all
the
skew
all
the
the
subtotals
and
all
the
line
item
totals
as
well.
So
how
do
we
access
this?
Well,
first
of
all,
what
I
want
to
do
is
I
want
to
put
like
the
total
text
in
here.
So
I'll
drop,
a
quick
label
in
here.
E
Go
and
I'll
just
pop
this
right,
underneath
this
just
the
time
being.
Of
course,
we're
not
gonna
make
this
very
pretty
right
now,
but
we'll
go
ahead
and
say
something
like
how
about
we
say:
merchant,
okay
and
we'll
do
now
that
you'll
notice
on
the
left.
Here
it's
called
receipt
processor,
one!
So
there's
a
whole
list
of
of
static
objects.
We
can
get
and
there's
a
whole
list
of
collections.
E
We
can
get
as
well
we're
gonna
just
go,
go
to
an
object
here
like
I
want
to
get
that
vendor
name
of
where
I
actually
bought
this
from
so
I'll
point
over
to
receipt,
processor
one
then
go
to
dot
and
then
you'll
see
that
the
merchant
address
the
merchant
name.
Now
it's
going
to
show
you
objects
that
that
may
not
actually
have
data
in
it
either.
E
Like
the
merchant
address,
for
example,
the
target's
address
wasn't
actually
captured,
but
I
do
have
the
merchant
name
and
you'll
see
it
actually
recognizes
a
little
o
from
target,
as
well
as
the
actual
target
as
well.
So
it
recognizes
it
that
thinks
it's
an
o
in
this
case,
but
did
recognize
target
and
we
can
also
go
through
and
say:
let's
also
get
the,
how
about
the
let's
say
and
we'll
say,
total
and
go
back
to
receipt
processor.
E
Here
we
go
and
this
time
we'll
do,
let's
type
in
total
here
that
should
work
here
we
go
so
there
we
go
now
we
can
see
how
much
was
the
receipt
at
pretty
darn
cool,
but
now
I
want
to
actually
get
a
line
item
listing
of
all
the
items
in
this
receipt.
E
So
to
do
that
we'll
just
need
a
quick
gallery
I'll
just
throw
in
a
quick
blank
gallery
right
here
and
just
kind
of
slide
it
over
here
and
I'm
going
to
drop
in
a
little
label
here,
wrong
place,
okay
and
for
the
gallery
itself.
Let's
go
ahead
and
point
to
the
the
items
that
were
actually
purchased
so
we'll
go
again,
go
back
and
receive
processor
one
again
and
do
dot
and
then
we'll
see,
purchased
items
now
notice
in
here.
E
You
also
have
some
other
goodies
as
well
like
if
I
go
to
detected
fields,
for
example,
if
I
select
that
look
at
the
kind
of
objects
you
get
inside
of
here,
we
can
see
what
it
actually
found
on
the
receipt,
so
you
can
build
business
rules
on
hey.
Do
I
see
things
like
you
know,
tips
for
example,
or
not
tips.
We
can
actually
have
some
rules
that
say:
did
you
detect
certain
things
and
act
certain
ways
based
on
what
you
found?
You
can
also
get
a
list
of
all
the
raw
objects
as
well.
E
Okay,
perfect
and
the
minute
we
do
that,
let's
go
ahead
and
drop
in
a
quick
label.
Okay,
there
we
go
we're
already
seeing
our
items.
Let's
go
ahead
and
skinny
this
up.
There
we
go
and
then
what
we
typically
do.
What
our
customers
request
is
we're
using
this
for
the
initial
validation
of
the
receipt,
so
I'm
going
to
go
ahead
and
drop
in
a
quick
input
label.
Our
input
box.
E
Excuse
me
there
we
go
captured
it
right
there
we
go
and
on
this
one
we'll
just
go
through
and
do
a
this
item
dot,
and
I
should
see
a
total
there.
There
we
go
total
price
so
now
we're
seeing
all
the
list
items
and
their
prices.
So
by
doing
this
now
I
can
have
my
my
account
person
actually
overwrite
and
say:
oh,
I
got
it
wrong,
got
it
right
and
I
can
go
ahead
and
figure
it
out.
You
know
based
on
that
on
that
individual
line
and
where
it
all
adds
up.
E
So
the
first
thing
that
we
see
customers
want
to
do
here
also
is
just
validate
this
number
okay,
so
I
have
what
we
think
is
the
to
the
total
down
on
the
receipt.
Does
that
line
up
with
the
total
right
here?
In
other
words,
is
it
screwing
up
something
like
you
see
right
here,
the
the
coupon
value.
Is
it
putting
that
as
a
line
item?
In
this
case,
it
did
not
on
about
on
about
30
receipts
that
we
uploaded
just
the
other
day
to
test
this.
E
We
had,
we
had
about
a
a
98
percent
hit,
so
we
had
only
two
receipts,
not
eight
percent.
Ninety
percent-
about
ninety
percent
hit.
We
have
two
receipts
that
had
small
issues
and
one
of
those
two
was
a
little
bit
larger
of
an
issue,
so
all
in
all,
pretty
darn
good.
So
the
next
step
you
may
want
to
do
is
we
want
to
go
ahead
and
do
some
data
validation
on
this.
E
What
I'm
doing
is
I'm
saying
taking
all
these
text
inputs
and
adding
it
up
and
making
sure
it
actually
equals
the
total
you
see
on
the
left
here,
so
it
looks
like
in
my
case
the
values
of
this
have
all
added
up,
and
you
can
see
that
counting
person
can
now
actually
change
that
and
go
to
70
cents,
for
example,
and
we'll
actually
see
those
values
all
change
also,
so
we
can.
You
can
quickly
change
that
and-
and
you
could
do
things
like-
let's,
let's
make
that
turn
red
or
it
has
some
kind
of
really.
E
You
know
bright,
flashing
colors.
That
say
you
know
things
aren't
balancing
right
now,
so
the
last
thing
you
may
want
to
do
is
to
turn
on
some
extra
stuff
that
that's
pretty
darn
slick
here,
I'm
doing
pretty
well
on
time
here.
So
let
me
go
ahead
and
add
one
or
two
more
labels
here,
and
I
love
this
one.
So
I'm
going
to
go
ahead
and
just
put
a
value
for
two
okay
and
we'll
just
do
receipt
processor.
E
E
E
Okay,
so
the
reason
I'm
doing
this
is,
I
want
to
show
you
a
more
complex
receipt,
the
the
one
that
we
get
day
on
day
out
when
we
go
to
a
restaurant
and
we're
traveling
all
in
business,
and
we
actually
want
to
see
this
value.
So
let's
go
ahead
and
scan
a
different
receipt
and
I'll
use
this
as
a
restaurant
one-
and
it
has
some
interesting
things
in
this
one,
this
time,
there's
no
products,
of
course,
but
it
has
some
some
craziness
right.
You
see
someone
actually
hand
sketched
some
areas
here.
E
So
now
we're
seeing
okay,
we
have.
Oh
you
just
kind
of
shuffle
this
around
there.
We
go
all
right
so
now
we're
seeing
that
it
actually
recognized
that
this
is
at
tgi
fridays
and
it
recognizes
the
12
bill
not
only
that
it
recognized
that
somebody
hand
wrote
a
two
dollar
tip
inside
of
this,
and
that
made
the
total
12
12
79
with
a
subtotal
of
10.79.
E
So
in
many
cases
what
we
have
is
a
this
big
county.
That's
using
this
for
is
they're
scanning
all
the
receipts
coming
in
from
a
coveted
expense
perspective.
The
cares
act
perspective
to
make
sure
they
balance
and
they
hit
certain
rules
so
they're
doing
this
in
power
automate,
but
they're
also
going
to
get
powerapps
to
load
the
load,
the
listed
library
as
well,
so
we're
seeing
a
number
of
entry
points
for
doing
this
type
of
stuff.
E
So
this
is
a
quick
example
on
how
you
can
use
some
of
the
new
brand
new
preview
features
in
ai
builder
for
a
citizen
developer,
just
a
really
practical
example,
all
right
so
toddle.
I
think
I'm
right
at
15
minute
mark.
A
Yeah
you're,
great
and
belinda
was
a
little
short,
so
we
have
a
few
more
minutes
here
before
we
need
to
hand
over
to
paul,
and
I
have
a
couple
questions
I
bet
the
audience
is
wondering
too
so
the
first
time
that
I
ever
worked
with
ai
the
whole
concept
of
after
I
did
my
initial
run
on
it
and
I
found
out
what
the
ai
didn't
do.
What
I
was
asking
it
to
do.
You
mentioned
you
uploaded
a
bunch
of
receipts.
It
didn't
get
a
couple
right.
E
Yeah,
so
in
this
case
this
is
the
packaged
model,
so
it
is
still
3d
mode.
So
it's
got
some
some
flaws
in
some
areas
and
it
came
down
to
my
case
to
just
some.
It
was
a
paper
that
was
kind
of
crumpled
up
in
one
case,
so
it's
more,
I'm
not
sure
if
the
model
is
ever
going
to
get
better
things
where
you
have
some
vendors
had
like
sub
sub
grids
inside
the
grids
and
didn't
do
as
well
with
those
areas
where
they
had.
E
They
had
line
items
that
were
kind
of
indented
as
a
sub
it
sub.
It
was
still
a
lot
still
a
line
on
them,
but
was
sub
indented
and
it
had
its
own
little
grid
underneath
that
so
some
more
complex
examples,
so
you
can
solve
that
with
things
like
azure
ml
or
our
cv,
and
you
can
kind
of
build
your
own
where
it
has
it
kind
of
takes
it
and
slices
it.
E
A
Yeah-
and
I
think
that's
a
really
good
thing
that
you
point
out
to
80,
because
I
think
a
lot
of
people
have
an
expectation
when
they
go
into
these
ai
things.
They
think,
because
they
watch
the
tv
commercials
that
it
will
get
everything
100
correct,
all
the
time
and
you're
even
saving
time
if
it
doesn't
get
it
100
correct,
like
you
said,
and
you
demonstrated
how
to
build
a
user
interface
to
evaluate.
Did
it
get
it
right
or
not,
really
quickly.
E
Yeah,
so
on
that
last
one
we
basically
would
go
through
and
on
that
target
receipt
and
our
accounting
group
and
the
county's
accounting
group
for
this
covet
example,
I
listed
would
go
through
each
line
item
and
just
make
sure
that
the
totals
added
up.
If
the
totals
added
up
this
number-
that's
here
and
this
number
here,
they
would
check
the
total
make
sure
the
total
is
good.
They
would
pass
that
receipt
on
without
any
touch
at
all
and
they
would
have
a
drop
down
box
to
categorize
these
items
as
well.
E
But
if
you,
if
something
didn't
line
up,
then
they
would
just
go
review.
The
lineups
make
sure
something's
not
off
and
then
make
those
adjustments
and
hit
the
save
button.
At
that
point,.
A
Perfect,
I
have
one
more
question
with
you
about
for
you
about
this.
I
noticed
when
you
were
in
the
intellisense
in
the
formula
bar
at
the
top
and
you
went
receipt
processor
one
dot,
and
you
had
the
collection
that
you
were
binding
up
to
your
gallery.
There
yeah,
which
there
was
another
one
besides
purchased
items
too,
and
what
was
the
first
one.
You
showed
us
that
had
all
the
possible
things
does
it
only
present
you
in
your
preview
here
for
detected
text,
what
it
thought
you
found
or
are
there
any?
A
A
E
A
E
E
Yeah,
I'm
building
a
video
today.
I
actually
just
made
a
few
extra
examples,
also
that
we
put
out
on
youtube
yesterday
as
well,
and
we
give
this
app
away.
This
is
a
the
back
to
work
example
and
this
one
all
the
code
is
out
there,
but
also
the
app
that
we
built.
That
was
always
what
other
as
well
and
it's
all
around.
Looking
for.
You
know
what
are
your
symptoms
and
are
you
eligible
to
go
back
to
the
office
and
then
we're
building
one
right
now
as
well?
E
This
is
a
a
gamification
for
a
classroom,
and
this
is
where
you
basically
go
through,
and
you
say
all
right.
This
is
a
brian
knight
and
then-
and
you
can,
you
know
what
kind
of
kind
of
50
points
for
gryffindor
for
doing
x,
y
and
z,
so
we're
we're
putting
out
a
whole
bunch
of
examples
in
the
next
few
weeks
that
we're
going
to
give
away
as
well
as
accelerators
for
for
schools
and
for
businesses
that
want
to
use
that.
But
that's
the
coveted
one
is
already
out
there.
E
A
C
E
Yeah
they
would
have
spent
more
than
an
hour
reviewing
all
those
receipts
in
the
past
to
make
sure
they
were
business
type
expenses
and
all
that
so
and
then
you
could
even
enhance
it
by
by
integrating
the
category
view
as
well,
that
the
other
ai
builder
component
and
say
is
this:
is
this
categorized
at
you?
If
I
see
the
word
beer,
for
example,
is
that
a
business
expense,
so
you
can
go
through
and
even
add
them
extra
layers
of
ai
to
automatically
categorize
those
as
well.
B
E
Well,
in
this
case,
microsoft
has
built
some
pre-built
models
for
you,
so
you're
not
having
to
use
azure
ml.
To
do
this,
you
know
behind
the
scenes.
There
could
be
some
stuff
happening
there,
but
microsoft's
already
done
on
training
for
you.
So
it
recognizes
those
elements.
If
you
want
to
do
like
a
forum
processor,
you
do
have
to
do
some
additional
training
there
to
teach
it.
What
kind?
What
is
a
1099
tax
form
look
like,
for
example,
or
what
does
an
invoice
form
look
like
for
the
receipt
processor?
There's
no
training
involved
at
all.
B
Yeah
my
question
is
around:
like
you
know,
the
model
is
built
by
a
certain
team
in
microsoft.
Is
it
the
cognitive
services
team
which
has
already
built
the
model?
I
see?
Okay,
and,
and
are
you
guys
like
in
the
app?
Are
you
using
azure
ml
pipelines?
Basically,
you
know,
because
you
are
scanning
these
right
and
the
the
model
is
actually
processing
this
data
and
inferring.
You
know
what
your
items
are
and
what
the
prices
are.
Is
that
something
that
you
had
to
do
or
something
that
is
inbuilt.
E
A
D
Actually,
the
the
the
ai
builder
team-
I
I
I
can
take
this
offline.
B
A
E
That
was
my
understanding
too
and
before
you
could
have
done
this,
but
you
would
have
had
to
use
the
connector
for
for
for
acs
or
azure
cognitive
services
and
and
done
it
that
way,
but
it
would
have
been
a
lot
more
work,
a
lot
more
training
to
make
it
happen.
Now
it's
just
one
click
you're
done.
E
I'll
next,
the
the
back
to
work
example
in
the
chat
window.
Again
this
is
a
free
freebie.
You
can
download
perfect.
A
That's
what's
the
greatest
thing
about
this
call
every
time
you
get
on
the
call
you
just
watch
the
chat
and
a
million
like
free
links,
pop
up
to
download
cool
powerapps
a
lot
of
fun.
It's
like
christmas,
very
good!
Well,
thanks
again,
brian.
Let's
move
on
over
to
paul
now
all
right,
all
right,
paul!
Welcome
to
the
call
thanks
for
coming
and
sharing
your
expertise
as
well.
A
Here
today,
and,
as
I
mentioned
at
the
beginning,
the
back
story
behind
paul's
topic
today
on
the
call
was
something
we
were
actually
working
with
in
the
production
scenario:
building
a
power
app
and
we
couldn't
figure
out
how
to
get
around
something
and
we
were
reaching
out
to
other
people
in
the
community
for
help
and
we
reached
out
to
paul
and
he's
like,
oh
yeah.
I
know
how
to
fix
this
one
and
after
he
fixed
it.
A
D
All
righty,
so,
as
todd
mentioned,
this
came
from
a
problem
that
his
team
was
having
and
if
I'm
remembering
it
right,
the
problem
that
they
were
running
into
was
they
were
working
with
a
sharepoint
list
that
has
a
massive
number
of
fields
and
they
really
didn't
want
to
return
all
those
fields.
So
what
they
wanted
to
do
was
to
go
out
and
limit
the
number
of
fields
that
were
being
returned.
The
number
of
columns
by
using
a
view,
unfortunately
powerapps,
doesn't
do
that.
That's.
A
D
Yeah,
that
was
what
it
was
the
number
of
look-up
columns,
the
other
spot
where
this
comes
from,
which
predates
todd's
call
was
the
reason
I
knew
how
to
to
kind
of
work
through
to
fix
this
was
I
had
worked
in
the
past
with
sql,
and
one
of
the
limitations
of
powerapps
is
that
the
sql
connector,
when
you're
in
powerapps,
cannot
call
a
sql
stored
procedure,
but
flow
can
so
the
idea
of
the
demo
today
is,
if
you
run
into
certain
limits
in
retrieving
data
in
power
apps.
D
D
It's
a
solution
for
a
spot
where
one
of
the
limitations
of
retrieving
data
in
powerapps
doesn't
leave
you
enough
options
to
go
and
limit
what
you're
getting
the
way
you
want
to
limit
it,
and
so,
for
example,
as
todd
said
in
his
case,
they
had
more
lookups
than
were
allowed
for
retrieving
things
in
power
apps.
D
But
if
you
went
into
flow
limited
to
the
number
of
columns
you
were
bringing
back
based
on
a
view,
then
you
could
go
ahead
and
pull
all
the
data
and
get
the
data
that
you
needed
and
since
they
didn't
need
those
extra
lookup
columns,
they
were
fine.
So,
let's
just
jump
into
the
demo.
I've
got
a
really
simple
boil
down
demo
here
to
walk
you
through
the
basic
steps.
So
we
have
a
power
app
here
and
on
the
main
screen
of
the
powerapp.
We
have
a
simple
gallery
just
title
subtitle
and
body.
D
Where
I'm
going
to
map
three
of
the
fields
from
my
sharepoint
list,
then
I've
got
a
text
box
and
what
I'm
going
to
use
that
text
box
for
is
to
retrieve
some
data
that
I'm
going
to
feed
into
the
flow
as
a
parameter,
so
that
I
can
use
that
as
part
of
an
odata
filter
to
filter
the
number
of
records
that
are
being
returned.
D
Now
you
can
pass
multiple
parameters
if
you
need
them.
I
tried
to
keep
this
pretty
simple.
When
this
returns,
it
will
return,
as
you
will
see,
a
javascript
object,
notation,
okay,
which
we
are
then
going
to
just
dump
into
a
collection
that
I
call
mydata
and
every
time
I
hit
this
button,
it's
going
to
refresh
that
entire
collection
and
then
my
gallery
is
just
bound
to
my
data.
D
Okay.
So,
let's
take
a
look
at
the
flow
close
to
do
this
and
in
fact,
todd.
I
think
this
flow
is
a
little
bit
more
refined
than
the
one
that
we
used
with
with
your
solution
are
really
pretty
simple.
Your
trigger
is
just
a
basic
powerapps
trigger
nothing
to
set
in
there.
Nothing
to
do
you
just
drop
that
into
the
the
flow
as
the
trigger.
D
Then
we
go
out
and
do
a
get
items,
and
this
is
where
some
of
the
magic
happens.
So
in
this
case
I'm
tying
to
a
sharepoint
list
called
projects
and
in
that
you'll
notice
that,
in
your
advanced
options,
there
are
a
number
of
ways
that
you
can
manage
the
data.
That's
coming
back,
you
can
issue
an
odata
filter,
query
which
gets
you
around
some
of
the
delegation
rules,
because
it's
a
bit
more
robust
than
delegation
is.
D
If
that
doesn't
work,
you
can
just
do
your
get
items
and
then
do
in
a
filter
array
and
use
the
array
because
that'll
definitely
get
you
around
it.
If
you
go
into
your
settings
and
turn
on
pagination,
this
is
one
of
the
things
that
you
can
do
in
flow
where
you
can
go
out
and
get
an
entire
data
set,
no
matter
how
big
it
is,
and
it
will
return
it
now,
there's
no
magic
here.
D
The
other
way
to
really
decrease
the
size
of
that
data
is
to
limit
the
number
of
columns
that
are
returned
by
using
a
sharepoint
view.
So
the
standard
view
for
this
list
is
all
items,
and
then
I
have
a
a
custom
view
that
I
called
flow
test.
So
if
we
go
out
here,
this
is
the
actual
list.
It's
just
a
little
list,
and
you
can
see
here
is
my
flow
test
view,
and
I've
only
got
four
columns
in
that
view,
if
I
go
out
to
all
items.
D
You
can
see
I
have
a
number
of
other
columns,
including
lookup
columns
that
I'm
just
not
interested
in
so
by
using
the
flow
test
view.
I
can
limit
the
number
of
columns
which
limits
the
amount
of
data
that
is
being
returned
back
to
the
flow.
You
can
also
limit
the
total
number
of
records
that
you
want
to
get
back.
You
can
order
the
data
based
on
an
odata
query
so
that
you
can
order
the
data
in
a
certain
way
say
give
me
the
top
100
and
be
done
with
the
whole
thing
all
right.
D
The
problem
is
that
it
really
doesn't
return.
Just
that
view
it
returns
that
view
plus
a
whole
bunch
of
system
fields.
So
if
I
go
out
here
for
the
moment-
and
let's
take
a
look
at
a
previous
run
and
go
in
here
and
take
a
look
at
this
select
statement,
you
can
see
that
the
input
here
is
a
lot
more
than
just
those
four
fields.
I
have
an
internal
id
number.
D
D
There
are
two
ways
that
you
can
get:
data
from
flow
back
into
powerapps.
The
one
that
comes
with
the
standard
license
is
called
respond
to
powerapps.
It's
really
nice.
There's
one
issue:
you
can
return
individual
types
of
data
like
text
date
number
and
so
on,
but
you
can't
return
an
array
to
return
an
array
you
have
to
use
the
http
request
response
action,
which
is
what
I'm
using
here.
The
only
problem
involved
here
is.
This
is
not
standard
license.
This
is
premium.
B
D
The
way
we
use
this
we
go
out
and
we
have
to
add
this
content
type
header
set
for
application
json
to
tell
the
system
that
what
I'm
turning
back
is
javascript
object.
Notation,
then
what
we
return
is
the
output
of
this
select
statement
and
that's
going
to
be
an
array
of
those
three
fields
that
I
picked.
B
D
D
C
D
And
so
now,
when
it
hits
this
particular
property
title,
it
says
well
that
property
might
be
a
string
and
it
might
be
null
just
adapt
with
whichever
one
it
is
and
that'll
get
you
over
some
of
the
problems
you
can
run
into
when
you
generate
schema
from
sample.
Okay,
so
back
to
powerapps,
as
I
said,
then
what
we
do
is
we
just
take
the
results
of
that
and
dump
that
into
my
data
and
what
we'll
get
is.
D
D
D
D
I
will
come
back
with
just
one
record
and
then
from
here
I
can
do
whatever
I
want
to
do
on
this.
I
added
a
little
edit
form
and
I
can
go
and
click
on
that
and
here's
my
edit
form-
and
you
can
put
things
in
here.
The
only
key
here
is
that
you're,
if
you're
binding
the
form,
you're
binding
it
to
the
collection
and
updating
the
collection,
isn't
going
to
update
the
back
end
data
source.
A
It's
all
good,
we're
tracking
good
on
time.
That's
a
really!
I
love
how
you
walk
through
it
front
to
back,
because,
as
you
think,
through
this
problem,
it
really
does
flow
straight
down
the
flow
right
I
found
the
hardest
part
of
getting.
This
right
is
the
whole
scheme
apart
and
the
very
last
part
you
described
about
getting
your
schema
in
there
correctly.
Do
you
find
that's
also
the
most
time
consuming
and
one
that
is
the
gotcha
in
this
process?.
D
It
it
was
until
I
realized
that
it
doesn't
auto-populate
that
schema
for
you.
I
wrestled
with
it
when
I
was
redoing
this
demo.
I
wanted
to
do
a
fresh
one
for
the
presentation
today,
and
it
took
me
about
three
hours
yesterday
to
realize
that
the
reason
I
kept
getting
false
or
true
was
that
I
wasn't
populating
that
schema
and
the
response.
A
D
And
then,
as
I
said,
the
only
other
key
is
to
be
careful.
If
your
json
can
return
a
null
value,
you've
got
to
go
in
and
hand
edit
the
schema
to
make
that
possible.
I've
run
into
that
it'll.
Give
you
a
very
clear
error
if
you
read
it
that
this
particular
property
was
null,
and
I
can't
do
that,
based
on
your
schema,
so.
A
B
D
But
anytime
you
get
into
doing
head
editing
of
schema.
It's
it's
difficult.
I
think
when
we
did
the
solution
for
you,
we
were
actually
taking
the
get
items
and
parsing
that
out
as
json
and
then
doing
things
with
it
and,
as
you
can
see
from
the
demo
today,
I've
realized
in
the
meantime,
that's
actually
not
required.
A
Yeah
yeah,
it's
simpler
thanks
for
sharing
it.
That's
a
great
pattern.
A
lot
of
people
going,
oh
wow,
I
didn't
know
you
could
do
that.
Oh
I
see
how
you
can
do
it
and-
and
we
have
a
big
push
to
go
vote
on
getting
that
feature
to
filter
by
view
into
powerapps.
Now
I
think
people
push
the
links
to
user
voice
too.
A
A
First
time
that
I
use
this
pattern
actually
was
for
executing
a
stored
procedure
when
I
had
to
craft
the
json
payload
back
to
the
power
app
myself
really
nice
trick,
though,
on
that
that
view
filter
by
view
within
the
flow
thanks
again
paul
for
coming
on
and
sharing
that
today,.
A
All
right,
let's
see
here,
wrapping
up
our
call
here,
just
a
couple
slides
left
for
today.
These
are
neat
things
that
have
been
going
on
in
the
powerapps
community
in
the
last
month.
So
I'd
love
to
bring
your
attention
to
them.
If
you're
into
alm
the
power
platform,
build
tools
have
now
reached
ga-
and
I
know
if
you
played
with
those
during
the
preview-
there
were
some
things
in
them
that
they
hadn't
figured
out
yet,
but
they've
got
them
all
figured
out
now.
A
I
don't
even
know
if
I
should
bring
the
name
up,
but
this
is
a
really
cool
integration
with
microsoft
teams
and
powerapps,
and
I
really
encourage
you
to
check
it
out,
because
I
have
a
feeling
that
we're
going
to
see
tons
of
app
dev
for
line
of
business
applications
being
built
within
the
project.
Oakdale
stack
going
forward
and
then
also
the
bunch
of
october
wave
2
release.
Updates
that
have
come
out.
You
want
to
check
all
those
out
some
things
with
model
driven
apps
and
some
other
little
tweaks
to
the
platform.
A
You
may
find
helpful
talk
a
little
bit
about
our
awesome,
powerapps
community
that
we're
all
thankful
to
be
part
of
here.
The
first
thing
we'd
like
to
do
is
give
a
shout
out
to
all
those
folks
who
are
part
of
the
powerapp
cc
hashtag.
This
is
what
we
use
to
kind
of
advertise
and
you
know
gel
our
community
of
the
folks
who
join
together
here
for
this
call
every
month.
So
thank
you
to
all
you
folks
for
sharing
what
you're,
working
on
and
and
spreading
the
good
news
about.
A
Powerapps
there's
also
a
couple
other
places.
If
you
like
this
format
of
call,
I
bet
you'll
love
this
one
too.
This
one's
called
the
power
addicts
hangout
the
next
one
is
in
september.
I
don't
know
the
exact
date
yet,
but
this
is
a
call
very
much
like
this
one
where
people
come
on
and
share
what
they're
learning
and
doing
with
powerapps
and
it
just
like
this
one.
You
can
get
your
questions
answered
and
learn
a
lot
of
great
things
and
meet
people
who
are
interested
in
this
check
out.
A
We
are
poweraddicts.com
and
go
learn
more
about
that.
There's
also
this
great
video
series
by
donna
and
sarah,
and
this
one
is
called
less
code
more
power
and
you
can
see
the
url
here.
I
encourage
you
to
go
check
that
out.
They
have
tons
of
videos
coming
up
they're
a
lot
shorter
than
this
hour-long
format.
We
have
for
the
call
brian.
A
I
know
you've
been
on
there
before
I've
also
seen
many
other
folks
who
are
in
the
chat
here
on
that
as
well,
and
I
like
these
videos,
because,
if
you've
got
five
minutes
in
between
a
meeting-
and
you
want
to
learn
a
new
topic-
five
ten
minute
little
quick
hit,
especially
if
you
put
it
in
two
times
talk
speed.
You
can
learn
some
really
things
very
fast.
A
So,
finally,
I'd
like
to
say
thank
you,
we
all
would
to
everybody
who
who
came
on
and
shared
your
time
or
just
joined
us
and
asked
questions
and
participated
in
the
chat
today.
This
recording
will
be
available
soon
on
the
microsoft
developer
channel.
You
can
follow
the
microsoft
365
dev
tag
on
twitter
to
get
a
link
to
it
and
more
updates
about
this
call
we're
going
to
meet
again
next
month
on
september
16
again
at
8
00
a.m.