►
Description
Further embrace global diversity with a little help from this solution. In this 13-minute citizen developer-focused demo, Lindsay Shelton delivers a Power App with a Power Automate flow sitting on a SharePoint page and a document library. See the app in action – recording name and pronouns, listing to the recording, then going behind UI to see the Power App elements used. Step through capturing and transferring 3 variables from Power App into flow actions. Sample available.
This PnP Community demo is taken from the Microsoft Power Platform community call – January 2023, recorded on January 18, 2023.
Demo Presenter
• Lindsay Shelton | @LShelton_Tech
Community Call Conversation
• aka.ms/Jan18-Demo1
Supporting materials
• YouTube Channel - Daniel Christian | https://www.youtube.com/@DanielChristian19
• Article - Building beautiful buttons in Canvas Apps part 1 - neumorphic buttons | https://www.kristinekolodziejski.com/blog/building-beautiful-buttons-in-canvas-apps-part-1-neumorphic-buttons
Stay connected
• Twitter https://twitter.com/microsoft365dev
• Call attention to your great work by using #PowerAppsCC and #PnPWeekly on Twitter.
Learn more
• Microsoft 365 Unified Sample gallery - https://aka.ms/m365/samples
• Microsoft 365 Platform Community in YouTube - https://aka.ms/m365/videos
• Microsoft 365 Platform Community Blog - https://aka.ms/m365pnp/blog
• Microsoft 365 Platform Community - https://aka.ms/m365/community
👋 Join to our weekly Microsoft 365 & Power Platform Community calls to learn more. These are PUBLIC calls for you to get access on the latest details from Microsoft and to see awesome demos from community on these technologies - Download recurrent invites from https://aka.ms/community/calls
A
A
Pronunciation
quote-unquote
database
using
both
powerapps
and
power
automate
and
just
first
to
tell
you
a
little
bit
about
myself.
My
name
is
Lindsay
Shelton
I
am
an
application
programmer
from
the
Kansas
City
metro
area.
I
am
a
Microsoft
certified
trainer
and
a
fun
fact
about
me.
I
was
actually
a
teacher
for
10
years
before
switching
careers
and
I
don't
regret
a
single
day.
Switching
careers
I
love
doing
what
I
do
now.
I'm
really
excited
about
it
every
day
and
I
do
a
lot
of
different
things.
A
With
my
current
position,
my
biggest
push
that
I'm
working
on
right
now
is
Power
Platform,
adoption
governance,
implementation
at
my
organization,
which
I'm
really
excited
about,
but
I've
also
done
work
with
things
like
SharePoint
framework
development,
Azure,
apim
implementation.
So
is
any
of
that
interests.
You
feel
free
to
connect
with
me
on
socials
LinkedIn
at
Lindsay,
T
Shelton.
A
So
this
is
something
you
know:
I
don't
have
a
name,
that's
mispronounced
very
often,
but
I
do
have
a
name.
That's
misspelled,
quite
a
lot,
so
I
I
can
understand.
Certainly
why
it's
important.
This
is
a
quote
that
kind
of
helped
Drive
why
this
was
an
important
Initiative
for
us
to
work
on
our
names.
Are
our
identities
closely
linked
to
our
heritage?
Mispronouncing,
a
name
can
be
experienced
as
a
kind
of
microaggression,
as
the
person
may
feel,
put
down
invisible
or
unworthy
and
I.
A
Don't
think
anyone
on
this
call
would
ever
want
to
make
someone
feel
any
of
those
ways,
and
especially
not
on
purpose
and
I.
Think
you
know
the
bigger
issue.
Is
we
don't
do
it
on
purpose?
We
just
don't
necessarily
have
a
way
of
knowing
how
to
pronounce
someone's
name,
especially
in
this
time
of
hybrid
work,
where
we're
not
meeting
people
face
to
face
and
getting
to
hear
their
names.
You
know
we're
we're
kind
of
putting
out
our
best
guess
and
there's
not
an
easy
built-in
out
of
the
box
way
for
Microsoft.
A
You
know
like
there's
with
LinkedIn,
to
tell
us
how
to
pronounce
someone's
name-
and
this
was
especially
an
important
initiative
where
I
work,
because
we
are
a
medical
research
institute,
we're
a
non-profit
and
because
we're
you
know
a
scientific
organization
we
bring
in
employees
from
all
over
the
globe.
So
we
celebrate
diversity,
we're
an
incredibly
diverse
organization.
So
you
know
what
were
we
doing
to
help?
A
For
our
hackathon
and
we
came
up
with
this
solution,
so
it's
not
technically
a
database,
that's
just
you
know
a
more
of
a
casual
misnomer
to
call
it
a
database.
What
it
is
it's
a
SharePoint
site
and
it's
got
two
columns
on
it.
One
column
has
an
embedded
power.
App
and
one
column
has
an
embedded
SharePoint
document
library
and
the
way
it
works
is
one
of
our.
We
call
them
members.
A
Our
users
will
come
in
and
record
their
name
pronunciations
and
we
actually
added
in
pronouns,
because
in
the
year
of
2023
we
also
don't
have
a
built-in
way
in
Microsoft
to
you
know
record
our
pronoun
preference.
So
you
know
we
have
the
prompt
up
here.
You
can
say
you
know
your
name
pronunciation,
my
pronouns
are:
are
they
them
or
whatever?
They
are?
A
You
record
it
through
the
power
app
and
then
it's
populated
via
a
power
automate
flow
into
the
SharePoint
document,
Library
I,
just
blurred
out
the
names
for
privacy,
and
then
you
can
go
in
here
and
listen
to
other
people's
name
pronunciations
and
pronouns.
So
you
know
if
I'm
going
to
go
meet
with
someone
or
if
I've
just
met
someone
and
I'm
not
sure
how
to
pronounce
their
name.
A
The
solution
is
actually
made
up
of
this
power
app
sitting
on
top
of
a
power
automate
flow
which
sits
on
top
of
the
SharePoint
page
and
document
library
and
I
will
tell
you.
I
am
not
a
UI
person
or
one
of
my
teammates
actually
graduated
from
Kansas
City,
Art
Institute,
and
she
wanted
to
get
her
hands
on
this
and
I
said
you
don't
know
how
to
do
power.
Apps
you're
going
to
break
it.
So
forgive
any
UI
problems
with
it.
A
How
does
it
work
on
the
front
end?
So
the
user
clicks
on
this
microphone
control
to
start
the
recording
they
record
their
name
and
pronouns
if
they
wish
and
they
click
the
same
button
to
stop
the
recording,
then
they
go
down
to
step
two.
This
is
not
actually
populated
when
they
just
first
open
up
the
app,
so
they
click
here
and
the
preview
audio
button,
and
then
it
populates
this
audio
control
in
a
gallery.
Then
they
can
listen
to
their
name.
A
You
know
their
recording
as
many
times
as
they'd
like
they
can
trash
it.
They
can
start
over
record
it
again.
Preview
audio
do
that
as
many
times
as
they
want.
It's
not
getting.
Uploaded
nothing's
actually
happening
it's
just
living
in
the
app
and
then
as
soon
as
they're
happy
with
it.
They
click
the
upload
audio
file
button.
Then
a
power
automate
flow
is
working
in
the
background
to
upload
it
to
the
SharePoint
document
Library,
which
is
as
I,
showed
you
on
the
other
side
of
the
page.
That
has
the
power
app
on
it.
A
The
PowerApp
uses
just
some
basic
media
controls.
It's
got
the
microphone
control
and
then
the
audio
control
that
plays
the
recording
back.
It's
got
a
gallery
control
that
has
the
audio
recordings
in
it.
That
just
shows
you
the
most
recent
recording
the
button
that
populates
the
gallery
with
the
most
recent
recording
done
and
then
that
button
at
the
bottom.
The
upload
button
that
is
triggering
a
power
automate
workflow.
It
is
numeric
just
to
be
extra,
because
I
have
a
little
extra
time
in
the
hackathon.
A
So
I
wanted
to
use
one
of
Christine
K's
tutorials
and
make
it
a
little
bit
cool.
So
just
to
show
you
I'm
not
going
to
show
you
everything.
This
sample
is
in
the
PNP
samples
Gallery,
both
the
power
app
and
the
power
automate
workflow,
so
you
can
feel
free
to
grab
it
and
use
it.
However,
you
would
like,
but
I
did
want
to
point
out
just
a
few
things.
So
this
microphone
control
here,
it's
not
the
onstart
that
does
anything.
A
It's
the
on
stop
where
we
actually
set
things
up
and
now
I'm
going
to
try
to
explain
this
to
you,
but
I'm
also
going
to
tell
you
right
now:
Daniel
Christian
posted
a
video
a
few
years
ago
that
went
into
the
technical
details
of
this,
and
this
is
how
I
was
able
to
make
this
happen.
So
he
didn't
have
this
exact
use
case
and
I
did
some
tweaking
of
my
own,
but
I
just
have
to
shout
out
Daniel
Christian,
because
I
wouldn't
have
been
able
to
get
this
work
without
his
video.
A
This
first
up
here.
This
sets
the
time
stamp
for
the
video.
Then
we
get
the
actual
audio
for
the
recording.
Once
again,
we
stop
the
recording,
then.
Basically,
as
it
was
explained,
the
audio
file,
we
get
a
ton
of
data
around
the
audio
file.
We
don't
need
most
of
that
data,
so
these
next
two
things
the
temp
Json
and
the
string
beef
64
VAR.
That's
just
pulling
out
just
the
little
bits
that
we
need
in
order
to
send
those
to
SharePoint.
A
Ultimately,
so
we're
going
to
use
specifically
this
string,
b64
VAR
in
the
next
control,
which
is
this
preview
audio
button,
so
like
I
said
this
doesn't
show
up.
I
can
actually
show
you
that
really
quick
I
forgot
to
pull
that
up
here.
So
the
way
that
it
actually
works
is
Lindsay
Shelton,
my
pronouns
are
she
her
I,
previewed
the
audio
and
then
that
control
shows
up
and
I
can
delete
it
or
I?
A
Can
preview
it
again
and
then
I
can
upload
it
so
when
I
go
back
in
here
from
current
slide,
so
when
I
click
that
preview
audio
button,
what
it's
doing
is
it's
building
it's
using
the
collect
function
and
it's
Gathering.
Most
importantly,
these
three
variables,
the
duration
variable
which
we're
going
to
use
and
put
in
our
SharePoint
Library,
the
recording
name,
which
is
obviously
going
to
be
the
name
of
our
file
and
the
recording
itself,
which
you
can
see
we're
setting
to
this
string.
B64
variable.
A
So
that's
that
kind
of
finessed
finagled
version
of
the
audio
that
we're
going
to
utilize
and
that's
what's
going
to
be
uploaded
when
we
click
that
upload
audio
button,
so
we're
triggering
the
power
automate
flow.
So
let's
switch
gears
here.
Let's
go
over
to
that
prior
to
making
the
power
automate
flow.
You
want
to
make
a
SharePoint
document
library
and
it's
very
simple
setup.
The
only
column
you
need
to
add
is
a
number
column
called
duration,
so
call
it
duration,
just
the
number
column
you
don't
need
to
change
any
of
the
other
settings.
A
Then
you
go
and
you
make
your
flow.
The
trigger
is
powerapps
instant
flow
and
then
we're
bringing
over,
as
I
said,
three
variables
from
the
Power
app,
so
we're
initializing
a
variable
using
that
string,
64
VAR
variable
and
we're
turning
it
into
a
string.
We're
we're,
including
that
value
in
here
and
we're
calling
it
The
base64
to
audio,
then
we're
creating
a
file
in
SharePoint.
So
we've
got
our
site
name
our
folder
path.
This
is
the
second
variable
here.
The
create
file.
A
This
is
the
file
name,
I
just
have
to
add
the
dot
MP3
just
to
kind
of
type
it.
And
then
this
is
the
really.
The
trickiest
part
of
the
flow
is
we're
using
one
expression.
This
is
the
one
thing
I
did
have
to
tweak
from
how
Daniel's
video
did
it
I'm,
not
sure
why
I?
You
know
I
kind
of
smashed
my
way
through
things
and
then
just
tweak
try
things
until
they
work.
A
I
had
to
use
base64
to
Binary
and
then
translate
this
variable,
the
basics
before
to
audio
I,
translated
that
to
Binary
and
that's
what
got
it
to
work,
and
so
that's
the
file
content
and
then
we
just
had
to
add
a
third
action
here
for
updating
the
file
properties,
because
I
wanted
to
put
in
the
duration.
For
me,
especially
when
testing
it
was
helpful
to
see
the
duration,
because
I
could
tell
oh.
This
is
that
file
I,
just
tested
or
oh
it
didn't
upload
properly,
because
that
duration
didn't
change.
A
We've
got
the
name
of
our
power
automate
flow
here.
The
generic
save
audio
file,
just
SharePoint
online
run
and
then
our
three
variables
recording
the
recording
name
and
the
duration.
So
that's
basically
it
I'm.
Sorry,
if
I
went
through
that
too
fast
but
like
I
said
it
is
on
the
PNP
samples
Gallery.
A
The
whole
project,
as
I
said,
wouldn't
be
possible
without
Daniel
Christian's
video,
so
go
check
out
his
YouTube
channel
and
also
check
out
Christine
K's
tutorial.
She
makes
some
amazing
stuff.
She
did.
The
walk
through
on
the
dimorphic
buttons,
I
I
didn't
show
you
the
dimorphic
button.
I'll
show
you
really
quick.
Oh
there
you
go.
That's
it.
B
Awesome,
thank
you
Lindsay.
This
is
really
fantastic
and
for
someone
who
always
has
trouble
I'm,
I'm
horrible
at
it
I
admit
I
love
this
so
helpful.
It
creates
a
sense
of
togetherness
and
respect
for
other
people
to
properly
identify
and
call
them
by
their
real
name.
So
thank
you
for
sharing
that
really
great
stuff.