PowerAutomate: “Notify me on Teams when I receive an email with negative sentiment”
You want that the AI to analyze sentiment in Outlook emails?
Table of Contents
The PowerAutomate portal provides ready-made flows to try out. To be able to use them, you must have an account with Microsoft. Otherwise an account can be created here.
Today we will look at the following flow:
Notify me on Teams when I receive an email with negative sentiment
(Use AI Builder to analyze sentiment in Outlook emails. When a negative email arrives, you will receive a new message in Teams. )
Setup the Flow to analyse negative sentiment in Outlook emails
After successful creation, the flow looks like this. Here I have only made a small adjustment to specify the AI.
If the “Probability overall text is negative” value is detected as negative above 3/4 (0.75) a team notification should be triggered. There are more Values that you can use from the Step before. In my Case for the AI to analyze sentiment in Outlook emails I use the negative Selection.
At the end of the flow, save and from now on, all emails that land in the inbox will be monitored and evaluated by Microsoft AI Builder.
Let’s Test the Flow
To test the whole thing, I had a negative mail created (funnily enough also via AI), which I sent via test mailbox. Here a Test example:
Test Mail
Hi
I am extremely disappointed and frustrated with the Device that I purchased from your company on 01.01.2023 18:23 PM. It is not functioning properly and I have been extremely dissatisfied with the customer service that I have received thus far.
I contacted your Helpdesk Team and was told that there was nothing that could be done to resolve my issue. I find this response unacceptable and unfair, as I have a brand new Device that should be functioning properly.
I demand a written statement from your company outlining your position on this matter and what steps will be taken to rectify the situation. I have been waiting for a response for days and am extremely dissatisfied with the lack of action and urgency on your part.
If I do not receive a response within 24 hours, I will file complaints with relevant consumer agencies and explore my legal options. I will also cancel the invoice and demand a refund if this issue is not resolved immediately.
I expect prompt action and communication from your company. Please contact me at this email or by phone.
Sincerely,
The Hateful Guy
The mail was received in the mailbox at 15:14, which is monitored by PowerAutomate Flow, i.e. Microsoft AI Builder.
After a few seconds the flow was ready and a Teams PowerAutomate Chat Bot message arrived.
This shows the flow works and the test mail was considered very negative.
PowerAutomate Run History [Analytics]
If we now take a closer look at the flow, we see that my test mail was rated with a negative value of 0.84 by the AI. That’s why the Teams message was triggered otherwise the flow would not trigger any further steps.
Conclusion
The future is AI, as the last few days and weeks have shown. To combine this with the working world a little bit, this prefabricated flow definitely helps.
How far the whole thing can still reach is unclear, but in any case, the topic remains brand hot.
If you want to learn more about PowerAutomate, take a look at the following article: How to get RSS Feed Notifications with PowerAutomate (Smartphone)
