►
Description
Learn how to create your own sort of "datasheet" view in a gallery in a canvas app, where you can quickly edit rows without having to open up a form.
Fill out this form if you're joining our live discussion for the first time http://bit.ly/2u68Dze
Check out our free Power Apps Basics Course: https://www.iwmentor.com/courses/powerapps-introduction
Buy me a coffee: https://bmc.link/wonderlaura
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -
Join the newsletter to vote for topics: https://bit.ly/PowerHourNews
Free Power Hour every Wednesday at 11am CST
Laura's Blog: http://www.wonderlaura.com
IW Mentor (Information Worker Mentor)
A
A
Alright,
so
I'm
Laura
Rogers-
and
this
is
Joelle
jobson
here
in
the
window-
hey
Joelle-
and
this
is
a
show
we
do
Wednesdays
at
11,
Central
and
we've
been
doing
this
for
about
10
years,
and
it's
all
about
things
that
you
can
do
in
Microsoft
365
that
are
not
too
technical.
So
it's
geared
towards
business
users
and
power
users
and
we
like
to
just
do
random
demos.
So
today
it's
going
to
be
powerapps
now,
if
you've
taken
our
courses,
powerapps
Basics
and
powerapps
advanced
at
iwmintor.com.
You've
got
all
those
fundamentals.
A
You
understand
kind
of
the
gist
of
how
everything
works,
and
you
understand
what
all
those
concepts
mean.
So
when
I
do
Power
hours,
it's
really
I'm,
not
necessarily
going
to
teach
things
from
scratch,
but
I'm
basically
going
to
jump
right
in
to
this
gallery
and
show
you
how
to
configure
it
and
show
you
how
to
make
how
and
why
to
make
this
Gallery
so
that
it
allows
you
to
edit
things
directly
in
the
gallery
and
joelle's
been
working
on
one
of
these
just
this
week
on
a
project
for
work.
A
So
in
this
first
thing
that
I'll
do
it's
going
to
be
it's
going
to
show
you
kind
of
what
that
looks
like
and
kind
of
what
this
interface
is
that
you'll
learn
today
and
if
it's
your
first
time
in
power
hour,
we
have
a
lively
chat
going
on
in
Microsoft
teams.
There's
a
link
right
below
this
video
to
fill
out
the
form
to
get
invited
to
teams.
So
it's
really
fun
because
you
know
people
ask
questions
and
we
chat
the
whole
time.
A
A
Okay,
so
that's
the
app
that
I'm
going
to
show
you
and
then
here
is
teams.
So
this
is
a
team
called
Power
Hour
you'll
be
put
in
power
hour
when
you
join
and
in
the
general
Channel
I
have
tabs
for
each
Power
Hour.
So
here's
today's
Tab
and
then,
when
you
click
this
little
conversation
bubble,
then
that's
where
you
can
watch
the
video
and
also
chat
with
us.
While
we
go
so
that's
where
all
that
is
okay,
so
here
is
my
company
store
app?
A
The
idea
behind
this
is
like
a
company
store,
like
you,
you're
working
in
your
cubicle,
and
you
maybe
need
some
equipment
or
something
like
that.
It
works.
So
there's
no
actual
like
purchasing
going
on
in
here.
It's
just
basically
it's
going
to
send
an
email
saying
this
is
what
this
person
ordered.
So
here
is
my
cart,
and
this
is
actually
a
collection.
So,
as
I
add
things
to
the
cart,
I
put
them
in
a
collection,
so
the
collection
is
being
displayed
in
a
gallery.
A
So
I'm
going
to
show
you
how
I'm
going
to
show
you
kind
of
what
this
interface
looks
like
and
then
we're
going
to
go
in
and
build
one
and
just
build
a
gather
like
an
ugly,
just
like
a
brand
new
gallery
from
scratch
and
kind
of
build
the
whole
thing
so
that
you
can
see
all
the
pieces
and
kind
of
how
it
comes
together.
But
this
is
like
a
pretty
shiny
one.
That's
already
done
that.
A
You
know
took
a
lot
of
time
to
build
and
looks
lovely,
so
you
notice
that
as
soon
as
I
put
my
cursor
in
one
of
these
boxes,
it
lets
me
edit.
It
so
I
can
change
my
quantity
to
maybe
one
shirt
and
then,
when
I
change
it
then
I
have
this
little
save
button,
and
then
it
goes
away
so
here's
another
one,
I
put
my
cursor
in
here
when
I
put
my
cursor
in
the
text
box.
A
A
Yeah,
so
what
do
you
all
think
is
this
something
that
you
would
like
to
do?
Have
you
tried
before,
or
do
you
do
often
I'm
interested
to
hear
your
feedback
in
the
chat
kind
of
as
we
go?
So
this
is
what
it
looks
like
again.
This
is
a
gallery
and
the
items
of
the
gallery
is
just
a
collection
called
collection.
A
A
A
And
then
for
the
list
that
we're
going
to
use
I'll
just
use.
This
is
a
list
that
we've
used
a
lot
just
in
this
class
and
a
lot
of
examples.
So
it's
got
plenty
of
data
in
it.
So
we're
going
to
use
this
travel
request
list
so
in
my
power,
app
I'm
going
to
grab
the
URL
to
this
Power
Hour
site
and
then
I'll
add
that
as
a
data
source
SharePoint,
which
is
way
down
the
list.
A
A
So
now,
when
I
add
my
gallery,
then
that's
going
to
be
the
data
that
I'm
editing
in
the
gallery,
so
I
can
go
insert
here
and
choose
gallery
or
I
can
go
to
this
little
Plus
and
when
I
type
Gallery
it's
got
all
the
different
types
of
galleries,
I'm,
basically
going
to
do
a
blank
vertical
gallery
and
then,
when
you
do
with
blank
you're
going
to
just
not
going
to
have
it,
it's
not
going
to
show
anything
in
here.
I'm.
A
Just
picking
what
my
data
source
is
and
then
I
can
actually
quickly
pick
a
layout
over
here,
I
kind
of
like
the
title,
subtitle
and
body,
and
it
just
gives
me
a
few
Fields
it
kind
of
guesses
guesses
it
a
few
things
so
I'm
going
to
say,
I
want
this
to
say
this
item
Dot
and
I'm,
going
to
put
something
else,
some
other
column,
that's
a
little
nicer.
Looking
so
reason
for
travel
is
a
conference.
A
Okay,
so
I've
got
the
name
of
the
item,
the
title,
the
reason
for
travel
and
then
the
status,
and
so
what
we're
going
to
do
in
this
Gallery
is
we
got
to
think
of
something
that
we
want.
You
know
that
we
want
them
to
be
able
to
edit.
Do
we
want
them
to
be
able
to
edit
everything
in
here?
So
the
most
simple
thing
that
we'll
start
with
will
just
do
a
we'll
just
put
a
text
box
in
here
and
just
pick
a
column
that
will,
you
know
decide
to
edit.
A
So,
let's
see
I
think
I
want
to.
Let
me
open
one
of
these.
Let's
see
I
think
airfare
is
going
to
be
a
good
one,
we'll
just
put
I'll
just
put
airfare,
because
that's
just
a
number
and
that's
just
a
good
kind
of
simple
thing
to
start
with
so
I'll
use
airfare
as
the
field
that
we'll
start
with
just
to
be
able
to
edit.
What's
in
that
field,
I'm
going
to
move
this
stuff
over
here
a
little
bit,
and
instead
of
so
most
of
these
all
these
other
things
that
are
in
the
gallery
right
now.
A
Those
are
labels.
So
what
I'm
going
to
do
for
to
be
able
to
edit?
It
is,
instead
of
inserting
a
label.
I
have
to
be
sure
and
put
my
cursor
in
this
top
part
of
the
in
this.
The
template,
basically
the
top
of
the
gallery,
the
first
item
in
the
gallery
and
then
insert
a
text
input
box
instead
of
a
label.
A
So
then
my
text
input
put
box
is
going
to
be.
Let
me
get
rid
of
the
words
text.
Input
and
I'll.
Just
put
I
can
put
some
hint
text
and
I'll
put
airfare
that
and
then
that
kind
of
is
a
quick
way
to
get
to
show
people
kind
of
what
they're
supposed
to
be
typing
in
there,
and
so
we're
just
going
to
make
this
very,
very
simple,
as
we
allow
people
to
edit
the
airfare
in
each
of
these
items.
So
what
I
have
going
on
in
this
in
this
example
is
I.
A
Have
a
few
things.
I
have
a
couple
of
buttons
that
I've
added
that
so
that
when
you
click
in
the
Box,
the
buttons
will
appear
because
I
want
them
to
save
that.
You
know
save
that
row
make
an
edit
to
that
row
and
then
save
it
on
that
row
itself,
so
I'm
going
to
go
ahead
and
insert
and
I'll
put
like
a
little
I'll
do
some
icons
here.
Let
me
see,
let
me
get
my
icons
they're
all
down
here.
A
A
So
there's
kind
of
two
different
ones:
yeah
I'll
just
use
the
little
X
there
we
go
and
then
you
can
make
you
know
you
can
make
the
X
different
color
or
something
like
that
like
red
and
then
the
thing
about
these
is.
We
only
want
them
to
appear
right.
When
somebody
is
on
that
row,
we
don't
want
the
save
and
X's
to
show
like
through
the
whole
thing.
B
A
A
So
let
me
go
to
my
so
I'm
going
to
use
a
context
variable
and
when
someone
Clicks
in
this
box
right
here,
the
airfare
box,
the
one
that
they're
editing
I'm
going
to
go
to
the
on
select
property
and
then
I'm
going
to
say,
update,
context
and
I'm
going
to
call
call
it
CTX
cart.
Well,
this
is
not
going
to
be
a
cart,
I'll
just
say
travel.
The
other
one
was
the
cart
and
then
this
item
dot.
A
A
This
item,
dot
ID,
so
I
only
want
it
to
be
visible
once
I
click
in
the
box
and
that
variable
gets
set.
Then
I
want
this
save
button
to
be
visible.
So
then,
and
the
let's
see
it's
kind
of
be
the
same
thing
for
that
little
X
as
well.
So
it's
going
to
be
I'm
just
going
to
take.
You
know
what
a
couple
different
things
I
can
do
for
this
is
I.
Can
just
take
this
formula
right
here
and
copy
it
and
paste
it
to
the
visible
property
of
the
X.
A
But
another
thing
that
I
can
do
is
instead
of
just
copying
and
pasting,
it
I
could
actually
refer
to
that
save
button
and,
and
actually
just
say,
I
want
this
visible
property
to
equal
the
visible
property
on
the
save
button.
So
it's
just
kind
of
two
different
ways
that
you
could
accomplish
that
so
now
they
both
disappeared
because
I,
you
know,
change
the
visible
property.
So
let's
go
ahead,
and
so
when
I
click
notice
when
I
click
in
that
box.
A
Now
they
appear
so
now
that
they've
appeared
and
they're
appearing
for
the
correct
row.
That's
when
I
need
to
set
up
what
happens
when
I
click
the
save
button
and
what
happens
when
I
click
the
x
button,
so
I'm
going
to
click
on
the
save
button
and
go
to
the
on
select
for
that
and
then
that's
where
I'm
going
to
write
a
kind
of
a
complex
formula.
A
I
need
to
know
if,
if
they've
changed
it
to
zero,
if
they've
actually
like
cleared
it
out
and
changed
it
or
change
it
to
zero
because
they
want
to
get
rid
of
that
cart
item
now,
I
guess
you
could
put
a
delete
button
but
another
way
that
you
can
get
rid
of
things
in
a
cart
that
I've
seen
a
lot
in
different
apps.
Is
you
just
basically
change
it
to
zero,
and
then
it
removes
it.
So,
in
this
case,
I
need
to
know
if
they
change
it
to
zero.
A
So
it's
going
to
basically
say
if
the
value
is
and
and
see
in
that
other
example.
It
was
a
cart.
It
was
a
grocery
I
mean
not
a
grocery
cart.
It
was
a
shopping
cart,
but
this
one's
travel.
So
for
this
one
it's
got
like
a
little
bit
of
a
different
concept
because
they
change
the
airfare
to
zero.
That
doesn't
necessarily
need
to
remove
the
item.
So
don't
I
don't
need
to
do
the
exact
same
things
that
I
was
doing
with
the
card
with
this
travel.
A
A
A
Estimated
airfare
so
then
I'm
going
to
say,
I
want
the
estimated
airfare
to
equal.
What
is
that?
Whatever
is
in
this
box
that
I
just
that
I
have
on
the
screen,
so
I
need
to
give
I
need
to
go
ahead
and
just
give
this
box
a
better
name
instead
of
text
input,
one
so
I'll
call
it
txt,
airfare
airfare,
edit
I,
guess
txt
airfare
edit.
So
that's
what
I
need
to
use
in
my
formula
when
I'm
patching
I
need
to
know
the
name
of
that
so,
and
this
is
this
is
actually
a
number.
A
A
If
it's
text,
you
don't
need
to
use
the
value
function,
so
I'm
going
to
say
text
the
text
of
what
is
typed
in
there.
Another
thing
that
I
can
do
specifically
because
this
needs
to
be
a
number
on
this
text
box
is
I-
can
make
sure
that
this
format
over
here
is
number
and
that
enforces
in
the
text
box
itself
and
make
sure
that
people
can
only
type
a
number
in
there
and
they
can't
type
text.
A
So
it's
another
method
you
can
use
when
you
just
have
expect
people
to
type
a
number
and
want
to
enforce
it.
So
right
now,
that's
the
only
column.
So
if
I
had
other
columns
that
I
needed
to
add,
you
know
to
patch
I'll
I'll
be
building
upon
this,
but
right
now,
I
just
have
a
single
column,
so
I'll
just
close
out
my
patch
and
then
which
we
can
just
try
that
out
and
see
what
happens.
A
So,
let
me
see
oh
and
another
thing
that
you'll
notice
when
I
click
the
save
button,
when
you
know
when
I
start
doing
this,
is
that
I
need
it
to
not
be
lit
up
anymore
on
that
item
and
I
need
the
save
button
and
the
cancel
button
to
disappear
again.
So
I'm
gonna
have
to
edit
that
CTX
travel
item
update
ID
variable
as
well,
so
that
it
kind
of
wipes
it
back
out.
A
A
A
So
let's
go
over
to
what
it
is
going
to
be
doing,
and
it's
basically
going
to
be
updating
contacts,
updating
that
variable
when
I
select
it
so
update
context,
and
then
that's
also
that
CTX
travel
item,
update,
ID
and
that's
again,
I'm
doing
the
same
thing,
I'm
just
putting
it
as
a
negative
one
just
so
that
it
kind
of
resets
itself.
Another
thing
that
I
can
do
to
reset
just
a
function
that
I
can
use
anytime
I
want
to
reset
any
any
field.
A
Well,
it
does
work
a
little
different
for
different
types
of
field
Fields,
but
I
can
use
a
reset
function,
so
I
can
say
reset
and
that's
that
txt
airfare
edit
text
box
and
it
resets
the
text
box
itself
so
that
it
you
know,
is
back
to
kind
of
the
actual
value
that's
supposed
to
be
in
it,
and
then
another
thing
about
this
is
that,
like
in
this
example
that
I
showed
you
it's.
It's
got
to
start
off
by
showing
the
airfare
number
that's
in
there.
A
So
I
do
need
to
have
the
default,
so
they
have
something
they
can
change.
So
I'll
go
back
to
my
default
property
and
for
the
defaults
of
the
text
box.
It's
just
going
to
be
this
item
just
this
thing
that
I'm
on
so
this
item,
Dot
airfare
estimated
estimated
airfare.
So
there
are
the
estimated
airfare
numbers
and
I
can
even
just
add
a
little
extra
text
label
just.
A
So
you
can
kind
of
see
what
it's
supposed
to
be:
okay,
let's
try
it
out
so
I
already
clicked
in
this
first
one.
So
that's
the
one
that's
selected
if
I
click
in
the
second
one
notice
see
these
light
up
so
I'm
going
to
change
this
to
1000,
save
and
that
patches
that
number
to
SharePoint
and
then
makes
the
buttons
go
away
and
it's
it's
saved
now.
A
So
another
thing
you
could
do
is:
if
you
want
people
to
get
it
to
be
more
obvious
that
it
got
saved,
would
just
you
could
do
maybe
like
a
notify
function
or
something
so
it
like
splashes
little
meshes
across
the
top,
but
I'll
go
ahead
and
edit
another
one
and
we'll
go
look
at
the
data
behind
the
scenes.
So,
let's
go
see.
I've
got
a
Walt
Disney
World,
here's
Walt,
Disney
World
and
let's
go
ahead
and
show
that
column.
A
A
And
here
it
is
right
here
so
I'll
preview
that
and
then
I'll
change
that
to
five
that's
a
really
really
cheap
flight
and
then
I
save
that
and
we'll
go
double
check
in
SharePoint
and
refresh
this
and
refresh
SharePoint
does
refresh
itself.
Nowadays
it
does
a
pretty
good
job
of
that.
So
now
you
can
see
it
says
five
dollars
in
there.
A
A
B
A
Yeah
I'm
I'm
kind
of
torn
it
I
feel
like
it's
probably
possible,
but
I'm,
not
sure
if
in
think
about
like
the
real
world
and
real
like
actual
users
using
this,
and
they
if
they
go
down
the
page
and
start
editing
a
bunch
of
things
and
they
think
they've
added
them
and
then
like
they,
never
click
finish
or
they
close
the
app
or
something
like
that.
Then
nothing
gets
edited
and
also
think
about.
When
you
have
people
editing
like
a
whole
bunch
of
things
at
once.
A
The
concept
of
maybe
someone
else
has
the
app
open.
At
the
same
time
and
they're
trying
to
edit,
like
you,
could
have
potentially
way
more
conflicts,
more
save
conflicts.
If
you
allow
people
to
just
kind
of
sit
there
and
have
the
whole
thing
open,
just
editing
a
whole
bunch
of
things,
as
opposed
to
just
edit
save
edit
save.
B
A
I
feel
like
a
for
all
could
be
used
for
that,
but
that's
something
that
we
can.
We
can
try,
but
it's
not
something
that
you
know
they'll
be
one
of
those
things
that
I
didn't,
prepare
and
I'm,
not
sure
how
to
do
and
I
could
like
kind
of
fumble
around
towards
the
end
and
see
if
we
could
figure
it
out,
but
because
the
for
all
is
tricky.
A
When
you
use
the
for
all
function,
you
can't
use
the
four
like
if
I
have
the
travel
requests
list
in
this
gallery
and
I
want
to
do
an
action.
Basically
like
patch
to
everything
in
the
travel
request
list,
you
can't
patch
to
the
same
exact
data
source
that
you're
doing
the
for
all
through,
like
you
know
what
I
mean.
A
A
A
A
A
B
A
B
B
B
A
A
A
Because
it
was
one
of
those
built-in
templates,
you
know
all
right,
SharePoint,
Saturday,
Hawaii,
that's
the
title
of
the
item
and
then
I
need
to
be
able
to
so
when
someone
Clicks
in
it
I
need
that
also
to
set
that
variable.
So
right
now,
I
have
this
one
and
it's
on
select
it's
doing
the
update
context,
but
I
need
to
do
that
exact
same
thing.
So
this
is
the
txt
airfare
edit
on
select
I'll,
just
copy.
A
That
and
I
just
put
the
exact
same
thing
in
the
on
select
another
thing
you
can
do
if
you
want
to
be
able
to
click
something
and
have
it
do
the
exact
same
thing,
then
another
click
on
that
same
screen
does
instead
of
copying
and
pasting
the
formula,
because,
if
you
like
maybe
have
several
different
things,
you
can
actually
use
the
name
of
this,
so
it's
txt,
airfare,
edit,
so
I
can
say
select
which
is
kind
of
already
in
there.
It's
already
in
all
the
different
controls
that
you
put
in
a
gallery.
A
So
when
I
click
on
it,
it's
basically
going
to
do
the
exact
same
thing
that
it
does
when
I
do
the
on
select
for
that
other
control.
So
again,
if
you
ever
have
like
multiple
buttons
on
the
same
screen
that
you
want
the
same
thing
to
happen,
the
same
exact
thing
to
happen
when
you
click
on
them.
That's
what
that
select
function
is
for
so
now
I'll.
Try
that
I'll
click
in
it
and
now
see
that
just
lights
up.
A
So
then
the
other
thing
that
I
have
to
consider
when
I
start
adding
more
Fields
is
just
that
patch.
So
that's
something
that
I
have
to
manually
do
so.
Let
me
change
this
change.
The
name
of
this
txt
test
and
it's
actually
the
title
title
edit,
so
I
have
to
be
able
to
patch
both
of
those
so
to
tell
it
what
field
I'm
patching
and
what
field
it's
patching
to.
So
this
is
going
to
be
title
and
that's
txt,
not
airfare
edit
title
edit
dot
text
all
right.
Let's
try
that.
A
Okay,
so
this
one's
going
to
be
mobile,
I'll,
just
change
it
to
Mobile,
Bay
and
Save,
okay,
and
then
it's
got
the
new
value
here
and
I
can
go.
Look
at
just
go
double
check,
it's
F5
and
now
it
says
Mobile
Bay,
it
doesn't
say
mobile
anymore.
So
that's
how
to
do
a
text.
One
text
is
text
is
the
easiest
and
then
let's
do
a
date
so
for
the
date
I
have
to
do
a
date.
Picker
so
give
this
a
shot.
Okay,
so
I
put
my
cursor
in
here
insert
a
date
picker.
A
A
Oh
it's
on
popular
icons,
modern
controls.
There
we
go
date,
picker
cool,
oh,
see,
look
what
I
did.
This
is
just
something
if
you've
never
worked
in
a
gallery
before.
This
is
something
that
happens.
I
inserted
this,
but
my
cursor
was
not
in
the
gallery
first
row
when
I
inserted
it,
so
it
just
kind
of
put
it
on
top
of
the
gallery
like
this.
So
I
need
to
put
my
cursor
inside
of
this
first
row
and
then
paste
it
and
then,
when
I
do
that
it
puts
it
down.
A
B
A
It's
start,
travel
start
date,
okay,
so
it
looks
like
it
has
cool.
It
has
the
correct
travel
start
date
and
then
that's
what
I
want
to
patch.
So
that's
going
to
be
another
thing
where
I
have
to
do
the
on
select
and
I
can
have
it
be
the
exact
same
on
select
as
the
txt
airfare
edit,
so
I'll
go
to
my
onsl.
A
Oh,
it
doesn't
have
it
on
select
for
a
date
picker
interesting,
okay,
so
maybe
maybe
it
doesn't
have
it
on
select
for
this
new
modern
date
picker,
but
I'll
just
do
it
on
change
and
see.
If
that
does
the
same
thing
select
and
that's
going
to
be
that
txt,
airfare
edit
and
then
also
I
need
to
do
the
patch.
So
let's
click
on
it.
Oh
see,
I
actually
have
to
pick
a
date.
A
That's
all
because
it's
on
change,
since
it
doesn't
have
it
on
select,
so
it
changed
the
date
and
then
this
would
appear.
So
that's
just
kind
of
you
know
some
little
different,
weird
thing
about
the
date
picker.
So
then,
when
I
do
my
patch
I
have
to
add
the
date
picker?
So
that's
going
to
be
my
travel
start
date,
so
I've
got
the
estimated
airfare
the
title
and
you
can
see
this
is
kind
of
tedious
when
you
do
when
you
do
these.
A
And
you
do
patching
and
that's
that
DTE
start
edit
Dot
dot
value,
I,
think
all
these
new
modern
controls,
instead
of
like
dot
selected
item
or
dot
text
or
dot
date,
dot
selected
date,
all
the
different
things
for
to
tell
you
what
the
data
is
in
them
that
we
refer
to
for
the
regular
controls.
All
these
new
modern
controls,
I
noticed
they
have
just
dot
value.
It's
just
like
a
standard
across
the
board,
which
kind
of
makes
it
simpler,
which
is
good.
So
it's
going
to
be
whatever
date.
A
A
Next
week,
and
also
change
my
airfare
to
1201
for
my
Vermont
vacation
and
then
save
it
and
then,
of
course
it
didn't
give
an
error
or
anything.
So,
let's
see
refresh
that
I
think
we
kind
of
know
that
they're
they're
gonna,
it's
gonna
work
so
yeah.
It
says
May
31st
that's
next
week
and
it
changed
it
to
1201..
A
A
A
If
you
had
just
one
just
two
different
choices,
you
could
use
a
toggle
and
then
you
have
ratings
are
just
Star
Choices.
You
also
have
a
list
box
which
is
another
way
you
could
do
it
and
then
for
the
modern
ones.
You
have
a
drop
down,
which
is
you
just
got
a
little
different
icon.
I,
don't
think
the
drop
down
itself
is
that
different?
You
have
a
radio
group,
spinner
tablets
text,
so
tab
list
is
kind
of
interesting,
but
that's
going
to
look
more
like
tabs
to
to
click
on
so
I.
A
A
There's
status,
there's
category
yeah
I'll
do
I,
don't
wanna
I,
don't
want
to
have
one
that
allows
multiple,
but
I
guess
I
could
try
that
you
know
status
actually
makes
more
sense
for
this
functionality
because
I
feel
like
if
you
have
maybe
some
travel
requests
that
you
need
to
approve.
You
could
go
through
and
approve
them
quickly
in
a
gallery.
Another
thing
that
you
can
do
would
just
be
to
provide
a
button.
A
If
you
want
people
to
be
able
to
see
their
list
of
travel
requests
and
just
approve
something,
you
could
just
give
them
an
approve
button
and
they
just
click
it
and
it
changes
it
to
approve
or
you
could
give
them
radio
buttons
where
they
can
pick
from.
One
of
you
know
the
several
options,
so
we
could
try
a
couple
of
different
ways
to
do
that.
A
So
I'm
gonna,
I'm
gonna
go
ahead
and
use
the
status
as
our
column
and
we'll
we'll
use
that
and
then
tried
a
couple
of
different
ways
to
do
the
status
so
go
back
over
to
the
power
app.
So
my
items
for
the
status
I
need
to
know
what
the
actual
status
choices
are
supposed
to
be.
So
there
are
a
couple
different
ways
that
I
can
go
about
that
too.
So
I
have
new
and
progress
approved
and
rejected.
So
one
quick
way
that
you
can
do
it
is
to
just
manually
type
them
in
here.
A
I
have
to
add
the
value,
so
they
can
see
it,
and
so
that's
what
that
one
looks
like
now.
Here's
kind
of
I'll
show
you
a
hack
for
figuring
out
how
to
just
automatically
make
it
show
what
the
choices
are
in
SharePoint
so
that
you
don't
have
to
ever
go
manually
change
what
these
choices
are.
So
let's
go
ahead
and
go
to
I'm
going
to
create
another
new
screen.
A
A
A
So
when
I
select
this
I'm
going
to
do
the
same
thing,
I
just
wanted
to
do
the
exact
same
thing:
that's
happening
when
I
click,
the
airfare
that
thing
that
I
set
up
when
I
click
here
of
setting
that
variable
and
then
the
other
thing
that
every
time
I
add
a
field.
The
other
thing
that
I
need
to
do
is:
do
that.
Add
that
patch
so
I'm
going
to
change
this?
A
A
And
then
I'll
try
like
actually
putting
the
command
in
here.
If
that
doesn't
work
because
it
might
be
a
little
buggy,
oh
yeah
there.
It
goes
so
that
one
changes
cancel
that
one
change
this
one
to
oh
look
there.
It
goes.
It
just
took
a
couple
of
clicks.
So
I
changed
that
one
to
in
progress
the
Walt,
Disney,
World
and
I'm,
changing
it
to
six
and
oh
I,
didn't
put
the
patch
I
was
just
changing
it
just
so
this
would
light
up.
So
then
I
could
add
the
patch
to
it
there.
A
Okay,
so
then
I'm
patching
and
then
I
just
have
to
add,
do
a
column,
a
comma
here
and
add
another
column
that
I'm
patching.
So
what's
the
name
of
the
column
that
I'm
patching
status
not
to
be
confused
with
States
and
then
I
want
the
status
to
be,
and
then
do
I
have
a
good
name
for
that
choice.
No
I,
don't
RDO
status
edit.
There
we
go
I'm
gonna
have
a
good
name
for
it,
so
RDO
status,
edit
Dot
selected.
A
A
Oh
no
I
don't
need
the
value
it
doesn't
like
that
there,
okay,
let's
try
that
out.
Okay,
so
this
one
I'll
cancel
it
and
somewhere
warm
I'm
going
to
change
this
to
in
progress
and
save
it
and
it
looks
like
it
saved
it.
So
I'll
make
sure
somewhere
warm
it
was
approved.
Now
it
should
change
to
in
progress.
A
B
A
A
Tab,
maybe
anyway,
so
yeah
I'm,
totally
relying
on
you
for
the
questions,
because
I
can't
even
see
the
teams
as
being
weird
I
can't
even
see
them
okay.
So
the
next
thing
that
we'll
do
is
show
like
kind
of
a
prettier
way
to
change
kind
of
the
way
like
the
multiple
choice
options
would
look
so
I'm
going
to
use
the
statuses
again
just
again,
because
status
seems
like
something
very
common
that
people
would
want
to
quickly
change
on
on
items
now.
A
Another
thing
about
status
is
that
it
doesn't
necessarily
have
to
be
like
a
like
a
box.
You're
filling
in
it
can
just
be
a
button.
So
the
thing
about
that
is,
if
we're
just
putting
a
button
in
this
Gallery,
do
we
even
need
to
have
this
whole
sort
of
editing,
columns,
data
sheet
thing,
because
all
we
really
need
if
we're
going
to
click
a
button
and
have
it
change
the
status
is
we
could
just
have
the
Press
of
the
button?
Do
the
patch,
so
that
would
save
a
couple
of
clicks.
A
So
if
we
are
filling
out
a
bunch
of
fields
like
a
date
and
a
text
box
and
changing
changing
a
number
and
things
like
that
for
filling
things
out,
we
want
them
to
be
able
to
be
presented
with
the
ability
to
save
all
their
changes.
But
if
we're,
if
we
do
this
kind
of
other
option
of
just
being
able
to
provide
them
a
button
that
says
basically
set
this
to
approved,
then
the
button
itself
can
do
the
patch,
and
you
won't
have
to
do
any
of
this
other
stuff.
A
So
that
kind
of
is
not
really
it
kind
of
negates.
It's
not
really
part
of
what
this
whole
data
sheet
concept
is
that
we're
doing,
but
now
that
I've
showed
you
a
way
that
you
can
give
them
like
a
couple
of
clicks
to
edit
individual
rows
in
here.
I'll
show
you
just
that
really
other
quick
way
that
would
just
be
able
to
let
them
set
a
status.
A
So
I
gotta
give
myself
a
little
room
in
here,
so
I'm
going
to
take
these
and
move
them
over
and
then
I'll.
This
is
getting
kind
of
getting
a
little
crowded.
It's
kind
of
ugly
I,
don't
I,
don't
usually
spend
a
lot
of
time
during
Power
Hour
trying
to
make
it
look
really
pretty.
So
let
me
go
ahead
and
add
a
couple
of
buttons.
Let's
see
like
you
could
do
buttons,
you
could
do
an
icon,
so
I'll
do
I'm
gonna,
do
like
a
little
checkbox
I
check
icon
like
this.
A
Oh
there's,
actually
yeah
do
this
one.
So
it
looks
like
a
little
round
check
and
if
I
want
to
approve
it,
we
can
make
it
so
that
when
they
check
the
they
click
the
button,
it
directly
approves
it.
So
again
that
has
nothing
to
do
with
this
data
sheet
concept,
but
it's
just
another
way
that
you
would
be
able
to
quickly
edit
items,
so
you
can
even
make
it
say
like
for
the
tool
tip
approve
this.
A
And
then
I'll
go
ahead
and
say
on
select
and
I'm
going
to
take
some
of
that
patch
code,
just
functionality
in
here
real,
quick
and
just
copy
it
just
to
save
some
time,
because
it's
the
same
item
that
I'm
patching
to
so
on,
select
I
can
patch
to
the
travel
request,
this
item
and
then
I'm
going
to
be
doing
the
status
and
I
want
the
status.
Now.
Here's
the
tricky
part
the
status
is
a
choice
column.
So,
whenever
I'm
patching
to
a
choice
column,
it
actually
I
need
to
use
this
weird
other
syntax.
A
So
the
other
this
little
Choice
box
that
I
was
clicking
from
it
kind
of
already
had
that
syntax
built
in
the
dot
value
thing.
But
when
I'm
patching
just
directly
just
by
clicking
a
button
to
set
a
value
in
a
choice,
column
in
SharePoint
I
have
to
do
this
little
weird
syntax.
So
I
have
to
do
this
curly
bracket
value
and
then
approved.
A
Different
curly
closes
there.
We
go
yep,
so
there's
my
curly
open
for
the
patch
itself
and
then
I
have
a
curly
open
and
close
for
that
one
little
Choice
column
and
then
what
if
I
can
make
this
green?
So
so
it
looks
more
like
an
approve
button
and
if
something's
already
approved
I
can
make
this
hidden
so
that
they
there's
no
reason
to
show
that
if
it's
already
approved.
A
Yeah,
it
doesn't
like
that
yeah
Boolean
and
text.
Okay,
so
right
now
it
only
is
showing
if
it
equals
approved,
I
want
it
to
be
not
equals
to
approved.
So
I
got
to
do
the
opposite.
So
now,
I
can
see
only
the
ones
that
see
the
ones
that
are
not
approved
already.
Have
a
button
so
now
watch
this
RDC
training,
analysis,
I'll,
click
this
and
look
at
that.
It
changed
it
to
approved
right
before
my
eyes
and
it
immediately
changed
the
data,
pretty
cool
right.
A
Okay,
we
are
not
having
power
hour
next
week
because
it's
Memorial
Day
week
we're
taking
a
taking
a
break
and
thanks
everybody
for
coming
for
the
actual
power
apps.
There's
a
link
in
the
description
here
of
this
YouTube
video
If.
You
go
take
our
powerapps
Basics
course
for
free
and
we
have
lots
of
other
classes.