►
From YouTube: Design productivity apps with SharePoint lists and libraries, Power Apps, and Power Automate
Description
No-code and low-code apps have been essential in SharePoint for a long time. Additional tolls from the Power Platform - Power Apps and Power Automate - provide additional power and capability to build productivity using SharePoint lists as the data source. We also discuss the patterns to help transform customer solutions that still remain on-premises and/or in legacy tool sets like InfoPath, SharePoint Designer or Access Web Apps. Presented by Chakkaradeep "Chaks" Chandran.
Create a Power App for a list in SharePoint for Microsoft 365: https://support.microsoft.com/office/create-a-power-app-for-a-list-in-sharepoint-online-9338b2d2-67ac-4b81-8e67-97da27e5e9ab
Learn more about Microsoft 365: https://www.microsoft.com/microsoft-365
A
I'm
shocked
relieved
one
of
the
program
managers
in
onedrive
and
SharePoint
working
on
automating
business
processes
and
apps.
Today,
we're
gonna
talk
about
building
productivity,
apps
with
SharePoint
lists,
libraries,
power,
apps
and
power
automate,
as
you
know,
SharePoint
as
a
platform,
but
whereas
many
of
the
services
and
capabilities
in
Microsoft
365,
be
it
file
sharing
or
collaboration
or
building
your
intelligent
intranet
workplace
along
with
it.
We
also
have
different
capabilities,
such
as
search
ai
security,
also
forward
when
SharePoint
in
Microsoft
365.
A
In
that
regard,
Microsoft
lists
in
Microsoft
365
gives
users
a
tremendous
opportunity
to
build
apps
and
enhance
their
business
correctly.
Reading
Microsoft
lists
are
simple,
flexible
and
also
easy
to
share
and
collaborate
with
your
users,
not
only
that
with
Microsoft
lists,
you
can
easily
build
no
code
solutions
and
automate
business
processes
by
integrating
with
the
power
platform,
specifically
the
power
apps
empower
automate.
So
with
Microsoft
lists,
you
can
build
simple
to
complex
business
processes.
It
all
starts
with
the
continuum.
A
We
provide
a
lot
of
native
efficiency,
a
lot
of
features
out
of
the
box
that
helps
inducers
kickstart
lists
with
as
an
at
with
list.
You
can
create
a
blank
list
or
a
list
from
a
template
which
we
will
very
soon
look
at
it,
and
then
users
go
into
configuring
the
list
so
that
it
helps
stay,
productive
and
bring
users
together.
A
lot
of
configuration
options
available
for
end
users
to
quickly
configure
the
list,
the
way
they
want.
A
Citizen
developers
can
get
a
lot
of
benefit
from
the
integrations
we
have
at
our
platform
and
professional
developers
have
a
choice
for
choosing
the
common
data
service
as
their
back-end
to
build
custom
solutions
or
go
deeper
and
integrate
with
as
your
offerings
and
SharePoint
framework
and
Microsoft
graph
API
is
we
have
in
the
platform
as
well.
So
now,
let's
dive
deeper
into
what
each
of
those
pillars,
the
native
efficiency,
simple
configuration
and
integrated
solutions
offer.
So
with
native
efficiency,
Microsoft
lists,
there's
the
core
center
of
the
business
app
scenarios.
A
You
can
create
lists
from
lists
if
you
have
a
list
already
that
you
know
so
you
want
to
bring
the
data
structure
together
into
your
new
list,
or
you
can
also
create
a
list
from
an
excel
file.
Sometimes
we
use
Excel
a
lot
and
you
might
want
to
transfer
the
data
and
mention
it
in
a
list
and
we're
also
going
to
have
a
lot
of
prosperity
templates
available
pretty
soon
that
you
can
choose
a
template
instead
of
starting
from
scratch
and
along
with
it
now
in
Microsoft
365.
A
A
So
in
the
simple
forms
configuration
space
we
released
show/hide
and
we
are
a
few
months
back.
We're
gonna
follow
up
with
releasing
the
ability
for
you
to
conditionally
show
our
hide
fields
based
on
a
columns
value
and
along
with
it,
you're
able
to
also
configure
header,
footer
and
body
with
sections
in
a
form
and
I'm
happy
to
announce
a
new
feature
for
lists
called
roots
with
rules.
Users
can
create
quick
actions
based
on
if-then
conditions,
so
that
they
can
send
notifications
to
specific
people,
be
it
a
column,
value
or
a
specific
person.
A
Now
these
rules
are
triggered
based
on
when
column
value,
changes
or
column
changes
or
when
items
are
created
and
deleted.
So
let's
look
at
the
demo
of
how
to
conditionally
show
or
hide
columns
and
the
farms
configuration
and
also
dive
into
groups.
So
here's
a
Microsoft
list
app
where
I
have
a
list
of
conference
sessions
that
I
am
managing.
If
I
look
at
the
list
form
here,
and
you
will
see
that
I
have
customized
the
form
with
a
header,
the
body
has
multi
column,
support
and
I
also
have
a
Buddha
here.
A
That
tells
me
to
find
more
details
in
a
given
link.
So
this
was
possible
because
there
was
able
to
configure
the
form
with
the
JSON
properties
for
header,
footer
and
the
body.
Let's
go
look
at
how
to
do
that
so
I'm,
gonna
click
configure
layout
and
that's
gonna.
Take
me
to
a
place
where
I
can
configure
the
header,
footer
and
body
for
this
forum
and
also
preview.
My
changes,
if
you
look
here,
I,
have
the
option
to
select
header
body
and
footer
in
the
header.
A
I
have
here
the
JSON
that
represents
the
formatting
options
for
the
header.
This
is
the
same
formatting
options
that
you
are
familiar
with
configuring,
the
view
for
matters
and
column
format,
as
they
are
pretty
much
exactly
the
same.
So
with
the
knowledge
I
had
with
my
waveform
writers.
I
was
quickly
able
to
configure
the
header
for
this
list
form
as
well
as
if
I
know,
switch
to
party
well
body
does
not
give
you
the
robust,
customizations
and
configurations
you
want,
as
in
manipulating
the
attack
there,
it
does
give
you
few
options.
A
It
allows
you
to
put
sections
in
your
form
like,
for
example,
you
can
see
here
that
I
have
my
session
name
at
the
top,
but
then
I
have
some
of
the
fields
here
put
inside
the
section
details
and
then
I
have
a
section
for
speakers.
Then
I
have
a
section
for
location.
It
helps
me
to
easily
categorize
the
different
things.
I
want
for
users
to
quickly
relate
and
understand
when
they
are
working
with
the
list
form.
So
the
JSON
looks
really
simple.
A
Json
says:
I
have
a
display
name,
and
you
mean
the
fields
for
every
section
that
I
have
in
my
fault
and
finally,
I
have
the
footer
is
the
same
as
the
header
I
get
to
configure
the
day
of
the
way
I
want,
and
it's
again
similar
to
the
view
format.
Is
that
you're
very
familiar
with
it
uses
the
same
JSON
sent
back
the
same
JSON
expressions
so
with
that
I
can
now
add
a
footer
so
that
every
user
visiting
this
list
now
has
more
information,
just
not
the
form,
but
also
providing
some
valuable
information.
A
The
header,
footer
and
organizing
the
form
the
way
really
uses.
What
and
along
with
it
here's
another
feature
that
I
have
so
you
can
see.
I
have
speakers
and
I
have
notes.
So
now,
if
I
remove
michaela
at
the
speaker
and
just
add
some
other
user
as
a
speaker,
you
can
see
the
note
fields
disappeared,
right
and
as
soon
as
I
add
Makayla
back.
You
can
see
that
the
notes
field
comes
back.
This
is
the
conditional
show/hide
feature
that
I
was
talking
about
so
conditionally
show/hide
the
column.
A
It
is
available
in
the
same
place
where
you
go
in
it
call-ups.
If
you
go
to
edit
columns
in
your
list
where
you
will
see
a
lot
of
the
columns
are
available
so
that
you
can
hide
or
the
order
or
show
you
now
see,
it's
been
updated
with
many
few
features,
so
you
can
see
that
since
we
have
sections
in
the
body,
you
got
the
ability
to
rearrange
fields
inside
sections
and
not
only
that
you
can
see
here.
The
note
field
is
disabled.
A
You
can't
really
hide
the
visibility
of
the
notes
field
because
it's
now
controlled
by
a
conditional
formula
that
powers
the
show/hide
condition
feature.
So
if
I
click
on
this
dot
here,
I
get
edit
conditional
formula
when
I
click.
This
now
I
have
the
ability
to
put
my
formula.
There
was
a
game,
the
JSON
expression
that
we
are
very
familiar
with
formatting
fields
and
views.
A
So
here
I'm
saying,
if
my
speaker,
field,
dot
email
is
admin
in
this
case
Michaela,
then
it's
true,
meaning
that
the
field
will
show
up
else,
it's
false,
meaning
that
the
field
will
not
show
up.
It's
that
simple.
Now
you
can
click.
This
link
learn
to
use
condition
formulas
to
know
more
about
how
to
craft
these
expressions
quickly
for
various
field
types.
A
Microsoft
365
provides
tremendous
opportunities
by
integrating
with
Mike
the
power
platform,
so
starting
with
Microsoft
forms,
which
is
still
an
option
for
end-users
to
quickly
create
forms,
and
you
know
gathers
and
surveys,
and
you
can
then
extend
the
data
into
any
data
cells.
You
have
be
it
a
SharePoint
list
or
library
or
even
a
common
data
service
entity
that
you
might
be
interacted
with.
A
We
also
have
webparts
the
data,
entry
and
rissalah's
that
you
can
invert
in
your
intranet
and
get
users
submit
forms
so
as
users
enter
and
submit
data
in
these
forms,
or
any
other
input
form
that
you
might
have,
whether
it's
a
custom
or
the
Microsoft
form
or
a
SharePoint
list.
The
next
obvious
step
would
be
to
take
the
data
and
automate
to
do
some
processes
across
apps
and
data
power
automate
exactly
offers
you
the
tools
to
build,
workflows
and
automate
that
process.
A
So
power
automate
provides
a
lot
of
pre-built
templates
for
scenarios
like
approvals
data
collection,
reminders
and
whatnot,
and
connect
with
300
plus
services.
In
the
platform
you
want
to
connect
the
SharePoint,
you
have
the
SharePoint
connector.
You
want
to
connect
you
onedrive.
We
have
that
option
as
well
and
if
you
want
to
connect
your
to
your
on-premises
sequel
server
that
you
might
be
requiring
to
integrate
some
of
these
apps,
we
have
support
there
too,
and
from
there
we
extend
the
integration
options.
A
We
have
those
300
plus
data
source,
also
available
in
your
power,
app
to
connect
and
build,
and
you
know
power
the
app
that
you
want
with
your
organization.
So
Microsoft
power
platform
is
very
powerful,
as
its
name
suggests
provides
you
different
choose
for
different
scenarios,
building,
apps
and
custom
forms
in
SharePoint.
We
have
power
apps
for
Bill,
custom,
workflows
and
business
processes.
We
have
power
automate
and
to
analyze
and
drive
insights.
A
We
also
have
power
bi
and
if
you
look
at
the
Microsoft
365
ecosystem
and
Dynamics
365
ecosystem,
all
of
these
scenarios
are
powered
by
Microsoft
power
platform.
It
gives
you
a
very
good
leverage
to
use
these
in
your
solutions
that
you're
building
to
extend
listing
libraries
in
Microsoft
365.
So
let's
look
at
the
power
automate
integrations
and
SharePoint
mainly
for
automating
processes
across
absent
data.
So
we
have
several
features
with
power
automate
in
SharePoint.
We
have
out-of-the-box
flows
that
help
you
to
create
personal
reminders
for
add
a
column
in
your
list
or
a
library.
A
We
also
have
a
very
simple
approval:
workflow
called
request,
sign-off
that
any
user
can
use
in
SharePoint,
and
then
we
also
have
content
approval
support
for
those
features
that
require
governance
when
you
think
about
approval
lifecycle
for
documents
or
list
items
along
with
it.
We
also
have
page
approvals
for
requiring
approval
when
you
submit
a
page
for
publishing.
This
is
very
useful
in
an
intranet
scenario
or
even
in
a
hub
site
where
users
submit
news
or
post,
and
that
needs
to
be
moderated
for
further
publishing
action
for
hub
join
approvals.
A
Helps
you
to
easily
manage
your
hub
and
below
which
sites
you
want
to
get
associated
with
it's
very
helpful
for
site
owners
to
understand
who's,
requesting
to
join,
look
at
the
site
that
is
requesting
to
join
and
make
a
decision
quickly,
and
if
none
of
these
scenarios
are
able
to
help
you,
we
have
the
ability
to
create
your
own
flow
templates
and
and
build
your
custom
processes
and
workflows,
empower
automate
platform.
So
that
starts
with
interacting
with
many
connectors
available
in
the
power
platform.
A
So,
as
I
said
earlier,
there
are
more
than
300
plus
connectors
available,
and
one
of
them
is
SharePoint
connector,
as
you
might
have
guessed,
SharePoint
connector
allows
you
to
talk
to
the
SharePoint
lists
and
libraries
and
we
have
a
lot
of
complaints
available
to
get
you
started
if
you
go
to
the
power
automate
website
and
all
of
those
templates
have
predefined
actions
and
triggers
that
you
don't
have
to
think
about.
But
the
template
provides
you
those
options
to
get
you
started
so
SharePoint
Connect
was
very
powerful.
A
We
have
46
actions
and
pin
triggers
to
surface
a
lot
of
scenarios
that
you
might
be
thinking
about.
Customizing
that
business
process
you
have
in
your
organization,
so
what
is
new?
There
are
46
actions
and
10
triggers
like
that
seems
a
lot,
but
we
keep
pushing
updates.
So
we
can
make
this
platform
very
powerful
for
users
to
build
business
processes.
So
in
that
regard
we
have
support
for
folders.
This
was
one
of
the
top
tasks
in
the
user
voice
as
well
to
provide
good
folder
support.
A
So,
in
the
gate
items
action
we
have
the
ability
to
now
filter
items
based
on
a
folder
and
as
well
as
the
for
a
selected
item
trigger
that
supports,
triggering
the
flow
on
a
folder
and
the
same
for
a
selected
item
will
work
for
a
selected
file
as
well.
Now
we
also
have
support
for
lookup
columns
in
the
gate
item
actions
if
we
want
to
filter
using
all
data
queries
and
if
that
column
happens,
to
be
a
look
of
column
in
your
list.
A
A
Previously
we
only
supported
100
MB
file
size
when
you
use
to
create
files
from
flows,
but
now
the
chunk
upload
option
is
enabled
by
default
in
the
create
file
action,
so
you
can
even
upload
up
to
2gb
of
files
or
create
2gb
of
files.
In
your
workflows
with
design,
we
have
some
updated
experiences
when
running
close
and
SharePoint.
A
You
might
have
seen
those
design
updates
in
the
power
automate
website,
so
we
have
brought
the
same
in
SharePoint
as
well
now
coming
soon,
one
of
the
biggest
ask
from
customers
is
the
trigger
for
when
an
item
is
modified.
Today
we
have
the
trigger,
when
an
item
is
created
when
an
item
is
created
or
modified,
but
there
isn't
a
specific
trigger
that
helps
you
to
monitor
when
an
item
is
modified,
so
we're
bringing
that
very
soon
for
you
to
the
powerful
business
process.
A
When
item
modifications
or
file,
modifications
for
the
file
properties
happen
along
with
it,
we
also
get
get
changes
for
an
item
action
that
helps
you
to
query
that
change
and
understand
which
specific
fields
got
modified
in
that
process.
So
let's
look
at
the
Microsoft
power
and
apps
integration.
Now
so
with
power
apps,
you
can
easily
build
the
business,
apps,
standalone,
apps
or
even
customize
the
form
in
SharePoint.
We
provide
three
integration
options.
We
have
the
ability
to,
as
I've
said
earlier,
custom
forms.
A
So
if
you
have
a
list
form
and
the
simple
configuration
options,
do
not
give
you
that
power
to
extend
N
and
build
the
form
you
mean
we
have
integration
with
power
apps
to
take
that
experience
further
down
the
road
by
ability
to
customize
anything.
You
want
on
the
form
with
the
book
code
development
tool
and
we
also
have
the
ability
to
build
standalone.
Apps
connect
to
SharePoint
data
source,
as
you
were,
able
to
connect
in
your
in
your
power
automate
flow
to
the
SharePoint
triggers
and
actions.
A
We
have
similar
experience
in
the
power
apps
for
apps,
that
you
build
to
connect
and
interact
with
SharePoint
lists
and
library
data
and
finally,
we
have
the
power
apps
web
path.
So
with
the
power
apps
web
part,
you
can
now
embed
your
apps
inside
the
SharePoint
sites
and
provide
users
access
right
there,
where
they
come
and
live
every
day,
their
intranet
porins.
A
So
what
is
new
with
power
apps?
So,
as
you
saw
earlier
in
the
during
the
start
of
the
presentation,
one
of
the
things
we
talked
about
was
how
we
provide
the
native
efficiency
and
then
we
provide
the
simple
configuration
options
and
then
we
have
also
the
power
of
integrating
with
many
different
services
in
building
your
custom
solutions.
But
one
of
the
key
thing
we
focus
is:
how
do
we
drive
these
features
and
do
that
continue?
So
in
that
regard,
the
show
or
hide
columns
that
we
have
as
an
out-of-the-box
feature
available
for
inducers
to
configure.
A
I
talk
at
you
know
different
conferences,
the
performance
and
reliability
fixes,
you
know
are
always
a
key
for
us
to
keep
delivering
value,
and
that's
why
you
see
is
pushing
hard
on
making
the
experience,
performant
and
the
label,
and
and
and
this
you
know,
a
series
of
months.
We've
been
really
focused
on
improving
the
power
app
studio
to
be
really
fast
and
performant,
from
makers
to
quickly
build
apps
and
customize
props.
So
with
that,
let's
go
look
at
some
of
the
demos
folder
support
in
get
get
items.
A
Action
as
well
as
the
date
delegation
support
in
power
apps,
so
here's
a
library
where
I
have
folders
and
document
sets
and
each
folder
and
document
set
have
a
set
of
documents
inside
in
a
typical
Enterprise
scenario.
Many
customers
want
to
automate
so
that
an
approval
is
sent
for
all
of
these
documents
together
instead
of
selecting
every
document
and
then
sending
an
approval,
and
that's
where
the
folders
support
scenario
comes
into
play
right.
A
So
previously,
when
I
selected
a
document
said
or
a
folder,
I
did
not
have
the
automated
command,
but
now,
with
the
support
for
folders,
we
can
now
go
dive
deeper
into
the
scenario
such
a
way
that
I
can
allow
a
user
to
select
a
document
set
or
a
folder
and
then
go
to
automate
and
see
the
custom
approval
flow
that
I
have
both
my
organization.
So
here
is
a
request.
Approval
flow
that
I
built
for
this
particular
library.
A
So
I
can
go
back
now
and
this
flow.
As
you
see,
it
is
asking
me
to
enter
an
approval,
so
I'm
going
to
enter
Nestor
and
then
hit
run
flow.
So
now
that's
going
to
go
and
one
my
flow
and
what
this
flow
is
going
to
do
is.
It
is
going
to
quickly
send
a
team's
message
for
mr.
as
soon
as
I
get
in
here
there
you
go.
I
got
a
message
from
Nestor
and
you
can
see
that
it
is
sending
me
hey.
A
You
have
the
following
documents
to
approve
and
you
can
see
every
document
inside
the
document
said
that
I
had
so,
for
example,
contoso
electronics.
Do
you
open
Miami
store?
Well,
that's
that's
a
that's
some
news
right
there.
You
can
see
that
if
I
go
into
my
market
promotions,
I
have
that
a
document
here
so
just
to
make
sure
that
the
documents
we
are
seeing
are
indeed
from
inside
the
document
set
right
so
now
I
can
go,
they
don't
approve
or
reject.
So
let's
go
approve
this
request
and
now
the
flow
is
going
to
say.
A
Oh,
the
request
is
approved
so
I'm
going
to
update
the
channel
right.
So
now,
if
I
go
to
my
channel,
which
is
here
and
right
now,
I
got
the
message
that
Nestor
just
approved
the
following
documents
and
I
can
also
click
view
document
see
if
I
have
to
go
view
that
particular
folder.
So
this
is
really
nice
value
right.
So
now
you
can
good.
A
Will
I
really
go
to
the
documents
said
all
the
folder
selected
requests,
the
approval
flow
or
any
other
flow
that
you
have
built
and
iterate
through
all
of
the
documents
in
one
set
and
then
send
it
to
user
for
approval,
rather
than
ten
of
who
was
a
twenty
approval
that
you
might
get.
So
how
did
we
build
this
flow?
Let's
go
look
at
this
flow,
so
here
is
the
flow
right
here.
So
it
starts
with
the
trigger
right.
So
we
have
for
us.
A
So
that's
great
so
for
a
selected
file
trigger
and
then
I
got
the
profile
and
then
I
also
get
file
properties.
Now
I
need
to
understand
whether
this
is
a
folder
or
a
file,
and
in
order
to
do
that,
I
need
to
query
the
the
properties
of
the
file,
so
I
use
the
action,
get
file
properties
and
pass
in
the
ID
I
get
from
the
trigger.
A
Now,
let's
come
back
to
this
initialize
variable
later
now,
I
can
quickly
check
if
it's
a
folder
or
not
so
here,
I
use
the
property
is
folder
when
I
check,
for
this
is
folder
dynamic
property.
You
can
see
that
it
is
coming
out
of
the
gate.
File
properties,
so
I
can
quickly
say
is
its
folder.
It
is
equal
to
true.
A
Well,
if
it's
true,
then
it's
a
folder
so
now
I
can
enumerate
the
files
inside
that
folder,
so
I
use
the
get
files
operation
which
basically
enumerates
and
use
the
properties
rather
than
the
content,
and
that's
why
it
has
properties
only
in
its
name.
So
now
I
can
enumerate
the
photos
so
I
use
the
same,
get
files
option,
sorry
action
and
you
can
see
I
can
limit
entries
to
a
specific
folder
right.
That's
pretty
neat!
A
Now
I,
don't
have
to
create
all
the
documents
and
then
verify
which
one's
belong
to
this
folder,
which
is
how
customers
were
able
to
do
this.
But
now
we
made
it
much
simpler
to
limit
the
increase
to
specific
folder
and
the
full
path
of
the
folder.
Well,
that's
coming
from,
as
you
might
have
guessed,
the
properties
action
right
to
get
file
properties.
A
So
now
what
I
can
do
I
have
a
collection
of
files,
I
use
the
apply
to
each
and
iterate
through
the
file,
so
I
can
build
a
bulleted
list
of
the
files
with
that
URLs.
So
I
can
click
on
it
and
view
the
file
as
well.
To
do
that,
I
use
a
pretty
good
trick:
I
initialize
a
string
variable
and
then
I
in
the
apply
to
each
I.
A
Basically,
you
know
create
the
bulleted
list,
which
is,
and
then
the
markdown
syntax,
that
I
can
use
in
my
approval
action,
which
is
where
I
now
get
to
put
the
name
of
the
file,
as
well
as
the
link
of
the
item
and
then
I
create
my
approval
right.
So
I
get
to
choose
what
the
approval,
type
and
I
also
have
this
approver
from
the
inputs
in
the
trigger
and
then
I
say:
hey
the
following
document:
the
curator
of
Google
and
I
put
the
string
value
here.
A
The
string
value
using
space
which
in
markdown
will
create
a
bulleted
list
and
then
I
post
the
adaptive
card
that
I
get
from
this
approval
to
the
team's
user,
which
is
the
approval
right.
So
I
use
the
Microsoft,
Deans
connector
and
use
the
adaptive
card
as
flow
bot.
Action
to
post
my
own
adaptive
card,
which
here
in
this
case
the
approval
and
then
I,
wait
for
an
approval
to
see
what
happens.
The
user
clicks
approve
or
the
user
clicks
reject.
Meanwhile,
I
also
use
different
actions
to
create
the
other
set
of
files.
A
I
need
in
order
to
send
send
more
information,
or
you
know,
craft
the
way
or
how
I
want,
in
this
case,
I'm
using
the
Select
operation
and
basically
creating
an
adaptive
card
syntax
that
I
can
post
to
themes
which
you
will
see
later
and
we'll
come
back
to
this
action
at
that
point.
So
when
the
request
is
approved,
I
post
my
owner
active
card
as
flow
bar
to
a
channel,
but
here
you
can
see
that
I
actually
have
an
adaptive
card.
Syntax
right.
This
is
not
something
I
get
from
a
plural
act
action.
A
This
is
my
own
adaptive
card
that
I'd
built
in
the
adaptive
card
designer
now,
if
you
are
familiar
with
that,
you
can
quickly
build
that,
and
one
of
the
things
here
I
have
is
the
items
right
so
in
order
to
get
that
items
list.
That
is
what
I'm
doing
previously
by
selecting
all
of
the
items
and
making
them
in
the
JSON
syntax
I
want
that
is
capable
adaptable
to
the
adaptive
card
and
then
I
joined
them
using
a
comma
right.
So
come
output.
Make
sure
that
it's
it's
a
it's
a
comma
separated
list
item.
A
A
So
that's
pretty
much
my
flow,
it's
very
simple,
I'm
able
to
use
the
same
trigger
and
familiar
with,
and
then
I
use
the
profile
to
get
profile,
username
and
whatnot,
and
then
I
can
use
get
file
properties
to
check
if
the
selected
file
that
user
operated
on
was
a
folder
or
just
a
file.
If
it's
folder
I
can
go,
do
everything
that
I
want
to
do
by
enumerating
those
files
and
then
applying
my
business
process
to
it.
So
that's
it
flow.
How
you
can
now
get
folder
support
in
your
business
process?
A
So
here
is
the
power
app
that
I
built
and
connect
it
to
my
SharePoint
list,
and
you
can
see
I
have
the
option
here
where
I
can
filter
items
for
this
gallery,
control
that
and
use
it.
But
if
all
when
you
connect
SharePoint,
when
you
connect
up
our
apps
to
a
SharePoint
data
source,
especially
a
list,
you
get
a
ready
to
go
app
that
you
can
immediately
publish,
but
you
might
want
to
do
some
changes
right,
which
is
you
might
want
to
filter
them,
maybe
for
specific
dates,
filters
that
you
might
have
in
this
case.
A
You
can
see
that
I'm
filtering
the
start
time
for
specific
months
right
and
and
filtering
the
data
out
instead
of
showing
thousands
of
rows
or
even
you
know,
just
even
50
rows,
which
would
just
be
more
for
users
to
consume.
So
you
can,
you
can
now
use
the
date/time
delegation
to
you,
know,
connect
to
their
list
and
then
filter
items
based
on
date,
values.
A
So
we
get
April
all
the
items
between
April
and
June.
So
that's
exactly
what
we
get
here
in
our
filter
items.
You
can
see
the
date
I
have
right
now.
If
I
change
this
date.
Let's
say
we
change
this
date
to
October
right,
so
you
can
see
that
the
list
will
now
refresh
and
bring
in
the
items
until
October,
so
that
how
you
can
that's
how
you
can
now
use
date/time
fields
and
delegate
this
operation
to
get
executed
in
the
survey
and,
if
you've
noticed,
we
don't
get
any
errors
or
warnings
for
this
column.
A
So
this
feature
will
be
available
soon
to
all
in
the
next
few
weeks.
If
you
use
it
today,
you'll
see
a
blue
color
underlined
on
this
column,
where
it
will
say
a
delegation
warning,
but
once
this
feature
is
available,
you
have
to
edit
your
app
and
you
happy
refresh
the
data
source
and
that
delegation
warning
will
go
away
and
the
your
app
we
start
using
this
feature
so
that
it
sends
the
request
to
SharePoint
get
executed
and
it
just
brings
those
values
back
in
this
case.
A
A
You
do
on
a
list
so
now
that
we
have
seen
a
lot
of
updates
coming
up
in
out-of-the-box,
Microsoft
lists
and
power,
automate
and
power
apps
it's
time
to
go
back
and
look
at
some
of
the
classic
solutions
we
have
built
in
this
world
right,
so
some
of
the
classic
solutions
that
you
might
remember
and
still
be
using
the
classic
workflows
and
InfoPath
designer,
so
the
classic
workflows
and
InfoPath
designer
are
soon
to
be
retired.
So
the
power
platform
is
the
future
and
pretty
much
it's
not
the
pitch.
It's
what's
happening
right
now.
A
So
you
can
go,
build
your
own
connector
and
connect
these
data
sources.
So
it's
the
platform
that
we
recommend
customers
today
that
are
looking
to
build
custom
process
and
to
look
at
Power
Platform
and
really
come
out
of
the
classic
clothes
an
improper
world
because
of
all
of
the
features
that
we
are
pushing
and
innovating
in
the
Power
Platform.
With
that
I
think
it's
very
important
to
ask.
How
do
I
know
my
tenant?
Are
my
users
in
my
organization
are
using
workflows
and
InfoPath?
That's
great!
A
That
power
platform
is
what
that
we
should
be
looking
at.
But
how
do
I,
as
an
organization,
understand
what
is
going
on?
So
we
have
a
tool
called
modernization:
scanner
in
Microsoft,
PNP
project
that
allows
you
to
scan
your
organization,
whether
it
be
a
business
unit
or
site
or
even
web,
that
you
might
have
in
your
classic
world
and
understand
and
get
an
inventory
of
all
of
the
classic
workflows,
2010
and
2013,
and
the
InfoPath
forms
being
a
claim
form.
Our
library
customized
form
that
you
might
have
on
lists.
A
Customized
form
you
might
have,
and
it
gives
you
a
detailed
analysis
of
those
which
ones
are
active,
which
ones
haven't
been
active
for
a
while.
So
you
can
make
a
decision
and
also
for
the
workflows
it
gives
you
an
upgrade
ability,
score
of
how
those
workflows
would
perform,
and
if
you
want
to
look
at
them
building
it
empower
automate
flows.
A
So
with
that
I
think
we
have
really
simple
three
steps
to
go:
follow
up
right,
scan
your
channel
for
workflows
and
forms
triage.
The
active
and
inactive
inventories
right.
Maybe
you
might
want
to
quickly
connect
with
the
site
collection
owner
from
the
SharePoint
admin
portal.
When
you
do
find
some
of
the
workflows
are
active
and
then,
if
they're,
not
inactive,
you
know
start
the
conversation
or
hey
you.
Do
those
workflows
and
forms
make
sense?
If
not,
can
we
you
know,
remove
them
from
the
service
or
can
we
can
we
have
them?
A
You
know
check
for
users
if
they
really
want
to
keep
that
in
the
in
the
in
the
site
and
finally
understand
when
would
be
the
right
time
to
turn
off
SharePoint
were
closed
and
InfoPath.
We
have
those
options
as
a
tenant
admin
that
can
use
and
turn
off
these
for
that
channel.
So
there
would
be
a
good
option,
so
you
can
start
the
bleeding
and
users
move
towards
the
modern
platforms
and
get
the
benefit
both
from
organization
perspective
and
even
from
governance
and
other
benefits
that
those
platforms
provide
so
you're,
not
alone.