►
Description
In this 17-minute developer focused demo, André Lage uses JSON formatting to transform an out-of-box discussion board to next level robust discussion view. Add menu with support features (permission checker, default editing, comments & responses to post), add a custom discussion board timeline view, support information lookup (discussion answers list), and add voting with Emoji’s. leverages existing capabilities – SharePoint page, filter web parts, Microsoft Power Automate (declarative JSON for Flow), and Microsoft Teams. Uses code from 3 PnP samples.
This PnP Community demo is taken from the General Microsoft 365 Developer community call recorded on May 12, 2022.
Demo Presenter
• André Lage (Datalynx AG) | @aaclage
Supporting materials
• Sample - discussion board format | https://github.com/pnp/List-Formatting/tree/master/view-samples/discussion-board-format
• Sample - Calculator sample | https://github.com/pnp/List-Formatting/tree/master/column-samples/generic-calculator
• Sample - Percent chart format | https://github.com/pnp/List-Formatting/tree/master/view-samples/percent-chart-format
• Samples - List Formatting Samples | aka.ms/list-formatting
• Demo - List formatting magic - Discussion board formatting - André Lage (Datalynx AG) | @aaclage
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 - http://aka.ms/m365pnp
A
A
Like
I
told
last
the
last
presentation,
I
talk
about
the
the
boarding
and
today
I
want
to
have
a
discussion
regarding
the
discussion
board
we
and
how
we
can
formatting
that
we
can
easily
identify
and
work
itself.
So
I
started
with
like
I
did
until
the
last
time.
We
do
some
consulting
approach.
We
try
to
make
the
the
five
main
questions.
What
when?
Why?
Who
and
we
try
to
answer
all
these
questions
itself,
and
for
that
we
make
some
analysis.
What
is
out
there?
A
We
I
make
some
identification,
what
is
with
the
old
discussion
board
list
that
was
provided
and
also
try
to
identify
other
discussion
boards,
for
example
in
github
and
other
other
services
that
is
around
there
and
try
to
adapt
what
could
fit
for,
in
this
case,
my
own
niche
and
can
be
more
username
itself
and
using
that.
I
include
some
additional
features
that
I
think
can
be
useful
for
you,
and
also
for
the
community
that
can
explore
and
see
what
is,
the
current
capabilities
and
to
keep
some
type
of
interaction.
A
This
is
main
basically
the
ability
to
use
some
additional
menu
with
features
in
this
case
this
case
a
permission
checker
the
default
out
of
the
box
options
like
editing
and
items,
add
comments
and
response.
This
is
different
things.
One
thing
is
a
comment.
Another
is
a
response
of
a
post
and
I
will
explain
later
on.
I
also
include
some
additional
custom
view
that
is
called.
I
call
it.
A
The
discussion
board
timeline,
and
this
is
a
different
type
of
timeline
and
also
like
I
said
it,
we
have
a
response
and
then
I
I
create
a
support
list
from
my
discussion
board
that
I
am,
I
store
the
the
answers
and
I
will
make
a
lookup
that
will
display
the
answer
from
each
one
of
the
users.
I
also
you
give
the
ability
to
have
votes
and
also
emotions
that
you
already
saw
on
some
of
the
other
applications
itself,
so
I'm
using
for
this
sharepoint
page
filter
web
patch.
A
I
will
start
some
power
ultimate
flows
using
declarative
json
and
we
can
use
teams
for
the
realization
of
the
content
itself.
So
what
is
the
goal
here?
So
what
I
have
done
is
to
identify
what
math
information
we're
going
to
have.
So
with
the
initial
board
that
users
will
be
able
to
identify
and
from
there
they
will
have
the
ability
to
see
what
is
the
posting?
What
is
the
target
association?
What
is
the
tags
and
the
categories
associated
there
yeah
under
your
top
left?
A
We
have
also
a
menu
and
also
a
bunch
of
options
that
help
describe
it
later
on.
The
second
part
is
the
card.
So
the
moment
we
click
on
the
title.
We
have
the
the
title
and
the
description
that
will
be
on
that
post.
On
that
and
any
moment
we
can
define
emotions,
for
example.
I
like
it,
I
dislike
it.
I
want
to
have
more
more
details
and
we
can
make
them
a
small
conversation.
A
Nothing
complex,
very
straightforward
itself
and
below
where
you
see,
is
the
text
box
area
that
you
can
create
your
comment
and
then
the
workflow
will
do
some
action
that
I'll
explain
later
on.
So
on
the
menu
itself,
so
on
the
initial
board,
we
have
so
the
vaulting
the
category
and
in
this
ma
in
this
main
area
here
that
we
have
it.
A
We
also
have
the
ability
to
have
fixed
menu
options,
and
this
is
the
majority
of
the
out
of
the
box,
and
here
we
have
the
comments,
and
we
here
we
have
the
response
to
the
to
the
to
the
post
that
people
use
it.
This
is
this
option
here
is
is
a
new
one
that
I
identified
some
days
ago,
and
I
included
that
is
the
permission
checker
that
and
I
will
say
how
we
can
do
that.
Also
on
the
left.
A
This
is
a
more
dynamic
and
I
wanted
to
include
it
because
it's
not
only
to
make
some
posting,
but
we
can
also
include
some
features
that
can
support
the
the
person
who
is
creating
the
post
to
to
make
a
better
content
and
a
better
description.
So
it's
a
support
feature
for
the
for
the
creation
of
the
post
itself.
So
what
is
the
idea?
We?
We
click
on
the
on
the
on
the
title.
A
We
have
the
card
and
this
is
the
match
information,
the
title,
the
description,
the
emotion
and
the
answers
look
up,
and
basically
we
using
my
support
list.
I
will
make
the
the
comments
that
I
will
include
that
and
I'll
have
a
small
commenter.
I
have
the
text
box
where
I
I
will
be
able
to
put
the
text
and
then
I
have
the
old
information
regarding
the
different
actions
itself
there.
A
So
what
is
the-
and
here
is
the
flow
associated
the
moment.
Someone
want
to
give
an
answer.
He'll
fill
out
this
text
box
here
and
the
moment
it
is
ready.
You
get
the
message
that
you
can
click
it
to
to
to
send
the
comments.
The
moment
they
click
send,
there
is
a
flow.
There
is
a
formatting
to
call
the
flow
actions
and
this
will
fire
the
following
workflow.
That
will
create
a
item
on
my
on
our
support
list
and
then
he's
going
to
collect
all
the
existing
responses.
A
From
that
specific
item
and
he's
going
to
update
the
comment.
Another
thing
that
he
also
does
is
also
creating
a
comment
and
also
the
response
on
that
specific
item
and
after
everything
is
clear,
he's
just
going
to
clear
the
the
message
that
the
user
wanted
and
the
status
will
return
as
normal.
I
will
show
on
the
example,
because
we
we
have
one
main
board
where
people
can
interact.
There
is
a
second
one
that
I
created.
A
That
is
a
more
timeline
approach
that
is
ordered
by
modify
where
we
have
also
the
card,
but
only
on
the
edit.
Only
on
the
displayed
mode.
The
only
option
that
the
users
can
manage
is
more
on
the
emotion
they
can
like
it
than
dislike
it,
it's
more
for
visualization
and
we
can
also
filter
by
the
different
categories
itself,
and
here
is
the
features
itself.
So,
every
time
we
have
an
answer,
there's
this
support
list
that
I
group
it
by
the
type
of
the
responses.
A
Of
course,
the
lookup
will
collect
this
information
and
we
will
send
it
to
the
main
list
where
you
saw
on
the
card
the
answers
itself-
and
this
is
the
visibility-
how
we
this
is,
how
I
make
the
grouping
and
the
customization
on
the
grouping
itself
of
the
options
here
is
more.
Regarding
the
permission
checker
there
is
a
there
is
a
multiple
method,
information
that
you
can
pick
from
the
from
the
list.
Formatting
itself.
A
One
of
them
is
the
permission
mask
and
when
you
use
this,
this
parameter
you're
going
to
have
the
xml
text
in
x,
xml
of
the
value
itself
for
a
lot
of
users.
This
doesn't
mean
a
lot
of
of
the
information,
and
basically
this
can
be
converted
to
binary
and
from
the
binary
you
can
define
different
roles
itself
so
to
keep
it
simple
for
the
users,
I
try
only
to
use
the
three
main
security
groups
read
edit
and
full
control,
and
I
try
to
fix
the
access
xml
for
these
ones.
A
That
will
give
us
what
type
of
permission
that
we
have
at
on
that
specific
moment.
We
cannot
expect
too
much
from
the
list.
Formatting,
though
the
only
thing
I
did
that
I'll
just
pick
the
three
main
exodus
mouse
and
the
create
three
main
conditions.
If
you
have
more
groups
with
more
complex
permissions,
you
will
need
to
create
and
to
figure
out
what
is
the
access
xml
for
the
specific
reasons
itself,
but
for
very
basic
themes
and
site.
This
will
be
more
than
enough.
A
The
the
other
option
that
I
have
it
here
is
the
emotions.
What
I
have
done
is
to
create
a
bunch
of
validations
and
values
that
will
be
configured
in
two
different
columns.
One
will
collect
all
the
emotions
from
the
different
users
and
the
the
last
one.
That
is,
the
emotion,
will
register.
Who
was
the
user
and
what
emotion
he
was
associated
there.
So
we
have
one
for
the
counter
and
one
to
identify
who
did
what
on
the
on
the
measure.
A
So,
let's
go
to
our
example:
I'm
just
going
to
jump
to
my
site
and
I'm
going
to
right
away
to
the
to
the
sharepoint
page,
where
I'm
using
in
this
case
the
the
discussion
board.
As
you
see
it
here,
you
have
a
filter
area,
the
dispersion
board,
and
we
call
it
here
on
the
menu.
If
you
click
it
here,
we're
going
to
have
some
additional
features.
This
is
nothing
more
than
a
normal
sharepoint
list.
Support
that
I
created
that
interacts,
expanding
and
collapsing
itself.
So
let's
return
it
to
my
view
itself.
A
What
I'm
going
to
do
is
just
going
to
create
a
new
entry,
I'm
just
I'm
just
making
an
iframe
that
redirects
to
my
main
area-
and
I
will
say
post
about
chemicals,
for
example,
example-
and
here
I
will
say
this-
is
the
content
for
the
post
post
about
chemical
sample,
and
here
I
will
call
it
as
a
general
information
that
we
want
to
define.
I
will
say
this
will
be
used
for
investigation
and
for
supporting
of
our
features,
we're
going
to
define
some
main
information
for
for
percentage
calculation.
So
we
have
a.
A
I
have
some
addition.
One
additional
feature-
and
I
define
that
we
make
an
inquire
on
25,
000
users
and
we
have
a
response
of
45
for
14
587
and
we
have
all
our
entry
for
our
discussion
board.
We
save
it
and
he
automatically
will
be
returned
to
our
menu
option
here.
So
the
only
option
here
is
there
is
some
time
until
this
is
refreshed,
but
I
can
always
speed
it
up
with
the
process,
and
here
we
have
our
new
post
itself.
A
A
I
will
go
directly
to
our
view
and
I'll
go
directly
to
my
area
here
and
I'm
going
to
include
this
is
my
custom
response
the
moment
I
click
enter.
He'll
say
that
the
same
content
to
be
send
it,
I
click
it
and
the
workflow
will
be,
will
start
to
fire.
So
just
one
question
of
seconds
run
and
in
theory
everything
should
be
already
created.
So
what
will
happen
right
now?
We
have
a
response
and
we
have
a
comment.
Let's
give
a
look,
how
it
is
appearing.
A
Oh,
we
have
an
answer,
someone
answered
itself
and
we
also
have
also
on
the
menu
the
ability
to
see
what
who
answer
and
what
amount
of
answers
that
we
have
it.
On
my
flow,
I
am
doing
two
different
actions.
One
is
the
response
and
if
I
go
to
the
my
item,
I
also
include
a
comment
directly
here,
so
this
is
oh
basically
what
I
have
done.
I
created
a
item
in
my
support
list.
A
So
I
just
need
to
return
back
itself
and
if
we
expand
it,
we
have
also
these
options
here.
So,
as
you
can
see,
there
is
multiple
options
that
we
can
already
see,
and
one
of
them
is
the
the
the
matrix
of
the
permissions
that
we
have
it
here
and
when
I
click
it
on
this,
a
dialog
will
appear
and
will
say
what
is
the
full
control
for
the
presentation
I
have
this
grease,
but
for
the
for
the
formatting
I
have
on
github,
I
have
it.
I
have
it
only.
A
What,
if
the
information
that
we
have
it
here
and,
for
example,
I
have
a
different
user,
and
this
is
my
guest
user
here
and,
as
you
can
see
here,
I
don't
this
user
in
this
items.
They
don't
have
the
menu.
Why?
For
this
specific
user,
he
only
for
this
specific
item.
He
only
have
edit
permissions,
but
for
all
the
other
ones,
he
only
have
read
permissions
itself,
so
this
can
be
very
useful
when
you
are
making
this
type
of
comments.
Like
I
said
before,
we
have
the
edit
permission.
A
The
center
descended
the
item
and
one
thing
that
we
also
do
because
we
are
doing
about
chemicals.
We
need
to
inform
ourselves.
What
is
the
first
thing
if
we
are
working
so
we
can
create
also
some
visual
tables
and
content
that
can
also
support
the
our
discussion
board.
For
example,
I
created
a
periodic
table
and
if
I
go
over
oxygen,
he'll
give
me
some
atomic
information
and
when
I
click
it,
he
will
he'll
link
it
directly
to
wikipedia.
A
Where
is
all
these
keywords
associated
because
they
are
both
integrated
okay,
I
have
some
atomic
information,
so
what
I
can
do
more.
I
can
pick
this
information
from
for
the
calculation
and
I
can
do
very
basic
separation,
like
I
will
put
45
plus
five,
and
I
will
divide
it
by
five,
and
this
will
give
me
some
information
that
I
can
use
for
my
own
needs
and
remember
the
percentage
value.
So
what
we
have
it
here
is
also
okay.
A
We
make
this
inquire
to
25
percent
20
000
25
000
persons,
and
they
give
me
some
answers
itself
and
based
on
that
information,
I
can
say:
okay
59
answer,
but
at
any
moment
we
can
go
there
and
we
can
also
change
and
we
have
a
different
chart
that
we
can
use
for
our
own
investigation.
What
type
of
information
we
have
it
here
at
any
moment,
if
you
like
the
posting
associated,
you
can
like
it
as
you
see
here
this
one
already,
that
is
already
there.
A
So
if
I
click
click
it,
I
will
get
information
from
me
and
the
other
person
who
click
it
and
also
we
have
the
information
who
who
gave
answers
on
the
on
the
item.
So
I
have
two
answers
with
the
two
users
and
at
any
moment,
if
we
click
it
there
we're
going
to
have
access
to
the
responses
itself.
So
these
are
the
responses,
and
this
is
the
meta
information
how
it's
done
so
I'm
just
going
to
return
to
my
main
information
and
I'm
going
to
to
show
very
fast.
What
is
the
background
here?
A
This
is
the
main
information
we
have
the
title
of
the
description.
The
category
and
the
voting
there
is
nothing
more
than
a
person
user
that
is
collecting
the
users
who
is
voting
itself.
Here
is
the
the
person
for
the
emotion
who
is
making
who
is
liking
and
disliking
and
the
person
who
is
collecting
the
counting
and
the
answers
itself,
and
this
is
how
I'm
making
the
the
management.
So
this
is
a
lookup,
so
we
have
a
meta
information
that
we
can
try
treated
and
we
respond
to
way
that
you
are
visualization.
A
You
have
realization
like
today,
returning
to
my
my
my
presentation,
so
what
one
last
action
if
we
go,
we
have
a
custom
view
where
we
have
these
timelines
and
this
is
organized
by
every
time.
I
make
some
change
on
the
on
the
item
itself.
Any
moment
we
can
filter
and
we
have
organized
way
how
we
can
see
it.
If
we
click
on
the
title,
as
you
can
see,
we
can
only
see
the
information.
This
is
a
good,
for
example,
if
we
are
making
a
presentation
so
on
our
team's
site.
So
this
is
my
teams.
A
This
is
my
content.
I
want
to
have
a
visualization
and
we
can
go
to
the
teams
and
all
everything
looks
in
a
better
and
nicer
way
and
in
a
very
simple
not
that
simple.
I
have
to
admit
this
is
not
that
simple.
We
can
have
a
way
that
we
can
create
some
content.
We
can
interact
and
we
can
have
some
type
of
responses
itself,
and
this
is
what
I
wanted
to
show
all
the
different
capabilities.
The
features
the
the
the
visualization
then
the
content
itself
that
you
can
use
it.
A
So,
on
the
repository
of
the
list
formatting,
I
have
multiple
of
these
different
formats,
like
the
calculator,
the
percentage
reporting
and
also
the
and
also
a
simplified
discussion
board
without
the
responses
because
of
the
workflow
dependencies
so
and
you
can
use
it
to
create
and
to
interact
even
to
collect
some
data
that
you
can
use
for
filtering
and
collecting
to
identify.
How
can
you
improve
your
own
process
itself
and
in
a
very
basic
way
that
you
can
analyze
and
see
what
you
can
do
on
the
using
the
list?
Formatting
itself
and
david?