Sentiment Analysis Application: Microsoft Power Automate, Power Apps and AI Builder

Thanks to AI Builder in Microsoft Power Apps and Flow, now we have access to sentiment analysis,

Keyword extraction and Language detection inside Microsoft Flow is now available.

In this post, I am going to show how to do sentiment analysis inside Power Automate.

First What is sentiment Analysis and what sort of analysis we have inside AI Builder for text analytics.

Text Analytics

in Power Automate and Power Apps three analytics is available as sentiment analytics, keyword extraction, and Language detection as below

As you can see in the below picture in AI builder under Build we have these three modules.

 

In this example, I am going to show sentiment analytics. The first login to account with AI builder account, then click on the Build and then click on the sentiment analysis

Then the new windows show the main purpose of the sentiment analysis. As you can see in the below picture, the only option to use is on Microsoft Power Automate (flow).

Next, you able to see some hints about using it in the Microsoft power Automate

Note: For long Text, analyze each sentence, not the whole document

 

Note: Use the same language for a document not multiple languages in a document

Then click on the Use in a Flow,

IN the Power Automate ( make sure you are in the same environment), then click on the solution and then click on the New then Flow.

In the new flow, click on the When a new email arrives

then choose the folder as inbox and the subject as Hotel

 

Next search for the predict for CDS, and for the model choose the SentimentAnalysis model, Then for the text choose the Body Preview,

Next for the language choose the language you will have as it is en for me

In the next step,  we are going to store the result in one drive for example, that you can provide a specific name for the file using the Concat function. In this example, I use the Utcnow to get the current time and date and the file type that is Text file as .txt.

 

 

 

for the file content, I am going to use the sentence to put in the file, before creating it, just click on the run you had from the previous example

as you can see we have a sentence-level sentiment analysis and a global level. I am going to Concat both of them.

then after the run code you should see below text file in the onedrive.

 

Leila Etaati on LinkedinLeila Etaati on TwitterLeila Etaati on Youtube
Leila Etaati
Trainer, Consultant, Mentor
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

Leave a Reply