Sentiment Analysis with Desktop Flows?

[drake]

Hello, we need to use the AI Builder Sentiment Analysis functionality with a desktop flow.  We have AI Builder credits available for this, and this works with cloud flows, but we are not seeing a way to use Sentiment Analysis with desktop flows?  There is the Cognitve>Microsoft>Text Analysis>Sentiment action in Power Automate Desktop, but this seems to only use Microsoft Cognitive Services (versus AI Builder).  

Is there a way to use AI Builder Sentiment Analysis with desktop flows?

[JoeF-MSFT · Accepted solution]

Hi @drake,

Thanks for posting this question.

You can’t call yet AI Builder models directly from Power Automate Desktop but there is a workaround you can use by calling a cloud flow from a desktop flow. Here is how to do it:

1. Create a cloud flow like the following one with the ‘When a HTTP request is received’ trigger, the AI Builder sentiment analysis action and a Response action that will return the Overall text sentiment.

2. From the desktop flow use the Invoke web service action and use as URL the one you will get once you save your cloud flow on the HTTP POST URL field on the trigger. Set the method to POST.

Important! When you paste the URL in Power Automate Desktop, you will need to put an extra percentage sign (%) next to the percentage signs already in the URL. So if in your URL have something like this &sp=%2Ftriggers, when you paste it in Power Automate Desktop you will need to put &sp=%%2Ftriggers

3. The sentiment analysis result returned by the cloud flow will be in the WebServiceResponse flow variable from the Invoke web service action.



Hope this helps!

[drake]

@JoeF-MSFT thanks that worked!  But how would this work with the "Detect the language being used in text" action, which I will need to use in conjunction with the detect sentiment action?  It returns this error:

"The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach."

I attempted to use this expression in the Reponse action, but it did not work either:

first(outputs('Detect_the_language_being_used_in_text')?['body'])?['language']

[JoeF-MSFT]

Great @drake !

Would having language detection + sentiment analysis in the same cloud flow work? If so you can build it like this:

This would be the expression to use: 

first(outputs('Detect_the_language_being_used_in_text')?['body/responsev2/predictionOutput/results'])?['language']

[drake]

@JoeF-MSFT your example worked perfectly, but how did you know to use this:

?['body/responsev2/predictionOutput/results'])

I don't see where this string is displayed in the Power Automate UI anywhere.

[JoeF-MSFT]

Good question @drake. 🙂

I built a simple cloud flow where the language output from the language detection action is added to an 'Apply to each' loop. I then hover the mouse over the 'results' output to see how to reference this array in an expression:

I do the same to check the name for the language output:

Hope this helps! 

[Betty_Xu]

Hi I am new here, i want to know where the HTTP URl comes from?