Up next in 10
Proactive Customer Support with Email Sentiment Analysis: Automate Your Business Processes - Ep.8
0 views
Aug 6, 2025
Automatically analyze the sentiment of incoming customer emails in Dynamics using AI Builder. The sentiment score is stored in Dataverse and can trigger alerts for negative responses using Power Automate. 📺 CSharp TV - Dev Streaming Destination http://csharp.tv 🌎 C# Corner - Community of Software and Data Developers https://www.c-sharpcorner.com #CSharpTV #csharpcorner #CSharp
View Video Transcript
0:02
[Music]
0:13
[Music]
0:23
I know you can do it.
0:28
[Music]
0:34
Greetings everyone. Welcome back to the
0:37
Greetings everyone. Welcome back to the
0:37
Greetings everyone. Welcome back to the another episode of business automation.
0:40
another episode of business automation.
0:40
another episode of business automation. So where we talk about how we can use
0:44
So where we talk about how we can use
0:44
So where we talk about how we can use Microsoft technologies or Microsoft non
0:47
Microsoft technologies or Microsoft non
0:47
Microsoft technologies or Microsoft non technologies to automate your business
0:50
technologies to automate your business
0:50
technologies to automate your business activities.
0:52
activities.
0:52
activities. In every session we take a new use case
0:55
In every session we take a new use case
0:55
In every session we take a new use case and we explain that for that particular
0:58
and we explain that for that particular
0:58
and we explain that for that particular use case what are the tool set we can
1:00
use case what are the tool set we can
1:00
use case what are the tool set we can use and how we can automate that
1:02
use and how we can automate that
1:02
use and how we can automate that particular use case. Okay. So today we
1:07
particular use case. Okay. So today we
1:07
particular use case. Okay. So today we are going to talk about
1:10
are going to talk about
1:10
are going to talk about proactive support
1:12
proactive support
1:12
proactive support for the customer. Right? So if let's say
1:17
for the customer. Right? So if let's say
1:17
for the customer. Right? So if let's say you are on any business whether it's a
1:19
you are on any business whether it's a
1:19
you are on any business whether it's a product development service company or
1:21
product development service company or
1:21
product development service company or you are doing some kind of maintenance
1:23
you are doing some kind of maintenance
1:23
you are doing some kind of maintenance for your customer whenever you done with
1:26
for your customer whenever you done with
1:26
for your customer whenever you done with your project you want to know what is
1:29
your project you want to know what is
1:29
your project you want to know what is their feedback okay about your services
1:32
their feedback okay about your services
1:32
their feedback okay about your services about your product okay about your
1:35
about your product okay about your
1:35
about your product okay about your interaction with them. So that feedback
1:38
interaction with them. So that feedback
1:38
interaction with them. So that feedback what we get from there how we can do
1:40
what we get from there how we can do
1:40
what we get from there how we can do analysis on that and we can you know
1:43
analysis on that and we can you know
1:43
analysis on that and we can you know actively response on that and actively
1:45
actively response on that and actively
1:46
actively response on that and actively act on that so that you know we can get
1:48
act on that so that you know we can get
1:48
act on that so that you know we can get some more detail or maybe we can set up
1:50
some more detail or maybe we can set up
1:50
some more detail or maybe we can set up the process how we can improve if there
1:52
the process how we can improve if there
1:52
the process how we can improve if there is some some kind of gap is there or
1:55
is some some kind of gap is there or
1:55
is some some kind of gap is there or some kind of miscommunication there. So
1:58
some kind of miscommunication there. So
1:58
some kind of miscommunication there. So those kind of thing basically part of
2:00
those kind of thing basically part of
2:00
those kind of thing basically part of the proactive customer support. Okay. So
2:04
the proactive customer support. Okay. So
2:04
the proactive customer support. Okay. So here is the agenda. So we will start
2:06
here is the agenda. So we will start
2:06
here is the agenda. So we will start with a basic introduction and then we
2:08
with a basic introduction and then we
2:08
with a basic introduction and then we will see that what is our proposed
2:10
will see that what is our proposed
2:10
will see that what is our proposed solution. There may be different you
2:12
solution. There may be different you
2:12
solution. There may be different you know proposed solution but in today's
2:15
know proposed solution but in today's
2:15
know proposed solution but in today's scenario. So we will discuss like what
2:16
scenario. So we will discuss like what
2:16
scenario. So we will discuss like what are the tools that we are going to use.
2:18
are the tools that we are going to use.
2:18
are the tools that we are going to use. For example, we will uh talk about
2:20
For example, we will uh talk about
2:20
For example, we will uh talk about outlook and we'll talk about uh power
2:23
outlook and we'll talk about uh power
2:23
outlook and we'll talk about uh power automate. Then we will talk about how we
2:25
automate. Then we will talk about how we
2:25
automate. Then we will talk about how we can utilize AI builder you know to read
2:28
can utilize AI builder you know to read
2:28
can utilize AI builder you know to read those email to get that sentimental
2:30
those email to get that sentimental
2:30
those email to get that sentimental information from there and then how we
2:32
information from there and then how we
2:32
information from there and then how we can use team to uh you know send the
2:34
can use team to uh you know send the
2:34
can use team to uh you know send the notification to the concern team. Okay.
2:36
notification to the concern team. Okay.
2:36
notification to the concern team. Okay. Okay. So whether it's a positive or
2:38
Okay. So whether it's a positive or
2:38
Okay. So whether it's a positive or negative depending on that scenario all
2:40
negative depending on that scenario all
2:40
negative depending on that scenario all these things we are going to talk and
2:42
these things we are going to talk and
2:42
these things we are going to talk and finally we will show you demo that how
2:44
finally we will show you demo that how
2:44
finally we will show you demo that how these tools interact with each other and
2:47
these tools interact with each other and
2:47
these tools interact with each other and can you know use that information from
2:49
can you know use that information from
2:49
can you know use that information from back and forth from one tool to another
2:51
back and forth from one tool to another
2:51
back and forth from one tool to another tool and then make use of that
2:54
tool and then make use of that
2:54
tool and then make use of that information you know pass to the
2:56
information you know pass to the
2:56
information you know pass to the customer pass to the concern team and
2:58
customer pass to the concern team and
2:58
customer pass to the concern team and maybe you know record in our uh uh
3:02
maybe you know record in our uh uh
3:02
maybe you know record in our uh uh system whether it's you have some uh you
3:04
system whether it's you have some uh you
3:04
system whether it's you have some uh you know dashboard that you have created
3:06
know dashboard that you have created
3:06
know dashboard that you have created whether it's you know Microsoft database
3:08
whether it's you know Microsoft database
3:08
whether it's you know Microsoft database or non-Microsoft database that can be
3:10
or non-Microsoft database that can be
3:10
or non-Microsoft database that can be also done as a separate thing. Okay. So
3:13
also done as a separate thing. Okay. So
3:13
also done as a separate thing. Okay. So before jumping into the uh agenda let's
3:16
before jumping into the uh agenda let's
3:16
before jumping into the uh agenda let's have a quick introduction about ourself
3:18
have a quick introduction about ourself
3:18
have a quick introduction about ourself myself Mahendra and I have my friend Sep
3:21
myself Mahendra and I have my friend Sep
3:21
myself Mahendra and I have my friend Sep with me. So we both are Microsoft MVP
3:23
with me. So we both are Microsoft MVP
3:23
with me. So we both are Microsoft MVP and we have been working with the
3:25
and we have been working with the
3:25
and we have been working with the Microsoft technologies it's more than 10
3:27
Microsoft technologies it's more than 10
3:27
Microsoft technologies it's more than 10 years now. So we are also sharp corner
3:29
years now. So we are also sharp corner
3:29
years now. So we are also sharp corner MVPs and we both are hosting this and I
3:33
MVPs and we both are hosting this and I
3:33
MVPs and we both are hosting this and I will be taking care of the PPT and I
3:35
will be taking care of the PPT and I
3:35
will be taking care of the PPT and I will explain the scenarios on that and
3:37
will explain the scenarios on that and
3:37
will explain the scenarios on that and Sep will be taking care of the demo
3:39
Sep will be taking care of the demo
3:39
Sep will be taking care of the demo part. Okay.
3:42
part. Okay.
3:42
part. Okay. So let's start our
3:44
So let's start our
3:44
So let's start our topic.
3:48
Okay. So as I said that in whatever
3:51
Okay. So as I said that in whatever
3:52
Okay. So as I said that in whatever business you are when you have done your
3:56
business you are when you have done your
3:56
business you are when you have done your deployment whether it's a service
3:58
deployment whether it's a service
3:58
deployment whether it's a service deployment whether it's a product
4:00
deployment whether it's a product
4:00
deployment whether it's a product deployment whether you have you know
4:02
deployment whether you have you know
4:02
deployment whether you have you know selling some product to them or you are
4:04
selling some product to them or you are
4:04
selling some product to them or you are doing some kind of maintenance or
4:06
doing some kind of maintenance or
4:06
doing some kind of maintenance or upgrade depending on different different
4:08
upgrade depending on different different
4:08
upgrade depending on different different scenario what is your business after
4:11
scenario what is your business after
4:11
scenario what is your business after completing your whatever project that is
4:14
completing your whatever project that is
4:14
completing your whatever project that is that you want to know okay what is the
4:16
that you want to know okay what is the
4:16
that you want to know okay what is the customer feedback on that Okay, because
4:19
customer feedback on that Okay, because
4:19
customer feedback on that Okay, because you want to retain that customer, right?
4:21
you want to retain that customer, right?
4:21
you want to retain that customer, right? So you need to know that okay, what they
4:23
So you need to know that okay, what they
4:23
So you need to know that okay, what they are thinking about your services, about
4:25
are thinking about your services, about
4:25
are thinking about your services, about your product, right? So based on the
4:27
your product, right? So based on the
4:28
your product, right? So based on the feedback positive or negative you can
4:30
feedback positive or negative you can
4:30
feedback positive or negative you can see that okay if this customer is going
4:32
see that okay if this customer is going
4:32
see that okay if this customer is going to stay with us or you know if we are if
4:35
to stay with us or you know if we are if
4:35
to stay with us or you know if we are if they having any issue in our uh in the
4:38
they having any issue in our uh in the
4:38
they having any issue in our uh in the process that we follow in our you know
4:40
process that we follow in our you know
4:40
process that we follow in our you know company maybe there is some uh you know
4:44
company maybe there is some uh you know
4:44
company maybe there is some uh you know way that we can improve at uh improve
4:46
way that we can improve at uh improve
4:46
way that we can improve at uh improve that process and maybe based on their
4:49
that process and maybe based on their
4:49
that process and maybe based on their feedback we can add some more you know
4:51
feedback we can add some more you know
4:52
feedback we can add some more you know layers on that and maybe we can improve
4:54
layers on that and maybe we can improve
4:54
layers on that and maybe we can improve our process to get you provide uh better
4:57
our process to get you provide uh better
4:58
our process to get you provide uh better service right so all that thing
5:00
service right so all that thing
5:00
service right so all that thing basically here that as you can see on
5:03
basically here that as you can see on
5:03
basically here that as you can see on that like when we do that you cannot
5:05
that like when we do that you cannot
5:05
that like when we do that you cannot make all 100% customer happy right but
5:11
make all 100% customer happy right but
5:11
make all 100% customer happy right but it depends on the process that you are
5:13
it depends on the process that you are
5:13
it depends on the process that you are using for the development or the
5:16
using for the development or the
5:16
using for the development or the services deployment right maybe they
5:19
services deployment right maybe they
5:19
services deployment right maybe they have some different expectation when
5:21
have some different expectation when
5:21
have some different expectation when they will tell you that what is their
5:23
they will tell you that what is their
5:23
they will tell you that what is their feedback if they are telling you the you
5:26
feedback if they are telling you the you
5:26
feedback if they are telling you the you positive feedback that okay the process
5:28
positive feedback that okay the process
5:28
positive feedback that okay the process that you are following that is very good
5:30
that you are following that is very good
5:30
that you are following that is very good and you you know if there is a room of
5:33
and you you know if there is a room of
5:33
and you you know if there is a room of the improvement maybe you can uh you
5:35
the improvement maybe you can uh you
5:35
the improvement maybe you can uh you know convey that message to you that
5:36
know convey that message to you that
5:36
know convey that message to you that okay you can improve your process like
5:38
okay you can improve your process like
5:38
okay you can improve your process like this right or if there is some
5:41
this right or if there is some
5:42
this right or if there is some miscommunication or there is some issue
5:43
miscommunication or there is some issue
5:43
miscommunication or there is some issue with the product maybe there will be a
5:46
with the product maybe there will be a
5:46
with the product maybe there will be a not a happy customer and they will
5:48
not a happy customer and they will
5:48
not a happy customer and they will provide you some kind of negative
5:50
provide you some kind of negative
5:50
provide you some kind of negative feedback and that is very critical for
5:53
feedback and that is very critical for
5:53
feedback and that is very critical for our business because you need to know
5:54
our business because you need to know
5:54
our business because you need to know that okay why the response was negative,
5:57
that okay why the response was negative,
5:57
that okay why the response was negative, right? So, you want to fill the gap, you
6:00
right? So, you want to fill the gap, you
6:00
right? So, you want to fill the gap, you want to improve the process so that next
6:03
want to improve the process so that next
6:03
want to improve the process so that next you know customer won't face that kind
6:05
you know customer won't face that kind
6:05
you know customer won't face that kind of issue or this customer will also be
6:08
of issue or this customer will also be
6:08
of issue or this customer will also be staying with us if we are going to make
6:10
staying with us if we are going to make
6:10
staying with us if we are going to make them happy. Right? So that's the uh use
6:14
them happy. Right? So that's the uh use
6:14
them happy. Right? So that's the uh use case that we are going to talk about and
6:16
case that we are going to talk about and
6:16
case that we are going to talk about and we will see that you know when we send
6:18
we will see that you know when we send
6:18
we will see that you know when we send that feedback email to the customer and
6:21
that feedback email to the customer and
6:21
that feedback email to the customer and when we are getting that response from
6:23
when we are getting that response from
6:23
when we are getting that response from them how we can analyze that how we can
6:26
them how we can analyze that how we can
6:26
them how we can analyze that how we can get that sentimental information from
6:28
get that sentimental information from
6:28
get that sentimental information from that email and that information how we
6:31
that email and that information how we
6:31
that email and that information how we can utilize using the different tool set
6:33
can utilize using the different tool set
6:33
can utilize using the different tool set that we are going to talk today.
6:36
that we are going to talk today.
6:36
that we are going to talk today. Okay.
6:38
Okay.
6:38
Okay. So what is our proposed solution here?
6:41
So what is our proposed solution here?
6:41
So what is our proposed solution here? So as I said that there can be different
6:44
So as I said that there can be different
6:44
So as I said that there can be different ways of implementing that solution but
6:47
ways of implementing that solution but
6:47
ways of implementing that solution but for this use case for this uh session we
6:49
for this use case for this uh session we
6:50
for this use case for this uh session we are going to take these two set. The
6:51
are going to take these two set. The
6:52
are going to take these two set. The first one we are going to take is the
6:53
first one we are going to take is the
6:53
first one we are going to take is the outlook. Okay that will be for the email
6:56
outlook. Okay that will be for the email
6:56
outlook. Okay that will be for the email communication. So whether we are sending
6:58
communication. So whether we are sending
6:58
communication. So whether we are sending email or we are getting email from the
7:00
email or we are getting email from the
7:00
email or we are getting email from the customer. So we are going to use outlook
7:03
customer. So we are going to use outlook
7:03
customer. So we are going to use outlook connector for that. And under that
7:05
connector for that. And under that
7:05
connector for that. And under that outlook connector once we will have that
7:08
outlook connector once we will have that
7:08
outlook connector once we will have that email information we can pass that
7:10
email information we can pass that
7:10
email information we can pass that information to the power automate where
7:13
information to the power automate where
7:13
information to the power automate where basically all that automation logic will
7:16
basically all that automation logic will
7:16
basically all that automation logic will happen right and then on that we will
7:20
happen right and then on that we will
7:20
happen right and then on that we will also going to use AI builder which will
7:22
also going to use AI builder which will
7:22
also going to use AI builder which will basically get that information from the
7:25
basically get that information from the
7:25
basically get that information from the email and it will extract that basically
7:27
email and it will extract that basically
7:27
email and it will extract that basically sentimental analysis on that and then it
7:30
sentimental analysis on that and then it
7:30
sentimental analysis on that and then it will depending on the scenario it will
7:32
will depending on the scenario it will
7:32
will depending on the scenario it will take the decision what need to to be
7:34
take the decision what need to to be
7:34
take the decision what need to to be done in the next step. Okay. And then we
7:38
done in the next step. Okay. And then we
7:38
done in the next step. Okay. And then we have the teams for the notification. So
7:41
have the teams for the notification. So
7:41
have the teams for the notification. So that we want to quickly let them know in
7:44
that we want to quickly let them know in
7:44
that we want to quickly let them know in you know it's basically for our manager
7:46
you know it's basically for our manager
7:46
you know it's basically for our manager or for whoever team is concerned on that
7:49
or for whoever team is concerned on that
7:49
or for whoever team is concerned on that department who technician is dependent
7:52
department who technician is dependent
7:52
department who technician is dependent or you know related to this case. So we
7:55
or you know related to this case. So we
7:55
or you know related to this case. So we want to let them know what is the
7:56
want to let them know what is the
7:56
want to let them know what is the feedback that is coming from the
7:58
feedback that is coming from the
7:58
feedback that is coming from the customer. Right? So that's the proposed
8:00
customer. Right? So that's the proposed
8:00
customer. Right? So that's the proposed solution we are going to talk today.
8:05
So first one outlook right so this is uh
8:09
So first one outlook right so this is uh
8:09
So first one outlook right so this is uh the part of the Microsoft cloud right so
8:12
the part of the Microsoft cloud right so
8:12
the part of the Microsoft cloud right so we are mostly we talk about that uh
8:15
we are mostly we talk about that uh
8:15
we are mostly we talk about that uh cloud one because power automate you
8:17
cloud one because power automate you
8:17
cloud one because power automate you know that that's basically a cloud
8:18
know that that's basically a cloud
8:18
know that that's basically a cloud workflow from Microsoft right so here we
8:22
workflow from Microsoft right so here we
8:22
workflow from Microsoft right so here we are going to use that outlook connector
8:24
are going to use that outlook connector
8:24
are going to use that outlook connector this basically provides a different set
8:26
this basically provides a different set
8:26
this basically provides a different set of actions which we can use you know to
8:30
of actions which we can use you know to
8:30
of actions which we can use you know to get that uh emails and you know act from
8:33
get that uh emails and you know act from
8:33
get that uh emails and you know act from those emails. Okay. So whether you want
8:35
those emails. Okay. So whether you want
8:35
those emails. Okay. So whether you want to send that email to the customer or
8:37
to send that email to the customer or
8:37
to send that email to the customer or you want to receive that email from the
8:39
you want to receive that email from the
8:39
you want to receive that email from the customer, all those email can be tracked
8:42
customer, all those email can be tracked
8:42
customer, all those email can be tracked using those actions. So you can use that
8:44
using those actions. So you can use that
8:44
using those actions. So you can use that outlook connector and once you will
8:46
outlook connector and once you will
8:46
outlook connector and once you will select that connector, you need to
8:48
select that connector, you need to
8:48
select that connector, you need to configure the connection. You need to
8:49
configure the connection. You need to
8:50
configure the connection. You need to tell that okay who who is the you know
8:53
tell that okay who who is the you know
8:53
tell that okay who who is the you know connection
8:55
connection
8:55
connection user will be that like when they will uh
8:57
user will be that like when they will uh
8:57
user will be that like when they will uh you know sending that email. So on on
9:00
you know sending that email. So on on
9:00
you know sending that email. So on on behalf of which user this uh connector
9:02
behalf of which user this uh connector
9:02
behalf of which user this uh connector is going to send that email. Okay. So
9:05
is going to send that email. Okay. So
9:05
is going to send that email. Okay. So mostly that is basically owner of the
9:07
mostly that is basically owner of the
9:07
mostly that is basically owner of the power automate that we create. Okay. But
9:11
power automate that we create. Okay. But
9:11
power automate that we create. Okay. But there is a way of doing that
9:13
there is a way of doing that
9:13
there is a way of doing that impersonation as well. We can select
9:15
impersonation as well. We can select
9:15
impersonation as well. We can select that you from this user we want to send
9:17
that you from this user we want to send
9:17
that you from this user we want to send that email. So we can see here we have
9:20
that email. So we can see here we have
9:20
that email. So we can see here we have different type of actions that is
9:21
different type of actions that is
9:21
different type of actions that is available. we can use these actions and
9:24
available. we can use these actions and
9:24
available. we can use these actions and once when uh we will send that email or
9:27
once when uh we will send that email or
9:27
once when uh we will send that email or we will get email from the customer our
9:31
we will get email from the customer our
9:31
we will get email from the customer our automation logic will trigger. Okay, so
9:34
automation logic will trigger. Okay, so
9:34
automation logic will trigger. Okay, so that's what we have here for the outlook
9:36
that's what we have here for the outlook
9:36
that's what we have here for the outlook for the email communication.
9:42
The next one and this is the key
9:44
The next one and this is the key
9:44
The next one and this is the key component here. This is the key part
9:46
component here. This is the key part
9:46
component here. This is the key part here that is basically power automate
9:48
here that is basically power automate
9:48
here that is basically power automate that's a cloud workflow engine that we
9:51
that's a cloud workflow engine that we
9:51
that's a cloud workflow engine that we are using here which will basically do
9:54
are using here which will basically do
9:54
are using here which will basically do all that automation here right so it is
9:57
all that automation here right so it is
9:57
all that automation here right so it is using different different connectors all
9:59
using different different connectors all
9:59
using different different connectors all the connector that we are talking about
10:01
the connector that we are talking about
10:01
the connector that we are talking about whether it's a outlook team or you know
10:03
whether it's a outlook team or you know
10:03
whether it's a outlook team or you know any other connector that we are going to
10:06
any other connector that we are going to
10:06
any other connector that we are going to use that's basically part of the power
10:08
use that's basically part of the power
10:08
use that's basically part of the power automate only okay so we can create
10:11
automate only okay so we can create
10:11
automate only okay so we can create different type of power autobase there
10:14
different type of power autobase there
10:14
different type of power autobase there are different type of like you can
10:15
are different type of like you can
10:15
are different type of like you can create you know on demand or you can
10:17
create you know on demand or you can
10:17
create you know on demand or you can create basically that can run on some
10:19
create basically that can run on some
10:19
create basically that can run on some specific trigger or you can have some
10:22
specific trigger or you can have some
10:22
specific trigger or you can have some kind of scheduled one that you know when
10:24
kind of scheduled one that you know when
10:24
kind of scheduled one that you know when you are saying that okay during this
10:26
you are saying that okay during this
10:26
you are saying that okay during this time period that should run okay so
10:28
time period that should run okay so
10:28
time period that should run okay so those kind of thing that is available on
10:30
those kind of thing that is available on
10:30
those kind of thing that is available on the power automate and you can see here
10:32
the power automate and you can see here
10:32
the power automate and you can see here we have this basically the flow that is
10:34
we have this basically the flow that is
10:34
we have this basically the flow that is here so you can see that we have
10:36
here so you can see that we have
10:36
here so you can see that we have different branches here right so in the
10:39
different branches here right so in the
10:39
different branches here right so in the power automate we have controls that is
10:41
power automate we have controls that is
10:41
power automate we have controls that is available which we can use so we have if
10:44
available which we can use so we have if
10:44
available which we can use so we have if control where we can say that okay if
10:46
control where we can say that okay if
10:46
control where we can say that okay if the condition is true which step we want
10:48
the condition is true which step we want
10:48
the condition is true which step we want to do if that is false which step we
10:50
to do if that is false which step we
10:50
to do if that is false which step we want to do that right we do have a
10:52
want to do that right we do have a
10:52
want to do that right we do have a switch control as well so those controls
10:55
switch control as well so those controls
10:55
switch control as well so those controls we can use for the checking and based on
10:58
we can use for the checking and based on
10:58
we can use for the checking and based on that we can decide like okay which step
11:00
that we can decide like okay which step
11:00
that we can decide like okay which step it will execute okay so those type of
11:03
it will execute okay so those type of
11:03
it will execute okay so those type of control that is available we can do the
11:05
control that is available we can do the
11:05
control that is available we can do the looping if there are multiple uh you
11:07
looping if there are multiple uh you
11:07
looping if there are multiple uh you know data if there is a array or there
11:09
know data if there is a array or there
11:09
know data if there is a array or there is a collection and we want to process
11:11
is a collection and we want to process
11:11
is a collection and we want to process those collections so we can use looping
11:13
those collections so we can use looping
11:13
those collections so we can use looping So we have for each loop we have
11:15
So we have for each loop we have
11:15
So we have for each loop we have different loops are there which we can
11:17
different loops are there which we can
11:17
different loops are there which we can use to you know run on the collection
11:19
use to you know run on the collection
11:20
use to you know run on the collection and one by one we can extract that
11:22
and one by one we can extract that
11:22
and one by one we can extract that information. Okay. So as I said that
11:25
information. Okay. So as I said that
11:25
information. Okay. So as I said that this is the key component and we have
11:28
this is the key component and we have
11:28
this is the key component and we have hundreds of connectors available which
11:30
hundreds of connectors available which
11:30
hundreds of connectors available which we can use to interact these different
11:33
we can use to interact these different
11:33
we can use to interact these different application whether it's a Microsoft
11:34
application whether it's a Microsoft
11:34
application whether it's a Microsoft application or non Microsoft
11:37
application or non Microsoft
11:37
application or non Microsoft application. If there is no connector
11:39
application. If there is no connector
11:39
application. If there is no connector available, you can also build your own
11:41
available, you can also build your own
11:41
available, you can also build your own connector, right? And that is there.
11:45
connector, right? And that is there.
11:45
connector, right? And that is there. Apart from this, the connector that we
11:47
Apart from this, the connector that we
11:47
Apart from this, the connector that we are using, some of them are free. So you
11:49
are using, some of them are free. So you
11:50
are using, some of them are free. So you can simply use them. But some of them
11:52
can simply use them. But some of them
11:52
can simply use them. But some of them are premium character. So you need to
11:53
are premium character. So you need to
11:53
are premium character. So you need to buy license for that and after that you
11:56
buy license for that and after that you
11:56
buy license for that and after that you can utilize uh utilize them on the power
11:58
can utilize uh utilize them on the power
11:58
can utilize uh utilize them on the power automate.
12:02
Okay. So AI builder. So AI builder is
12:07
Okay. So AI builder. So AI builder is
12:07
Okay. So AI builder. So AI builder is basically that what we are saying that
12:09
basically that what we are saying that
12:09
basically that what we are saying that we are getting different type of emails
12:11
we are getting different type of emails
12:12
we are getting different type of emails right so customer sending some response
12:14
right so customer sending some response
12:14
right so customer sending some response and based on that response uh data that
12:17
and based on that response uh data that
12:17
and based on that response uh data that is there whether it's a you know subject
12:19
is there whether it's a you know subject
12:19
is there whether it's a you know subject information that we want to use or
12:21
information that we want to use or
12:21
information that we want to use or whether it's a email body part that we
12:23
whether it's a email body part that we
12:23
whether it's a email body part that we want to use from that we want to extract
12:26
want to use from that we want to extract
12:26
want to use from that we want to extract that sentimental information those kind
12:29
that sentimental information those kind
12:29
that sentimental information those kind of thing we can use using the AI builder
12:32
of thing we can use using the AI builder
12:32
of thing we can use using the AI builder so if you can see here on the AI builder
12:34
so if you can see here on the AI builder
12:34
so if you can see here on the AI builder we have different connection connectors
12:35
we have different connection connectors
12:35
we have different connection connectors available. So we can connect use these
12:38
available. So we can connect use these
12:38
available. So we can connect use these different connectors. So for example we
12:40
different connectors. So for example we
12:40
different connectors. So for example we can you know do that analysis there. We
12:42
can you know do that analysis there. We
12:42
can you know do that analysis there. We can detect that okay what is the
12:44
can detect that okay what is the
12:44
can detect that okay what is the language of that email. So those kind of
12:47
language of that email. So those kind of
12:47
language of that email. So those kind of different actions that is available that
12:49
different actions that is available that
12:49
different actions that is available that we are going to use today and these
12:52
we are going to use today and these
12:52
we are going to use today and these basically action will help us to get the
12:55
basically action will help us to get the
12:55
basically action will help us to get the data analyze the data and pass that
12:57
data analyze the data and pass that
12:57
data analyze the data and pass that information to the concern. So for after
13:00
information to the concern. So for after
13:00
information to the concern. So for after that we can use our next character which
13:04
that we can use our next character which
13:04
that we can use our next character which basically teams one that basically
13:07
basically teams one that basically
13:07
basically teams one that basically sending the notification so that they
13:09
sending the notification so that they
13:09
sending the notification so that they can proactively take action on those
13:12
can proactively take action on those
13:12
can proactively take action on those response right if it's a positive
13:14
response right if it's a positive
13:14
response right if it's a positive feedback so sending them a thank you
13:16
feedback so sending them a thank you
13:16
feedback so sending them a thank you email so thank you for providing your
13:18
email so thank you for providing your
13:18
email so thank you for providing your positive feedback if there is a negative
13:20
positive feedback if there is a negative
13:20
positive feedback if there is a negative email just reaching out to them getting
13:23
email just reaching out to them getting
13:23
email just reaching out to them getting some more information okay what was the
13:25
some more information okay what was the
13:25
some more information okay what was the issue where was the gap and what type of
13:27
issue where was the gap and what type of
13:27
issue where was the gap and what type of issue they are facing Okay. So those
13:29
issue they are facing Okay. So those
13:30
issue they are facing Okay. So those type of thing we can do easily on the
13:32
type of thing we can do easily on the
13:32
type of thing we can do easily on the Microsoft team. So this can easily we
13:35
Microsoft team. So this can easily we
13:35
Microsoft team. So this can easily we can post that you know notification on
13:37
can post that you know notification on
13:37
can post that you know notification on the team. So normally companies use team
13:40
the team. So normally companies use team
13:40
the team. So normally companies use team channels. So we have you know we can
13:43
channels. So we have you know we can
13:43
channels. So we have you know we can create different type of channel
13:44
create different type of channel
13:44
create different type of channel depending on the teams whoever handling
13:46
depending on the teams whoever handling
13:46
depending on the teams whoever handling that particular service or product.
13:48
that particular service or product.
13:48
that particular service or product. Right. So as soon as and mostly
13:51
Right. So as soon as and mostly
13:51
Right. So as soon as and mostly companies use a team as a you know their
13:53
companies use a team as a you know their
13:53
companies use a team as a you know their day-to-day communication in the office.
13:55
day-to-day communication in the office.
13:55
day-to-day communication in the office. Right. So when they will use that these
13:58
Right. So when they will use that these
13:58
Right. So when they will use that these uh team connector they can send that
14:00
uh team connector they can send that
14:00
uh team connector they can send that notification and immediately that will
14:02
notification and immediately that will
14:02
notification and immediately that will get you know on that team channel they
14:05
get you know on that team channel they
14:05
get you know on that team channel they will get that notification and from
14:07
will get that notification and from
14:07
will get that notification and from there they can start acting on the
14:10
there they can start acting on the
14:10
there they can start acting on the response right. So these type of thing
14:14
response right. So these type of thing
14:14
response right. So these type of thing that is uh these type of control these
14:17
that is uh these type of control these
14:17
that is uh these type of control these type of connectors that we are going to
14:19
type of connectors that we are going to
14:19
type of connectors that we are going to use today for doing this uh sentimental
14:22
use today for doing this uh sentimental
14:22
use today for doing this uh sentimental analysis. And now we are going to jump
14:26
analysis. And now we are going to jump
14:26
analysis. And now we are going to jump on the demo where we will see much
14:29
on the demo where we will see much
14:29
on the demo where we will see much detail that how these tools can interact
14:32
detail that how these tools can interact
14:32
detail that how these tools can interact with each other and pass information for
14:36
with each other and pass information for
14:36
with each other and pass information for from each other and then based on that
14:38
from each other and then based on that
14:38
from each other and then based on that sentimental we can how we can take the
14:40
sentimental we can how we can take the
14:40
sentimental we can how we can take the decision that which paths we want to
14:42
decision that which paths we want to
14:42
decision that which paths we want to use. So we can see the different control
14:44
use. So we can see the different control
14:44
use. So we can see the different control that we are using right
14:48
that we are using right
14:48
that we are using right okay so sep I'm going to pass mic to you
14:53
okay so sep I'm going to pass mic to you
14:53
okay so sep I'm going to pass mic to you >> that
14:54
>> that
14:54
>> that >> you can share
14:54
>> you can share
14:54
>> you can share >> thank you very much
14:57
>> thank you very much
14:57
>> thank you very much yes so let me share my screen
15:07
>> okay so we are waiting for your screen
15:11
>> okay so we are waiting for your screen
15:11
>> okay so we are waiting for your screen is it visible
15:13
is it visible
15:13
is it visible Uh not yet.
15:15
Uh not yet.
15:16
Uh not yet. Yeah, it's loading. Yeah, we can see it.
15:18
Yeah, it's loading. Yeah, we can see it.
15:18
Yeah, it's loading. Yeah, we can see it. Yep.
15:19
Yep.
15:19
Yep. >> Okay. So, as Mahendra told that we will
15:22
>> Okay. So, as Mahendra told that we will
15:22
>> Okay. So, as Mahendra told that we will use power automate. So, what I'm going
15:25
use power automate. So, what I'm going
15:25
use power automate. So, what I'm going to do is I will create a flow step by
15:28
to do is I will create a flow step by
15:28
to do is I will create a flow step by step. So, we can see that how we can uh
15:31
step. So, we can see that how we can uh
15:31
step. So, we can see that how we can uh analyze the sentiment of customer email
15:34
analyze the sentiment of customer email
15:34
analyze the sentiment of customer email and based on that we will take action.
15:37
and based on that we will take action.
15:37
and based on that we will take action. So the first thing like automated
15:40
So the first thing like automated
15:40
So the first thing like automated cloudflow
15:41
cloudflow
15:41
cloudflow and we will search for
15:44
and we will search for
15:44
and we will search for when email
15:47
when email
15:48
when email arrives.
16:02
So we'll use that.
16:05
So we'll use that.
16:05
So we'll use that. Let me fix the connection.
16:25
Let me check this.
16:34
Good.
17:03
So let me delete and start from
17:07
So let me delete and start from
17:07
So let me delete and start from beginning.
17:15
All right.
17:26
Just a second.
17:40
Okay. So now the next step is that we
17:44
Okay. So now the next step is that we
17:44
Okay. So now the next step is that we will just use like after getting that
17:47
will just use like after getting that
17:47
will just use like after getting that email we will get the user profile. So I
17:51
email we will get the user profile. So I
17:51
email we will get the user profile. So I will search for get user
17:56
will search for get user
17:56
will search for get user info.
17:58
info.
17:58
info. So I will use this
18:03
get user info
18:06
get user info
18:06
get user info and then we will use this
18:12
no parameter needed here
18:19
and the next thing is that we will use
18:23
and the next thing is that we will use
18:23
and the next thing is that we will use HTML.
18:26
So for example whatever we are content
18:29
So for example whatever we are content
18:29
So for example whatever we are content we are getting uh that is in email we
18:31
we are getting uh that is in email we
18:31
we are getting uh that is in email we need to convert that HTML into the text
18:35
need to convert that HTML into the text
18:35
need to convert that HTML into the text so we can pass to the AI builder. So I
18:37
so we can pass to the AI builder. So I
18:37
so we can pass to the AI builder. So I will just use this and the body that is
18:41
will just use this and the body that is
18:41
will just use this and the body that is what I will use here.
18:43
what I will use here.
18:43
what I will use here. And the next step is that we will go for
18:47
And the next step is that we will go for
18:47
And the next step is that we will go for the AI builder.
18:52
And you can see all those uh AI models
18:55
And you can see all those uh AI models
18:55
And you can see all those uh AI models we have in Power Automate. For example,
18:58
we have in Power Automate. For example,
18:58
we have in Power Automate. For example, if you want to analyze the business card
19:00
if you want to analyze the business card
19:00
if you want to analyze the business card or you want to analyze the sentiment
19:02
or you want to analyze the sentiment
19:02
or you want to analyze the sentiment analysis, that is what we are going to
19:04
analysis, that is what we are going to
19:04
analysis, that is what we are going to use here. classify into custom
19:06
use here. classify into custom
19:06
use here. classify into custom categories like classify into the
19:09
categories like classify into the
19:10
categories like classify into the standard categories. Describe the image.
19:13
standard categories. Describe the image.
19:13
standard categories. Describe the image. This is in preview like detect the
19:15
This is in preview like detect the
19:15
This is in preview like detect the language and all these models are
19:18
language and all these models are
19:18
language and all these models are already trained by Microsoft. So you
19:20
already trained by Microsoft. So you
19:20
already trained by Microsoft. So you just need to use them in power automate
19:22
just need to use them in power automate
19:22
just need to use them in power automate flow and uh you will able to get the
19:25
flow and uh you will able to get the
19:25
flow and uh you will able to get the output based on the input uh you will
19:29
output based on the input uh you will
19:29
output based on the input uh you will provide to that particular model. For
19:31
provide to that particular model. For
19:31
provide to that particular model. For example, you can see we have process
19:33
example, you can see we have process
19:33
example, you can see we have process document process identity
19:36
document process identity
19:36
document process identity identity of the document process process
19:39
identity of the document process process
19:39
identity of the document process process receipt. So for example like when we are
19:41
receipt. So for example like when we are
19:41
receipt. So for example like when we are using uh like co-pilot or any other
19:44
using uh like co-pilot or any other
19:44
using uh like co-pilot or any other thing that is where you can use the AI
19:46
thing that is where you can use the AI
19:46
thing that is where you can use the AI model but in power automate we don't
19:49
model but in power automate we don't
19:49
model but in power automate we don't have that capability in that case uh
19:51
have that capability in that case uh
19:51
have that capability in that case uh these are the small models that is what
19:54
these are the small models that is what
19:54
these are the small models that is what we can add as a step and we can give the
19:57
we can add as a step and we can give the
19:57
we can add as a step and we can give the input and we will get output uh using
20:00
input and we will get output uh using
20:00
input and we will get output uh using these AI models. So what I'm going to
20:02
these AI models. So what I'm going to
20:02
these AI models. So what I'm going to use it I'm going to use uh sentiment
20:05
use it I'm going to use uh sentiment
20:06
use it I'm going to use uh sentiment analysis language we need to select
20:08
analysis language we need to select
20:08
analysis language we need to select here. So I will select English language
20:11
here. So I will select English language
20:11
here. So I will select English language and then I will use the input from the
20:15
and then I will use the input from the
20:15
and then I will use the input from the text
20:17
text
20:17
text and the next thing we'll use switch
20:19
and the next thing we'll use switch
20:19
and the next thing we'll use switch cases.
20:24
I will use this
20:26
I will use this
20:26
I will use this and here we will pass the output from
20:30
and here we will pass the output from
20:30
and here we will pass the output from our uh
20:34
our AI model.
20:37
our AI model.
20:37
our AI model. So all these things we have like as a uh
20:41
So all these things we have like as a uh
20:41
So all these things we have like as a uh as a output.
20:44
as a output.
20:44
as a output. So I will use
20:47
So I will use
20:47
So I will use sentiment
20:50
and then so let me see that we are
20:53
and then so let me see that we are
20:53
and then so let me see that we are getting like as by default it's added
20:57
getting like as by default it's added
20:57
getting like as by default it's added for each. Let me check that we are
20:59
for each. Let me check that we are
20:59
for each. Let me check that we are getting like response and sentence.
21:02
getting like response and sentence.
21:02
getting like response and sentence. Okay. And then we are getting okay. So
21:05
Okay. And then we are getting okay. So
21:05
Okay. And then we are getting okay. So now we will add the the conditions. So
21:09
now we will add the the conditions. So
21:09
now we will add the the conditions. So for example what we are going to get all
21:12
for example what we are going to get all
21:12
for example what we are going to get all these things uh
21:15
these things uh
21:15
these things uh if we will go to this model we can see
21:18
if we will go to this model we can see
21:18
if we will go to this model we can see that
21:20
that
21:20
that the inputs we will get that is the first
21:23
the inputs we will get that is the first
21:23
the inputs we will get that is the first one is uh uh negative.
21:28
So we'll add the negative
21:30
So we'll add the negative
21:30
So we'll add the negative case
21:31
case
21:31
case then we will add
21:36
neutral
21:38
neutral
21:38
neutral and by default we will use this uh the
21:42
and by default we will use this uh the
21:42
and by default we will use this uh the positive sentiment as a default we will
21:45
positive sentiment as a default we will
21:45
positive sentiment as a default we will use and let me change the name here
21:50
use and let me change the name here
21:50
use and let me change the name here diff
22:02
and then here we'll use
22:07
negative one.
22:11
So now our almost flow is ready where we
22:14
So now our almost flow is ready where we
22:14
So now our almost flow is ready where we are getting the email we are getting
22:15
are getting the email we are getting
22:15
are getting the email we are getting user information then we are extracting
22:19
user information then we are extracting
22:19
user information then we are extracting text from the email and then we are
22:21
text from the email and then we are
22:21
text from the email and then we are doing sentiment analysis it is positive
22:24
doing sentiment analysis it is positive
22:24
doing sentiment analysis it is positive negative or neutral
22:27
negative or neutral
22:27
negative or neutral and if it is negative uh that's the case
22:30
and if it is negative uh that's the case
22:30
and if it is negative uh that's the case when we need to be more alert in that
22:34
when we need to be more alert in that
22:34
when we need to be more alert in that case what we'll do is we'll create a
22:36
case what we'll do is we'll create a
22:36
case what we'll do is we'll create a team post like the first thing we do
22:38
team post like the first thing we do
22:38
team post like the first thing we do we'll send a message to the like staff
22:42
we'll send a message to the like staff
22:42
we'll send a message to the like staff members and managers. So we use send
22:45
members and managers. So we use send
22:45
members and managers. So we use send email
22:49
and we use send email here
22:56
stop
22:58
stop
22:58
stop negative for this.
23:06
So for example like you know your staff
23:08
So for example like you know your staff
23:08
So for example like you know your staff members that is what you can use here.
23:10
members that is what you can use here.
23:10
members that is what you can use here. So let me
23:14
I will use the email address we are
23:16
I will use the email address we are
23:16
I will use the email address we are using for receiving the email
23:21
and the subject.
23:26
We will take the subject from
23:29
We will take the subject from
23:29
We will take the subject from email
23:34
and then the next thing we'll take that
23:36
and then the next thing we'll take that
23:36
and then the next thing we'll take that is username.
23:40
is username.
23:40
is username. So we take display name
23:50
feedback
23:52
feedback
23:52
feedback like this is negative
23:57
negative feedback
24:00
negative feedback
24:00
negative feedback from customer
24:05
email address.
24:08
email address.
24:08
email address. use the email address from that
24:10
use the email address from that
24:10
use the email address from that particular email. So we'll use this and
24:13
particular email. So we'll use this and
24:13
particular email. So we'll use this and from
24:17
sentiment
24:20
sentiment
24:20
sentiment just add the sentiment.
24:26
So please
24:28
So please
24:28
So please click or look. So something like based
24:31
click or look. So something like based
24:31
click or look. So something like based on your content that is what you can add
24:33
on your content that is what you can add
24:33
on your content that is what you can add here. So we created a email to send to
24:36
here. So we created a email to send to
24:36
here. So we created a email to send to the staff member. If you want to add
24:38
the staff member. If you want to add
24:38
the staff member. If you want to add more email addresses that is what you
24:40
more email addresses that is what you
24:40
more email addresses that is what you can just add the comma like you want to
24:43
can just add the comma like you want to
24:43
can just add the comma like you want to send the message to your manager or
24:45
send the message to your manager or
24:45
send the message to your manager or something like that that is what you can
24:47
something like that that is what you can
24:47
something like that that is what you can add here. So let me save it. So next
24:49
add here. So let me save it. So next
24:49
add here. So let me save it. So next thing we can do like if it is on high
24:51
thing we can do like if it is on high
24:51
thing we can do like if it is on high alert in that case uh
25:01
so for now I will just use the name as
25:04
so for now I will just use the name as
25:04
so for now I will just use the name as you need VPN I know
25:08
you need VPN I know
25:08
you need VPN I know so the next thing we'll do we'll add add
25:10
so the next thing we'll do we'll add add
25:10
so the next thing we'll do we'll add add the
25:12
the
25:12
the user VPN is required let me check that
25:15
user VPN is required let me check that
25:15
user VPN is required let me check that how we can fix
25:20
I can add.
25:27
So I'm just using email address. And now
25:31
So I'm just using email address. And now
25:31
So I'm just using email address. And now I will go here.
25:34
I will go here.
25:34
I will go here. And the next thing we'll do we'll send
25:36
And the next thing we'll do we'll send
25:36
And the next thing we'll do we'll send message in teams.
25:40
message in teams.
25:40
message in teams. So I will use teams connector. And we
25:43
So I will use teams connector. And we
25:43
So I will use teams connector. And we can see like post a message into a team
25:47
can see like post a message into a team
25:47
can see like post a message into a team channel. So post a message into chat or
25:51
channel. So post a message into chat or
25:51
channel. So post a message into chat or channel that is what what I will select.
25:53
channel that is what what I will select.
25:53
channel that is what what I will select. And then we'll use the flow board. We
25:56
And then we'll use the flow board. We
25:56
And then we'll use the flow board. We use the channel
25:58
use the channel
25:58
use the channel and
25:59
and
26:00
and we'll use the teams
26:02
we'll use the teams
26:02
we'll use the teams that is like I will use demo team
26:07
that is like I will use demo team
26:07
that is like I will use demo team and the particular channel you want to
26:09
and the particular channel you want to
26:09
and the particular channel you want to use. So for example like based on your
26:11
use. So for example like based on your
26:12
use. So for example like based on your uh team structure whatever channel
26:14
uh team structure whatever channel
26:14
uh team structure whatever channel whatever team you want to use that is
26:16
whatever team you want to use that is
26:16
whatever team you want to use that is what you can select here. You can al
26:18
what you can select here. You can al
26:18
what you can select here. You can al also type the message like we got
26:22
also type the message like we got
26:22
also type the message like we got negative give it back from customer and
26:27
negative give it back from customer and
26:28
negative give it back from customer and you can mention the customer name or
26:30
you can mention the customer name or
26:30
you can mention the customer name or email address.
26:35
So this is how you can create a alert in
26:38
So this is how you can create a alert in
26:38
So this is how you can create a alert in Microsoft Teams. The next thing we can
26:41
Microsoft Teams. The next thing we can
26:41
Microsoft Teams. The next thing we can do we can if you want to send message to
26:44
do we can if you want to send message to
26:44
do we can if you want to send message to back to the customer that is what you
26:46
back to the customer that is what you
26:46
back to the customer that is what you can also uh use. So we can add send
26:53
can also uh use. So we can add send
26:53
can also uh use. So we can add send email. The next
26:56
email. The next
26:56
email. The next email we will send back to the customer.
27:01
email we will send back to the customer.
27:01
email we will send back to the customer. Just send email to
27:04
Just send email to
27:04
Just send email to customer. We'll use the from address.
27:14
So from where message is coming. Thanks
27:17
So from where message is coming. Thanks
27:17
So from where message is coming. Thanks for
27:20
for
27:20
for feedback.
27:29
Thank you for your feedback
27:36
look to the issue. So this is like like
27:40
look to the issue. So this is like like
27:40
look to the issue. So this is like like I'm just adding demo content but based
27:43
I'm just adding demo content but based
27:43
I'm just adding demo content but based on your requirement that is what you can
27:45
on your requirement that is what you can
27:45
on your requirement that is what you can add here. So we have our negative flow
27:48
add here. So we have our negative flow
27:48
add here. So we have our negative flow ready. In case of neut neutral it means
27:51
ready. In case of neut neutral it means
27:51
ready. In case of neut neutral it means that customer is neither happy nor uh
27:56
that customer is neither happy nor uh
27:56
that customer is neither happy nor uh sad about your services. So what we can
27:59
sad about your services. So what we can
27:59
sad about your services. So what we can do is we can just send a alert to our
28:03
do is we can just send a alert to our
28:03
do is we can just send a alert to our team
28:05
team
28:05
team send email
28:11
and I will use this.
28:17
So I will use two
28:22
and we'll use the subject
28:25
and we'll use the subject
28:25
and we'll use the subject from message
28:28
from message
28:28
from message and hi team
28:35
whatever content like uh we got feedback
28:41
whatever content like uh we got feedback
28:41
whatever content like uh we got feedback from customer
28:43
from customer
28:43
from customer and customer
28:46
and customer
28:46
and customer email you can type here.
28:51
So I just take email from address and
28:53
So I just take email from address and
28:54
So I just take email from address and then comma sentiment.
28:58
then comma sentiment.
28:58
then comma sentiment. You can take from AI video that is
29:01
You can take from AI video that is
29:01
You can take from AI video that is sentiment analysis.
29:04
sentiment analysis.
29:04
sentiment analysis. So this is what we'll send. We'll send
29:07
So this is what we'll send. We'll send
29:07
So this is what we'll send. We'll send in a neutral case. I just need to change
29:10
in a neutral case. I just need to change
29:10
in a neutral case. I just need to change the title that is
29:19
neutral
29:21
neutral
29:21
neutral I will save it. In case of positive like
29:25
I will save it. In case of positive like
29:25
I will save it. In case of positive like for example you are getting message from
29:27
for example you are getting message from
29:27
for example you are getting message from customer and he is quite happy. So in
29:30
customer and he is quite happy. So in
29:30
customer and he is quite happy. So in that case if you want to send message
29:33
that case if you want to send message
29:33
that case if you want to send message back to the customer you will just use
29:36
back to the customer you will just use
29:36
back to the customer you will just use send message
29:40
and
29:47
Send email
29:53
again. We'll use the customer email
29:55
again. We'll use the customer email
29:55
again. We'll use the customer email address here.
30:00
We'll use address
30:03
We'll use address
30:03
We'll use address forward back to the we'll take the
30:06
forward back to the we'll take the
30:06
forward back to the we'll take the subject
30:09
subject
30:09
subject and hi
30:14
Thank you for
30:17
Thank you for
30:17
Thank you for being our valued customer.
30:21
being our valued customer.
30:21
being our valued customer. So you will send a thank you message as
30:23
So you will send a thank you message as
30:23
So you will send a thank you message as you are getting positive feedback from
30:26
you are getting positive feedback from
30:26
you are getting positive feedback from the customer. Also if you want to send
30:28
the customer. Also if you want to send
30:28
the customer. Also if you want to send message to your manager or
30:33
message to your manager or
30:33
message to your manager or let me again change the
30:37
title. Now we will see. So this is how
30:40
title. Now we will see. So this is how
30:40
title. Now we will see. So this is how we have here we are sending message to
30:43
we have here we are sending message to
30:43
we have here we are sending message to the uh staff then we are posting in team
30:46
the uh staff then we are posting in team
30:46
the uh staff then we are posting in team message and then we are sending message
30:48
message and then we are sending message
30:48
message and then we are sending message back to the customer in case of negative
30:51
back to the customer in case of negative
30:51
back to the customer in case of negative in case of neutral we are just sending
30:53
in case of neutral we are just sending
30:53
in case of neutral we are just sending message to the stock that just try to
30:56
message to the stock that just try to
30:56
message to the stock that just try to improve their quality so customer will
30:58
improve their quality so customer will
30:58
improve their quality so customer will be happy. In case of positive uh we are
31:01
be happy. In case of positive uh we are
31:01
be happy. In case of positive uh we are just sending message back to the uh
31:03
just sending message back to the uh
31:03
just sending message back to the uh customer that thank you for being our
31:06
customer that thank you for being our
31:06
customer that thank you for being our valued customer. So let me run this uh
31:09
valued customer. So let me run this uh
31:09
valued customer. So let me run this uh flow and see that how it's working. So
31:12
flow and see that how it's working. So
31:12
flow and see that how it's working. So let me save it
31:15
let me save it
31:15
let me save it and I will just send from here.
31:18
and I will just send from here.
31:18
and I will just send from here. So before that we will just try in a
31:20
So before that we will just try in a
31:20
So before that we will just try in a test mode.
31:35
customer feedback.
31:40
I team
31:42
I team
31:42
I team I am not happy with your
31:48
services
31:51
services
31:51
services and support.
31:53
and support.
31:53
and support. I will just send it and see that how
31:55
I will just send it and see that how
31:55
I will just send it and see that how this flow is working.
32:01
So sometimes when we are using like
32:03
So sometimes when we are using like
32:03
So sometimes when we are using like external connectors uh like sometimes
32:07
external connectors uh like sometimes
32:07
external connectors uh like sometimes it's taking time. So we'll just wait for
32:09
it's taking time. So we'll just wait for
32:09
it's taking time. So we'll just wait for till that this blue will run.
32:34
So now it's running. You can see like
32:35
So now it's running. You can see like
32:35
So now it's running. You can see like the first step then we are getting user
32:37
the first step then we are getting user
32:37
the first step then we are getting user information
32:39
information
32:39
information and then we are extracting information
32:42
and then we are extracting information
32:42
and then we are extracting information from that email and it's going here.
32:46
from that email and it's going here.
32:46
from that email and it's going here. Let's see that's
32:48
Let's see that's
32:48
Let's see that's going to the neutral. So here like I
32:52
going to the neutral. So here like I
32:52
going to the neutral. So here like I thought that it's negative but if you
32:53
thought that it's negative but if you
32:54
thought that it's negative but if you are just sending this kind of message
32:55
are just sending this kind of message
32:55
are just sending this kind of message it's not negative. So I got like thank
32:58
it's not negative. So I got like thank
32:58
it's not negative. So I got like thank you for your feedback. We look into the
33:00
you for your feedback. We look into the
33:00
you for your feedback. We look into the issue. So it's going through this route
33:03
issue. So it's going through this route
33:03
issue. So it's going through this route like uh according to the AI this kind of
33:05
like uh according to the AI this kind of
33:06
like uh according to the AI this kind of message is just neutral message. So we
33:08
message is just neutral message. So we
33:08
message is just neutral message. So we got this uh so this is how you can see
33:11
got this uh so this is how you can see
33:11
got this uh so this is how you can see like easily if uh in case I'm sending a
33:14
like easily if uh in case I'm sending a
33:14
like easily if uh in case I'm sending a message that
33:16
message that
33:16
message that uh sep and we'll just try to check
33:23
customer with back.
33:27
customer with back.
33:27
customer with back. So I will use
33:31
So I will use
33:31
So I will use it.
33:33
it.
33:33
it. Thank you for your
33:37
Thank you for your
33:37
Thank you for your uh
33:40
awesome
33:42
awesome
33:42
awesome support on project
33:46
support on project
33:46
support on project you
33:50
project
33:52
project
33:52
project you did for us. So let's see that what
33:55
you did for us. So let's see that what
33:55
you did for us. So let's see that what which kind of sentiment analysis we are
33:57
which kind of sentiment analysis we are
33:57
which kind of sentiment analysis we are getting for this particular uh email. So
34:00
getting for this particular uh email. So
34:00
getting for this particular uh email. So again I will go here.
34:04
again I will go here.
34:04
again I will go here. go back and see.
34:07
go back and see.
34:07
go back and see. So we'll just go try to run it.
34:13
So it's running for our existing
34:17
So it's running for our existing
34:17
So it's running for our existing email.
34:45
It's taking time.
34:50
So this is how like like uh we just
34:52
So this is how like like uh we just
34:52
So this is how like like uh we just created a demo version based on like
34:54
created a demo version based on like
34:54
created a demo version based on like sometimes when you are working in a
34:57
sometimes when you are working in a
34:57
sometimes when you are working in a organization it's very important that
34:59
organization it's very important that
34:59
organization it's very important that you should not get any kind of negative
35:01
you should not get any kind of negative
35:01
you should not get any kind of negative feedback. In that case like you can
35:03
feedback. In that case like you can
35:03
feedback. In that case like you can create alerts, you can send
35:05
create alerts, you can send
35:05
create alerts, you can send notifications, you can send m message to
35:08
notifications, you can send m message to
35:08
notifications, you can send m message to manager like uh this project is going
35:11
manager like uh this project is going
35:11
manager like uh this project is going from a critical stage. You just need to
35:13
from a critical stage. You just need to
35:14
from a critical stage. You just need to look in into it. So that is how you can
35:16
look in into it. So that is how you can
35:16
look in into it. So that is how you can create all those kind of things. I think
35:17
create all those kind of things. I think
35:17
create all those kind of things. I think that I just need to cancel this flow and
35:20
that I just need to cancel this flow and
35:20
that I just need to cancel this flow and see that. So it's working. Let's see
35:23
see that. So it's working. Let's see
35:23
see that. So it's working. Let's see where it is going.
35:29
So again it's going to the uh neutral
35:32
So again it's going to the uh neutral
35:32
So again it's going to the uh neutral and that is what we are getting as a
35:34
and that is what we are getting as a
35:34
and that is what we are getting as a message. So
35:37
message. So
35:37
message. So so hope you will able to understand that
35:40
so hope you will able to understand that
35:40
so hope you will able to understand that how like if you have any kind of support
35:43
how like if you have any kind of support
35:43
how like if you have any kind of support email or any special email where
35:46
email or any special email where
35:46
email or any special email where customer is communicating you will able
35:48
customer is communicating you will able
35:48
customer is communicating you will able to analyze and alert your team based on
35:51
to analyze and alert your team based on
35:51
to analyze and alert your team based on customer feedback. I'm going to pass
35:53
customer feedback. I'm going to pass
35:53
customer feedback. I'm going to pass this uh like stage to Mahendra over to
35:57
this uh like stage to Mahendra over to
35:57
this uh like stage to Mahendra over to you.
35:58
you.
35:58
you. >> Okay. So here uh just want to add here
36:02
>> Okay. So here uh just want to add here
36:02
>> Okay. So here uh just want to add here like as you can see that this flow that
36:04
like as you can see that this flow that
36:04
like as you can see that this flow that we have created right and on this flow
36:08
we have created right and on this flow
36:08
we have created right and on this flow so we have utilized different type of
36:11
so we have utilized different type of
36:11
so we have utilized different type of control that is part of the power
36:13
control that is part of the power
36:13
control that is part of the power automate. So as you can see that have we
36:15
automate. So as you can see that have we
36:15
automate. So as you can see that have we are using for each loop. So this is
36:17
are using for each loop. So this is
36:17
are using for each loop. So this is basically the collection. You can see
36:19
basically the collection. You can see
36:19
basically the collection. You can see here we have the four right the
36:21
here we have the four right the
36:21
here we have the four right the collection there are the four items that
36:23
collection there are the four items that
36:23
collection there are the four items that it is fetching from that uh you know
36:26
it is fetching from that uh you know
36:26
it is fetching from that uh you know email and based on that it's doing that
36:29
email and based on that it's doing that
36:29
email and based on that it's doing that loop and based on the content of these
36:32
loop and based on the content of these
36:32
loop and based on the content of these collection it's going through one by one
36:34
collection it's going through one by one
36:34
collection it's going through one by one so then further we have used this switch
36:36
so then further we have used this switch
36:36
so then further we have used this switch control for the you know checking that
36:39
control for the you know checking that
36:39
control for the you know checking that and then you know that AI model
36:41
and then you know that AI model
36:41
and then you know that AI model basically that's a Microsoft train model
36:44
basically that's a Microsoft train model
36:44
basically that's a Microsoft train model here maybe we can try to add some kind
36:47
here maybe we can try to add some kind
36:47
here maybe we can try to add some kind of uh you know
36:49
of uh you know
36:49
of uh you know Like it's some kind of words where which
36:52
Like it's some kind of words where which
36:52
Like it's some kind of words where which is we can say like you know your support
36:54
is we can say like you know your support
36:54
is we can say like you know your support or something like that like maybe
36:56
or something like that like maybe
36:56
or something like that like maybe horrible or something maybe it will
36:58
horrible or something maybe it will
36:58
horrible or something maybe it will detect and it will go to the negative
37:00
detect and it will go to the negative
37:00
detect and it will go to the negative one. Yeah, even though that model if you
37:03
one. Yeah, even though that model if you
37:03
one. Yeah, even though that model if you want to just test that model how it is
37:05
want to just test that model how it is
37:05
want to just test that model how it is working, you can also go here like we
37:08
working, you can also go here like we
37:08
working, you can also go here like we can go to power automate and uh to test
37:11
can go to power automate and uh to test
37:11
can go to power automate and uh to test that model you will directly will go to
37:13
that model you will directly will go to
37:13
that model you will directly will go to the AI hub and here all those models we
37:17
the AI hub and here all those models we
37:17
the AI hub and here all those models we can get. So for example uh
37:22
can get. So for example uh
37:22
can get. So for example uh we will go here AI models
37:25
we will go here AI models
37:25
we will go here AI models and you can see like the all those
37:28
and you can see like the all those
37:28
and you can see like the all those models are available here. We can click
37:30
models are available here. We can click
37:30
models are available here. We can click and we can search for that particular
37:32
and we can search for that particular
37:32
and we can search for that particular model. We will search for sentiment
37:35
model. We will search for sentiment
37:35
model. We will search for sentiment analysis
37:37
analysis
37:37
analysis like you can see. So this is so here you
37:39
like you can see. So this is so here you
37:39
like you can see. So this is so here you will put your uh like to test it you
37:41
will put your uh like to test it you
37:41
will put your uh like to test it you will just put your like overall the
37:43
will just put your like overall the
37:44
will just put your like overall the email or contact you want to test you
37:46
email or contact you want to test you
37:46
email or contact you want to test you will get that you are getting positive
37:48
will get that you are getting positive
37:48
will get that you are getting positive negative. Even though you want to use
37:50
negative. Even though you want to use
37:50
negative. Even though you want to use this existing model, you can use you can
37:53
this existing model, you can use you can
37:53
this existing model, you can use you can also like customize it as your own and
37:57
also like customize it as your own and
37:57
also like customize it as your own and you can analyze this model and use for
38:00
you can analyze this model and use for
38:00
you can analyze this model and use for your your own uh own workflow.
38:05
your your own uh own workflow.
38:05
your your own uh own workflow. >> Yeah. So we we are using that existing
38:07
>> Yeah. So we we are using that existing
38:07
>> Yeah. So we we are using that existing model that is part of the you know
38:09
model that is part of the you know
38:09
model that is part of the you know Microsoft here. But if we want we can
38:13
Microsoft here. But if we want we can
38:13
Microsoft here. But if we want we can also like the there are three text that
38:15
also like the there are three text that
38:15
also like the there are three text that is basically you know they have the
38:17
is basically you know they have the
38:17
is basically you know they have the different cases that they have trained
38:19
different cases that they have trained
38:20
different cases that they have trained for it right. So if we want to add our
38:22
for it right. So if we want to add our
38:22
for it right. So if we want to add our own, we want to train and want to create
38:25
own, we want to train and want to create
38:25
own, we want to train and want to create our own model that can be also done and
38:27
our own model that can be also done and
38:27
our own model that can be also done and we can you know test different type of
38:30
we can you know test different type of
38:30
we can you know test different type of uh you know contents based on that as
38:32
uh you know contents based on that as
38:32
uh you know contents based on that as Sundep was showing and based on the
38:34
Sundep was showing and based on the
38:34
Sundep was showing and based on the content we can see that okay what is the
38:36
content we can see that okay what is the
38:36
content we can see that okay what is the feedback it will give when it will we
38:38
feedback it will give when it will we
38:38
feedback it will give when it will we will actually use it on the our
38:40
will actually use it on the our
38:40
will actually use it on the our automate. So that's basically there are
38:43
automate. So that's basically there are
38:43
automate. So that's basically there are different type of models and in our
38:45
different type of models and in our
38:45
different type of models and in our coming sessions we will be utilizing
38:47
coming sessions we will be utilizing
38:47
coming sessions we will be utilizing some more models and we'll showcase how
38:49
some more models and we'll showcase how
38:49
some more models and we'll showcase how we can utilize these more models and
38:52
we can utilize these more models and
38:52
we can utilize these more models and here as well as I said like if can you
38:55
here as well as I said like if can you
38:55
here as well as I said like if can you please scroll down a little bit yeah so
38:57
please scroll down a little bit yeah so
38:57
please scroll down a little bit yeah so we can see here like after sending that
39:00
we can see here like after sending that
39:00
we can see here like after sending that notification so let's take an example
39:02
notification so let's take an example
39:02
notification so let's take an example that if we are maintaining that uh you
39:05
that if we are maintaining that uh you
39:05
that if we are maintaining that uh you know database for the customer feedback
39:07
know database for the customer feedback
39:07
know database for the customer feedback okay so for the for example the post
39:10
okay so for the for example the post
39:10
okay so for the for example the post deployment of the project and we want to
39:13
deployment of the project and we want to
39:13
deployment of the project and we want to keep history of those communication and
39:15
keep history of those communication and
39:15
keep history of those communication and we are keeping that response that we got
39:18
we are keeping that response that we got
39:18
we are keeping that response that we got from the customer so that you know it
39:20
from the customer so that you know it
39:20
from the customer so that you know it can be used for the training purpose you
39:22
can be used for the training purpose you
39:22
can be used for the training purpose you know later sometime of you know new uh
39:25
know later sometime of you know new uh
39:25
know later sometime of you know new uh new training guys are there so we can
39:27
new training guys are there so we can
39:27
new training guys are there so we can train them and we can you know showcase
39:29
train them and we can you know showcase
39:29
train them and we can you know showcase them all those type of scenarios. So we
39:31
them all those type of scenarios. So we
39:31
them all those type of scenarios. So we can also use the different connector
39:33
can also use the different connector
39:33
can also use the different connector here to pass this data that is collected
39:37
here to pass this data that is collected
39:37
here to pass this data that is collected by this AI model to data versse or any
39:40
by this AI model to data versse or any
39:40
by this AI model to data versse or any other database that is basically
39:42
other database that is basically
39:42
other database that is basically Microsoft or non-Microsoft. So that can
39:44
Microsoft or non-Microsoft. So that can
39:44
Microsoft or non-Microsoft. So that can be also done right. So those kind of
39:46
be also done right. So those kind of
39:46
be also done right. So those kind of thing can easily do it here right.
39:49
thing can easily do it here right.
39:49
thing can easily do it here right. >> Yeah. In some cases like when we want a
39:51
>> Yeah. In some cases like when we want a
39:51
>> Yeah. In some cases like when we want a report for example like how many
39:54
report for example like how many
39:54
report for example like how many feedback we got positive how many we got
39:56
feedback we got positive how many we got
39:56
feedback we got positive how many we got negative and also based on the team
39:59
negative and also based on the team
39:59
negative and also based on the team member who is helping working on that
40:00
member who is helping working on that
40:00
member who is helping working on that project. So that kind of work we can
40:02
project. So that kind of work we can
40:02
project. So that kind of work we can also do like we can store somewhere and
40:04
also do like we can store somewhere and
40:04
also do like we can store somewhere and create that kind of report.
40:07
create that kind of report.
40:07
create that kind of report. >> Yeah. So the these like we can build
40:09
>> Yeah. So the these like we can build
40:09
>> Yeah. So the these like we can build PowerBI report or any any other
40:12
PowerBI report or any any other
40:12
PowerBI report or any any other dashboard that you know or any
40:13
dashboard that you know or any
40:13
dashboard that you know or any application that you are using or maybe
40:15
application that you are using or maybe
40:16
application that you are using or maybe you are using a Microsoft portal in the
40:18
you are using a Microsoft portal in the
40:18
you are using a Microsoft portal in the portal or you know on the power pages
40:20
portal or you know on the power pages
40:20
portal or you know on the power pages you can display those kind of uh you
40:22
you can display those kind of uh you
40:22
you can display those kind of uh you know reports and maybe the higher
40:24
know reports and maybe the higher
40:24
know reports and maybe the higher authority they will be checking that
40:26
authority they will be checking that
40:26
authority they will be checking that okay after this project completed right
40:29
okay after this project completed right
40:29
okay after this project completed right like VP of this IT or depending on that
40:33
like VP of this IT or depending on that
40:33
like VP of this IT or depending on that whoever is the higher authority they can
40:35
whoever is the higher authority they can
40:35
whoever is the higher authority they can see that okay how was our project went
40:38
see that okay how was our project went
40:38
see that okay how was our project went right. So we completed that project but
40:40
right. So we completed that project but
40:40
right. So we completed that project but what was the uh customer feedback and
40:42
what was the uh customer feedback and
40:42
what was the uh customer feedback and what we can do to improve that if there
40:44
what we can do to improve that if there
40:44
what we can do to improve that if there is some kind of negative feedback that
40:46
is some kind of negative feedback that
40:46
is some kind of negative feedback that is you know we have gotten from the
40:48
is you know we have gotten from the
40:48
is you know we have gotten from the customer right so those type of thing we
40:51
customer right so those type of thing we
40:51
customer right so those type of thing we can easily done on this uh use case so
40:53
can easily done on this uh use case so
40:53
can easily done on this uh use case so that's what we discuss uh today and all
40:57
that's what we discuss uh today and all
40:57
that's what we discuss uh today and all our past use cases that we discussed
41:00
our past use cases that we discussed
41:00
our past use cases that we discussed past sessions all are there on the car
41:03
past sessions all are there on the car
41:03
past sessions all are there on the car corner live TV you can watch there
41:05
corner live TV you can watch there
41:05
corner live TV you can watch there that's the available on the YouTube as
41:07
that's the available on the YouTube as
41:07
that's the available on the YouTube as well so you can see our past session
41:09
well so you can see our past session
41:09
well so you can see our past session theres and we will be back with the
41:11
theres and we will be back with the
41:11
theres and we will be back with the another use case and where we will
41:13
another use case and where we will
41:13
another use case and where we will showcase that how you know we can do
41:16
showcase that how you know we can do
41:16
showcase that how you know we can do that business automation for that
41:17
that business automation for that
41:17
that business automation for that particular use case. If you have any
41:19
particular use case. If you have any
41:20
particular use case. If you have any scenario that you want us to work on
41:21
scenario that you want us to work on
41:21
scenario that you want us to work on please feel free to comment and provide
41:25
please feel free to comment and provide
41:25
please feel free to comment and provide uh you know your feedback and you can
41:27
uh you know your feedback and you can
41:27
uh you know your feedback and you can send that topic and we can work on that
41:29
send that topic and we can work on that
41:29
send that topic and we can work on that and we can provide a demo for you know
41:31
and we can provide a demo for you know
41:31
and we can provide a demo for you know automating that particular use case
41:33
automating that particular use case
41:33
automating that particular use case right. So, thank you very much for
41:35
right. So, thank you very much for
41:35
right. So, thank you very much for joining us today. Stay tuned with us for
41:37
joining us today. Stay tuned with us for
41:37
joining us today. Stay tuned with us for the next sessions. Thank you very much.
41:40
the next sessions. Thank you very much.
41:40
the next sessions. Thank you very much. >> Yeah. Thank you guys. Bye.
41:43
>> Yeah. Thank you guys. Bye.
41:43
>> Yeah. Thank you guys. Bye. [Music]