►
From YouTube: Office Scripts with Power Automate
Description
Learn how Office Scripts integrates with Power Automate to increase the capabilities beyond the power of Excel to help businesses easily automate tasks and run businesses efficiently anytime, anywhere.
Learn more about Office Scripts https://aka.ms/office-scripts-docs
This demo was taken from the June Office Add-ins community call
View the full call https://youtu.be/RGSAYrQB89M
Stay connected
Twitter https://twitter.com/microsoft365dev
YouTube https://aka.ms/M365DevYouTube
Blogs https://aka.ms/M365DevBlog
A
I'm
gonna
be
speaking
a
little
bit
about
office
groups
of
power,
automate
I'm,
one
of
the
PM's
on
that
part
of
the
product,
and
this
may
be
a
little
bit
of
a
repeat
for
anybody.
Who's
joined
us
at
the
MVP
summit
or
build,
but
I'm
gonna
try
to
whip
through
some
of
this
content
and
give
you
guys
a
little
bit
more
of
a
forum
for
asking
questions.
A
It
has
a
little
bit
more
of
an
overhead.
Definitely
is
a
bit
more
on
the
complicated
end
of
the
spectrum.
It's
less
likely
to
be
accomplishable
by
somebody
who
has
more
minimal
programming
experience.
Additionally,
comm
Adan's
and
VBA
are
confined
only
to
the
desktop,
and
so
what
office
scripts
has
been
filling
for
us.
Is
this
sort
of
area
of
the
solutions
marketplace
that
it's
more
approachable
to
end-users?
It's
a
little
bit
less
overhead
to
kind
of
spin
up
and
get
started
in.
A
A
So
this
really
is
like
a
full,
deep
integration
with
power
automate
where
previously
the
power
automate
Excel
connector
could
accomplish
like
a
handful
of
simple
tasks.
Again,
this
is
a
connector
that
did
exist
prior
to
this
new
imminently
released
upcoming
feature.
You
were
mostly
only
able
to
accomplish
things
like
reading
and
writing
data
from
a
table
and
an
Excel
workbook,
but
as
of
a
moment
that
this
is
released,
which
is
gonna
be
sometime
very
soon.
This
will
actually
allow
you
to
accomplish
almost
any
operation
that
is
possible
via
office
J
s
Excel.
A
So
that
is
gonna
be
a
really
really
big
deal
and
we
are
really
excited
to
see
what
people
can
do
with
this.
Again.
It's
a
little
bit
more
catered
towards
end
users
that
are
not
able
to
build
their
own
add-ins,
but
I'm
actually
also
kind
of
interested
to
hear
from
you
guys
as
to
whether
or
not
you
see
this
as
a
potential
like
prototyping
bench
or
even
something
that
you
might
be
able
to
build.
A
It's
you
actually
complete,
but
no
scripts.
This
becomes
actually
a
very
trivial
and
automated
task.
So
what
I've
got
here
is
a
script
that
allows
you
to
basically
get
all
of
the
people
in
this
that
have
not
yet
completed
their
report.
I'm
just
gonna
run
it
real
quick
for
you
and
not
focus
on
the
actual
logic,
as
you
can
see
here.
What's
happened
is
the
missing.
A
Rose
values
have
been
highlighted
that
a
cell
has
been
highlighted
and
the
output
is
the
actual
name
of
the
individual
and
their
email
so
again
trying
to
focus
mostly
on
the
power
automate
integration
rather
than
actual
logic.
I'm
gonna.
Take
you
guys
over
to
power
automate,
and
here
I
can
actually
go
to
my
flows.
A
Currently,
this
is
only
available
as
a
feature
in
preview
environments.
This
is
what's
going
to
be
changing
in
the
next
two
weeks
and
it's
going
to
fail
abduction,
power,
automate,
a
set
of
environments.
You
do
not
have
to
create
and
set
up
a
special
environment
in
order
to
access
the
feature
or
you
will
not
and
in
creating
a
brand-new
flow.
I'm,
just
gonna
make
a
manual
one
and
add
an
Excel
connector
as
first
action
step
now
inside
this
Excel
online
for
business
connector,
which
is
again
something
that
has
previously
been
available.
A
There
is
now
going
to
be
an
additional
run,
script
preview
action
and
by
adding
this
I,
can
actually
find
the
location
of
the
workbook
that
I'm
interested
in
targeting
since
this
is
a
demo.
Tenant
is
just
kind
of
top-level
tasks,
reminders,
workbook
and
then
I'm
going
to
grab
the
scripts
that
actually
want
to
run
on
it.
A
So
here
I
have
a
get
people
script,
which
is
again
the
one
that
we've
just
kind
of
run
and
what
I'm
actually
trying
to
do
here
is
I'm
trying
to
accomplish
automating
this
task
of
reminding
everybody
who
wants
to
go
or
who
needs
to
go,
fill
out
this
spreadsheet
and
complete
the
status
report
cell
to
go
to
so
without
actually
any
effort
on
my
part.
So
you
might
imagine
that
this
manual
trigger
will
eventually
become
some
kind
of
recurrence
trigger.
That
happens.
A
A
And
then,
since
this
get
people,
scripts,
outputs
and
objects
containing
a
list
of
both
the
person's
name
and
their
email,
I
can
then
just
select
from
the
dynamic
content.
Section
users
email.
It
knows
power
automate
knows
the
fact
that
this
email
component
is
actually
contained
inside
a
list,
and
so
it's
smart
enough
to
add
and
apply
to
each
block
automatically.
Then
I
can
say
please
status
and
say
hi
name,
please
etc.
A
B
A
Had
my
active
card
in
it
went
so
I
may
do
that
in
the
background
as
we're
answering
questions,
because
that's
sort
of
a
core
component
of
the
adaptive
cards
approach,
but
you
might
imagine
the
gist
here-
is
that
there's
a
JSON
blob
that
defines
an
adaptive
card
highly
recommend
checking
this
out
if
you
haven't
yet
played
around
with
them.
These
are
what
adaptive
cards
look
like:
they're,
defined,
simple
by
a
JSON
blob
and
rendered
by
accommodation,
JavaScript,
CSS,
etc.
They
actually
worked
fairly
nicely
in
email
as
well
and
a
whole
bunch
of
other
different
platforms.
A
B
Look
for
that.
Let's
answer
questions
both
in
the
chat
here
and
through
the
questions
middle
forum
about
integrating
power,
automate
and
office
add-ins,
so
not
just
the
office
scripts,
but
the
the
adding
component
to
so.
If
you
could
speak
to
that,
I
can
send
you
your
JSON
thing
through
teams,
yeah.
A
Absolutely
basically
I
think
what
the
questions
asking
is,
whether
or
not
there's
going
to
be
some
kind
of
official
or
explicit
integration
between
add-ins
and
general
and
power
automate
and
I'm,
not
a
hundred
percent
sure
what
the
questions
going
for
specifically
because
of
the
fact
that
there
is
the
option
for
users
to
create
their
own
custom
connectors
in
power
automate.
And
so,
if
you
are
an
owner
of
an
add-in
building,
an
integration
yourself
with
power.
Automate
is
actually
something
that
would
be
fairly
easy
to
do
for
any
developer.
A
B
A
C
Alex
Danny
I
think
there
was
a
follow
up.
Note
on
that
question,
which
was
around
the
scenario
was
around
refreshing
data.
We're
having
your
script
called
a
data
refresh
operation
that
you're
adding
would
go
and
fetch
new
data
I
think
at
least
from
a
add-ins
Excel
add-ins
perspective
just
off
the
top
of
my
head.
One
thing
you
could
potentially
do
is
use
excels
calculation
engine
to
do
a
refresh.
So
let's
say
you
are
doing
custom
functions
and
you
you're
bringing
in
data
from
your
back-end
through
a
JavaScript
custom
function.
C
A
So
we
have
not
yet
very
deeply
explored
integrations
between
Adams
and
office
scripts.
That's
actually
something
we'd
be
interested
to
hear
more
you
guys
on
about
like
interests
and
that
sort
of
integration
and
like
what
possible
scenarios
you
might
think
of.
But
here
your
example
is
an
excellent
one.
That
is
absolutely
something
we
might
imagine
people
doing
someday
and
at
the
moment
you
can
kind
of
do
so
in
an
informal
way
where
you
like,
recommend
users
creating
an
office
script.
Slash
power,
automate
combo
to
like
do
a
particular
thing
on
a
regular
basis.
A
You
might
even
be
able
to
do
so
with
a
little
bit
of
acrobatics
on
your
part.
Programmatically,
as
power
automate
does
have
a
set
of
like
management
api's
that
allow
you
to
on-the-fly
create
flow
either
for
yourself
or
on
behalf
of
the
user.
That
said,
they're.
Definitely
not
that
like
tightly
integrated
at
the
moment,
it's
something
that
might
be
interested
in
changing
the
future.
An
imperfect
thing
does
that
answer.
What
you're
going
for
yeah.
B
C
So
I
think
for
the
moment
our
teams
focused
on
building
some
great
experiences
using
office
JavaScript,
and
so
what
I
would
say
for
a
blazer?
Is
we
hear
you?
We
actually
think
it's
really
cool
technology
and
the
best
way
to
voice
your
need
for
that
is
on
our
user
voice.
Channel,
but
I,
don't
think
we
have
any
imminent
plans
for
a
blazer
support.
Awesome.
A
A
So
again,
here
this
thing
is
to
find
entirely
by
JSON.
We
can
do
some
fancy
things
if
we
want
to
buy
like
modifying
the
message
tank
with
the
person's
name.
That
is
all
kind
of
up
to
us,
and
we
can
do
that
right
here.
So
what
I've
done
is
I've
pasted
this
JSON
blob
directly
into
the
message
field
of
the
team's
connector,
and
it
doesn't
actually
need
to
be
any
real
modification
unless,
like
me,
feel
like
we
want
it.
A
That
type
of
modification
might
look
like
again,
hi
person's
name
but
really
beyond
typing
in
hi
person's
name
or
adding
whatever
dynamic
field
you
actually
want
to.
All
that's
required
is
simply
this
email,
dynamic
field
objects
and
the
JSON
blob
defining
the
card
here.
I'm
also
going
to
modify
the
like
update
message
to
say
thanks
for
your
response
and
then
should
update
card
is
going
to
say
yes,
because
this
is
the
question
of
whether
or
not
after
submission
of
some
kind
of
info
via
the
card.
A
Should
you
change
the
appearance
of
it
or
should
you
allow
more
submissions
later
in
advanced
options,
I'm
going
to
say
yes,
I
wanted
to
be
able
to
alert
because
I
want
it
to
ping
and
spam
the
person
until
such
time
as
they
actually
have
completed
their
report?
That's
part
of
the
value
here,
I,
don't
have
to
be
the
bad
guy.
The
slow
bot
can
be
the
bed
yeah
I'm
on
behalf
and
here
I'm
actually
not
gonna
leave
a
summary,
because
it's
since
I
don't
leave
the
summary.
A
So
where
the
previous
scripts
returned
an
array
of
people,
this
one
actually
does
not
return
about
you
and
instead
accepts
value
as
its
parameters
before
running.
So
here
we
know
that
the
sender
is
going
to
be
the
person
with
the
corresponding
email
from
the
scenes
card.
I'm
actually
gonna
just
to
make
sure
that
there
isn't
anything
that
might
get
out
of
sync:
try
to
use
the
output
of
the
team's
card,
which
is
lagging
on
me
a
little
bit.
A
C
A
I'm
gonna
stop
trying
to
like
mess
with
this
demo,
because
clearly,
I
didn't
take
the
records
of
time
to
set
it
up.
So
I
apologize
to
you
guys
on
your
behalf
that
you
can't
see
this
right
in
this
moment,
but
I
actually
encourage
you
in
the
next
week
or
two
to
go
play
around
with
it
yourselves,
because,
whenever
I
figure
out
what
silly
thing
I'm
doing
right
here,
that's
causing
it
to
fail
whenever
I
figure
out
what
that
is,
it's
gonna
work
beautifully.
A
This
has
actually
been
something
that
we
are
actively
using
on
our
team
in
multiple
places
and
across
a
couple
of
other
teams
like
Microsoft
edge.
It's
you,
like
handle
status
report,
updates,
send
out
like
email
reports
automatically
like
ping
people
across
like
hundred
person.
Teams
like
this
really
is
something
that
is
actually
impressively
robust
and
like
serves
us
very
well,
and
a
number
of
different
real
business
case
applications.
So
I'm
gonna
like
hold
off
on
this
and
stop
trying
to
be
optimistic
about
this
demo
and
working
Alex.
I.
A
B
Sure
yeah
here
let
me
share
something
so
Thank
You
Danny
for
that
demo
and
presentation.
This
sample
of
automated
task
reminders
through
power,
automate
and
office
scripts
will
be
on
our
office
scripts
documentation
once
the
our
automate
feature
or
connector
goes
live.
You
can
follow
along
with
the
setup
instructions.
Here's
the
script,
that
Danny
ran
to
get
all
the
data
and
then
to
add
it
back
to
the
workbook.
We
have
that
JSON
for
the
adaptive
card
and
you
can
kind
of
follow
along
to
see
how
to
make
your
power
automate.