►
From YouTube: Dataverse Dataflows as a sync mechanism
Description
In this 15-minute citizen developer-focused demo, Eickhel Mendoza relates how Power Apps Dataverse Dataflows – a Power Platform tool is used to connect to services and get information to Dataverse. Learn about connectivity to services, ETL capabilities using Power Query, accessing multiple data sources from one solution, and using a merge query to sync data without duplicates. See creating a Dataflow, taking information from SharePoint, transforming and mapping it, and inserting it in a Dataflows table. This PnP Community demo is taken from the Microsoft Power Platform community call – October 2022, recorded on October 19, 2022.
Demo Presenter
• Eickhel Mendoza (Intelequia Technologies) | @eickhel
Supporting materials
• Documentation - Create and use dataflows in Power Apps | https://learn.microsoft.com/power-apps/maker/data-platform/create-and-use-dataflows
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
A
B
Mendoza
I'm
a
business
applications
MVP
and
also
the
business
apps
team
lead
at
intellectual
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
a
good
book
implies,
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.
B
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
that
reverse.
As
you
can
see,
we
have
a
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
flows
to
extract
that
information
into
dataverse.
B
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
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
Data
flows.
You
can
find
it
here
under
dataverse.
You
can
go
to
data
flows
and
you
will
be
presented
with
this
screen
here.
B
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
dataflow.
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?
B
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,
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
are
getting
this
data,
we
can
get
from
folders
in
this
in
this
in
this.
B
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.
B
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.
B
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're
having
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.
B
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.
B
It's
a
great
opportunity
to
so
you
can
handle
all
the
information
I
don't
want
a
customers
from
a
I,
don't
know
from
one
a
particular
location
or
I.
Don't
want
a
only
this
type
of
data
or
or
on
this.
This
time
range.
Okay.
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.
B
Okay,
so
it
allows
you
to
build
some
a
Transformations.
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
to
dataverse
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.
B
B
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
we're
going
to
do
right
now
or
automatically,
you
can
set
a
frequency
based
on
days,
minutes
numbers
or
a
specific
day
or
times
for
this
example.
B
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.
B
Everything
went
well
with
the
data
coming
from
the
serpent
to
that
soon
from
that
from
SharePoint
to
dataverse,
and
it's
now
a
refreshing,
the
data.
If
everything
goes
as
expected,
where
should
be
seeing
and
limited
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.
B
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.
B
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
show
you
how
to?
How
can
we
do
this?
We
can
first
get
new
data.
B
We
are
creating
a
new,
a
new
query
here:
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.
B
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.
B
B
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
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?
B
B
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
the
verse.
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.
B
Setting
and
set
do
not
load
I,
don't
want
the
data
from
the
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
device.
If
I
click
again,
it
will
see
that
data
already
existed
into
the
version.
B
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
just
let
you
know
that
the
power
query
accepts
information
even
from
URLs
from
apis.
That
show
you
a
complex
information.
B
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.