►
Description
This PnP community demo is taken from the bi-weekly SharePoint Developer Community - General Development Special Interest Group (SIG) call recorded on February 20, 2020.
In this 16-minute video, Erwin van Hunen delivers a step-by-step on using PnP PowerShell in the new Windows Terminal to create and populate a custom list (GenericList) on a targeted site. After Erwin creates a list, he then adds columns, declares column types, reorders columns, then adds items to the new list. See how to apply json row and column formatting samples into your list via PowerShell variables. Finally, Erwin shows viewers how to move (copy) a single list (with all formatting) from one site to another including the list's content.
Demo Presenter: Erwin van Hunen (Valo Intranet) | @erwinvanhunen
Supporting materials:
• PnP PowerShell | https://aka.ms/sppnp-PowerShell
All SharePoint PnP Developer Community demos: https://www.youtube.com/playlist?list=PLR9nK3mnD-OWSbg0o9a7mx_E7s2u7h_o2
Learn more about the SharePoint developer community at: http://aka.ms/sppnp.
A
Least
customization,
so
it's
a
it's.
A
relatively
basic
story
come
to
tell,
but
it's
always
good
to
to
reiterate
or
to
reshow
you
to
refresh
your
brain
and
show
you
also
a
bit
of
how
you
can
use
death
in
amazing
demos
that
Kris
is
making
and
how
to
actually
apply
them
to
your
site
without
using
the
user
interface.
So
the
idea
is
that
I
will
obviously
use
pimpy
PowerShell
I
have
to
the
window
open
on
my
screen.
If
you
haven't
checked
it
out
yet
this
is
the
new
Windows
terminal
or
Microsoft
terminal
I.
A
Think
it's
called
I
strongly
recommend
that
it's
actually
a
much
better
experience
compared
to
all
the
other
PowerShell
environments
and
not
only
PowerShell.
This
also
runs
the
command
prompt
and
Linux,
even
if
you
want
to
so
that
was
a
little
sidetrack,
so
I
am
connected
to
my
site.
The
site
is,
is
hovering
here
behind
me,
standard,
empty,
SharePoint,
site
and
I
will
start
to
create
first,
my
list
and
for
that
I
use
the
command
which
new
pinpin
list
I,
give
it
a
title.
A
I
say
projects
and
I
wanted
on
the
quick
launch
and
the
template
is
a
generic
list
so
because
we're
using
the
api's
behind
the
scenes
in
the
user
interface,
you
will
see
this
called
a
custom
list
in
the
API,
so
it's
called
generic
list.
That's
why
there
is
generic
list
here,
press
ENTER
and
it
will
create
a
site.
You
don't
have
to
specify.
The
URL
is
what
we
do
defaults
to
each
less
lists
and
then
the
name
of
the
of
the
list.
A
So
if
I
reload
this
page,
there
should
be
my
projects
here
and
I
should
have
called
the
project
project
now.
I
want
to
add
a
field
to
it.
So
that's
the
fields
to
my
list
project
that
I
just
traded
as
long
as
you
don't
have
any
spaces
in
your
title.
You
don't
have
to
put
quotes
around
it.
So
just
if
the
name
is
just
without
spaces
just
enter
the
name
of
the
the
list.
Here,
then
the
display
name
of
the
field
will
be
a
project
name.
A
You
see
that
I
put
a
space
in
the
display
name,
so
I
prefer
surrounded
and
then
say
my
internal
name
is
project
linked
with
outer
space
and
the
type
of
the
field
text.
Presenter
pants.
The
field
is
being
added
to
the
list.
Now,
if
I
reload
this
page
now,
you
will
see
that
the
list,
the
field
is
not
part
of
my
human.
A
So
if
I
do
get
pimpy
view
and
at
once
name
of
the
list
project,
you
see
this
basically
on
one
view
and
it
this
one
is
called
all
items
the
one
we
actually
are
looking
at
right
now,
so
that
one
I
will
use
so
set
pimpy
view,
I'm
updating
the
view.
I
say
the
least:
project
identity
of
the
view
is
all
items
and
then
I
say
which
fields
do
I
want
in
there.
A
So
I
want
the
title
field
in
there
and
the
project
name
field
in
there
and
press
ENTER,
and
now
my
field
has
been
added
to
this
view.
If
I
reload,
you
see
in
the
title
and
the
project
name
field
enter
now,
this
is
a
to
commence.
I
did.
Obviously
there
is
a
way
of
doing
it,
actually
a
bit
easier.
So
if
I
go
back
in
my
history
at
PP
field
now
I
say
not
project
name,
that's
a
project
manager,
I'm,
editing,
adding
another
filthier
project
manager.
A
There
is
an
option
saying
add
to
default
view
presenter
every
Lotus
there's
my
project
manager.
If
I'm
not
happy
with
the
order
of
these
columns,
say
I
want
to
move
the
project
management
before
the
project
name
field.
I
can
also
use
the
set
PT
field.
View
functionality
so
say:
I
want
to
put
project
manager
in
front
of
it.
Then
I
change
the
order
of
this
list
of
fields.
Here,
I
say
here:
project
manager
goes
before
the
project
name.
A
Reload
and
now
project
manager
is
standing
before
project
name,
so
that's
a
very
simple
way
of
creating
at
least
adding
Collins
to
it,
and
we
support
basically
all
tall
column
types
here
now.
Let
me
for,
for
demo
reasons,
add
a
couple
of
items
to
this
to
decide
to
this
list
and
a
nice
simple
way
of
actually
adding
items
is
like
say:
I
want
to
have
three
items
called
a
title:
a
B
and
C.
So
a
a.
A
B
C:
this
is
an
array
typing.
That's
you!
This
is
a
shortcut
for
for
each
for
each
object,
for
each
object
is
and
PowerShell
commands,
but
you
can
use
the
shortcut
percent
and
then
I
say,
add,
being
paid
list
item
to
the
list
project
and
then
I
set
a
value
of
the
title
field
equals
to,
and
then
the
dollar
equals
and
I
realize
there's
this
pin
P
parish
and
logo
there.
So
hopefully
you
can
see
it
today
and
this
dollar
underscore
reflects
to
the
current
item
I'm
processing.
A
So
it
goes
for
first
a
then
B,
then
C
and
in
the
first
time
it
will
be
eight
second
time
it
will
be
the
third
time
to.
Let
me
see
so,
risen
closing
this
one
and
then
I'm
closing
the
for
each
loop
there
that
pump,
I
close
it
press
ENTER,
creates
a
creates,
be
great
see
you
see
that
the
UI
is
already
by
a
discrete
updating
here,
let's
force
it
there's
my
three
items
here
so
there's
a
very
easy
way
to
yeah.
Add
a
couple
of
test
items
to
two
of
these
thing.
A
You
can
officially
set
multiple
columns
in
in
one
go.
If
you
want
to
do
that,
like
that
now,
Chris
showed
his
alternates
row
formatting
things
so
if
I,
for
instance,
go
to
a
list
that
I
already
have
here,
this
has
bolts.
Let's
go
formatting
applied
to
the
view
say:
go
to
format
current
view
and
I
just
copy,
this
wonderful,
readable,
Jason
out
of
it
and
have
it
copied
in
my
clipboard
right
now.
So
I
want
to
use
that
one
in
PowerShell.
A
So
now,
if
I
just
enter
this
one
on
an
empty
line,
I
press
ENTER-
you
can
see
that
my
Jason
is
outfitted
Saudi
Jason
that
I
copied
to
my
clipboard
is
now
part
of
this
is
now
in
store
it
in
that
variable.
So
now,
I
will
update
I
go
back
to
my
project
list
here
and
I.
Do
another
time
get
P
in
P
view
should
do
list?
Can
I
specified
it
directly,
so
I
want
to
get
hold
of
that
I
want
to
update
this
view.
Do
all
items,
so
what
I
will
do?
A
I
will
put
it
into
a
variable
because
I
can
also
specify
identity.
So
now
I
will
only
retrieve
the
old
items
view
and
put
it
into
the
variable
view.
So
there
we
have
that
view.
Now
what
you
can
do
in
Flower
Show,
you
can
say:
okay,
listen,
PowerShell.
What
kind
of
properties
does
this
object
have
and
if
I
do
get
memories
here,
whole
list
of
properties
here
and
one
of
them?
A
A
So
what
I
will
do
now
is
I
will
update
my
view
and
add
that's
Jason
farm,
and
that
can
be,
of
course,
any
formatter
for
any
of
you
into
my
of
update
my
view
with
that
Jason,
so
I
can
be
using
the
set
pinkey
view
commandlets
this
project
based
project,
identity,
all
items,
values
and
then
I,
say:
custom
formatter,
oh,
so
now
you
would
be
tempted
to
write
Jason
here.
If
I
do
that,
it
will
actually
go
wrong.
The
command
with
has
a
tries
to
actually
take
this
as
an
object
and
goes
wrong.
A
It
needs
a
string
so
we're
going
to
force
it
to
a
string.
So
in
PowerShell,
if
you
write
something
like
this,
it
will
force
it
as
a
string
and
we'll
take
the
value
of
this
variable
and
put
it
into
these
quotes
here.
So,
if
I
press
ENTER
now
the
view
has
been
updated
and
if
a
reverse
refresh
this
view,
you
will
see
that
it
has
all
sense
from
formatting.
So
this
is
a
very
simple
way
of
actually
getting
those
JSON
files
out
there.
A
So,
basically,
the
easiest
way,
if
you
want
to
play
around
with
the
samples
that
Chris
made
is
basically
get
a
copy
of
that
we
post
tree
in
your
file
system,
create
the
lists
navigate
to
the
folder
and
use
these
command
lists
to
very
simply
apply
these
JSON
files
to
your
list
and
just
play
around
with
them,
see
what
they
do.
Instead
of
like
opening
the
file
copying
the
contents
pasting
it
etc.
You
can,
of
course,
also
get
hold
of
an
existing
list.
A
An
existing
view
take
the
value
of
this
custom,
formatted
property,
put
it
into
a
variable
and
then
apply
to
another
list
and
another
way.
If
you
want
to
do
a
column
for
matter,
it's
the
same
idea.
So
if
you
have
a
field,
the
field
also
has
a
custom
format,
a
property,
just
your
updated
field
that
you
set
the
custom,
formatter
property
to
that
value,
and
it
will
use
that
custom
formatter
for
that
fields.
So
there's
a
very
simple
way
of
getting
data
out
of
there.
The
last
thing
I
want
to
show
is
an
little
tip.
A
If
you
want
to
move
a
list
from
one
side
to
another,
be
just
a
single
list
and
nothing
else,
there
is
actually
a
relatively
easy
way
for
you
to
export
a
list
to
a
provisioning
template
and
just
at
that
specific
list,
and
that
is
exports
PNP
list
to
provisioning
template.
So
if
I
say
what
is
my
list
called,
this
is
called
project
and
I
want
to
output
it
to
my
list.
Xml
install
engine
behind
the
scenes,
but
it
will
only
do
that
specific
list
that
you
specified
in
this
case
the
project
list.
A
So
we'll
take
a
bit
so
much
done
there
we
go
and
if
I
open
this
image
to
the
code,
you
see
the
list
here
and
here
you
see
actually
the
casting
for
matter
with
the
Jason
that
we
just
applied
to
that
list.
So
this
is
just
the
just
that
single
list
in
there.
So
this
is
a
very
easy
way
of
like
getting
me
the
whole
list
and
move
the
whole
list
with
all
the
columns
and
formatting
and
everything
over
from
one
side
to
the
other
or
make
a
copy
of
the
list.
A
B
A
Okay,
you
want
to
copy
a
list
with
content.
This
is
the
the
provisioning
engine
allows
you
to
export,
but
then
you
will
have
to
fool
engine
note:
these
exports
commandlets.
Here
we
have
the
full
engine.
We
allow
you
to
specify
and
a
list
and
include
its
content
based
on
a
camel
query
that
you
can
say:
oh
or
you
can
define
a
chemical.
It
goes
a
bit
too
far
right
now
to
actually
go
you
through
how
to
set
it
up,
but
there
is
a
way
of
doing
it
in
and.
B
I
think
we
have
a
demo
actually
on
that
one
from
autumn
in
in
the
YouTube
channel,
so
you
should
be
able
to
find
out
I
think
we
showed
the
configuration
files
on
all
time
and
also
one
question.
Sorry
Earvin
there
and
Ramprasad
is
asking
a
how
system
recognize
where
the
list
to
be
created
with
site
without
the
site.
Url
parameter
you
yes,.
A
The
pimpy
partial
command
is
always
work
on
the
context
of
a
single
site,
so
you
do
get
connect
pimpy
online
URL
and
then
this
is
the
realm
of
your
site.
So
in
this
case
it
was
sharepoint
those
columns
where
science,
1001
and
then
I
connected
a
specific
site.
You
see
that
in
my
prompt
here
this
is
my
tenant
name.
This
is
I'm
connected
to
and
then
that's
how
I
can
see
where
I
am
and
that's
how
the
commander's
know
where
the
list
is
being
applied.
Jim.
B
The
last
question
from
Mike,
and
then
we
go
to
the
ACS
screen-
I
missed
the
beginning,
so
apologize
does
this,
require
shipment
admin,
privileges
or
our
site.
Admin.
Ok
question!
Ok!
Yes,
because
the
BMP
publisher
doesn't
connect
at
a
tenant
admin
site.
It
connects
to
the
actual
site
as
long
as
we
have
the
permission
to
the
site-
collection,
yeah,
you're
good,
to
go
to
operate
within
a
site
collection.
Yes,
so
it's
a
slightly
different,
let's
say
approach,
then
with
the
tenant
at
me
to
be
fair,
just
to
be
super
clear.
B
A
See
if
it's
a
tenant,
recycle
bin
item
the
well
most
of
them
actually
have
to
work
sanity
in
them,
I
would
say
the
biggest
giveaway
and
the
right
now
that's
interesting.
Actually
I
was
that
dropped
off.
We
have
to
check
that,
but
there
should
be
mentioning
that
it
requires
that
you
need
tenant
level
access
to
execute
these
commands
and
then.
B
They
say
still
follow
up
on
the
question,
so
the
site
owner
is
not
sufficient.
You
have
to
be.
If
you
operate
on
a
site
collection
level,
you
need
to
be
a
site,
collection,
administrator
and
now
the
contribute
permission
is
not
necessarily
sufficient
because
some
of
the
powers
or
commandments
or
the
behind
of
the
sense
the
code
actually
operates
potential
inside
collection
level
as
well.