►
Description
📺 In this 23 minute developer-focused demo Eickhel walks the audience through the concept of connectors in Power Platform and then creates a new custom connector providing all information step by step. He also explains that it is possible to utilize custom code (written in C#), to for example extend the functionality of the connector to validate a payload against a schema (RegEx). He then introduces us into his thought process using ChatGPT to get the right code snippet.
This demo is taken from the Microsoft 365 & Power Platform weekly call – 22nd of August, 2023. Join the next call! Download recurrent invite from https://aka.ms/community/calls
✨ Presenters
Eickhel Mendoza (Intelequia) – https://twitter.com/Eickhel
💡 Learn more about the Microsoft 365 & Power Platform community
• Microsoft 365 & Power Platform Unified Sample gallery - https://aka.ms/community/samples
• Microsoft 365 & Power Platform Community in YouTube - https://aka.ms/community/videos
• Microsoft 365 & Power Platform - http://aka.ms/community/home
Sharing is caring! You are awesome! 🧡
A
A
Slide
to
to,
let
me
introduce
myself,
my
name
is
Michael
Mendoza
I'm,
a
business
of
MVP.
They
also
the
team
lead
at
intellectual
technology.
The
company
I
work,
I,
work
for,
and
I'm
also
the
author
of
the
powerapps
good
book.
As
the
name
implies
it's
it's
a
book
that
helps
you
learn
about
powerapps
and
everything
that
is
around
powerapps
in
Power
Platform,
a
in
the
in
the
way
of
recipes
like
a
chef,
would
do
to
teach
you
all
about
the
things
that
you
see
in
in
Power
Platform.
A
A
A
You
can
see
connectors
from
ijira
Google
or
whatever
the
service
that
that
you
want
to
connect
to
as
long
as
they
allowed
you
to
connect
to
that,
maybe
from
a
database,
an
API
or
whatever
connection
that
you
need
to
have
a
to
gather
some
information
from
there
as
a
data
source
into
your
applications
or
or
other
services,
or
to
automate
those
Services.
We
also
have
hybrid
connectors
in
hybrid
connectivity
to
connect
to
those
on-premise
services
that,
from
from
some
reason,
a
company
doesn't
move
those
servers
to
the
cloud.
A
You
can
also
connect
to
those
servers
and
gather
information
from
there,
a
maybe
a
SQL
database
or
something
that
is
a
locally
for
the
for
that
for
that
company
and
also
what
I'm.
What
are
we
going
to
talk
today
is
about
creating
new
custom
connections
for
new
Integrations.
These
custom
connectors
allows
you
to
build
your
own
connector
with
your
own
actions
or
your
own
methods
to
do
something
with
that.
A
data
source
okay
about
the
most
strange
use
cases
that
you
that
I
have
I
come
across
by
creating
custom
connectors.
A
The
first
one
is
Docker
containers.
Docker
containers
are
a
special
pots
of
code
that
can
scale,
depending
on
the
demand
or
or
the
the
need
for
for
those
a
pot
of
code
to
do
something
of
provision
of
financial
computation
or
whatever
that
they
need
to
do.
We
created
a
constant
connector
that
connected
to
a
Docker,
a
Windows
Docker,
to
extract
that
information
to
get
that
information
into
a
canvas
app.
A
The
canvas
app
was
the
the
front
end
of
the
that
Financial
Financial
team
in
order
to
change
the
data
and
query
the
data
and
also
get
information
into
Power
bi,
but
all
the
the
calculations
and
all
the
stuff
for
the
financial
team
when
it
were
executed
on
Docker
containers
around
the
around
the
world.
So
it
was
really
crazy
to
do
that.
A
The
next
one
was
to
connect
to
a
custom
Erp
that
one
company
had
this
company
had
a
really
custom,
homemade
Erp
that
didn't
had
a
connectivity
to
the
database,
but
it
had
some
specific
methods
in
the
API
on
on
a
local
API.
So
we
connected
to
that
Erp,
even
though
it
was
on
on
a
local
server
and
integrated
with
that
API
and
got
the
get
and
allow
us
to
get
all
the
information
from
there
and
the
one
that
we
are
going
to
talk
about
today.
A
A
Okay.
So
here
we
are
go
back!
Okay!
We
are
here
in
the
powerapps
maker
portal.
We
are
here
on
the
custom
connector
site
I'm,
going
to
just
show
you
a
little
bit
of
information
about
how
to
build
this
type
of
a
custom
connectors
you
go
here
and
you
can
create
a
custom
connector
from
blank
from
scratch.
You
can
create
create
a
custom
connector
from
azure
and
from
Azure.
You
can
create
a
custom
connector
in
your
in
your
environment.
A
So,
as
you
can
see
here,
we
are
stepping
out
of
the
low
code
side
of
of
Power
Platform,
but
it
doesn't
mean
that
it's
going
to
be
scary
or
something
like
that,
because
this
allows
it
allow
us
to
embrace
the
fusion
team
in
our
organization.
We
can
ask
someone
from
a
from
the
pro
code
side
of
our
company.
A
Can
you
help
me
with
to
build
an
API
in
Azure
and
create
a
connector
for
that
API
into
my
environment,
or
you
can
create
a
an
API
from
scratch,
someone
that
knows
about,
for
example,
the
the
postman,
a
tool
that
allows
you
to
test
apis.
You
can
do
the
API
requests
and
give
me
that
information,
so
I
can
create
a
custom
connector
with
that
you
can
ask
your
team
in
your
organization.
A
Someone
must
know
Postman,
someone
must
know
how
to
run
apis,
how
to
work
with
Azure,
and
he
can
help
you
or
she
can
help
you
to
build
that
information
into
your
into
your
environment.
We're
going
to
a
to
for
this
demo
start
from
scratch.
Okay,
so
the
first
thing
I'm
going
to
do
here
is
to
give
a
name.
Okay.
This
is
going
to
be
reg,
apps,
regular
expression,
tester.
A
Why
is
this
example?
There
are
two
reasons
for
from
which
I
created
this
this
demo,
because
it's
already
a
sample
on
on
the
Microsoft
learning
site,
so
you
can
get
that
a
code
from
there
if
you,
if
you
need
that,
because
a
once
I
tell
you,
why
is
this
useful
you're
going
to
start
using
that
in
in
power
automate
and
the
second
one
is
because
I'm
going
to
show
you
how
to
improve
that
code?
That
is
on
Microsoft,
learn
by
using
chat,
apt,
okay,
D-
and
why
is
this
useful,
for
example,
for
power
effects?
A
Sorry
for
power
automate
is
because
how
many
times
the
in
your
automation
you
need
to,
for
example,
validate
that
simplest
string.
A
text
string
is
validated
as
an
email.
You
can
do
that
in
powerapps
with
power
effects,
but
as
long
as
power
effects
doesn't
come
to
power,
automate,
there's
no
way
to
for
you
to
validate
easily
an
email
in
a
text
string,
so
you
can
use,
for
example,
a
regular
expression
to
tell
in
this
case,
in
acoustic
connector.
This
is
the
text
I
I
want
you
to
test
by
this
pattern.
A
A
Dpt,
give
me
a
a
regular
expression
to
test
an
email
from
a
text
string
and
you
can
use
that
as
a
custom,
connector
and
power
to
mate
and
in
your
in
your
flow,
you
can
say:
okay,
this
is
the
email
I'm
getting
validated
that
that
is
our
a
correct
email
and
is
it
so
do
that
or
whatever
that
you
need
to
do?
Okay,
so
we
we're
going
to
start
from
scratch.
I'm
going
to
we
represented
with
this
first
screen,
where
we
are
going
to
describe
our
custom
connector
I'm
going
to
so
no
this!
A
No
oh
change
the
folder.
This
one
I'm
going
to
set
a
an
icon,
I'm
going
to
set,
for
example,
a
color
for
my
custom
connector.
So
it
appears
pretty
in
power,
automate
or
powerapps
and
given
a
description,
regular,
regular,
oh
man,
expression,
tester
and
then
I'm
going
to
tell
you
a
little
bit
of
the
settings
that
you
have
here.
For
example,
if
I
click
here
to
connect
to
on-premises
data
Gateway,
you
will
be
able
to
create
a
custom
connector
and
then
we're
doing
create
a
connection
using
this
custom.
A
A
This
is
not
I,
don't
know
it's
going
to
be
our
case,
a
in
this
scheme
and
where
we
need
to
say
a
from.
How
are
we
going
to
connect
to
this
a
URL
in
this
case?
We're
not.
We
always
need
to
select
https,
because
this
is
a
secure
protocol
but
I'm
going
to
change
some
things
here
here
you
would
put
the
host
a,
for
example,
api.contoso.com
and
the
base
URL
for
your
API
as
we
are
building
a
code,
a
connector.
We
are
not
going
to
have
a
URL
here,
so
we
put
a
dumb
information.
A
A
Sorry,
in
order
to
secure
our
connector,
we're
not
going
to
delve
into
that
today
and
we
are
going
to
start
from
the
definition
here
in
the
definition
we
need
to
set
here
is
where
we
create
the
actions
that
we're
going
to
see
on
the
power
in
this
case
on
the
power
automate
site
are
the
names
of
the
little
boxes
that
appear
below
our
connector.
In
this
case,
we
are
going
to
create
a
new
action
as
the
the
summary
is
going
to
be
a
regular
Recaps
tester.
A
Regex
tester
and
the
operation
ID
is
the
name
of
the
action
act
in
the
internal
name
of
the
action
test.
I'm
going
to
say
tell
the
name
of
this
operation
is
going
to
be
test
I'm
not
going
to
show
you
all
the
all
the
parameters
here
so
because
I
don't
run
Out
of
Time
of
My
Demo,
and
here
is
the
important
part.
The
request
here
is
going
where
I
need
to
tell
the
action
how
I'm
going
to
request
the
information.
A
The
information
through
the
custom
connector,
so
I
can
I'm
going
to
click
here,
import
from
sample,
because
I
want
to
give
the
the
custom
connector
the
ability
to
learn
from
a
an
API
request
to
get
that
data.
In
this
case
we
are
entering
information
to
the
custom
connector
and
it
will
give
me
information
about
it.
A
So
I'm
going
to
set
the
verb
is
the
way
that
you
talk
with
a
with
a
with
the
API
get,
as
the
name
implies,
get
information,
delete,
information,
post
information,
put
information
to
edit
and
some
stuff
like
that,
in
this
case
we're
going
to
set
post.
What's
the
URL
again,
we
put
some
dumb
information.
A
The
headers
we
are
not
going
to
talk
about
that
and
the
body.
Here's
the
Json
body,
with
the
with
a
a
information
that
I'm
going
to
post
into
the
this
custom
connector
in
this
example
I'm
going
to
copy
this
here.
As
you
see,
you
put
the
the
the
parameters
here
that
you're
posting
to
the
custom
connector,
if
I
paste
here
this
information
I'm
going
to
give
you
an
input
and
I'm
going
to
give
you
the
pattern.
A
So,
if
I
give
you
the
this,
a
text
you're
going
to
validate
it
with
the
pattern
and
tell
me:
is
it
bad
if
it
is
valid
or
not?
Okay,
I'm
going
to
click
import
as
you
can.
As
you
see
it
created
everything
for
me,
the
URL
here
the
body.
If
I
click
here
on
edit,
you
will
see
the
the
payload
that
is
going
into
the
body.
That
is
the
input
and
the
pattern.
Everything
is
working
correctly.
A
As
you
can
see
on
the
custom
connector
on
this
guideline,
you
will
see
that
everything
gets
validated
once
you
get
to
the
the
to
The
Next
Step,
okay,
so
we
have
the
request
ready.
This
is
what
I
need
to
use
on
my
on
my
power:
automate
I
want
to
use
the
test,
action
and,
and
then
I'm
going
to
go
to
the
code
part
this
step
on
the
custom.
Connector
side
is
relatively
new
because
it
wasn't
preview
until
two
days
ago.
A
A
So
if
I
click
here
code
enable,
it
will
be
ready
to
understand
that
this
custom
connector
is
not
going
to
connect
to
anything,
but
it
will
run
itself
the
code
that
is
here
from
the
payload
I
just
Define
and
do
something
okay
in
this
case,
this
is
the
part
where
it
might
be.
It
might
get
some
tricky
because
you
will
see
here
code,
Pro
code,
C,
sharp
code,
you
say:
okay,
what
is
this
I?
Don't
know
how
to
write
this
I,
don't
know
what
to
put
here.
A
I
just
need
something
to
validate
that
this
email
is
is
is
working
okay.
This
is
again
another
part
where
you
can
Embrace
a
fusion
team
and
ask
someone
in
your
organization
that
knows
about
c-sharp
that
knows
about
how
to
to
work
with
this
type
of
functions
that
you're
you're
having
here
on
this,
and
this
example
that
you
have
here.
Maybe
you
have
a
a
background
of
a
pro
gold
programming
and
you
can
start
a
changing
everything
here,
but
there's
now
an
easy
way
to
do
this.
A
You
can
go
here
too
scientific
and
I'm
going
to
show
you
my
way
of
thinking
about
this.
The
first
thing
is,
was
it
was
to?
Can
you
please
show
me
a
c-sharp
go
to
validate
a
regular
expression
against
a
pattern
sure
this
is
the
code?
Okay,
it's
amazing.
It
looks
correct.
It
looks
that
it
should
work
in
C
sharp
and
it
even
explains
that
the
code
is
going
to
work
and
what
you
need
to
make
it
work
and
okay
perfect.
A
A
Okay,
it
gives
me
the
code
with
the
async
task.
This
is
not
going
to
work
for
me.
It's
not
look.
This
code
doesn't
look
like
that,
like
the
one
on
the
custom,
connector,
so
I
said
well,
this
should
be
intelligent
enough
if
I
give
him
an
example
to
chat.
Deputy.
Give
me
an
example
of
code
that
does
regular
expression
against
a
pattern
by
using
this
type
of
code.
What
I
just
did
is
copy.
This
example
put
it
here.
A
Can
you
please
adapt
this
code
to
validator,
regular
expression
against
the
pattern
and
voila
I
have
the
the
code
here
and
I
was
what
this
is
amazing,
but
I
need
to
use
parameters.
I,
I,
I'm
I'm
not
going
to
have
the
the
information
here
reading.
This
is
the
pattern.
This
is
the
input.
No,
no
and
I
then
improve
this
one
change
the
input
pattern
string
to
receive
as
parameters.
He
started
to
change
everything
and
I
just
started
to
give
him
give
captivity
more
information
of
what
I
needed
about
this.
Can
you
make
that
thing?
A
Execute
async
method
receive
two
parameters:
here's
the
the
change.
Can
you
please
add
code
to
part
the
body
of
the
incoming
request?
Why?
Because
I
don't
I
didn't
need
to
have
those
a
in
those
the
input
and
the
pattern
as
parameters
I
need
that
from
a
post
in
in
the
API,
so
I
I
said
that
scratch.
That
can
you
please
add
code
to
parse
the
body,
the
body
that
I
just
defined
here
to
parse
that
information
in
the
incoming
request?
A
Okay,
perfect,
here's,
the
input,
here's
the
pattern
and
here's
the
parsing
of
that
information
and
as
J
and
the
only
thing
that
I
needed
to
to
change
is
to
because
I
test
this
this
code
and
the
custom
connector
said
no.
You
need
to
wrap
this
request
in
this
context.
Okay,
please
wrap
the
request
in
in
this
contact
request.
You
change
this
thing
only
and
everything
work,
and
the
beauty
of
this
is
that
the
the
the
last
thing
I
I
wanted
to
to
know
is
how
to
request
this
even
better
the
next
time.
A
A
So
let's
get
this
code,
that
is
the
well
man.
Here's,
okay,
I,
go
great
great
stuff,
just
RFI
we're
still.
We
have
one
more
demo,
so
we
got
to
wrap
it
up
pretty
quickly
here:
okay,
okay,
I'm,
going
to
be
fast,
okay,
so
I
faced
this
one
here
and
I'm
going
to
the
next
thing
is
to
test
this
I
create
a
connector.
This
is
going
to
take
a
little
bit
of
time.
A
I
promise
this
will
be
fast.
The
thing
is
that
a
when
you
create
a
custom
connector
using
Code.
It
will
take
a
little
bit
of
time
because
it
is
I'm
building
this
spot
of
code
in
order
to
respond
for
you,
I'm
not
going
to
wait
for
this
on
or
do
the
the
testing
completely
here
in
the
in
the
custom.
Connector
side.
A
I
have
a
one
all
already
here,
if
I
click
edit
in
this
in
this
power
automate,
if
I
click
here
to
add
an
action
in
the
custom,
a
tab,
you
will
see
your
custom
connector
that
you
just
created
the
one
that
I
just
created
is
not
appearing
here,
because
it's
still
building
I'm
going
to
click
here
on
code.
That
is
this
one
that
you
see
here,
and
it's
actually
trying
to
test
that
if
this
email
validates
to
this
regular
expression
pattern,
if
I
click
test,
you
can
use
this
on
on
power,
automate
or
powerapps
again.
A
A
A
The
one
from
just
activity
is
a
tiny
bit
better
because
it's
not
as
actually
responding
true
or
false,
but
it
will
actually
run
okay
if
everything
works
and
also
we
will
fail,
if
the
if
the
regular
expression
it
doesn't
match.
So
it
would
be
better
for
you,
when
you're
riding
the
flow
of
your
power
automate
and
I
just
to
wrap
it
up.
This
is
the
one
that
I
was
telling
you
about.
It
was
released
just
a
two
days
ago.
A
This
allows
it
to
have
a
custom
connector
in
Solutions,
so
it
will
be
good
for
your
LMA
scenarios
and
also
the
the
inclusion
of
the
custom
code
in
custom
connectors
that
you
will
see
here
in
the
in
the
documentation
how
to
so.
You
can
write
this
this
code
with
some
samples,
as
this
is
a
regular
expression,
a
string
you
you
can
try
the
one
that
I
just
created
on
chatipity
and
also
the
name
is
spaces
that
are
the
things
that
you
can
do
in
dot
in
that
a
c-sharp
code.
A
You
cannot
do
anything
everything,
sorry,
but
you
can
do
a
the
things
that
allows
you
from
this
namespace
just
to
give
you
this
and
be
sure
to
check
the
GitHub
samples
in
GitHub,
because
there
are
many
samples
on
how
to
do
anything
on
custom
code.
So
if
it
doesn't
show
on
shot
DPT
or
something
it
will
this
will
this
code
will
help
you,
so
the
community
is
helping
you
and
sorry
for
taking
so
much
time.
No,
it's
great
great
stuff,
Michael,
really
really
fantastic,
stuff,
I
think
opened
a
lot
of
eyes.
Thank
you.