►
From YouTube: Microsoft Power Platform community call – October 2022
Description
Latest updates and news on Power Platform including community events, training opportunities and the Monthly Community Tip. Three demos delivered – Dataverse Dataflows as a sync mechanism, Power Automate and Microsoft Teams approvals advanced scenarios, and Power Pages General Availability. Connect to other makers in your organization via chatbot, now in public preview - aka.ms/makermatch. Monthly Community Tip - Handle duplicate property names in JSON objects in Power Automate - George Doubinski | @georgedude. This call was hosted by David Warner II (Microsoft) | @DavidWarnerII and recorded on October 19, 2022. Questions addressed in chat throughout the call.
Learn more
• See the full blog post for this call in the Microsoft 365 platform community blog - https://aka.ms/m365pnp/blog
• 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 - https://aka.ms/m365/community
A
B
B
Let's
look
at
what
we're
going
to
talk
about
today,
so
we're
going
to
have
some
latest
updates
and
news
on
Power
Platform,
Todd
baginski
is
going
to
share
with
us
a
monthly
Community
tip,
we're
going
to
have
the
favorite
picture
time,
we're
going
to
click,
click,
click
and
then
we're
going
to
have
our
All-Star
presenters
of
the
day.
So
eichel
is
going
to
cover
dataverse
data
flows
as
a
sync
mechanism,
and
then
Thomas
is
going
to
talk
about
power,
automate,
Microsoft
teams,
approvals,
Advanced
scenario,
so
very,
very
cool,
and
then
what
happened?
B
Last
week,
power
Pages,
win
yay,
so
Hugo
Bernier
is
here
our
favorite
Power
Pages
Community
program
manager
to
share
with
us
all
of
the
goodness
that
was
announced
and
how
we
can
learn
more
and
take
advantage.
But
first
we
want
to
remind
you
all
that
you
are
invited
to
present
on
this
call.
This
is
your
call.
We
absolutely
welcome
everyone
in
the
community
to
show
tips,
tricks
cool
little
things
that
they
may
have
found
useful
within
the
Power
Platform.
We
want
everyone
to
have
an
opportunity
to
feel
welcome
and
we've
made
it
easy
on.
B
You
go
to
AKA
dot,
Ms
forward,
slash
ppcc,
demo
request.
We
invite
you
to
just
submit
your
information
and
we
will
absolutely
reach
out
and
get
you
into
future
slots.
So
don't
hesitate
to
take
advantage
of
this
again.
This
is
your
community
call.
This
is
something
that
we
want
you
to
take
advantage
of
and
ensure
that
you
feel
a
part
of,
because
it
is
your
community.
C
B
Excellent,
thank
you.
Now
April
had
mentioned
the
sharing
his
caring
program.
Now
this
is
a
program
that
we
started
to
provide
Hands-On
guidance.
Now
you
may
be
excited
about
all
those
samples
you
may
want
to
speak
at
these
com.
Community
calls,
but
you
may
be
a
little
bit
nervous
about
it.
Maybe
you've
not
done
it
before.
Maybe
GitHub
is
completely
foreign
to
you
and
you
hear
things
like
pull
requests
and
forking
and
what
are
all
those
terms?
They
don't
mean
anything.
B
B
As
you
all
know,
that
was
fantastic
because
of
the
amazing
attendance
that
you
all
brought
to
it,
and
so
now
that
that's
passed,
we're
getting
a
lot
more
events
and
programs
for
the
sharing
is
caring
sessions
scheduled
so
keep
an
eye
on
that
we'll
tweet
out
on
it
as
well,
when
we
schedule
those.
But
we
want
you
to
feel
empowered.
We're
also
starting
to
look
at
recording
some
of
these.
So
some
videos
on
demand
that
you
can
consume
assume.
B
So
don't
hesitate
to
keep
an
eye
out
as
April
just
put
in
the
chat.
We
absolutely
want
to
make
sure
that
you're
empowered
to
do
that
now,
once
you
have
contributed
in
a
variety
of
ways,
we
want
to
recognize
and
celebrate
the
amazing
work
that
you're
doing,
and
so
we
have
the
community
recognition
program.
This
is
a
program
that
will
absolutely
provide
accredited
and
formal
recognition.
We
powered
with
credly,
and
you
may
say,
credly
that
sounds
familiar.
That's
the
same.
Cred
lead
that
you
get
those
badges
from
when
you
get
certified.
B
We
have
partnered
with
credly
to
provide
Community
badges
to
celebrate
and
recognize
the
work
that
you're
doing,
and
thank
you
for
the
work
that
you're
doing
and
because
it
is
hacktober,
we
have
generated
a
hacktoberfest
badge.
So
if
you
do
any
contributions
in
the
month
of
October,
and
that
means
any
if
you
help
update
documentation,
if
you
submit
a
sample
all
kinds
of
stuff,
you
absolutely
will
get
a
hacktoberfest
badge
and
it's
only
available
this
month.
So
definitely
take
advantage
of
that.
B
If
you
have
any
questions
on
how
you
can
get
more
involved,
in
fact,
presenting
is
one
of
those
we
would
want
to
help
you
and
so
don't
hesitate
to
reach
out
to
anyone
else,
but
we
do
need
you
to
opt
in
for
the
recognition
program
just
so
that
we
can
connect
you
to
your
GitHub
account
and
a
variety
of
other
accounts
and
ensure
that
you
are
well
taken
care
of
there.
So
do
not
hesitate
to
to
do
that.
We
want
you
to
get
more
involved
now.
C
Thanks
again,
David
yeah,
so
I
had
the
amazing
opportunity
to
do
the
first
live
version
of
the
low
code.
Revolution
at
the
Microsoft
Power
Platform
conference
had
a
chance
to
sit
down
with
the
amazing
Scott
Duro
and
give
his
tips
and
tricks
for
Fusion
development.
So
an
interjecting
Pro,
Code
and
low
code,
together
with
the
Power
Platform,
so
really
great
conversation
with
Scott
at
the
conference,
I'd
love
being
able
to
finally
do
one
in
person
and
sit
down
with
them
in
real
life,
so
make
sure
to
check
that
out.
C
We
have
a
ton
of
other
episodes
too,
with
different
community
members
and
MVPs,
and
all
of
that.
So
if
you
want
to
be
a
guest
also
like
Scott
was,
you
can
just
go
to
aka.ms4,
slash
low
code,
Revolution
guests
and
I'd
love
to
have
you
on
the
show.
If
you
have
something
cool
to
demo,
thanks
David
awesome.
B
Thanks
April
now
another
event:
that's
coming
up
is
the
European
Power
Platform
conference.
This
is
a
super,
exciting
opportunity.
It
is
going
to
be
June
20th
through
the
22nd
next
year.
We
are
extremely
excited
about
this,
especially
all
of
us
having
come
off
the
Microsoft
Power
Platform
conference
that
just
occurred
in
Orlando
last
month.
This
is
going
to
be
the
European
version
and
we
are
super
super
excited
and
we
wanted
to
let
you
know
that
the
call
for
speakers
is
open
now.
B
This
is
obviously
an
opportunity
for
us
all
to
get
more
involved.
The
it
closes
on
the
14th
of
December
so
definitely
go.
Take
advantage
of
that.
You
can
learn
more
at
sharepointeurope.com,
submit
to
speak
eppc,
so
definitely
an
exciting
opportunity.
This
is
going
to
be
close
to
some
of
you
in
Europe
that
weren't
able
to
come
over
and
ideally
we'll
have
some
coming
over
to
Europe
from
the
states,
and
so
it's
again
a
wonderful
opportunity
for
us
to
come
together
as
a
community
and
work
together.
B
Collaborate
celebrate
see
each
other
have
those
lunch
conversations
and
those
hallway
conversations
that
we've
so
dearly
missed
the
last
few
years.
That
was
one
of
the
biggest
and
most
exciting
things
for
everyone
that
they
were
able
to
do
in
Orlando
and
hugs
right.
We
all
want
to
get
some
hugs,
so
we
definitely
look
forward
to
that
all
right.
Let's
move
on
to
some
news
and
for
that
I'm
actually
going
to
invite
zenkar
Desai
to
tell
us
about
what's
new
with
powerapps.
D
Thank
you,
David,
hey
everyone
very
excited
to
talk
to
you
about
what
was
just
released
in
at
ignite
last
week,
maker
matching,
which
essentially
allows
all
makers
to
connect
to
other
makers
in
your
organization
directly
in
product
via
the
chat
bot.
The
way
it
works
is
once
you
open
the
chat,
bot,
the
content
and
resources
presented
are
all
Microsoft
support,
documentation
and,
after
that,
make
imagine
gets
enabled.
D
So
essentially,
you
can
actually
see
all
of
your
internal
organizations
Community
channels
and
also
see
who
the
other
skilled
makers
are
in
the
organization,
so
you
can
directly
reach
out
to
them
via
teams
or
email
AK
dot
Ms
slash
maker
match
is
where
you
can
learn
more
about
it.
I
will
also
paste
in
a
link
in
the
chat
window
to
the
blog
that
was
just
released
to
help
you
understand
the
feature
more.
B
E
E
So
from
time
to
time,
you
may
encounter
Json
objects
and
power.
Automate
flows
that
contain
duplicate
property
names.
Consider
this
object.
For
example,
as
you
can
see,
the
ID
and
name
properties
appear
in
multiple
paths
in
the
Json
object
to
make
this
object
maker
friendly.
The
common
approach
is
to
use
the
parse
Json
action
and
derive
the
schema
from
the
data
itself.
So
you
do
that
by
clicking
that
button,
when
you
do
that,
you
can
then
use
the
properties
as
Dynamic
values
in
your
power.
Automate
flows
like
you
see
here.
E
However,
in
this
example,
some
properties
have
identical
names,
the
ID
and
name
properties.
In
this
example,
even
though,
as
we
saw,
their
path
is
different
in
the
Json,
if
we
put
the
mapping
up
and
look
at
it
side
by
side,
here
are
those
ID
and
name
throughout
the
Json
and
here's.
What
they
actually
map
to
this
can
become
confusing
and
make
it
hard
to
know
what
property
maps
to
what
value
in
the
Json
object
so
enter.
Georgia's,
awesome,
quick
tip
to
make
the
properties
easier
to
use
in
power
automate
flow.
E
E
The
result
is
a
game
changer.
As
you
can
see,
this
approach
makes
it
easy
to
determine
which
each
Dynamic
Property
correlates
to
inside
of
the
Json
object
and
as
George
put
it
now,
you
can
have
your
Json
and
eat
it
too.
I
love
his
little
stick
figure.
There
too.
He
looks
like
such
a
boss,
so
thanks
again
for
sharing
the
tip
George.
If
you
have
a
quick
tip,
please
reach
out
to
us
and
submit
your
idea,
and
we
will
present
it
on
the
call
thanks.
B
Awesome,
thank
you
Todd
and
yes,
thank
you
to
all
who
are
submitting
for
tips.
So
don't
hesitate
to
do
that.
We
want
to
see
your
tips
and
we're
looking
for
more
ways
to
really
showcase
you
all
for
the
amazing
things
that
you're
doing
so,
please
don't
hesitate
all
right.
What
time
is
it?
Click,
click,
click,
click
picture
time.
Let's
get
those
cameras
turned
on
and
I
will
share
my
camera
here
and
we
will
get
this
turned
into
together
mode.
B
There
we
go,
everybody
looks
fantastic.
Okay,
all
right,
I
feel
like
we're
all
at
like
a
sporting
event.
Right
like
we,
we
kind
of
need
to
do
some
sort
of
like
like
crowdclap
right
like
something
like
that,
all
right,
let's
just
wave
to
everybody
in
the
community.
Let
me
start
recording
and
let
her
go.
Let's
show
everybody!
How
awesome
you
are?
We
really
appreciate
you
all
fantastic.
You
look,
wonderful,
thank
you
for
being
the
best
part
of
our
community
as
you
are
so.
Thank
you
very
very
much.
B
F
Well,
first
of
all,
thank
you
for
having
me
here
again.
This
is
a
long
time
from
coming
to
the
community
calls
to
present
a
something
about
a
powerapps.
My
name
is
Michael
Mendoza
I'm,
a
business
applications
MVP
and
also
the
business
apps
team
lead
at
intellect
Technologies
I'm.
Also,
the
author
of
The
powerapps
cookbook
is
a
little
project
that
I
created
with
a
packed
editorial,
to
bring
something
to
the
to
the
world
about
some
recipes,
as
the
name
implies,
as
the
cookbook
implies.
F
Some
recipes
about
everything
around
powerapps
Power,
Platform,
a
power
automate,
some
things
that
you
can
see
to
adapt
to
your
use
cases
on
your
everyday
products.
Okay,
you
can
find
me
on
my
almost
all
the
time
from
on
Twitter
my
this
is
my
handle,
or
you
can
find
more
information
about
me
on
on
interlegia.
That's
the
name
of
my
my
company
or
my
blog,
that
is
powernables.com.
F
Okay,
I'm
here
to
talk
to
you
about
Power
Platform
data
flows
you
can
see
here
is
a
a
tool
that
Power
Platform
gives
us
to
connect
to
services
and
get
that
information
to
dataverse.
As
you
can
see,
we
have
connectivity
to
cloud
services,
a
Content,
a
databases
apis,
no
matter
the
the
service
that
you
want
to
connect,
even
on
a
local
services
that
you
may
have
on
your
on
your
organizations,
you
can
use
data
flow
to
extract
that
information
into
dataverse.
F
The
good
thing
that
we
have
here
is
that
we
have
a
neat
ATL
that
is,
extract,
transforms
and
load
in
this
information
or
this
data
using
power
query.
That
is
an
amazing
tool,
because
you
can
have
all
the
information
from
that
data
source
transform
it
to
to
whatever
you
need
to
use
and
put
it
there,
and
you
can
use
multiple
data
sources
in
a
single
data
flow
for
for
for
this
kind
of
process.
Okay,
this
is
all
the
slides
that
I
have
before.
B
F
Jump
into
the
demo
so
to
prepare
this
demo
too,
so
I
can
show
you
how
it
works.
A
I
prepared
a
simple,
a
SharePoint
list
with
10
persons
here
that
you
see
all
random
people
here
with
some
identifier,
just
just
a
number
and
the
full
name:
okay,
so
front
link,
okay,
so
in
the
Power
Platform
we
have
something
called
the
data
flows.
You
can
find
it
here
under
dataverse.
You
can
go
to
data
flows
and
you
will
be
presented
with
this
screen
here.
F
I
have
three
data
flows
is
to
show
you
as
an
example
to
see
how
it
works
and
to
use
this
a
data
flows
I'm
going
to
use
the
SharePoint
list
that
I
I
just
showed
you
and
I
created
a
solution
here
with
a
table
that
is
called
SharePoint
data
flow.
The
idea
is
to
take
that
information
from
SharePoint
to
this
table.
Okay,
so
it's
an
easy
table
that
has
the
same
columns
that
the
SharePoint
list
has
and
an
ID
and
a
full
name,
and
how
can
we
create
this
data
flow
to
take
this
data?
F
We
click
here
on
new
data
flow
put
in
the
name
platform.
Community
call
this
is
easier.
Okay,
there's
a
great
thing
that
I
was
telling
you
about
power.
Query
is
that
we
can
get
information
from
many
a
data
sources,
as
you
can
see
here,
but
you
can
use
a
a
IBM
Oracle
MySQL,
not
only
a
service
provided
by
Microsoft.
In
this
case,
we
are
going
to
select
for,
for
this
case,
SharePoint
online
list,
because
that's
where
from
where
we're
getting
this
data,
we
can
get
from
folders
in
this
in
this
in
this.
F
In
this
case,
it's
a
library.
So
we
click
that
and
then
put
the
URL
where
the
SharePoint
list
is
located.
Okay,
I'm
going
to
put
the
SharePoint
URL
and
there's
something
here
in
this
specific
case
for
SharePoint-
is
that
you
can
have
one
implementation
of
the
connection.
I
recommend
you
to
use
that
person
number
two,
because
you
can
select
from
which
view
in
SharePoint
you're.
Are
you
getting
the
data?
This
is
useful
because
if
you
are
creating
a
view
for
this
data,
you
can
specify
Only
The
Columns.
F
You
want,
in
this
case,
I
only
want
the
identifier
and
the
full
name,
not
the
created
by
or
the
modify
it
by
or
or
any
other
metadata,
okay,
so
I'm
going
to
select
just
retrieve
the
columns
from
the
default
view
in
SharePoint
list.
Okay,
once
I
put
this
URL
sorry
I
forgot
to
put
the
completely
a
I
need
to
create
a
connection
I'm
going
to
delete
this.
So
you
can
see
you
you
just
simply
need
to
to
select
an
existing
connection,
create
a
new
one.
Put
the
the
name
of
this
connection.
F
If
you
need
to
get
data
from
a
local
server,
you
will
use
a
data
Gateway
in
order
to
collect
that
information
and
the
the
type
of
authentication
in
this
case
is
going
to
be
a
Office
365
organizational
account.
So
we
click
next
and
once
a
it
gets
that
information.
It
will
start
showing
me
all
the
lists
that
you
have
in
on
SharePoint
I'm,
going
to
find
the
data
flows.
You
can
use
the
filter
here,
I'm
going
to
select
this
list
and
it
will
show
me
the
the
first
part
of
the
information.
F
If
you
have
a
long
list,
I'm
going
to
click
on
transform
data,
so
it
will
allow
me
to
transform
all
this
data
I
can,
for
example,
a
choose
any
column,
I
I
can
select
here
and
say:
oh
I,
don't
want
the
ID
I,
don't
want
this
column,
I
don't
want
the
other
I
want
all
this.
This
information
here
transform,
for
example,
you
can
click
here
and
I,
don't
know
all
in
uppercase
and
it
will
adapt
all
this
information
before
putting
that
into
dataverse.
F
F
So,
if
I
put
this
information
here,
you
will
see
that
we
I
will
be
creating
some
steps
here,
based
on
everything.
I
want
to
do
with
this
data
in
this
case,
I
get
the
source
information
I,
navigate
to
this
list
and
I'm
setting
an
uppercase
for
this
column.
Okay,
so
it
allows
you
to
build
some
a
Transformations.
F
You
can
find
more
information
about
all
the
Transformations
that
you
can
create
here
from
the
from
the
documentation,
and
once
you
click
next,
you
will
see
that
you
have
the
possibility
to
create
a
new
table
once
the
data
is
a
has
been
arrived
to
to
that
reverse
well
to
the
file
to
the
data
flow,
you
can
load
the
info
to
the
data
to
the
existing
table,
or,
if
you
want
you
don't
want,
you
are
not
going
to
load
any
data.
We're
going
to
see
why
this
is
a
news
case
in
the
next.
F
In
the
next
example,
I
am
going
to
select
here
my
table.
That
is
this
one
SharePoint
data
flow
is
the
one
that
we
see
here
and
I'm
going
to
map
the
information.
The
full
name
goes
here:
the
ID
goes
to
this
column
and
the
location
I'm
not
going
to
use
that
in
this
case,
you
can
also
select
this
this
check
to
delete
the
rows
that
are
no
longer
in
the
query
output,
if
I'm
getting
data
that
is
always
evolving
or
deleting
from
the
data
source,
and
you
want
to
that
data
to
be
deleted
here.
F
In
the
diverse
you
can
check
this
and
it
will
delete
the
information
as
soon
as
well
as
as
the
data
flow
completes,
its
Refresh
on
that
reverse
and
it
will
slow
down
the
the
process.
But
it's
a
it's
a
good
solution.
Okay,
if
I
click
next
I
will
see
the
some
refresh
settings
about
if
I
want
to
refresh
manually,
that's
we're
going
to
do
it
right
now
or
automatically.
You
can
set
a
frequency
based
on
days,
minutes
numbers
or
a
specific
day
or
times
for
this
example.
F
I'm
going
to
select
manually
and
I
always
recommend,
send
refresh
failure
for
the
creator
of
the
of
the
data
flow,
because,
if
I,
if
it
fails,
I
want
to
be
I
want
to
be
reminded
of
that.
Okay,
once
a
we
finish
with
the
data
flow,
it
will
build
the
data
flow
and
it's
going
to
be
published
some
something
like
where
when
we
are
working
with
powerapps,
you
build
the
app
and
then
you
publish
and
once
you
get
published
it
will
refresh.
As
you
can
see
here,
the
next
refresh
is
in
progress.
F
Everything
went
well
with
the
data
coming
from
the
serpent
to
that
soon
from
that
from
SharePoint
to
dataverse,
and
it's
now
refreshing
the
data.
If
everything
goes
as
expected,
where
should
be
seeing
any
minute?
The
information
here
see
if
it
works
fast,
because
I
need
it
to
work
fast,
okay,
it.
It
did
finish
if
I
hit
refresh
here,
I
see
the
data,
as
you
can
see,
I
heated
the
transformation
to
make
a
every
full
name
and
uppercase
is
now
it's
uppercase.
F
But
what
happens
if
I,
okay,
everything
is
working
well,
I'm,
going
to
refresh
the
data.
For
example,
you
set
the
fresh
method
to
be
every
day,
for
example,
if
I
click
refresh
again,
it
will
get
the
data
from
SharePoint.
Again,
I
will
put
that
again
on
that
and
dataverse.
That
means
that
it
will
not
check
if
the
data
is
already
there,
it
will
simply
pull
the
information
from
the
data
source
and
put
it
on
the
diverse.
F
That
is
not
what
we
want
if
I
click
here
on
the
refresh,
let's
see,
okay,
you
see
everything
is
duplicated.
This
is
not
what
what
we
want.
We
want
the
information
I'm
going
to
delete
it
here,
to
be
sync,
so
a
we
have
the
data
here
we
have
the
data
flows
is
this
is
the
same
data
flow
that
we
created
just
now
and
I
want
to
and
show
you
how
to?
How
can
we
do
this?
We
can
first
get
new
data.
F
We
are
creating
a
new,
a
new
query
here
and
go
to
select
more
and
I'm
going
to
say:
okay,
let's
do
a
new
query
to
dataverse
in
this
case
my
organization
is
this
one
I'm
going
to
put
it
here
and
I
have
the
connection
and
I'm
going
to
select
the
table
that
I
already
have
on
created
on
on
the
reverse?
Let's
see
if
it
goes
well.
Okay,
it's
loading.
The
data
data
flow,
this
one
and
I'm
going
to
create
this
connection.
F
What
it's
actually
doing
now
is
is
having,
in
my
data
flow,
both
queries,
one
querying
the
data
sourcing
SharePoint
and
the
other
one
querying
the
data
on
dataverse.
So
you
can
see
here
we
have
no
rows,
we
have
no
rows
and
what
we're
going
to
do
right
now,
we're
going
to
create
a
merge
query.
What
I'm
going
to
say
is:
okay,
I
have
data
from
SharePoint
that
I
want
to
merge,
with
other
words,
based
on
what
I
have
an
edited
identity,
identifier
that
is
one
two
three,
these
numbers
and
I
have
this
column
created
here.
F
F
What
kind
of
join
are
you
going
to
do,
and
you
can
see
here
if
I
hover
over
this
type
of
kind
of
joints,
you
will
see?
How
are
they
working?
How
are
we're
going
to
do
left
outer
joint,
a
simply
puts
the
information
from
the
left
side.
Compare
it
to
the
right
side.
If
everything
is,
is
there
we're
going
to
have
it
on
on
the
reverse?
F
F
It
will
show
you
that
this
evaluation
goes
through
through
Microsoft
service,
and
so
you
need
to
set
it's
okay,
it's
a
privacy
thing,
okay,
this
merge.
What
is
telling
me
now.
Everything
on
the
left
side
is
not
on
the
other
version.
Everything
in
SharePoint
is
not
under
diverse,
so
is
it
is
working
if
you
click
next,
you
will
see
we
have
all
this
data
from
from
my
data
flow.
We're
going
we're
going
to
do
with
this.
We're
not
going
to
get
the
data
directly
from
SharePoint
I'm,
going
to
reset
this
load.
F
Setting
and
set
do
not
load
I,
don't
want
the
data
from
their
dataverse
itself.
Do
not
load
but
I'm
going
to
use
the
merge.
There
are
six
and
the
resulting
from
both
a
merge
of
both
data.
So
I
can
go
here,
set
this
and
do
the
same
again
the
same
mapping
once
I
click
publish
it
will
get
the
information
from
SharePoint.
That
is
new,
that
is,
that
doesn't
exist
on
the
reverse
and
we'll
start
pulling
that
data
to
the
diverse.
If
I
click
again,
it
will
see
that
data
already
existed
into
the
version.
F
Let's
do
nothing,
and
and
if
everything
works
as
okay,
it
will
show
10
records
here
and
if
I
execute
the
data
flow
again,
it
will
show
you
again
that
there's
only
10
records
on
the
reverse,
let's
see
if
it
works
correctly.
While
this
is
working
you
can
and
just
to
let
you
know
that
the
power
query
accepts
information
even
from
URLs
from
apis.
That
show
you
a
complex
information.
F
One
great
thing
that
about
this
is
that
when
you
put
that
information
on
data
flow,
it
actually
learns
from
the
data
and
shows
you
all
the
real
good
structure
that
you
will
need
from
from
these
data.
I'll
see
here,
we
already
have
a
10
records
and
if
I
click
again
here
well
this
one
refresh
well
trust
me:
you
won't
see
the
duplicated
data
that
we
see
on
on
the
first
one
and
that's
about
it.
I
hope
you,
like
my
session.
B
Yeah
awesome
Michael,
really
good
adjustment
as
well
on
the
little
blips
there,
your
pro,
so
thank
you
so
much.
There
was
great
feedback
and
some
comments,
like
you
said
in
the
chat
I'll.
Let
you
look
at
those
in
the
interest
of
time,
we'll
turn
it
over
to
Thomas
for
power,
automate
and
Microsoft.
Advanced
scenarios
take
it
over.
G
All
right
so
hello,
everyone
yeah,
there
should
be
my
slide
somewhere
here.
So
just
a
short
introduction.
My
name
is
Tech
from
Warsaw
important
and
I'm
stoked
to
be
here
even
more
when
I
learned
about
the
badge
that
is
going
to
be
given
to
all
those
contributors
in
October,
so
anyways,
just
in
short
words,
I'm,
really
love,
I,
really
love
to
work
with
podcasts
from
I.
Do
us
for
over
four
years.
I
do
a
couple
of
thoughts.
I
mean
lots
of
things
around
contributions,
like
video
recordings
blog
posting.
G
They
are
working
on
dataverse,
of
course,
and
there
are
a
couple
of
tables
which
are
taking
part
in
the
approvals
and
by
telling
you
this
I
want
to
show
you
some
scenarios
that
you
cannot
simply
achieve
by
using
the
out-of-box
functionalities,
and
so
first
of
all,
there
is
the
main
table
that
is
called
approval,
which
is
storing
like
a
header
of
the
approval.
So
the
information
for
the
title
description
who
has
created
it
and
after
the
approval
is
completed.
What
was
the
outcome?
Then?
G
The
approval
request
is
a
table
that
stores
information
about
every
single
task
generated
during
the
follow-up
process,
together
with
information
to
whom
it
is
assigned.
Of
course,
then,
the
employer
response
is
serving
information
about
every
single
completed
task,
so
information
about
who
completed
it
and
what
was
the
outcome?
And
what
was
the
comment?
Now?
Then?
G
The
user
table
is
used
to
combine
all
these
tables
together
because
it
has
trim
up
the
aid
information
to
the
diverse
information
about
the
users
and
the
approval
table
is
the
most
important
one
in
terms
of
those
custom
scenarios,
because
it
holds
information
about
every
single
action
in
every
instance
of
a
flow
that
contains
an
action
related
approval.
So
if
you
have
a
flow
that
has
starting
wait
for
an
approval,
it
will
contain
just
one
one:
entry
in
the
flow
Pro
table.
G
You
have
to
be
aware
that
first
flows
are
environment
related,
so
that
there
is
no
like
a
general
storage
for
all
approvals.
In
all
the
environments
you
have,
they
are
stored
in
data
versus
mentioned,
therefore,
they're,
really
environment
related
and,
furthermore,
those
actions
which
are
waiting
for
the
approval
to
be
completed,
both
speaking
about
power
automate
like
wait
for
an
approval
and
wait
for
like
adaptive
cards
to
be
response
from
the
Adaptive
card.
They
only
wait
30
days
so,
but
it
doesn't
mean
that
the
approval
data
is
removed
from
the
dataverse.
G
No,
it's
not,
and
therefore
what
I'll
be
showing
you
can
as
well
be
used
to
create
some
really
long-running
workflows,
which
can
even
take
like
years
to
be
completed.
So
there
are
a
couple
of
scenarios
like
when
the
task
is
created.
Power
automate
is
writing
to
two
tables
so
into
approval
and
the
flow
requests.
G
G
So
speaking
about
the
reassignment,
the
only
things
that
are
happening
are
happening
within
the
approval
request
say
it
was
like
one
task
is
being
activated,
the
other
one
task
is
being
created,
record
is
being
activated,
the
other
one
is
activate,
is
created
and
when
speaking
about
the
reassignment
and
what
we
can
do
out
of
box,
they're
like
principles
which
power
automatic
is
following,
or
maybe
the
current
approvals
API.
So
first
user
cannot
reassign
a
task
which
is
not
assigned
to
themselves,
so
you
can't
reassign
others,
others
assignees
tasks.
G
G
I
mean
those
principles
can
be,
can
be
overcome
with
the
custom
custom
actions
that
you
can
do
on
the
approvals
table.
Obviously,
and
lastly,
when
a
task
is
canceled,
then
the
original
information
is
updated
again
in
approvals
table
with
the
outcome
that
is
canceled
and
the
result
that
is
canceled,
and
so
that's
it
it's
so.
Thank
you.
It's
just
that
I
will
be
now
jump
over
to
demos
because
they
are
way
more
interesting.
G
This
first
task
or
this
first
workflow
I,
will
just
show
you
how
you
can
complete
any
running
approval
like
no
matter
if
it
is
already
completed
or
well,
it
has
to
sorry
whether
it's
waiting
for
one
approval
or
whether
it's
waiting
for
10
approvals,
the
point
is
about
the
approvals
are
also
important.
Is
the
fact
that,
if
you
choose
to
approve
reject,
everyone
must
approve,
it
will
be
waiting
either
for
the
first
rejection
or
first
approve
of
all
the
approvals.
G
If
you
choose
the
proof,
reject
everyone
must
approved
but
custom
responses,
then
it
will
be
always
waiting
for
everyone
who
is
assigned
a
task
to
complete
their
tasks,
and
this
might
be
a
bottleneck
in
many
scenarios.
Just
imagine
if
someone
is
on
holidays
or
is
on
a
sick
leave
and
they
just
cannot
complete
their
tasks,
but
on
the
other
hand,
you
are
not
able
to
reassign
these
tasks
or
let
others
to
complete
these
tasks.
G
Its
mechanism
is
quite
simple,
I
mean
it
is,
and
it
is
not
that
very
deep
details
are
on
my
YouTube
channel
if
you'd
like
to
to
follow
and
to
get
into
details.
So,
first
of
all,
the
workflow
is
taking
information
about
the
approval
itself
about
all
the
assigned
tasks,
any
information
about
the
tasks
which
are
already
completed
so
like
if
I
go
now
to
list
of
my
assigned
tasks
and
I'll
just
complete
one
of
these,
which
are
assigned
in
this
approval
process
every
snap,
so
maybe
I'll
go
to
another
user.
G
Oh
there,
it
is
so
he'll
complete
yep,
and
that's
done
it's
done.
Yes,
he's
done
so
anyways.
This
flow
is
now
will
take
us
for
information
about
the
completed
tasks
and
then
it
is
reaching
out
to
the
table
to
get
the
flow
approval
into
the
four
Pros
table
to
get
the
information
about
the
flood
notification
Yuri.
Now.
What
I
found
out
is
that
if
you
have
the
same
scenario
as
I
do
have
so
that
you
have
like
two
actions,
one
is
assigning
an
approval.
The
second
one
is
wedding.
G
G
So
it's
called
the
flow
sequence
ID
and
therefore,
if
after
trying
to
get
the
flonificationary
with
the
first
attempt
with
the
first
action
using
the
approval,
ID
I
am
getting
nothing
so
that
the
phone
notification
here
is
empty
I'm.
Doing
the
second
call
to
check
if
there
is
a
flow
notification
Theory
available
for
the
flow
run,
sequence
ID,
that
I
was
able
to
obtain
from
the
first
call,
and
that's
just
the
most
movie
cumbersome
piece.
G
The
flow
is
marking
the
existing
approval
as
completed
and
then
is
building
the
request
body
that
is
in
the
end,
going
to
be
sent
to
this
fortification
urine.
So
just
let
me
show
you
how
this
can
be
done
now
trigger
this
workflow
by
providing
that
flow
by
that
approval.
Id-
and
here
we
go
so
oh-
and
by
the
way,
this
request
body
that
you
are
sending
this
notificationary,
it
can
be
literally
anything
it
just
has
to
be
a
valid
Json
and
it
is
being
returned
one
to
one
through
the
up.
G
But
then
this
outcome
is
going
to
be
stored
in
dataverse
and
it
will
be
as
well
returned
by
the
action
which
is
now
waiting.
So
let
me
navigate
here,
you
see
now.
The
information
is
that
if
my
flow
runs
successfully
and
when
I
go
through
the
outcomes,
I
can
see
that
there
is
My
outcome,
just
written
the
response
summary
because
General
researcher
has
already
approved
their
task
and
there
were
no
other
responses,
and
even
though
that
the
approval
was
waiting
for
three
responses
or
the
first
Rejection,
it
is
already
completed.
G
The
second
scenario
I
wanted
to
show
you
before
before
I
move
on
to
the
third
one.
If
I
still
have
time
is
the
reassignment,
because
one
of
one
of
those
things
I
found
the
most
important.
When
are
we
when
speaking
about
the
workflows?
Is
that
whenever
we
have
that
approval
process
waiting
for
multiple
assignments
for
their
responses,
we
really
can,
as
mentioned
it
before.
We
can
very
easily
find
ourselves
in
like
in
a
bottle
act.
G
Just
procrastinate
for
whatever
weeks
so
anyways
the
recycling
task
works.
This
way
that
it
is
obtaining
or
getting
the
information
about,
the
current
assignee
and
the
new
assignee.
It
is
as
well
getting
information
about
the
existing
task
details
because
in
the
end
it
has
to
create
a
new
entry
in
upload
requests
table.
G
That
simply
looks
up,
looks
of
the
existing
approval
request
and
once
this
new
approval
is
created
when
this
new
entry
is
created
with
the
new
assignee,
then
the
existing
one
is
simply
set
to
a
reassigned
stage:
complete
and
Status
inactive.
So
now,
once
I
hit
and
test
it,
I
also
need
to
navigate
back
to
another
example.
I
think
it
was
that
one,
this
task
is
pre-assigned
Task.
G
You
see
this
assigned
just
to
two
employees,
so,
like
General
researcher
doesn't
have
this
task
assigned
and
now
I'll
get
the
approval
ID
and
where
to
start
here,
I
think
it
was
here
so
I
want
to
reassign
my
task
to
John
and
run
it
so
just
to
show
you
I.
Have
this
reassigned
as
present
meanwhile
Joan
well,
John
has
but
it's
the
old
one,
so
I
can
see
if
he
can't
sell
it
and
it
will
not.
G
So
it's
gone
from
my
list,
however,
when
I
switched
to
John's
list
of
tasks
and
now
refresh
keys
you'll
see
that
right
here
this
test
now
appeared
so
now,
if
I
reject
it
here,
whatever
I'm
not
very
creative,
it
will
now
complete
the
the
workflow
this
workflow
yep,
because
it
is
set
to
wait
for
either
or
approvals
or
first
rejection.
So
in
that
case
the
outcome
is
reject
because
John
to
whom
it
was
really
signed,
decided
to
reject
the
task.
Okay,
so
all
right
so
I
mean
the
last
example.
G
I
would
like
to
show
you
was
about
how
to
create
this
kind
of
scenario
where
you
have
a
workflow
running
and
you
have
it
assigned
like
five
assignes
or
10
assignees,
but
you
want
to
complete
it
after
a
specific
quarter
of
of
responses
is
met.
That
is
the
same
as
we
used
to
have
in
SharePoint
workflows.
G
These
are
SharePoint
design
workflows
so
that
we
really
need
to
adjust
for
the
specific
percentage
of
approvals
to
be
collected,
and
that
is
basically
following
the
same
scenario
or
the
same
steps
as
I
showed
you
in
the
first
example.
The
only
difference
is
that
ISO
have
a
table
well
that,
in
this
scenario,
is
used
to
to
store
information
about
what
is
the
percentage
of
tasks
that
has
to
be.
G
That
has
to
be
made
so
that
the
whole
approval
is
collected,
and
then
you
can
imagine
that
there
is
a
workflow
which
is
being
triggered
every
time.
There
is
a
change
that
is
happening
inside
the
responses
table
and
it
is
simply
checking
if
the
number
of
responses
to
that
specific
approval
approval
process
is
already
equal
or
above
the
defined
port,
and
then,
if
it
is
above
the
quarter
or
equal
or
above
then
it
is
simply
following
the
same
scenario
as
in
the
first
example.
G
G
Thank
you
very
much
for
this
opportunity
to
showcase
this
and
I
really
think
this
has
a
very
much
of
the
potential
unless
we
are
given
some
cool
approvals,
API
that
we
can
that
we
can
just
do
it
out
of
box
what
I'm
showing
you
as
long
as
there
is
no
such
API,
then
well,
you
need
to
have
premium
licenses
and
and
take
it
from
here.
So
if
you
have
any
questions,
I'll
be
here
on
the
chat
to
answer
them
for
you.
B
Awesome,
thank
you.
Thomas
yeah,
a
lot
of
information
here.
Folks,
we
put
Thomas,
has
done
a
lot
of
videos
as
well,
so
you'll
find
that
link
in
the
chat,
don't
hesitate
to
take
a
look
there
and
we'll
have
him
back
again
to
talk
a
little
bit
more
about
it.
So
Hugo
maybe
give
us
a
little
overview
of
what
was
announced
last
week.
A
A
That's
not
what
we're
trying
to
do
we're
trying
to
make
it
easy
for
you
to
connect
to
your
data,
and
so
there's
a
few
things
that
are
available
here
and
we've
covered
some
of
these,
so
I'm
going
to
try
to
focus
on
what's
new.
So
we
have
that
new
fancy.
You
know
editing
Studio,
which
allows
you
to
view
the
navigation
and
edit
the
navigation,
and
you
can
actually
add
pages
from
there.
A
Once
you
add
pages,
let's
there
you
go,
let's
just
add
a
page
right,
you
can
add
a
page
and
you
can
pick
the
template
you
want.
You
can
pick
custom
templates
as
well,
but
once
you've
added
the
pages,
then
you'll
have
sections
in
your
page
and
you
can
actually
add
various
sections.
So,
let's
just
let
me
show
you
what
I'm
talking
about
here.
So
you
can
add
sections
to
the
page
and
the
sections
will
allow
you
to
control
things
like
the
layout
right.
A
So
how
many
columns
do
I
want
one
two,
three
columns:
one-third,
two-thirds,
spacer
and
stuff
for
that,
and
then
once
I
have
a
section
created.
So,
let's
just
add
one
then
I
can
actually
take
the
bunch
of
components
that
are
available
to
me
so
like
text
buttons
images
things
like
that,
but
wait.
If
you
order
now,
you
also
have
the
ability
to
select
some
additional
stuff
now,
a
little
secret
here,
or
maybe
it's
not
a
secret
you'll,
see.
There's
like
the
three
dots
on
the
right
there
right
there.
A
Actually
let
me
just
show
you
the
other
Pages,
where
you
go
faster
here
so
again
you
can
always
see
the
preview
of
the
content
of
the
page
and
that's
really
what
we
call.
What
you
see
is
what
you
get
right
and
this
whole
ability
to
preview,
the
stuff
that
you
are
doing
now.
Let's
see
if
I
can
show
you
this
super
quickly.
A
So
if
you
go
to
a
page,
you
can
actually
control
some
settings
of
the
page
right.
Then
we'll
skip
moving
stuff
into
navigation
stuff
that
but
in
the
page
settings
there's
one
thing
that
we
didn't
have
again
in
the
preview
that
we
want
to
show
you
now
is
that
you
have
the
ability
to
control
who
can
see
what
pages
and
based
on
what
roles
you've
created.
And
you
see
we
have
some
standard
roles
like
authenticated
users
and
administrators.
We
also
have
custom
roles.
A
You
can
create
custom
security
roles
so
that
you
can
control
again,
who
should
see
what
now
there's
also
the
styling
space
in
The
Styling
space.
We've
already
talked
about
the
styling
space,
where
it
allows
you
to
pick
themes
and
edit
themes
and
fonts
and
colors
and
stuff
like
that,
so
I'm
not
going
to
spend
too
much
time
on
that.
A
The
one
thing
that
is
really
cool
now
is
that
you
can
actually
go
into
the
styling
space
and
manage
your
cascading
style
sheet,
and
you
can
see
here
there's
already
three
bootstrap
style
sheets
that
are
applied
with
a
theme
and
a
portal
basic
theme.
You
can
upload
your
own
custom
style
sheet
again:
I'm,
not
expecting
makers
to
be.
You
know
who
are
just
getting
a
new
becoming
familiar
with.
You
know
CSS
and
JavaScript
and
HTML
to
do
that.
A
A
We
also
have
the
data
workspace
and
we've
talked
about
the
data
workspace
in
the
past.
But
you
know,
if,
for
those
of
you
who
are
familiar
with
dataverse,
we
can
do
the
same
stuff
that
we
would
go
in
a
dataverse.
You
know
environment,
Go,
create
tables,
and
things
like
that.
But
here
I
can
do
that
directly
from
within
the
data
workspace
to
control
what
data
I
want
to
show
within
my
website.
A
Let's
go
to
the
setup
workspace
in
a
setup.
Workspace,
we've
got
a
whole
bunch
of
options
that
we
can
do,
but
there's
a
few
things
I
wanted
to
show.
One
of
the
things
is
that
we
now
have
the
ability
from
here
to
be
able
to
do
things
like
custom
domains,
CNN
CDN,
sorry
for
faster
delivery
of
content,
IP
restrictions
and
things
like
that,
then
you
go
to
go
live
checklist
is
actually
a
checklist,
obviously
of
things
that
you
can
do
before.
Getting
ready
and
I'm
not
going
to
go
through
all
the
checklist.
A
I
just
want
to
show
you
something
else
really
cool
right
here.
So
we
have
the
ability
here
to
here
I'm
getting
just
customize
this
quickly
right
here
we
have
the
ability
to
create
Progressive
web
applications
from
from
the
site,
and
so
you
might
say,
what's
a
progressive
web
application.
Well,
if
you've
actually
used
Twitter
Uber,
you
know
what
else
Flipkart
and
so
on
and
so
forth.
You've
probably
used
a
progressive
web
application.
It's
a
website,
that's
hosted
as
an
app
all
right.
I've
got
like
what
two
minutes
left.
A
Let
me
see
if
I
can
wow
you
a
little
bit
with
this
new
cool
feature.
I
can
actually
go
to
a
page.
Now
and
let's
say
you
look
at
this
page
and
it's
like
yeah,
it
looks
kind
of
cool,
but
let
me
preview
it
and
it's
kind
of
boring
right.
It's
missing
some
fun
stuff.
I
want
to
do
some
animation.
I
want
to
do
something.
A
Well,
guess
what
now
we
have
the
ability
to
actually
use
Visual,
Studio
code
and
GitHub,
and
all
this
fun
stuff
to
integrate
I'm
going
to
go
to
a
cool
site
called
animista
and
animista
allows
me
to
find
animations
and
really,
if
you've
ever
ever
been
there
you'll
see
or
if
you
haven't
been
there,
you'll
see
how
awesome
it
is
so
animista.net
you
go
there.
You
pick
an
animation
that
suits
your
needs
and
then,
let's
see,
if
I
can
speed
this
up
a
little
bit.
A
It's
going
to
go
to
visual
studio
code
and
then
from
here
it's
going
to
actually
give
me
access
to
the
CSS,
the
JavaScript
and
the
HTML
for
that
page
and
I
have
full
control
over
that
right,
so
CSS
for
the
style
JavaScript
for
any
you
know,
code
logic,
that's
client-side
and,
of
course,
the
HTML
itself
and
then,
if
I
kind
of
I'm
going
to
kind
of
skip
this
a
little
bit
and
copy
I
copy.
The
code
that
I
just
pasted
from
my
animista
site
I'll
go
copy.
A
The
the
keyframes,
which
is
the
animation
from
CSS
and
then,
if
I,
go,
save
that
so
I
saved
that,
like
I,
would
normally
would
and
I
go
back
to
my
site.
I'm
gonna
get
something
that
looks
like
this
come
on.
You
can
do
it
there.
You
go
so
now.
I
go
back
in
sync
I
preview,
my
page
preview,
my
page.
It
knows
that
I'm
trying
to
speed
up
now.
A
That's
why
so
I'm
going
to
preview
my
page
quickly
and
when
I
can
preview,
it
you'll
see
that
that
fancy
animation
that
I
copied
and
pasted
from
admista
is
going
to
be
now
available.
So
when
I
Mouse
over
a
card
come
on
Mouse
over
a
card,
you
can
do
it
there.
You
go
Mouse
over
a
card.
I
have
that
subtle,
animation
that
I've
just
created.
So
again,
that
was
a
super
quick
tour
of
some
of
the
new
features
that
we
have
available
in
power.
Pages
power,
Pages
available.
A
B
Thank
you,
Hugo.
Let's
share
out
our
slides
and
wrap
this
up.
Thank
you
again
to
all
of
our
amazing
Community
presenters
and
Hugo
really
appreciate
it.
Let's
look
at
our
resources.
You
are
able
to
utilize
all
these
resources.
There
are
training
resources,
powerapps
community,
community,
Samples
videos
and
a
plenty,
so
don't
hesitate
to
take
advantage
of
those,
and
you
can
utilize
that
as
your
community,
we
want
you
to
get
more
involved
as
we
are
having
this
call.
There
are
many
more
calls
available
to
you.
B
The
Microsoft
365
platform
call
is
available
to
you
and
there
are
adaptive
cards.
Microsoft,
identity
platforms,
office,
add-ins,
Power,
Platform,
which
you
are
on
right
now
and
then
the
Microsoft
365
and
Power
Platform
development,
bi-weekly,
call
and
VB
connections.
You
can
access
all
these
calls
at
aka.ms
forward.
Slash
M365,
slash
calls
the
recording
will
be
available
for
this.
B
Within
about
24
hours
on
the
Microsoft
365
Community
YouTube
channel,
you
can
access
that
at
AKA,
dot,
Ms,
slash,
m365pnp,
slash,
videos
If,
you
subscribe,
you'll
be
the
first
to
know,
and
so
we
want
you
to
take
advantage
of
that.
You
will
not
be
able
to
download
it
from
the
team's
channel,
so
please
don't
try
it's
only
available
for
those
internal
to
Microsoft,
but
you
will
absolutely
be
able
to
get
it
from
the
YouTube
channel.